alex / alex/csv-sql

Batch mode

未关闭
#579 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Rust
星标
213
派生
19
PR 合并指标
30 天内没有已合并 PR

描述

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.

贡献指南

这个仓库没有索引到贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。