dbcli / dbcli/litecli

How do I auto-comple Foreign Key?

Aperta
#133 0 commenti 0 reazioni 0 assegnatari Vedi su GitHub
Lingua principale
Python
Stelle
3.3k
Fork
95
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

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)

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.