TODO


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

# vi: ft=vimwiki
* [ ] Reading a config file is broken if an option doesn't exist. 
* [ ] Column completion for nested sql.
* [ ] Refactor to sqlcompletion to consume the text from left to right and use
a state machine to suggest cols or tables instead of relying on hacks.
* [ ] Add JOIN to the list of keywords and provide proper autocompletion for it. 
* [ ] Add a few more special commands. (\l pattern, \di, \dp, \ds, \dv, \dy, \z etc)
* [ ] Write a doc about how to add new pgspecial commands.(psql -E)
* [ ] Show/hide docs for a statement using a keybinding.
* [ ] Cmd-K breaks in OS X iterm. - This might be a prompt_toolkit bug.
* [ ] Check why Indexes have a invalid at the end when \d is called on them.
* [ ] Check how to add the name of the table before printing the table.
* [ ] Add logging.
* [ ] Setup the pgcli.com website.
* [ ] Add a new trigger for M-/ that does dumb completion.
* [ ] Find a way to add documentation to sql commands. This could get tricky.
* [ ] Refactor the execution and output into a separate class.
* [ ] Create a class for the config and make it easy to access.
* [X] Set multi-line via config file.
* [ ] New Feature List - Write the current version to config file. At launch if the version has changed, display the changelog between the two versions.
* [X] Separate the column completions to be table specific. (SELECT, INSERT, UPDATE)
* [X] Fix: Autocompletion won't go away after semi-colons. This an artifact of stripping special chars in the partially typed words. Need to selectively remove parens.
* [X] Fix: SELECT id, <tab>  FROM django_migrations; - Auto-completion for the second column name is broken. Find the last keyword and use it for completion.
* [X] Show only table sensitive columns in autocompletion.
* [X] Skip the password prompt by default. It should only be presented if -W option is provided.
* [X] Detect a '.' and parse the word before it and get it's real name.
* [X] Multiple cols for dot is failing.
* [X] Table detection for INSERT INTO is not stopping after it encounters the lparen.
* [X] Improve the smart completion for Update statement. (Needs table specific columns)
* [X] Add some tests. Sanity, Unit, Completion, Config.
* [X] Add tests for smart completion.
* [X] Improve the smart completion for Insert statement. (Needs table specific columns)