com.goldencode.p2j.persist.orm

Class TenantManager.TenantSQL

java.lang.Object

com.goldencode.p2j.persist.orm.TenantManager.TenantSQL

Enclosing class:

TenantManager

private static class TenantManager.TenantSQL
extends java.lang.Object

Inner class responsible with storing SQLs that will be further used to manage tenants.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	CREATE_DATABASES_TABLE SQL for creating the tenant_databases table, if it doesn't already exist.
private static java.lang.String	CREATE_DOMAIN_INDEX SQL for creating an index for the sec_authentication_domain table.
private static java.lang.String	CREATE_DOMAIN_TABLE SQL for creating the sec_authentication_domain table, if it doesn't already exist.
private static java.lang.String	CREATE_MASTER_INDEX SQL for creating an index for the master table on the tenant_name column.
private static java.lang.String	CREATE_MASTER_TABLE SQL for creating the master table, if it doesn't already exist.
private static java.lang.String	CREATE_SYSTEM_INDEX SQL for creating an index for the sec_authentication_system table.
private static java.lang.String	CREATE_SYSTEM_TABLE SQL for creating the sec_authentication_system table, if it doesn't already exist.
private static java.lang.String	CREATE_TENANT_DB_INDEX SQL for creating an index for the tenant_databases table.
private static java.lang.String	DELETE_TENANT SQL used for deleting a tenant based on the tenant name value.
private static java.lang.String	DELETE_TENANT_DATABASE SQL used for deleting a database specific to a tenant from the tenant_databases table.
private static java.lang.String	DELETE_TENANT_DATABASES SQL used for deleting all the databases specific to a tenant from the tenant_databases table.
private static java.lang.String	ENABLE_TENANT SQL used for enabling/disabling a tenant.
private static java.lang.String	INSERT_TENANT SQL used for inserting a tenant into the master table.
private static java.lang.String	INSERT_TENANT_DATABASES SQL used for inserting a database into the tenant_databases table.
private static java.lang.String	IS_TENANT_ENABLED SQL used to check if a tenant is enabled or not.
private static java.lang.String	SELECT_ALL_TENANTS SQL for retrieving all the tenants.
private static java.lang.String	SELECT_DOMAIN_TYPES SQL used for selecting the domain types from the sec_authentication_system table.
private static java.lang.String	SELECT_DOMAINS SQL used for selecting the domains from the sec_authentication_domain table.
private static java.lang.String	SELECT_TENANT_DATABASE SQL for retrieving the information of a specific database, of a specific tenant.
private static java.lang.String	SELECT_TENANT_DATABASES SQL for retrieving the information of all databases of a specific tenant.
private static java.lang.String	SELECT_TENANT_NAME SQL used for selecting the tenant name based on a given domain name.
private static java.lang.String	UPDATE_DB_URL SQL used for updating the database URL for a tenant in the tenant_databases table.
private static java.lang.String	UPDATE_LDB_NAME SQL used for updating the database logical name of a tenant in the tenant_databases table.
private static java.lang.String	UPDATE_PASSWORD SQL used for updating the database password for a tenant in the tenant_databases table.
private static java.lang.String	UPDATE_PDB_NAME SQL used for updating the database physical name of a tenant in the tenant_databases table.
private static java.lang.String	UPDATE_TENANT_DB_NAME SQL used for updating a tenant's name in the tenant_databases table.
private static java.lang.String	UPDATE_TENANT_NAME SQL used for updating a tenant's name in the master table.
private static java.lang.String	UPDATE_USERNAME SQL used for updating the database username for a tenant in the tenant_databases table.

Constructor Summary

Constructors

Modifier	Constructor and Description
private	TenantSQL()

Method Summary

Methods inherited from class java.lang.Object

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

Field Detail

CREATE_MASTER_TABLE

private static final java.lang.String CREATE_MASTER_TABLE

SQL for creating the master table, if it doesn't already exist.

See Also:

Constant Field Values

CREATE_DATABASES_TABLE

private static final java.lang.String CREATE_DATABASES_TABLE

SQL for creating the tenant_databases table, if it doesn't already exist.

See Also:

Constant Field Values

CREATE_SYSTEM_TABLE

private static final java.lang.String CREATE_SYSTEM_TABLE

SQL for creating the sec_authentication_system table, if it doesn't already exist.

See Also:

Constant Field Values

CREATE_DOMAIN_TABLE

private static final java.lang.String CREATE_DOMAIN_TABLE

SQL for creating the sec_authentication_domain table, if it doesn't already exist.

See Also:

Constant Field Values

CREATE_MASTER_INDEX

private static final java.lang.String CREATE_MASTER_INDEX

SQL for creating an index for the master table on the tenant_name column.

See Also:

Constant Field Values

CREATE_TENANT_DB_INDEX

private static final java.lang.String CREATE_TENANT_DB_INDEX

SQL for creating an index for the tenant_databases table.

See Also:

Constant Field Values

CREATE_SYSTEM_INDEX

private static final java.lang.String CREATE_SYSTEM_INDEX

SQL for creating an index for the sec_authentication_system table.

See Also:

Constant Field Values

CREATE_DOMAIN_INDEX

private static final java.lang.String CREATE_DOMAIN_INDEX

SQL for creating an index for the sec_authentication_domain table.

See Also:

Constant Field Values

SELECT_ALL_TENANTS

private static final java.lang.String SELECT_ALL_TENANTS

SQL for retrieving all the tenants.

See Also:

Constant Field Values

SELECT_TENANT_DATABASE

private static final java.lang.String SELECT_TENANT_DATABASE

SQL for retrieving the information of a specific database, of a specific tenant.

See Also:

Constant Field Values

SELECT_TENANT_DATABASES

private static final java.lang.String SELECT_TENANT_DATABASES

SQL for retrieving the information of all databases of a specific tenant.

See Also:

Constant Field Values

INSERT_TENANT

private static final java.lang.String INSERT_TENANT

SQL used for inserting a tenant into the master table.

See Also:

Constant Field Values

INSERT_TENANT_DATABASES

private static final java.lang.String INSERT_TENANT_DATABASES

SQL used for inserting a database into the tenant_databases table.

See Also:

Constant Field Values

UPDATE_TENANT_NAME

private static final java.lang.String UPDATE_TENANT_NAME

SQL used for updating a tenant's name in the master table.

See Also:

Constant Field Values

UPDATE_TENANT_DB_NAME

private static final java.lang.String UPDATE_TENANT_DB_NAME

SQL used for updating a tenant's name in the tenant_databases table.

See Also:

Constant Field Values

UPDATE_PDB_NAME

private static final java.lang.String UPDATE_PDB_NAME

SQL used for updating the database physical name of a tenant in the tenant_databases table.

See Also:

Constant Field Values

UPDATE_LDB_NAME

private static final java.lang.String UPDATE_LDB_NAME

SQL used for updating the database logical name of a tenant in the tenant_databases table.

See Also:

Constant Field Values

UPDATE_DB_URL

private static final java.lang.String UPDATE_DB_URL

SQL used for updating the database URL for a tenant in the tenant_databases table.

See Also:

Constant Field Values

UPDATE_USERNAME

private static final java.lang.String UPDATE_USERNAME

SQL used for updating the database username for a tenant in the tenant_databases table.

See Also:

Constant Field Values

UPDATE_PASSWORD

private static final java.lang.String UPDATE_PASSWORD

SQL used for updating the database password for a tenant in the tenant_databases table.

See Also:

Constant Field Values

ENABLE_TENANT

private static final java.lang.String ENABLE_TENANT

SQL used for enabling/disabling a tenant.

See Also:

Constant Field Values

IS_TENANT_ENABLED

private static final java.lang.String IS_TENANT_ENABLED

SQL used to check if a tenant is enabled or not.

See Also:

Constant Field Values

DELETE_TENANT

private static final java.lang.String DELETE_TENANT

SQL used for deleting a tenant based on the tenant name value.

See Also:

Constant Field Values

DELETE_TENANT_DATABASE

private static final java.lang.String DELETE_TENANT_DATABASE

SQL used for deleting a database specific to a tenant from the tenant_databases table.

See Also:

Constant Field Values

DELETE_TENANT_DATABASES

private static final java.lang.String DELETE_TENANT_DATABASES

SQL used for deleting all the databases specific to a tenant from the tenant_databases table.

See Also:

Constant Field Values

SELECT_DOMAINS

private static final java.lang.String SELECT_DOMAINS

SQL used for selecting the domains from the sec_authentication_domain table.

See Also:

Constant Field Values

SELECT_DOMAIN_TYPES

private static final java.lang.String SELECT_DOMAIN_TYPES

SQL used for selecting the domain types from the sec_authentication_system table.

See Also:

Constant Field Values

SELECT_TENANT_NAME

private static final java.lang.String SELECT_TENANT_NAME

SQL used for selecting the tenant name based on a given domain name.

See Also:

Constant Field Values

Constructor Detail

TenantSQL

private TenantSQL()