Repository: sentry Updated Branches: refs/heads/master 985f4ad59 -> ddae7c04e
SENTRY-1405: Add test for "show grant role on all " command in V2 (Ke, Jia via Dapeng Sun) Project: http://git-wip-us.apache.org/repos/asf/sentry/repo Commit: http://git-wip-us.apache.org/repos/asf/sentry/commit/64fb094a Tree: http://git-wip-us.apache.org/repos/asf/sentry/tree/64fb094a Diff: http://git-wip-us.apache.org/repos/asf/sentry/diff/64fb094a Branch: refs/heads/master Commit: 64fb094abef815ea87cc79056bbcc4e65faaced1 Parents: 985f4ad Author: Sun Dapeng <[email protected]> Authored: Wed Aug 10 14:33:14 2016 +0800 Committer: Sun Dapeng <[email protected]> Committed: Wed Aug 10 14:33:14 2016 +0800 ---------------------------------------------------------------------- .../e2e/dbprovider/TestDatabaseProvider.java | 24 ++++++++++++++++++++ 1 file changed, 24 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/sentry/blob/64fb094a/sentry-tests/sentry-tests-hive-v2/src/test/java/org/apache/sentry/tests/e2e/dbprovider/TestDatabaseProvider.java ---------------------------------------------------------------------- diff --git a/sentry-tests/sentry-tests-hive-v2/src/test/java/org/apache/sentry/tests/e2e/dbprovider/TestDatabaseProvider.java b/sentry-tests/sentry-tests-hive-v2/src/test/java/org/apache/sentry/tests/e2e/dbprovider/TestDatabaseProvider.java index 8cfd0d0..4a55b5d 100644 --- a/sentry-tests/sentry-tests-hive-v2/src/test/java/org/apache/sentry/tests/e2e/dbprovider/TestDatabaseProvider.java +++ b/sentry-tests/sentry-tests-hive-v2/src/test/java/org/apache/sentry/tests/e2e/dbprovider/TestDatabaseProvider.java @@ -2188,4 +2188,28 @@ public class TestDatabaseProvider extends AbstractTestWithStaticConfiguration { statement.close(); connection.close(); } + + @Test + public void testShowGrantOnALL() throws Exception { + + // setup db objects needed by the test + Connection connection = context.createConnection(ADMIN1); + Statement statement = context.createStatement(connection); + statement.execute("DROP DATABASE IF EXISTS db_1 CASCADE"); + statement.execute("DROP DATABASE IF EXISTS db_2 CASCADE"); + statement.execute("CREATE DATABASE db_1"); + statement.execute("CREATE ROLE group1_role"); + statement.execute("GRANT ALL ON DATABASE db_1 TO ROLE group1_role"); + statement.execute("grant select on database db_1 to role group1_role"); + ResultSet res = statement.executeQuery("show grant role group1_role on all"); + List<String> returnedResult = new ArrayList<String>(); + List<String> expectedResult = new ArrayList<String>(); + expectedResult.add("db_1"); + while (res.next()) { + returnedResult.add(res.getString(1).trim()); + } + validateReturnedResult(expectedResult, returnedResult); + connection.close(); + } } +
