summary refs log blame commit diff stats
path: root/tests/untestable/tpostgres.nim
blob: 81fe8bf51150ce3d4096fc3742c7adcf4dc67ab5 (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11










                                                           

                                                           
 
          
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
# Check issue #3513
doAssert db.getValue(sql"SELECT name FROM myTable") == name

db.close()