lib/postgres: use NIT_TESTING_ID in table names

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

diff --git a/lib/postgresql/postgres.nit b/lib/postgresql/postgres.nit
index 7115a14..d8a475e 100644 (file)
--- a/lib/postgresql/postgres.nit
+++ b/lib/postgresql/postgres.nit
@@ -36,18 +36,19 @@
 # animals.add(cat)
 # animals.add(turtle)
 #
+# var db_suffix = "NIT_TESTING_ID".environ
 # var db = new Postgres.open("dbname=postgres")
 #
 # assert db_is_open: not db.is_closed
-# assert create_table: db.create_table("IF NOT EXISTS animals (aname TEXT PRIMARY KEY, kind TEXT NOT NULL, age INT NOT NULL)") else print db.error
+# assert create_table: db.create_table("IF NOT EXISTS animals_{db_suffix} (aname TEXT PRIMARY KEY, kind TEXT NOT NULL, age INT NOT NULL)") else print db.error
 #
 # for animal in animals do
-#   assert insert: db.insert("INTO animals VALUES('{animal.name}', '{animal.kind}', {animal.age})") else print db.error
+#   assert insert: db.insert("INTO animals_{db_suffix} VALUES('{animal.name}', '{animal.kind}', {animal.age})") else print db.error
 # end
 #
-# var result = db.raw_execute("SELECT * FROM animals")
+# var result = db.raw_execute("SELECT * FROM animals_{db_suffix}")
 # assert  result.is_ok
-# assert drop_table: db.execute("DROP TABLE animals")
+# assert drop_table: db.execute("DROP TABLE animals_{db_suffix}")
 # db.finish
 # assert db_is_closed: db.is_closed
 # ~~~