./mksql3db.sh idsjmk.db idsjmk/*.txt
mksql3db.sh: no existing db; using version 1
using database version 2
idsjmk/agency.txt
idsjmk/api.txt
idsjmk/calendar_dates.txt
idsjmk/calendar.txt
idsjmk/routes.txt
idsjmk/stops.txt
idsjmk/stop_times.txt
idsjmk/transfers.txt
idsjmk/trips.txt
Checking for missing calendar_dates.txt or calendar.txt...
Creating indices...
Indices created.
Adding head signs if not already in DB...
Error: in prepare, no such column: table
select sql from sqlite_master where type="table" and tbl_name="trips";
error here ---^
Parse error near line 1: duplicate column name: trip_headsign
Parse error near line 2: near ",": syntax error
insert into trips select ,trip_headsign from (select ,(select coalesce(stop_na
error here ---^
Adding head signs completed
Deleting departure time of last stop of each trip...
Error: in prepare, no such column: table
select sql from sqlite_master where type="table" and tbl_name="stop_times";
error here ---^
Parse error near line 1: near "from": syntax error
insert into stop_times select from (select from stop_times group by trip_id
error here ---^
Parse error near line 2: no such column:
here departure_time is not NULL and arrival_time<>"" and rowid not in (select
error here ---^
Deleting departure times completed
Renaming and cleaning up...
mv: cannot stat 'idsjmk.db': No such file or directory
mv: cannot stat 'idsjmk.db.version': No such file or directory
idsjmk.db: 75.5% -- replaced with stdout
kri164
commented
1 year ago
Dataset for IDS-JMK agency downloaded from
IDSJMK
What is wrong?
./mksql3db.sh idsjmk.db idsjmk/*.txt mksql3db.sh: no existing db; using version 1 using database version 2 idsjmk/agency.txt idsjmk/api.txt idsjmk/calendar_dates.txt idsjmk/calendar.txt idsjmk/routes.txt idsjmk/stops.txt idsjmk/stop_times.txt idsjmk/transfers.txt idsjmk/trips.txt Checking for missing calendar_dates.txt or calendar.txt... Creating indices... Indices created. Adding head signs if not already in DB... Error: in prepare, no such column: table select sql from sqlite_master where type="table" and tbl_name="trips"; error here ---^ Parse error near line 1: duplicate column name: trip_headsign Parse error near line 2: near ",": syntax error insert into trips select ,trip_headsign from (select ,(select coalesce(stop_na error here ---^ Adding head signs completed Deleting departure time of last stop of each trip... Error: in prepare, no such column: table select sql from sqlite_master where type="table" and tbl_name="stop_times"; error here ---^ Parse error near line 1: near "from": syntax error insert into stop_times select from (select from stop_times group by trip_id error here ---^ Parse error near line 2: no such column: here departure_time is not NULL and arrival_time<>"" and rowid not in (select error here ---^ Deleting departure times completed Renaming and cleaning up... mv: cannot stat 'idsjmk.db': No such file or directory mv: cannot stat 'idsjmk.db.version': No such file or directory idsjmk.db: 75.5% -- replaced with stdout