tests: use NIT_TESTING_ID for postgresql tests

Signed-off-by: Alexandre Terrasa <alexandre@moz-code.org>

diff --git a/tests/test_postgres_native.nit b/tests/test_postgres_native.nit
index ff3be6f..a228993 100644 (file)
--- a/tests/test_postgres_native.nit
+++ b/tests/test_postgres_native.nit
@@ -18,19 +18,20 @@ module test_postgres_native
 
 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
@@ -50,16 +51,16 @@ for i in [0..rows[ do
   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"]
@@ -68,6 +69,6 @@ var formats = [0,0,0]
 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

diff --git a/tests/test_postgres_nity.nit b/tests/test_postgres_nity.nit
index 9565335..900aac9 100644 (file)
--- a/tests/test_postgres_nity.nit
+++ b/tests/test_postgres_nity.nit
@@ -18,22 +18,23 @@ module test_postgres_nity
 
 import postgresql::postgres
 
+var db_suffix = "NIT_TESTING_ID".environ
 var db = new Postgres.open("dbname=postgres")
 assert open_db: not db.is_closed else print db.error
 
-assert create_table: db.create_table("IF NOT EXISTS users (uname TEXT PRIMARY KEY, pass TEXT NOT NULL, activated INTEGER, perc FLOAT)") else
+assert create_table: db.create_table("IF NOT EXISTS users_{db_suffix} (uname TEXT PRIMARY KEY, pass TEXT NOT NULL, activated INTEGER, perc FLOAT)") else
   print db.error
 end
 
-assert insert1: db.insert("INTO users VALUES('Bob', 'zzz', 1, 77.7)") else
+assert insert1: db.insert("INTO users_{db_suffix} VALUES('Bob', 'zzz', 1, 77.7)") else
   print db.error
 end
 
-assert insert2: db.insert("INTO users VALUES('Guilherme', 'xxx', 1, 88)") else
+assert insert2: db.insert("INTO users_{db_suffix} VALUES('Guilherme', 'xxx', 1, 88)") else
   print db.error
 end
 
-var result = db.raw_execute("SELECT * FROM users")
+var result = db.raw_execute("SELECT * FROM users_{db_suffix}")
 
 assert raw_exec: result.is_ok else print db.error
 
@@ -42,7 +43,7 @@ assert postgres_fname: result.fname(0) == "uname" else print_error db.error
 assert postgres_isnull: result.is_null(0,0) == false else print_error db.error
 assert postgres_value: result.value(0,0) == "Bob" else print_error db.error
 
-assert drop_table: db.execute("DROP TABLE users") else print db.error
+assert drop_table: db.execute("DROP TABLE users_{db_suffix}") else print db.error
 
 db.finish