Changeset: 748198ac0ef6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=748198ac0ef6
Added Files:
sql/test/Users/Tests/createSetUp.test
sql/test/Users/Tests/metadataConsistency.test
sql/test/Users/Tests/privs.test
sql/test/Users/Tests/privs2.test
sql/test/Users/Tests/sessioncontrol.test
Modified Files:
sql/test/Users/Tests/table.SQL.py
sql/test/Users/Tests/table.stable.out
sql/test/Users/Tests/test_privs_p1.SQL.py
sql/test/Users/Tests/test_privs_p1.stable.out
sql/test/Users/Tests/unknown_user.SQL.py
Branch: mtest
Log Message:
some more tests converted
diffs (truncated from 596 to 300 lines):
diff --git a/sql/test/Users/Tests/createSetUp.test
b/sql/test/Users/Tests/createSetUp.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/createSetUp.test
@@ -0,0 +1,34 @@
+statement ok
+CREATE SCHEMA library
+
+statement ok
+CREATE ROLE libraryWorker
+
+statement ok
+CREATE TABLE library.orders(price int, name VARCHAR(100))
+
+statement ok
+CREATE ROLE bankAdmin
+
+statement ok
+CREATE SCHEMA bank AUTHORIZATION bankAdmin
+
+statement ok
+CREATE TABLE bank.accounts(nr int, name VARCHAR(100))
+
+statement ok
+CREATE TABLE bank.loans(nr int, amount int)
+
+statement ok
+CREATE USER alice WITH PASSWORD 'alice' name 'alice' schema library
+
+statement ok
+CREATE USER april WITH PASSWORD 'april' name 'april' schema bank
+
+statement ok
+GRANT ALL ON bank.accounts to april
+
+statement ok
+GRANT bankAdmin to april
+
+
diff --git a/sql/test/Users/Tests/metadataConsistency.test
b/sql/test/Users/Tests/metadataConsistency.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/metadataConsistency.test
@@ -0,0 +1,63 @@
+statement ok
+create schema qdv
+
+statement ok
+set schema qdv
+
+query T rowsort
+select current_schema
+----
+qdv
+
+statement ok
+create user "jtest" with unencrypted password 'wacht01' name 'Jan Test' schema
"sys"
+
+query I rowsort
+select privileges from sys.privileges where auth_id = (select id from
sys.auths where name = 'jtest')
+----
+
+statement ok
+create table abem (col1 int)
+
+statement ok
+grant select on abem to "jtest"
+
+query I rowsort
+select privileges from sys.privileges where auth_id = (select id from
sys.auths where name = 'jtest')
+----
+1
+
+statement ok
+grant insert, update, delete, truncate on abem to "jtest"
+
+query I rowsort
+select privileges from sys.privileges where auth_id = (select id from
sys.auths where name = 'jtest')
+----
+1
+2
+4
+64
+8
+
+statement ok
+drop user "jtest"
+
+query I rowsort
+select privileges from sys.privileges where auth_id = (select id from
sys.auths where name = 'jtest')
+----
+
+statement ok
+drop table abem
+
+statement ok
+set schema sys
+
+query T rowsort
+select current_schema
+----
+sys
+
+statement ok
+drop schema qdv
+
+
diff --git a/sql/test/Users/Tests/privs.test b/sql/test/Users/Tests/privs.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/privs.test
@@ -0,0 +1,19 @@
+statement ok
+set schema "my_schema"
+
+statement ok
+CREATE table test (i int, b bigint)
+
+statement ok
+GRANT SELECT on table test to my_user
+
+statement ok
+GRANT INSERT on table test to my_user
+
+statement ok
+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/privs2.test b/sql/test/Users/Tests/privs2.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/privs2.test
@@ -0,0 +1,92 @@
+statement ok
+set schema "my_schema"
+
+statement ok
+create table version
+ (name varchar(10)
+ ,i int
+ )
+
+
+statement ok
+insert into version
+ (name
+ ,i
+ )
+values
+ ('test1'
+ ,1
+ )
+
+
+statement ok
+create function insertversion(iname varchar(10)
+ ,ii int
+ ) returns int
+begin
+ insert into version
+ (name
+ ,i
+ )
+ values
+ (iname
+ ,ii
+ )
+ ;
+ return 1;
+end
+
+statement ok
+create function updateversion(iname varchar(10)
+ ,ii int
+ ) returns int
+begin
+ update version
+ set i = ii
+ where name = iname
+ ;
+ return 1;
+end
+
+statement ok
+create function deleteversion(iname varchar(10)
+ ) returns int
+begin
+ delete
+ from version
+ where name = iname
+ ;
+ return 1;
+end
+
+statement ok
+GRANT SELECT on table version to my_user
+
+statement ok
+GRANT INSERT on table version to my_user
+
+statement ok
+GRANT UPDATE on table version to my_user
+
+statement ok
+GRANT DELETE on table version to my_user
+
+statement ok
+GRANT EXECUTE on function insertversion to my_user
+
+statement ok
+GRANT EXECUTE on function updateversion to my_user
+
+statement ok
+GRANT EXECUTE on function deleteversion to my_user
+
+statement ok
+GRANT EXECUTE on function insertversion to my_user2
+
+statement ok
+GRANT EXECUTE on function updateversion to my_user2
+
+statement ok
+GRANT EXECUTE on function deleteversion to my_user2
+
+
diff --git a/sql/test/Users/Tests/sessioncontrol.test
b/sql/test/Users/Tests/sessioncontrol.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/sessioncontrol.test
@@ -0,0 +1,186 @@
+query ITTIIII rowsort
+select sessionid, s."username", s."optimizer", s.sessiontimeout,
s.querytimeout, s.workerlimit, s.memorylimit from sessions as s
+----
+0
+monetdb
+default_pipe
+0
+0
+0
+0
+
+query ITTIIII rowsort
+call setoptimizer('minimal_pipe')
+----
+0
+monetdb
+default_pipe
+0
+0
+0
+0
+
+query ITTIIII rowsort
+call setsessiontimeout(5000)
+----
+0
+monetdb
+default_pipe
+0
+0
+0
+0
+
+query ITTIIII rowsort
+call setquerytimeout(123)
+----
+0
+monetdb
+default_pipe
+0
+0
+0
+0
+
+query ITTIIII rowsort
+call setworkerlimit(12)
+----
+0
+monetdb
+default_pipe
+0
+0
+0
+0
+
+query ITTIIII rowsort
+call setmemorylimit(8000)
+----
+0
+monetdb
+default_pipe
+0
+0
+0
+0
+
+query ITTIIII rowsort
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
