Changeset: 603f37dc61f5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=603f37dc61f5
Modified Files:
sql/test/Users/Tests/test_privs2_p2.SQL.py
Branch: mtest
Log Message:
convert tests for test_privs2_p2
diffs (119 lines):
diff --git a/sql/test/Users/Tests/test_privs2_p2.SQL.py
b/sql/test/Users/Tests/test_privs2_p2.SQL.py
--- a/sql/test/Users/Tests/test_privs2_p2.SQL.py
+++ b/sql/test/Users/Tests/test_privs2_p2.SQL.py
@@ -3,62 +3,71 @@
# table for which the USER does *not* have GRANTs (not possible).
###
+from MonetDBtesting.sqltest import SQLTestCase
-import os, sys
-import pymonetdb
+with SQLTestCase() as tc:
+ tc.connect(username="my_user2", password="p2")
+ tc.execute("SELECT * FROM version").assertFailed()
+ tc.execute("insert into version (name ,i) values ('test2'
,2)").assertFailed()
+ tc.execute("SELECT insertversion('test3', 3)").assertFailed()
+ tc.execute("SELECT updateversion('test1', 4)").assertFailed()
+ tc.execute("SELECT deleteversion('test1')").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()
-def sel1():
- err=0
- try:
- cursor.execute("SELECT * FROM version")
- except:
- err=1
- pass
- return err
+# def sel1():
+# err=0
+# try:
+# cursor.execute("SELECT * FROM version")
+# except:
+# err=1
+# pass
+# return err
-err = sel1()
+# err = sel1()
-try:
- cursor.execute("insert into version (name ,i) values ('test2' ,2)")
-except:
- err=err+2
- pass
+# try:
+# cursor.execute("insert into version (name ,i) values ('test2' ,2)")
+# except:
+# err=err+2
+# pass
-sel1()
+# sel1()
-try:
- cursor.execute("SELECT insertversion('test3', 3)")
-except:
- err=err+4
- pass
+# try:
+# cursor.execute("SELECT insertversion('test3', 3)")
+# except:
+# err=err+4
+# pass
-sel1()
+# sel1()
-try:
- cursor.execute("SELECT updateversion('test1', 4)")
-except:
- err=err+8
- pass
+# try:
+# cursor.execute("SELECT updateversion('test1', 4)")
+# except:
+# err=err+8
+# pass
-sel1()
+# sel1()
-try:
- cursor.execute("SELECT deleteversion('test1')")
-except:
- err=err+16
- pass
+# try:
+# cursor.execute("SELECT deleteversion('test1')")
+# except:
+# err=err+16
+# pass
-sel1()
+# sel1()
-if err != 31:
- print("User should have no access too this table\n")
- sys.exit(-1)
+# if err != 31:
+# print("User should have no access too this table\n")
+# 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
