alex / alex/csv-sql

Batch mode

Open
#579 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.