import postgresql::native_postgres
+var db_suffix = "NIT_TESTING_ID".environ
var db = new NativePostgres.connectdb("dbname=postgres")
assert postgres_open: db.status.is_ok else print_error db.error
-var result = db.exec("CREATE TABLE IF NOT EXISTS animals (aname TEXT PRIMARY KEY, class TEXT NOT NULL, sex INTEGER)")
+var result = db.exec("CREATE TABLE IF NOT EXISTS animals_{db_suffix} (aname TEXT PRIMARY KEY, class TEXT NOT NULL, sex INTEGER)")
assert postgres_create_table: result.status.is_ok else print_error db.error
-result = db.exec("INSERT INTO animals VALUES('Whale', 'mammal', 1)")
+result = db.exec("INSERT INTO animals_{db_suffix} VALUES('Whale', 'mammal', 1)")
assert postgres_insert_1: result.status.is_ok else print_error db.error
-result = db.exec("INSERT INTO animals VALUES('Snake', 'reptile', 0)")
+result = db.exec("INSERT INTO animals_{db_suffix} VALUES('Snake', 'reptile', 0)")
assert postgres_insert_2: result.status.is_ok else print_error db.error
-result = db.exec("SELECT * FROM animals")
+result = db.exec("SELECT * FROM animals_{db_suffix}")
assert postgres_select: result.status.is_ok else print_error db.error
assert postgres_ntuples: result.ntuples == 2 else print_error db.error
print fields
end
-result = db.exec("DELETE FROM animals WHERE aname = 'Lioness'")
+result = db.exec("DELETE FROM animals_{db_suffix} WHERE aname = 'Lioness'")
assert postgres_delete_1: result.status.is_ok else print_error db.error
-result = db.exec("DELETE FROM animals WHERE aname = 'Snake'")
+result = db.exec("DELETE FROM animals_{db_suffix} WHERE aname = 'Snake'")
assert postgres_delete_2: result.status.is_ok else print_error db.error
-result = db.prepare("PREPARED_INSERT", "INSERT INTO animals(aname, class, sex) VALUES ($1, $2, $3)", 3)
+result = db.prepare("PREPARED_INSERT", "INSERT INTO animals_{db_suffix}(aname, class, sex) VALUES ($1, $2, $3)", 3)
assert postgres_prepare: result.status.is_ok else print_error db.error
-result = db.exec("DELETE FROM animals WHERE aname = 'Frog'")
+result = db.exec("DELETE FROM animals_{db_suffix} WHERE aname = 'Frog'")
assert postgres_delete_3: result.status.is_ok else print_error db.error
var values = ["Frog", "Anphibian", "1"]
result = db.exec_prepared("PREPARED_INSERT", 3, values, lengths, formats,0)
assert postgres_exec_prepared: result.status.is_ok else print_error db.error
-result = db.exec("DROP TABLE animals")
+result = db.exec("DROP TABLE animals_{db_suffix}")
assert postgres_drop_table: result.status.is_ok else print_error db.error
db.finish