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: 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<TAB> 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<Tab>
Am I doing something wrong? Or is this simply not possible? (If not, then this would be a pretty nice feature)
Note: I am both new to SQLite and litecli, so maybe I just didn't find the right documentation.
I have two tables,
cards
andcard_types
. In my tablecards
I have an entry calledtype
, which uses a FOREIGN KEY:FOREIGN KEY("type") REFERENCES "card_types"("type")
. Now whenever I insert something intocards
I want to simply auto-complete mytype
fromcard_types
:"special"
incard_types
, I expected to be able toINSERT INTO cards (name, type, effect) VALUES ("Pocketsand", spec<TAB>
and have it autocomplete to"special"
.new_card | INSERT INTO cards (name, type, effect) VALUES ("$1", $2, "$3")
>new_card "Pocketsand" spec<Tab>
Am I doing something wrong? Or is this simply not possible? (If not, then this would be a pretty nice feature)