Hello,
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!
Hello,
Assume I have a sqlite3 database with a table
foo, and a file namedfoo.csvwhich 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.csvincludes several more columns not in thefootable 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-runoption that lets one know of these schema mis-matches, all of them, ahead of time, would be incredibly helpful.Thanks!