Changeset: e8199356114f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e8199356114f
Added Files:
sql/test/Users/Tests/changeSchemaUser.reqtests
Modified Files:
sql/test/Users/Tests/changeSchemaUser.SQL.py
Branch: mtest
Log Message:
convert changeSchemaUserTests
diffs (32 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
@@ -10,17 +10,17 @@ from MonetDBtesting.sqltest import SQLTe
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(err_message="ALTER USER: no such user 'april2'")
- tc.execute('ALTER USER "april" SET SCHEMA library2; --no such
schema').assertFailed(err_message="ALTER USER: no such schema 'library2'")
+ 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.connect(username="april", password="april")
- tc.execute('SELECT * from bank.accounts; --no such
table.').assertSucceeded().assertSucceeded().assertRowCount(0).assertDataResultMatch([])
- tc.execute('SELECT * from library.orders; --not enough
privileges.').assertFailed(err_message="SELECT: access denied for april to
table 'library.orders'")
+ tc.execute('SELECT * from bank.accounts; --no such
table.').assertSucceeded()
+ tc.execute('SELECT * from library.orders; --not enough
privileges.').assertFailed()
tc.connect(username="monetdb", password="monetdb")
tc.execute('ALTER USER "april" SET SCHEMA bank;').assertSucceeded()
tc.execute('CREATE SCHEMA forAlice AUTHORIZATION april;').assertSucceeded()
- tc.execute('DROP user april;').assertFailed(err_message="DROP USER:
'april' owns a schema")
+ tc.execute('DROP user april;').assertFailed()
# import os, sys
# try:
diff --git a/sql/test/Users/Tests/changeSchemaUser.reqtests
b/sql/test/Users/Tests/changeSchemaUser.reqtests
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/changeSchemaUser.reqtests
@@ -0,0 +1,1 @@
+createSetUp
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
