Changeset: a4c4bf9dd6c2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a4c4bf9dd6c2
Modified Files:
sql/test/Users/Tests/role.SQL.py
Branch: mtest
Log Message:
convert tests for role
diffs (68 lines):
diff --git a/sql/test/Users/Tests/role.SQL.py b/sql/test/Users/Tests/role.SQL.py
--- a/sql/test/Users/Tests/role.SQL.py
+++ b/sql/test/Users/Tests/role.SQL.py
@@ -4,28 +4,43 @@
# Assess it is not possible to recreate an existing role.
###
+from MonetDBtesting.sqltest import SQLTestCase
-import os, sys
-try:
- from MonetDBtesting import process
-except ImportError:
- import process
+with SQLTestCase() as tc:
+ tc.connect(username="monetdb", password="monetdb")
+ tc.execute("""
+ REVOKE bankAdmin from april;
+ CREATE ROLE bankAdmin2;
+ GRANT bankAdmin2 to april;
+ DROP ROLE bankAdmin2;
+ """).assertSucceeded()
+ tc.execute("DROP ROLE bankAdmin3; -- role doesn't exist").assertFailed()
-def sql_test_client(user, passwd, input):
- with process.client(lang="sql", user=user, passwd=passwd, communicate=True,
- stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE,
- input=input, port=int(os.getenv("MAPIPORT"))) as c:
- c.communicate()
+ tc.connect(username="april", password="april")
+ tc.execute("SET ROLE bankAdmin; -- role revoked").assertFailed()
+ tc.execute("SET ROLE bankAdmin2; -- role no longer exists").assertFailed()
-sql_test_client('monetdb', 'monetdb', input="""\
-REVOKE bankAdmin from april;
-CREATE ROLE bankAdmin2;
-GRANT bankAdmin2 to april;
-DROP ROLE bankAdmin2;
-DROP ROLE bankAdmin3; -- role doesn't exist
-""")
+# import os, sys
+# try:
+# from MonetDBtesting import process
+# except ImportError:
+# import process
+
+# def sql_test_client(user, passwd, input):
+# with process.client(lang="sql", user=user, passwd=passwd,
communicate=True,
+# stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE,
+# input=input, port=int(os.getenv("MAPIPORT"))) as c:
+# c.communicate()
-sql_test_client('april', 'april', input="""\
-SET ROLE bankAdmin; -- role revoked
-SET ROLE bankAdmin2; -- role no longer exists
-""")
+# sql_test_client('monetdb', 'monetdb', input="""\
+# REVOKE bankAdmin from april;
+# CREATE ROLE bankAdmin2;
+# GRANT bankAdmin2 to april;
+# DROP ROLE bankAdmin2;
+# DROP ROLE bankAdmin3; -- role doesn't exist
+# """)
+
+# sql_test_client('april', 'april', input="""\
+# SET ROLE bankAdmin; -- role revoked
+# SET ROLE bankAdmin2; -- role no longer exists
+# """)
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
