summaryrefslogtreecommitdiffstats
path: root/test/test_plan.wiki
blob: 43e90838beaaf7b45a437fd8f07e8e4262b9d22a (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
32
33
34
35
36
37
38
= Gross Checks =
    * [ ] Check connecting to a local database.
    * [ ] Check connecting to a remote database.
    * [ ] Check connecting to a database with a user/password.
    * [ ] Check connecting to a non-existent database.
    * [ ] Test changing the database.

    == PGExecute ==
    * [ ] Test successful execution given a cursor.
    * [ ] Test unsuccessful execution with a syntax error.
    * [ ] Test a series of executions with the same cursor without failure.
    * [ ] Test a series of executions with the same cursor with failure.
    * [ ] Test passing in a special command. 

    == Naive Autocompletion ==
    * [ ] Input empty string, ask for completions - Everything.
    * [ ] Input partial prefix, ask for completions - Stars with prefix.
    * [ ] Input fully autocompleted string, ask for completions - Only full match
    * [ ] Input non-existent prefix, ask for completions - nothing
    * [ ] Input lowercase prefix - case insensitive completions

    == Smart Autocompletion ==
    * [ ] Input empty string and check if only keywords are returned.
    * [ ] Input SELECT prefix and check if only columns and '*' are returned.
    * [ ] Input SELECT blah - only keywords are returned.
    * [ ] Input SELECT * FROM - Table names only

    == PGSpecial ==
    * [ ] Test \d
    * [ ] Test \d tablename
    * [ ] Test \d tablena*
    * [ ] Test \d non-existent-tablename
    * [ ] Test \d index
    * [ ] Test \d sequence
    * [ ] Test \d view
    
    == Exceptionals ==
    * [ ] Test the 'use' command to change db.