summary refs log tree commit diff stats
path: root/tests/untestable/tpostgres.nim
diff options
context:
space:
mode:
Diffstat (limited to 'tests/untestable/tpostgres.nim')
-rw-r--r--tests/untestable/tpostgres.nim13
1 files changed, 13 insertions, 0 deletions
diff --git a/tests/untestable/tpostgres.nim b/tests/untestable/tpostgres.nim
new file mode 100644
index 000000000..5f29da091
--- /dev/null
+++ b/tests/untestable/tpostgres.nim
@@ -0,0 +1,13 @@
+import db_postgres
+
+let db = open("localhost", "dom", "", "test")
+db.exec(sql"DROP TABLE IF EXISTS myTable")
+db.exec(sql("""CREATE TABLE myTable (
+                  id integer PRIMARY KEY,
+                  name varchar(50) not null)"""))
+let name = "Dom"
+db.exec(sql"INSERT INTO myTable (id, name) VALUES (0, ?)",
+        name)
+doAssert db.getValue(sql"SELECT name FROM myTable") == name
+
+db.close()
\ No newline at end of file