Changeset: d393d9869631 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d393d9869631
Added Files:
sql/test/Users/Tests/createUserRollback.reqtests
Modified Files:
sql/test/Users/Tests/createUserRollback.SQL.py
Branch: mtest
Log Message:
convert createUserRollback tests
diffs (74 lines):
diff --git a/sql/test/Users/Tests/createUserRollback.SQL.py
b/sql/test/Users/Tests/createUserRollback.SQL.py
--- a/sql/test/Users/Tests/createUserRollback.SQL.py
+++ b/sql/test/Users/Tests/createUserRollback.SQL.py
@@ -1,25 +1,43 @@
-import sys
-try:
- from MonetDBtesting import process
-except ImportError:
- import process
+
+from MonetDBtesting.sqltest import SQLTestCase
-with process.client('sql', stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as c:
- out, err = c.communicate('''
- CREATE TABLE sys.myvar (c BIGINT);
- INSERT INTO sys.myvar VALUES ((SELECT COUNT(*) FROM sys.users));
+with SQLTestCase() as tc:
+ tc.connect(username="monetdb", password="monetdb")
+ tc.execute("CREATE TABLE sys.myvar (c BIGINT);")
+ tc.execute("INSERT INTO sys.myvar VALUES ((SELECT COUNT(*) FROM
sys.users));")
+ tc.execute("""
+ START TRANSACTION;
+ CREATE USER "1" WITH PASSWORD '1' NAME '1' SCHEMA "sys";
+ ROLLBACK;
+
+ SELECT CAST(COUNT(*) - (SELECT c FROM sys.myvar) AS BIGINT)
FROM sys.users; -- The MAL authorization is not transaction aware, so the count
changes :/
+ DROP TABLE sys.myvar;
+ """).assertSucceeded()
+ tc.connect(username="1", password="1")
+ tc.execute("SELECT 1;")
- START TRANSACTION;
- CREATE USER "1" WITH PASSWORD '1' NAME '1' SCHEMA "sys";
- ROLLBACK;
+# import sys
+# try:
+# from MonetDBtesting import process
+# except ImportError:
+# import process
+
+# with process.client('sql', stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as c:
+# out, err = c.communicate('''
+# CREATE TABLE sys.myvar (c BIGINT);
+# INSERT INTO sys.myvar VALUES ((SELECT COUNT(*) FROM sys.users));
- SELECT CAST(COUNT(*) - (SELECT c FROM sys.myvar) AS BIGINT) FROM
sys.users; -- The MAL authorization is not transaction aware, so the count
changes :/
- DROP TABLE sys.myvar;
- ''')
- sys.stdout.write(out)
- sys.stderr.write(err)
+# START TRANSACTION;
+# CREATE USER "1" WITH PASSWORD '1' NAME '1' SCHEMA "sys";
+# ROLLBACK;
-with process.client('sql',user='1',passwd='1', stdin=process.PIPE,
stdout=process.PIPE, stderr=process.PIPE) as c: # error should not be possible
to login
- out, err = c.communicate('SELECT 1;')
- sys.stdout.write(out)
- sys.stderr.write(err)
+# SELECT CAST(COUNT(*) - (SELECT c FROM sys.myvar) AS BIGINT) FROM
sys.users; -- The MAL authorization is not transaction aware, so the count
changes :/
+# DROP TABLE sys.myvar;
+# ''')
+# sys.stdout.write(out)
+# sys.stderr.write(err)
+
+# with process.client('sql',user='1',passwd='1', stdin=process.PIPE,
stdout=process.PIPE, stderr=process.PIPE) as c: # error should not be possible
to login
+# out, err = c.communicate('SELECT 1;')
+# sys.stdout.write(out)
+# sys.stderr.write(err)
diff --git a/sql/test/Users/Tests/createUserRollback.reqtests
b/sql/test/Users/Tests/createUserRollback.reqtests
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/createUserRollback.reqtests
@@ -0,0 +1,1 @@
+createSetUp
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
