Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema mis-matches in multi-CSV imports into existing databases needs more helpful errors #76

Open
warriorstar-orion opened this issue Jan 27, 2021 · 0 comments

Comments

@warriorstar-orion
Copy link

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant