Batch mode
- Dominant language
- Rust
- Stars
- 213
- Forks
- 19
- PR merge metrics
- No merged PRs in 30d
Description
Thanks for this project; very useful.
I would be interested in running this in batch mode; i.e. specifying the query on `stdin` or in a file. I could then make `csv-sql` part of shell pipelines and run it in continuous integration.
Something like this syntax comes to mind:
```command
$ echo '.export(results.csv) SELECT COUNT(*) from t;' | csvsql file.csv
```
Alternatively, reading the query from a file would also be useful:
```command
$ echo '.export(results.csv) SELECT COUNT(*) from t;' > query.sql
$ csvsql file.csv --load-query-from query.sql
```
If `--load-query-from` would accept `-` as a symbol for `stdin`, the line would look like this:
```command
$ echo '.export(results.csv) SELECT COUNT(*) from t;' | csvsql file.csv --load-query-from -
```
Personally, the first option (read query from `stdin` if it's not a TTY) would be my preference.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.