Changeset: 9cd72a388d7f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9cd72a388d7f
Modified Files:
sql/test/Users/Tests/changeSchemaUser.SQL.py
Branch: mtest
Log Message:
convert tests for changeSchemaUser
diffs (77 lines):
diff --git a/sql/test/Users/Tests/changeSchemaUser.SQL.py
b/sql/test/Users/Tests/changeSchemaUser.SQL.py
--- a/sql/test/Users/Tests/changeSchemaUser.SQL.py
+++ b/sql/test/Users/Tests/changeSchemaUser.SQL.py
@@ -5,36 +5,48 @@
# Drop a user that owns a schema (not possible).
###
-import os, sys
-try:
- from MonetDBtesting import process
-except ImportError:
- import process
+from MonetDBtesting.sqltest import SQLTestCase
-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()
+with SQLTestCase() as tc:
+ tc.connect(username="monetdb", password="monetdb")
+ tc.execute('ALTER USER "april" SET SCHEMA library').assertSucceeded()
+ tc.execute('ALTER USER "april2" SET SCHEMA library; --no such
user').assertFailed()
+ tc.execute('ALTER USER "april" SET SCHEMA library2; --no such
schema').assertFailed()
+ tc.execute('SELECT * from bank.accounts; --no such
table.').assertSucceeded()
+ tc.execute('SELECT * from library.orders; --not enough
privileges.').assertSucceeded()
+ tc.execute('ALTER USER "april" SET SCHEMA bank;').assertSucceeded()
+ tc.execute('CREATE SCHEMA forAlice AUTHORIZATION april;').assertSucceeded()
+ tc.execute('DROP user april;').assertFailed()
+# import os, sys
+# try:
+# from MonetDBtesting import process
+# except ImportError:
+# import process
-sql_test_client('monetdb', 'monetdb', input="""\
-ALTER USER "april" SET SCHEMA library;
-ALTER USER "april2" SET SCHEMA library; --no such user
-ALTER USER "april" SET SCHEMA library2; --no such schema
-""")
+# 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()
-# This is the new april, so these operations should fail.
-sql_test_client('april', 'april', input="""\
-SELECT * from bank.accounts; --no such table.
-SELECT * from library.orders; --not enough privileges.
-""")
+# sql_test_client('monetdb', 'monetdb', input="""\
+# ALTER USER "april" SET SCHEMA library;
+# ALTER USER "april2" SET SCHEMA library; --no such user
+# ALTER USER "april" SET SCHEMA library2; --no such schema
+# """)
+
+# # This is the new april, so these operations should fail.
+# sql_test_client('april', 'april', input="""\
+# SELECT * from bank.accounts; --no such table.
+# SELECT * from library.orders; --not enough privileges.
+# """)
-sql_test_client('monetdb', 'monetdb', input="""\
-ALTER USER "april" SET SCHEMA bank;
-CREATE SCHEMA forAlice AUTHORIZATION april;
-DROP user april;
-""")
+# sql_test_client('monetdb', 'monetdb', input="""\
+# ALTER USER "april" SET SCHEMA bank;
+# CREATE SCHEMA forAlice AUTHORIZATION april;
+# DROP user april;
+# """)
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
