search

simonw / db-to-sqlite

CLI tool for exporting tables or queries from any SQL database to a SQLite file
Apache License 2.0
370 stars 29 forks source link

Support multiple --sql and --output pairs #15

Open simonw opened 5 years ago

simonw commented 5 years ago

Like this:

$ db-to-sqlite mysql://localhost/blah blah.db \
    --sql "select id, name from categories" --output="cats" \
    --sql "select id, name from authors" --output="authors"
simonw commented 3 years ago

This design doesn't feel right. Instead the --sql option should take two arguments - but that would break backwards compatibility now. Worth a major version bump?

simonw commented 3 years ago

I could add --query output_table sql_query and deprecate --sql and --output - leaving them available but removing them from the documentation and help using hidden=False.

jney commented 2 years ago

I would love this feature too. Is it still planned?