org.wso2.carbon.analytics.permissions.internal.dao

Class QueryManager

java.lang.Object

org.wso2.carbon.analytics.permissions.internal.dao.QueryManager

public class QueryManager
extends Object

Provides SQl queries for the common permission model.

Field Summary

Fields

Modifier and Type	Field and Description
static String	ADD_PERMISSION_QUERY
static String	CHECK_PERMISSION_EXISTS_QUERY
static String	CREATE_PERMISSION_TABLE_QUERY
static String	CREATE_ROLE_PERMISSIONS_TABLE_QUERY
static String	DELETE_PERMISSION_BY_ID_QUERY
static String	DELETE_PERMISSION_QUERY
static String	GET_APPNAME_QUERY
static String	GET_GRANTED_ROLES_BY_PERMISSION_ID_QUERY
static String	GET_GRANTED_ROLES_QUERY
static String	GET_PERMISSION_QUERY
static String	GRANT_PERMISSION_QUERY
static String	HAS_PERMISSION_BY_PERMISSION_ID_QUERY
static String	HAS_PERMISSION_QUERY
static String	PERMISSIONS_TABLE
static String	REVOKE_PERMISSION_BY_PERMISSION_ID_QUERY
static String	REVOKE_PERMISSION_BY_ROLE_ID_QUERY
static String	REVOKE_PERMISSION_BY_ROLE_QUERY
static String	REVOKE_PERMISSION_QUERY
static String	ROLE_PERMISSIONS_TABLE
static String	TABLE_CHECK_QUERY
static String	TABLE_NAME_PLACEHOLDER

Constructor Summary

Constructors

Constructor and Description
QueryManager(PermissionConfig permissionConfig)

Method Summary

Modifier and Type	Method and Description
String	getQuery(Connection connection, String key) Get SQL query.
String	getQuery(String dbType, String dbVersion, String key) Get SQL query for specific database type and version.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CREATE_PERMISSION_TABLE_QUERY

public static final String CREATE_PERMISSION_TABLE_QUERY

See Also:

Constant Field Values

CREATE_ROLE_PERMISSIONS_TABLE_QUERY

public static final String CREATE_ROLE_PERMISSIONS_TABLE_QUERY

See Also:

Constant Field Values

TABLE_CHECK_QUERY

public static final String TABLE_CHECK_QUERY

See Also:

Constant Field Values

GET_PERMISSION_QUERY

public static final String GET_PERMISSION_QUERY

See Also:

Constant Field Values

GET_APPNAME_QUERY

public static final String GET_APPNAME_QUERY

See Also:

Constant Field Values

ADD_PERMISSION_QUERY

public static final String ADD_PERMISSION_QUERY

See Also:

Constant Field Values

CHECK_PERMISSION_EXISTS_QUERY

public static final String CHECK_PERMISSION_EXISTS_QUERY

See Also:

Constant Field Values

DELETE_PERMISSION_QUERY

public static final String DELETE_PERMISSION_QUERY

See Also:

Constant Field Values

DELETE_PERMISSION_BY_ID_QUERY

public static final String DELETE_PERMISSION_BY_ID_QUERY

See Also:

Constant Field Values

GRANT_PERMISSION_QUERY

public static final String GRANT_PERMISSION_QUERY

See Also:

Constant Field Values

REVOKE_PERMISSION_QUERY

public static final String REVOKE_PERMISSION_QUERY

See Also:

Constant Field Values

REVOKE_PERMISSION_BY_PERMISSION_ID_QUERY

public static final String REVOKE_PERMISSION_BY_PERMISSION_ID_QUERY

See Also:

Constant Field Values

REVOKE_PERMISSION_BY_ROLE_QUERY

public static final String REVOKE_PERMISSION_BY_ROLE_QUERY

See Also:

Constant Field Values

REVOKE_PERMISSION_BY_ROLE_ID_QUERY

public static final String REVOKE_PERMISSION_BY_ROLE_ID_QUERY

See Also:

Constant Field Values

HAS_PERMISSION_QUERY

public static final String HAS_PERMISSION_QUERY

See Also:

Constant Field Values

HAS_PERMISSION_BY_PERMISSION_ID_QUERY

public static final String HAS_PERMISSION_BY_PERMISSION_ID_QUERY

See Also:

Constant Field Values

GET_GRANTED_ROLES_QUERY

public static final String GET_GRANTED_ROLES_QUERY

See Also:

Constant Field Values

GET_GRANTED_ROLES_BY_PERMISSION_ID_QUERY

public static final String GET_GRANTED_ROLES_BY_PERMISSION_ID_QUERY

See Also:

Constant Field Values

PERMISSIONS_TABLE

public static final String PERMISSIONS_TABLE

See Also:

Constant Field Values

ROLE_PERMISSIONS_TABLE

public static final String ROLE_PERMISSIONS_TABLE

See Also:

Constant Field Values

TABLE_NAME_PLACEHOLDER

public static final String TABLE_NAME_PLACEHOLDER

See Also:

Constant Field Values

Constructor Detail

QueryManager

public QueryManager(PermissionConfig permissionConfig)

Method Detail

getQuery

public String getQuery(Connection connection,
                       String key)
                throws SQLException

Get SQL query.

Parameters:

connection - SQLConnection object.

key - Query key

Returns:

SQL query

Throws:

SQLException

getQuery

public String getQuery(String dbType,
                       String dbVersion,
                       String key)
                throws SQLException

Get SQL query for specific database type and version.

Parameters:

dbType - Database type

dbVersion - Database version

key - Query key

Returns:

SQL query

Throws:

SQLException