diff options
Diffstat (limited to 'tests/untestable/tpostgres.nim')
-rw-r--r-- | tests/untestable/tpostgres.nim | 13 |
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 |