Sirius.server.sql

Class PostgresSQLStatements

java.lang.Object

Sirius.server.sql.PostgresSQLStatements

All Implemented Interfaces:

DialectProvider, ServerSQLStatements

public final class PostgresSQLStatements
extends Object
implements ServerSQLStatements

DOCUMENT ME!

Version:

0.1

Author:

martin.scholl@cismet.de

Constructor Summary

Constructors

Constructor and Description
PostgresSQLStatements()

Method Summary

Modifier and Type	Method and Description
String	getClassGetDefaultInstanceStmnt(String tableName, String primaryKey) DOCUMENT ME!
String	getClassGetEmptyResultStmnt(String tableName) DOCUMENT ME!
String	getClassGetInstanceStmnt(String tableName, String primaryKey) DOCUMENT ME!
PreparableStatement	getDefaultFullTextSearchStmt(String searchText, String classesIn, PreparableStatement geoSql, boolean caseSensitive) DOCUMENT ME!
PreparableStatement	getDefaultGeoSearchStmt(String wkt, String srid, String classesIn) DOCUMENT ME!
String	getDialect() DOCUMENT ME!
String	getDistinctValuesSearchStmt(String metaClass, String attribute) DOCUMENT ME!
String	getIndexTriggerDeleteAttrObjectArrayStmt() DOCUMENT ME!
String	getIndexTriggerDeleteAttrObjectDerivedStmt() DOCUMENT ME!
String	getIndexTriggerDeleteAttrObjectObjectStmt() DOCUMENT ME!
String	getIndexTriggerDeleteAttrStringObjectStmt() DOCUMENT ME!
String	getIndexTriggerInsertAttrObjectDerivedStmt() DOCUMENT ME!
String	getIndexTriggerInsertAttrObjectStmt() DOCUMENT ME!
String	getIndexTriggerInsertAttrStringStmt() DOCUMENT ME!
String	getIndexTriggerSelectBackReferenceStmt(int classId, int fk) DOCUMENT ME!
String	getIndexTriggerSelectClassIdForeignKeyStmt(int classId) DOCUMENT ME!
String	getIndexTriggerSelectFieldStmt(int classId, int refClassId) DOCUMENT ME!
String	getIndexTriggerSelectFKIdStmt(String tableName, String backref, int classId) DOCUMENT ME!
String	getIndexTriggerSelectObjFieldStmt(String fieldName, String tableName, int classId) DOCUMENT ME!
String	getIndexTriggerSelectReindexPureStmt(int classId, int objectId) DOCUMENT ME!
String	getIndexTriggerSelectTableNameByClassIdStmt(int classId) DOCUMENT ME!
String	getIndexTriggerUpdateAttrObjectStmt() DOCUMENT ME!
String	getIndexTriggerUpdateAttrStringStmt() DOCUMENT ME!
String	getObjectFactoryAttrPermStmt(int classId, String implodedUserGroupIds) DOCUMENT ME!
String	getObjectFactoryGetObjectStmt(String tableName, String fieldname, String referenceKey, String orderByField) Creates the statement for selecting n-m and 1-n array elements.
String	getObjectHierarchyFatherArrayStmt(int father, String fatherPk, String fatherTable, String attribute, String arrayKey, String childTable, String childPk) DOCUMENT ME!
String	getObjectHierarchyFatherStmt(int father, String pk, String tableName, String fieldName) DOCUMENT ME!
String	getPasswordSwitcherAdminActionChangeAndBackupStmt(String loginNameToSwitch, String loginNameToRead) DOCUMENT ME!
String	getPasswordSwitcherAdminActionRecoveryStmt(String loginName) DOCUMENT ME!
String	getPasswordSwitcherAdminActionSelectUserStmt(String loginName) DOCUMENT ME!
String	getPersistenceHelperNextvalStmt(String tableName) DOCUMENT ME!
String	getPersistenceManagerDeleteFromStmt(String tableName, String fieldName) DOCUMENT ME!
PreparableStatement	getPersistenceManagerInsertStmt(String tableName, String... fieldNames) DOCUMENT ME!
PreparableStatement	getPersistenceManagerUpdateStmt(String tableName, String pkField, String... fieldNames) DOCUMENT ME!
String	getPolicyHolderServerPoliciesStmt() DOCUMENT ME!
String	getQueryEditorSearchPaginationStmt(String tableName, int classId, String whereClause, int limit, int offset) DOCUMENT ME!
String	getQueryEditorSearchStmt(String tableName, int classId, String whereClause) DOCUMENT ME!
String	getUserGroupIdentifiersUgIdentifiersStmt() DOCUMENT ME!
String	getVirtualTreeAddNodeLinkStmt(String domain, int fatherId, int childId) DOCUMENT ME!
String	getVirtualTreeAddNodeStatement(int nodeId, String nodeName, int classId, int objectId, char nodeType, boolean root, String policy) DOCUMENT ME!
String	getVirtualTreeClassTreeNodesStatement(String implodedUserGroupIds) DOCUMENT ME!
String	getVirtualTreeDeleteNodeLinkStmt(int nodeId) DOCUMENT ME!
String	getVirtualTreeDeleteNodeLinkStmt(String domain, int fatherId, int childId) DOCUMENT ME!
String	getVirtualTreeDeleteNodePermStmt(int nodeId) DOCUMENT ME!
String	getVirtualTreeDeleteNodeStmt(int nodeId) DOCUMENT ME!
String	getVirtualTreeGetNodeStmt(int nodeId, String implodedUserGroupIds) DOCUMENT ME!
String	getVirtualTreeHasNodesStmt(String classId, String objId) DOCUMENT ME!
String	getVirtualTreeInheritNodePermStmt(int fatherId, int childId) DOCUMENT ME!
String	getVirtualTreeInitNonLeafsStmt() DOCUMENT ME!
String	getVirtualTreeLocalChildrenStmt(boolean artificialIdSupported, String implodedUserGroupIds, int nodeId) DOCUMENT ME!
String	getVirtualTreeNextNodeIdStatement() DOCUMENT ME!
String	getVirtualTreeNodeIsLeafStmt(int nodeId) DOCUMENT ME!
String	getVirtualTreeRemoteChildrenStmt(String serverName, int nodeId) DOCUMENT ME!
String	getVirtualTreeTopNodesStatement(boolean artificialIdSupported, String implodedUserGroupIds) DOCUMENT ME!

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgresSQLStatements

public PostgresSQLStatements()

Method Detail

getVirtualTreeAddNodeStatement

public String getVirtualTreeAddNodeStatement(int nodeId,
                                             String nodeName,
                                             int classId,
                                             int objectId,
                                             char nodeType,
                                             boolean root,
                                             String policy)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeAddNodeStatement in interface ServerSQLStatements

Parameters:

nodeId - DOCUMENT ME!

nodeName - DOCUMENT ME!

classId - DOCUMENT ME!

objectId - DOCUMENT ME!

nodeType - DOCUMENT ME!

root - DOCUMENT ME!

policy - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeNextNodeIdStatement

public String getVirtualTreeNextNodeIdStatement()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeNextNodeIdStatement in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getVirtualTreeClassTreeNodesStatement

public String getVirtualTreeClassTreeNodesStatement(String implodedUserGroupIds)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeClassTreeNodesStatement in interface ServerSQLStatements

Parameters:

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeTopNodesStatement

public String getVirtualTreeTopNodesStatement(boolean artificialIdSupported,
                                              String implodedUserGroupIds)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeTopNodesStatement in interface ServerSQLStatements

Parameters:

artificialIdSupported - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeLocalChildrenStmt

public String getVirtualTreeLocalChildrenStmt(boolean artificialIdSupported,
                                              String implodedUserGroupIds,
                                              int nodeId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeLocalChildrenStmt in interface ServerSQLStatements

Parameters:

artificialIdSupported - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeRemoteChildrenStmt

public String getVirtualTreeRemoteChildrenStmt(String serverName,
                                               int nodeId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeRemoteChildrenStmt in interface ServerSQLStatements

Parameters:

serverName - DOCUMENT ME!

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodeStmt

public String getVirtualTreeDeleteNodeStmt(int nodeId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeDeleteNodeStmt in interface ServerSQLStatements

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodeLinkStmt

public String getVirtualTreeDeleteNodeLinkStmt(int nodeId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeDeleteNodeLinkStmt in interface ServerSQLStatements

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodePermStmt

public String getVirtualTreeDeleteNodePermStmt(int nodeId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeDeleteNodePermStmt in interface ServerSQLStatements

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeAddNodeLinkStmt

public String getVirtualTreeAddNodeLinkStmt(String domain,
                                            int fatherId,
                                            int childId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeAddNodeLinkStmt in interface ServerSQLStatements

Parameters:

domain - DOCUMENT ME!

fatherId - DOCUMENT ME!

childId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodeLinkStmt

public String getVirtualTreeDeleteNodeLinkStmt(String domain,
                                               int fatherId,
                                               int childId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeDeleteNodeLinkStmt in interface ServerSQLStatements

Parameters:

domain - DOCUMENT ME!

fatherId - DOCUMENT ME!

childId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeInheritNodePermStmt

public String getVirtualTreeInheritNodePermStmt(int fatherId,
                                                int childId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeInheritNodePermStmt in interface ServerSQLStatements

Parameters:

fatherId - DOCUMENT ME!

childId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeHasNodesStmt

public String getVirtualTreeHasNodesStmt(String classId,
                                         String objId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeHasNodesStmt in interface ServerSQLStatements

Parameters:

classId - DOCUMENT ME!

objId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeGetNodeStmt

public String getVirtualTreeGetNodeStmt(int nodeId,
                                        String implodedUserGroupIds)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeGetNodeStmt in interface ServerSQLStatements

Parameters:

nodeId - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeNodeIsLeafStmt

public String getVirtualTreeNodeIsLeafStmt(int nodeId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeNodeIsLeafStmt in interface ServerSQLStatements

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeInitNonLeafsStmt

public String getVirtualTreeInitNonLeafsStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getVirtualTreeInitNonLeafsStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getUserGroupIdentifiersUgIdentifiersStmt

public String getUserGroupIdentifiersUgIdentifiersStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getUserGroupIdentifiersUgIdentifiersStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getPolicyHolderServerPoliciesStmt

public String getPolicyHolderServerPoliciesStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPolicyHolderServerPoliciesStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getClassGetInstanceStmnt

public String getClassGetInstanceStmnt(String tableName,
                                       String primaryKey)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getClassGetInstanceStmnt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

primaryKey - DOCUMENT ME!

Returns:

DOCUMENT ME!

getClassGetDefaultInstanceStmnt

public String getClassGetDefaultInstanceStmnt(String tableName,
                                              String primaryKey)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getClassGetDefaultInstanceStmnt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

primaryKey - DOCUMENT ME!

Returns:

DOCUMENT ME!

getClassGetEmptyResultStmnt

public String getClassGetEmptyResultStmnt(String tableName)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getClassGetEmptyResultStmnt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectHierarchyFatherStmt

public String getObjectHierarchyFatherStmt(int father,
                                           String pk,
                                           String tableName,
                                           String fieldName)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getObjectHierarchyFatherStmt in interface ServerSQLStatements

Parameters:

father - DOCUMENT ME!

pk - DOCUMENT ME!

tableName - DOCUMENT ME!

fieldName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectHierarchyFatherArrayStmt

public String getObjectHierarchyFatherArrayStmt(int father,
                                                String fatherPk,
                                                String fatherTable,
                                                String attribute,
                                                String arrayKey,
                                                String childTable,
                                                String childPk)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getObjectHierarchyFatherArrayStmt in interface ServerSQLStatements

Parameters:

father - DOCUMENT ME!

fatherPk - DOCUMENT ME!

fatherTable - DOCUMENT ME!

attribute - DOCUMENT ME!

arrayKey - DOCUMENT ME!

childTable - DOCUMENT ME!

childPk - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPersistenceHelperNextvalStmt

public String getPersistenceHelperNextvalStmt(String tableName)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPersistenceHelperNextvalStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPersistenceManagerDeleteFromStmt

public String getPersistenceManagerDeleteFromStmt(String tableName,
                                                  String fieldName)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPersistenceManagerDeleteFromStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

fieldName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPersistenceManagerUpdateStmt

public PreparableStatement getPersistenceManagerUpdateStmt(String tableName,
                                                           String pkField,
                                                           String... fieldNames)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPersistenceManagerUpdateStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

pkField - DOCUMENT ME!

fieldNames - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPersistenceManagerInsertStmt

public PreparableStatement getPersistenceManagerInsertStmt(String tableName,
                                                           String... fieldNames)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPersistenceManagerInsertStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

fieldNames - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPasswordSwitcherAdminActionSelectUserStmt

public String getPasswordSwitcherAdminActionSelectUserStmt(String loginName)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPasswordSwitcherAdminActionSelectUserStmt in interface ServerSQLStatements

Parameters:

loginName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPasswordSwitcherAdminActionChangeAndBackupStmt

public String getPasswordSwitcherAdminActionChangeAndBackupStmt(String loginNameToSwitch,
                                                                String loginNameToRead)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPasswordSwitcherAdminActionChangeAndBackupStmt in interface ServerSQLStatements

Parameters:

loginNameToSwitch - DOCUMENT ME!

loginNameToRead - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPasswordSwitcherAdminActionRecoveryStmt

public String getPasswordSwitcherAdminActionRecoveryStmt(String loginName)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getPasswordSwitcherAdminActionRecoveryStmt in interface ServerSQLStatements

Parameters:

loginName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getDefaultFullTextSearchStmt

public PreparableStatement getDefaultFullTextSearchStmt(String searchText,
                                                        String classesIn,
                                                        PreparableStatement geoSql,
                                                        boolean caseSensitive)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getDefaultFullTextSearchStmt in interface ServerSQLStatements

Parameters:

searchText - DOCUMENT ME!

classesIn - DOCUMENT ME!

geoSql - DOCUMENT ME!

caseSensitive - DOCUMENT ME!

Returns:

DOCUMENT ME!

getDefaultGeoSearchStmt

public PreparableStatement getDefaultGeoSearchStmt(String wkt,
                                                   String srid,
                                                   String classesIn)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getDefaultGeoSearchStmt in interface ServerSQLStatements

Parameters:

wkt - DOCUMENT ME!

srid - DOCUMENT ME!

classesIn - DOCUMENT ME!

Returns:

DOCUMENT ME!

getDistinctValuesSearchStmt

public String getDistinctValuesSearchStmt(String metaClass,
                                          String attribute)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getDistinctValuesSearchStmt in interface ServerSQLStatements

Parameters:

metaClass - DOCUMENT ME!

attribute - DOCUMENT ME!

Returns:

DOCUMENT ME!

getQueryEditorSearchStmt

public String getQueryEditorSearchStmt(String tableName,
                                       int classId,
                                       String whereClause)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getQueryEditorSearchStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

classId - DOCUMENT ME!

whereClause - DOCUMENT ME!

Returns:

DOCUMENT ME!

getQueryEditorSearchPaginationStmt

public String getQueryEditorSearchPaginationStmt(String tableName,
                                                 int classId,
                                                 String whereClause,
                                                 int limit,
                                                 int offset)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getQueryEditorSearchPaginationStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

classId - DOCUMENT ME!

whereClause - DOCUMENT ME!

limit - DOCUMENT ME!

offset - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrStringObjectStmt

public String getIndexTriggerDeleteAttrStringObjectStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerDeleteAttrStringObjectStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrObjectObjectStmt

public String getIndexTriggerDeleteAttrObjectObjectStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerDeleteAttrObjectObjectStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerInsertAttrStringStmt

public String getIndexTriggerInsertAttrStringStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerInsertAttrStringStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerInsertAttrObjectStmt

public String getIndexTriggerInsertAttrObjectStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerInsertAttrObjectStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerUpdateAttrStringStmt

public String getIndexTriggerUpdateAttrStringStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerUpdateAttrStringStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerUpdateAttrObjectStmt

public String getIndexTriggerUpdateAttrObjectStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerUpdateAttrObjectStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrObjectArrayStmt

public String getIndexTriggerDeleteAttrObjectArrayStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerDeleteAttrObjectArrayStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrObjectDerivedStmt

public String getIndexTriggerDeleteAttrObjectDerivedStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerDeleteAttrObjectDerivedStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerInsertAttrObjectDerivedStmt

public String getIndexTriggerInsertAttrObjectDerivedStmt()

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerInsertAttrObjectDerivedStmt in interface ServerSQLStatements

Returns:

DOCUMENT ME!

getIndexTriggerSelectClassIdForeignKeyStmt

public String getIndexTriggerSelectClassIdForeignKeyStmt(int classId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerSelectClassIdForeignKeyStmt in interface ServerSQLStatements

Parameters:

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectFieldStmt

public String getIndexTriggerSelectFieldStmt(int classId,
                                             int refClassId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerSelectFieldStmt in interface ServerSQLStatements

Parameters:

classId - DOCUMENT ME!

refClassId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectObjFieldStmt

public String getIndexTriggerSelectObjFieldStmt(String fieldName,
                                                String tableName,
                                                int classId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerSelectObjFieldStmt in interface ServerSQLStatements

Parameters:

fieldName - DOCUMENT ME!

tableName - DOCUMENT ME!

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectBackReferenceStmt

public String getIndexTriggerSelectBackReferenceStmt(int classId,
                                                     int fk)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerSelectBackReferenceStmt in interface ServerSQLStatements

Parameters:

classId - DOCUMENT ME!

fk - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectTableNameByClassIdStmt

public String getIndexTriggerSelectTableNameByClassIdStmt(int classId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerSelectTableNameByClassIdStmt in interface ServerSQLStatements

Parameters:

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectFKIdStmt

public String getIndexTriggerSelectFKIdStmt(String tableName,
                                            String backref,
                                            int classId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerSelectFKIdStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

backref - DOCUMENT ME!

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectReindexPureStmt

public String getIndexTriggerSelectReindexPureStmt(int classId,
                                                   int objectId)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getIndexTriggerSelectReindexPureStmt in interface ServerSQLStatements

Parameters:

classId - DOCUMENT ME!

objectId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectFactoryGetObjectStmt

public String getObjectFactoryGetObjectStmt(String tableName,
                                            String fieldname,
                                            String referenceKey,
                                            String orderByField)

Description copied from interface: ServerSQLStatements

Creates the statement for selecting n-m and 1-n array elements.

Specified by:

getObjectFactoryGetObjectStmt in interface ServerSQLStatements

Parameters:

tableName - DOCUMENT ME!

fieldname - DOCUMENT ME!

referenceKey - DOCUMENT ME!

orderByField - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectFactoryAttrPermStmt

public String getObjectFactoryAttrPermStmt(int classId,
                                           String implodedUserGroupIds)

Description copied from interface: ServerSQLStatements

DOCUMENT ME!

Specified by:

getObjectFactoryAttrPermStmt in interface ServerSQLStatements

Parameters:

classId - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!

getDialect

public String getDialect()

Description copied from interface: DialectProvider

DOCUMENT ME!

Specified by:

getDialect in interface DialectProvider

Returns:

DOCUMENT ME!