alex / alex/csv-sql

Batch mode

Abierto
#579 1 comentario 0 reacciones 0 asignados Ver en GitHub
Lenguaje dominante
Rust
Estrellas
213
Forks
19
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

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.

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.