summaryrefslogtreecommitdiffstats
path: root/sanity_checks.txt
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 17:40:12 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 17:40:12 +0000
commit8ffd3f30ec80895fe0f206b8dd3a25ea1457f9a5 (patch)
tree4e205849ae64ccd4d1797a1ad7579416f69f52ee /sanity_checks.txt
parentInitial commit. (diff)
downloadpgcli-8ffd3f30ec80895fe0f206b8dd3a25ea1457f9a5.tar.xz
pgcli-8ffd3f30ec80895fe0f206b8dd3a25ea1457f9a5.zip
Adding upstream version 3.5.0.upstream/3.5.0upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sanity_checks.txt')
-rw-r--r--sanity_checks.txt37
1 files changed, 37 insertions, 0 deletions
diff --git a/sanity_checks.txt b/sanity_checks.txt
new file mode 100644
index 0000000..d8a4898
--- /dev/null
+++ b/sanity_checks.txt
@@ -0,0 +1,37 @@
+# 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
+
+* Simple execution:
+ 1 Execute a simple 'select * from users;' test that will pass.
+ 2 Execute a syntax error: 'insert into users ( ;'
+ 3 Execute a simple test from step 1 again to see if it still passes.
+ * Change the database and try steps 1 - 3.
+
+* 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.
+
+