Changeset: 260f3e9db10b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=260f3e9db10b
Modified Files:
sql/test/Users/Tests/privs.test
sql/test/Users/Tests/table.SQL.py
sql/test/Users/Tests/test_privs_p1.SQL.py
Branch: mtest
Log Message:
more users tests
diffs (40 lines):
diff --git a/sql/test/Users/Tests/privs.test b/sql/test/Users/Tests/privs.test
--- a/sql/test/Users/Tests/privs.test
+++ b/sql/test/Users/Tests/privs.test
@@ -18,4 +18,3 @@ GRANT UPDATE on table test to my_user
statement ok
GRANT DELETE on table test to my_user
-
diff --git a/sql/test/Users/Tests/table.SQL.py
b/sql/test/Users/Tests/table.SQL.py
--- a/sql/test/Users/Tests/table.SQL.py
+++ b/sql/test/Users/Tests/table.SQL.py
@@ -14,7 +14,9 @@ with SQLTestCase() as tc:
time_e BIGINT NULL,
PRIMARY KEY (obsid)
) """).assertSucceeded()
- tc.execute("INSERT INTO my_schema.my_table (time_s) values
(300)").assertRowCount(1)
+ tc.execute("INSERT INTO my_schema.my_table (time_s) values (300)")\
+ .assertSucceeded()\
+ .assertRowCount(1)
# import os, sys
# import pymonetdb
diff --git a/sql/test/Users/Tests/test_privs_p1.SQL.py
b/sql/test/Users/Tests/test_privs_p1.SQL.py
--- a/sql/test/Users/Tests/test_privs_p1.SQL.py
+++ b/sql/test/Users/Tests/test_privs_p1.SQL.py
@@ -6,10 +6,10 @@ from MonetDBtesting.sqltest import SQLTe
with SQLTestCase() as tc:
tc.connect(username="my_user", password="p1")
- tc.execute("select * from test").assertRowCount(0)
- tc.execute("insert into test values(1,1)").assertRowCount(1)
- tc.execute("update test set b = 2").assertRowCount(1)
- tc.execute("delete from test").assertRowCount(1)
+ tc.execute("select * from test").assertSucceeded().assertRowCount(0)
+ tc.execute("insert into test
values(1,1)").assertSucceeded().assertRowCount(1)
+ tc.execute("update test set b = 2").assertSucceeded().assertRowCount(1)
+ tc.execute("delete from test").assertSucceeded().assertRowCount(1)
# import os, sys
# import pymonetdb
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list