You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Assume I have a sqlite3 database with a table foo, and a file named foo.csv which I'd like to import. The behavior is to add these data into the table with the existing filename, which is what I want. However, let's say foo.csv includes several more columns not in the foo table schema. To figure this out, I have to find out one column at a time: that is, run csvs-to-sqlite foo.csv db.sqlite, wait for it to spit out an error such as sqlite3.OperationalError: table foo has no column named bar, add that column to foo.csv, and try again, for each column missing in the schema.
A --dry-run option that lets one know of these schema mis-matches, all of them, ahead of time, would be incredibly helpful.
Thanks!
The text was updated successfully, but these errors were encountered:
Hello,
Assume I have a sqlite3 database with a table
foo
, and a file namedfoo.csv
which I'd like to import. The behavior is to add these data into the table with the existing filename, which is what I want. However, let's sayfoo.csv
includes several more columns not in thefoo
table schema. To figure this out, I have to find out one column at a time: that is, runcsvs-to-sqlite foo.csv db.sqlite
, wait for it to spit out an error such assqlite3.OperationalError: table foo has no column named bar
, add that column to foo.csv, and try again, for each column missing in the schema.A
--dry-run
option that lets one know of these schema mis-matches, all of them, ahead of time, would be incredibly helpful.Thanks!
The text was updated successfully, but these errors were encountered: