Changeset: 436e95869a36 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=436e95869a36
Modified Files:
sql/test/Users/Tests/test_privs_p2.SQL.py
Branch: mtest
Log Message:
convert tests for test_privs_p2
diffs (89 lines):
diff --git a/sql/test/Users/Tests/test_privs_p2.SQL.py
b/sql/test/Users/Tests/test_privs_p2.SQL.py
--- a/sql/test/Users/Tests/test_privs_p2.SQL.py
+++ b/sql/test/Users/Tests/test_privs_p2.SQL.py
@@ -2,43 +2,53 @@
# SELECT, INSERT, UPDATE, DELETE a table for which the USER does *not* have
GRANTs (not possible).
###
-import os, sys
-import pymonetdb
+
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ tc.connect(username="my_user2", password="p2")
+ tc.execute("select * from test").assertFailed()
+ tc.execute("insert into test values(1,1)").assertFailed()
+ tc.execute("update test set b = 2").assertFailed()
+ tc.execute("delete from test").assertFailed()
+
+# import os, sys
+# import pymonetdb
-db=os.getenv("TSTDB")
-port=int(os.getenv("MAPIPORT"))
-client = pymonetdb.connect(database=db, port=port, autocommit=True,
user='my_user2', password='p2')
-cursor = client.cursor()
+# db=os.getenv("TSTDB")
+# port=int(os.getenv("MAPIPORT"))
+# client = pymonetdb.connect(database=db, port=port, autocommit=True,
user='my_user2', password='p2')
+# cursor = client.cursor()
-err=0
-try:
- nr=cursor.execute("select * from test")
-except:
- err=1
- pass
+# err=0
+# try:
+# nr=cursor.execute("select * from test")
+# except:
+# err=1
+# pass
-try:
- rowaffected=cursor.execute("insert into test values(1,1)")
-except:
- err=err+2
- pass
+# try:
+# rowaffected=cursor.execute("insert into test values(1,1)")
+# except:
+# err=err+2
+# pass
-try:
- rowaffected=cursor.execute("update test set b = 2")
-except:
- err=err+4
- pass
+# try:
+# rowaffected=cursor.execute("update test set b = 2")
+# except:
+# err=err+4
+# pass
-try:
- rowaffected=cursor.execute("delete from test")
-except:
- err=err+8
- pass
+# try:
+# rowaffected=cursor.execute("delete from test")
+# except:
+# err=err+8
+# pass
-if err != 15:
- print("User should have no access too this table\n", file=sys.stderr)
- sys.exit(-1)
+# if err != 15:
+# print("User should have no access too this table\n", file=sys.stderr)
+# sys.exit(-1)
-cursor.close()
-client.close()
+# cursor.close()
+# client.close()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
