Changeset: 2648527ba582 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2648527ba582
Added Files:
sql/test/Users/Tests/user_default_schema.SQL.py
Modified Files:
sql/test/Users/Tests/All
Branch: userprofile
Log Message:
add test
diffs (30 lines):
diff --git a/sql/test/Users/Tests/All b/sql/test/Users/Tests/All
--- a/sql/test/Users/Tests/All
+++ b/sql/test/Users/Tests/All
@@ -17,3 +17,4 @@ unknown_user
userCallFunction
withGrantOption
user_default_role
+user_default_schema
diff --git a/sql/test/Users/Tests/user_default_schema.SQL.py
b/sql/test/Users/Tests/user_default_schema.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/user_default_schema.SQL.py
@@ -0,0 +1,17 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ tc.connect(username="monetdb", password="monetdb")
+ tc.execute("create user bar with password 'bar' name 'full name
bar'").assertSucceeded()
+ with SQLTestCase() as tc:
+ tc.connect(username="bar", password="bar")
+ tc.execute("select current_user").assertValue('bar')
+ tc.execute("select current_role").assertValue('bar')
+ tc.execute("select current_schema").assertValue('bar')
+ tc.execute("create table beers(name VARCHAR(20))").assertSucceeded()
+ tc.execute("insert into beers values ('Amstel'), ('Grolsch'),
('Brand')").assertSucceeded()
+ with SQLTestCase() as tc:
+ tc.connect(username="monetdb", password="monetdb")
+ tc.execute('select count(*) from bar.beers').assertValue(3)
+
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
