summaryrefslogtreecommitdiffstats
path: root/sanity_checks.txt
blob: 899c4c9d667d9280ab3bef55d5a06569ffe6b633 (plain)
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
# vi: ft=vimwiki

* Launch pgcli with different inputs. 
    * pgcli test_db
    * pgcli postgres://localhost/test_db
    * pgcli postgres://localhost:5432/test_db
    * pgcli postgres://amjith@localhost:5432/test_db
    * pgcli postgres://amjith:password@localhost:5432/test_db
    * pgcli non-existent-db

* Test special command
    * \d
    * \d table_name
    * \dt
    * \l 
    * \c amjith 
    * \q

* Test smart-completion
    * Sele - Must auto-complete to SELECT
    * SELECT * FROM  - Must list the table names.
    * INSERT INTO - Must list table names.
    * \d <tab> - Must list table names.
    * \c <tab> - Database names.
    * SELECT * FROM table_name WHERE <tab> - column names (all of it).

* Test naive-completion - turn off smart completion (using F2 key after launch)
    * Sele - autocomplete to select. 
    * SELECT * FROM - autocomplete list should have everything.