dbcli / dbcli/mssql-cli

Having access to raw results of the query would be handy

Abierto
#532 3 comentarios 1 reacción 0 asignados Ver en GitHub
Lenguaje dominante
Python
Estrellas
1.4k
Forks
191
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

This might be a duplicate of #231, but that was closed as fixed referencing [non-interactive output options](https://github.com/dbcli/mssql-cli/blob/master/doc/usage_guide.md#outputting-a-query-execution-in-non-interactive-mode). However that only talks about ways running in non-interactive mode and options to either send the results to file on standard out. That only gets us half the way there. Doing so still includes text in the result does not come from the query.

For example

`mssql-cli -S *** -U *** -P *** -Q "SET NOCOUNT ON; SELECT name FROM sys.databases"`

Yields this

```
Commands completed successfully.
+------------------------------------------+
| name |
|------------------------------------------|
| master |
| tempdb |
| model |
| msdb |
| Azurite_Blob |
| Mps_Configuration |
| Mps_653f5e5a-3fbb-44be-9e61-be90630a7187 |
+------------------------------------------+
Commands completed successfully.
```

While correct, that make consuming this output more difficult. Ideally there would an option so that the above query would yield this output
```
master
tempdb
model
msdb
Azurite_Blob
Mps_Configuration
Mps_653f5e5a-3fbb-44be-9e61-be90630a7187
```

My example may be an over simplification, newlines may not always be the best delimiter :smile:. So it may be handy to provide options to return the results in a standard format, here are a few that folks might find handy.
csv, tsv, json, yaml, xml, raw text

Most of the power of many command line tool does not come from running the tool in isolation, but instead comes from being able to combine it with other command line tools.

Guía de contribución

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

Línea de trabajo

Lee las opciones de salida no interactiva existentes en doc/usage_guide.md y, después, reproduce el comando de ejemplo del issue para inspeccionar qué texto de estado y qué formato de tabla se emiten. Define el comportamiento deseado de la salida legible por máquinas y las opciones de formato, mostrando la finalización mediante resultados de consulta que se puedan consumir sin texto adicional.

Escrito por el modelo de indexación a partir del texto del issue.

Evaluación

Stack tecnológico
python, sql
Área
cli, databases
Tipo de issue
Nueva funcionalidad
Dificultad
5/5
Tiempo estimado
Más de una semana
Estado de actividad
Estancado
Claridad
Bastante claro
Aptitud para principiantes
30/100

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.