dbcli / dbcli/litecli

How do I auto-comple Foreign Key?

Abierto
#133 0 comentarios 0 reacciones 0 asignados Ver en GitHub
Lenguaje dominante
Python
Estrellas
3.3k
Forks
95
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

Note: I am both new to SQLite and litecli, so maybe I just didn't find the right documentation.

I have two tables, `cards` and `card_types`. In my table `cards` I have an entry called `type`, which uses a [FOREIGN KEY](https://sqlite.org/foreignkeys.html): `FOREIGN KEY("type") REFERENCES "card_types"("type")`. Now whenever I insert something into `cards` I want to simply auto-complete my `type` from `card_types`:

- For example with an entry `"special"` in `card_types`, I expected to be able to `INSERT INTO cards (name, type, effect) VALUES ("Pocketsand", spec` and have it autocomplete to `"special"`.
- Same when using a "Favourite Query" (which are awesome, btw): `new_card | INSERT INTO cards (name, type, effect) VALUES ("$1", $2, "$3")` > `new_card "Pocketsand" spec`

Am I doing something wrong? Or is this simply not possible? (If not, then this would be a pretty nice feature)

Guía de contribución

Abrir la guía de contribución

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.