Sirius.server.sql

Interface ServerSQLStatements

All Superinterfaces:

DialectProvider

All Known Implementing Classes:

OracleSQLStatements, PostgresSQLStatements

public interface ServerSQLStatements
extends DialectProvider

DOCUMENT ME!

Version:

$Revision$, $Date$

Author:

martin.scholl@cismet.de

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	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 interface Sirius.server.sql.DialectProvider

getDialect

Method Detail

getVirtualTreeAddNodeStatement

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

DOCUMENT ME!

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

String getVirtualTreeNextNodeIdStatement()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeClassTreeNodesStatement

String getVirtualTreeClassTreeNodesStatement(String implodedUserGroupIds)

DOCUMENT ME!

Parameters:

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeTopNodesStatement

String getVirtualTreeTopNodesStatement(boolean artificialIdSupported,
                                       String implodedUserGroupIds)

DOCUMENT ME!

Parameters:

artificialIdSupported - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeLocalChildrenStmt

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

DOCUMENT ME!

Parameters:

artificialIdSupported - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeRemoteChildrenStmt

String getVirtualTreeRemoteChildrenStmt(String serverName,
                                        int nodeId)

DOCUMENT ME!

Parameters:

serverName - DOCUMENT ME!

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodeStmt

String getVirtualTreeDeleteNodeStmt(int nodeId)

DOCUMENT ME!

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodeLinkStmt

String getVirtualTreeDeleteNodeLinkStmt(int nodeId)

DOCUMENT ME!

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodePermStmt

String getVirtualTreeDeleteNodePermStmt(int nodeId)

DOCUMENT ME!

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeAddNodeLinkStmt

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

DOCUMENT ME!

Parameters:

domain - DOCUMENT ME!

fatherId - DOCUMENT ME!

childId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeDeleteNodeLinkStmt

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

DOCUMENT ME!

Parameters:

domain - DOCUMENT ME!

fatherId - DOCUMENT ME!

childId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeInheritNodePermStmt

String getVirtualTreeInheritNodePermStmt(int fatherId,
                                         int childId)

DOCUMENT ME!

Parameters:

fatherId - DOCUMENT ME!

childId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeHasNodesStmt

String getVirtualTreeHasNodesStmt(String classId,
                                  String objId)

DOCUMENT ME!

Parameters:

classId - DOCUMENT ME!

objId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeGetNodeStmt

String getVirtualTreeGetNodeStmt(int nodeId,
                                 String implodedUserGroupIds)

DOCUMENT ME!

Parameters:

nodeId - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeNodeIsLeafStmt

String getVirtualTreeNodeIsLeafStmt(int nodeId)

DOCUMENT ME!

Parameters:

nodeId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getVirtualTreeInitNonLeafsStmt

String getVirtualTreeInitNonLeafsStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getUserGroupIdentifiersUgIdentifiersStmt

String getUserGroupIdentifiersUgIdentifiersStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getClassGetInstanceStmnt

String getClassGetInstanceStmnt(String tableName,
                                String primaryKey)

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

primaryKey - DOCUMENT ME!

Returns:

DOCUMENT ME!

getClassGetDefaultInstanceStmnt

String getClassGetDefaultInstanceStmnt(String tableName,
                                       String primaryKey)

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

primaryKey - DOCUMENT ME!

Returns:

DOCUMENT ME!

getClassGetEmptyResultStmnt

String getClassGetEmptyResultStmnt(String tableName)

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectHierarchyFatherStmt

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

DOCUMENT ME!

Parameters:

father - DOCUMENT ME!

pk - DOCUMENT ME!

tableName - DOCUMENT ME!

fieldName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectHierarchyFatherArrayStmt

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

DOCUMENT ME!

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

String getPersistenceHelperNextvalStmt(String tableName)

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPersistenceManagerDeleteFromStmt

String getPersistenceManagerDeleteFromStmt(String tableName,
                                           String fieldName)

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

fieldName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPersistenceManagerUpdateStmt

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

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

pkField - DOCUMENT ME!

fieldNames - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPersistenceManagerInsertStmt

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

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

fieldNames - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPolicyHolderServerPoliciesStmt

String getPolicyHolderServerPoliciesStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getPasswordSwitcherAdminActionSelectUserStmt

String getPasswordSwitcherAdminActionSelectUserStmt(String loginName)

DOCUMENT ME!

Parameters:

loginName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPasswordSwitcherAdminActionChangeAndBackupStmt

String getPasswordSwitcherAdminActionChangeAndBackupStmt(String loginNameToSwitch,
                                                         String loginNameToRead)

DOCUMENT ME!

Parameters:

loginNameToSwitch - DOCUMENT ME!

loginNameToRead - DOCUMENT ME!

Returns:

DOCUMENT ME!

getPasswordSwitcherAdminActionRecoveryStmt

String getPasswordSwitcherAdminActionRecoveryStmt(String loginName)

DOCUMENT ME!

Parameters:

loginName - DOCUMENT ME!

Returns:

DOCUMENT ME!

getDefaultFullTextSearchStmt

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

DOCUMENT ME!

Parameters:

searchText - DOCUMENT ME!

classesIn - DOCUMENT ME!

geoSql - DOCUMENT ME!

caseSensitive - DOCUMENT ME!

Returns:

DOCUMENT ME!

getDefaultGeoSearchStmt

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

DOCUMENT ME!

Parameters:

wkt - DOCUMENT ME!

srid - DOCUMENT ME!

classesIn - DOCUMENT ME!

Returns:

DOCUMENT ME!

getDistinctValuesSearchStmt

String getDistinctValuesSearchStmt(String metaClass,
                                   String attribute)

DOCUMENT ME!

Parameters:

metaClass - DOCUMENT ME!

attribute - DOCUMENT ME!

Returns:

DOCUMENT ME!

getQueryEditorSearchStmt

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

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

classId - DOCUMENT ME!

whereClause - DOCUMENT ME!

Returns:

DOCUMENT ME!

getQueryEditorSearchPaginationStmt

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

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

classId - DOCUMENT ME!

whereClause - DOCUMENT ME!

limit - DOCUMENT ME!

offset - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrStringObjectStmt

String getIndexTriggerDeleteAttrStringObjectStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrObjectObjectStmt

String getIndexTriggerDeleteAttrObjectObjectStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerInsertAttrStringStmt

String getIndexTriggerInsertAttrStringStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerInsertAttrObjectStmt

String getIndexTriggerInsertAttrObjectStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerUpdateAttrStringStmt

String getIndexTriggerUpdateAttrStringStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerUpdateAttrObjectStmt

String getIndexTriggerUpdateAttrObjectStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrObjectArrayStmt

String getIndexTriggerDeleteAttrObjectArrayStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerDeleteAttrObjectDerivedStmt

String getIndexTriggerDeleteAttrObjectDerivedStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerInsertAttrObjectDerivedStmt

String getIndexTriggerInsertAttrObjectDerivedStmt()

DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectClassIdForeignKeyStmt

String getIndexTriggerSelectClassIdForeignKeyStmt(int classId)

DOCUMENT ME!

Parameters:

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectFieldStmt

String getIndexTriggerSelectFieldStmt(int classId,
                                      int refClassId)

DOCUMENT ME!

Parameters:

classId - DOCUMENT ME!

refClassId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectObjFieldStmt

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

DOCUMENT ME!

Parameters:

fieldName - DOCUMENT ME!

tableName - DOCUMENT ME!

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectBackReferenceStmt

String getIndexTriggerSelectBackReferenceStmt(int classId,
                                              int fk)

DOCUMENT ME!

Parameters:

classId - DOCUMENT ME!

fk - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectTableNameByClassIdStmt

String getIndexTriggerSelectTableNameByClassIdStmt(int classId)

DOCUMENT ME!

Parameters:

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectFKIdStmt

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

DOCUMENT ME!

Parameters:

tableName - DOCUMENT ME!

backref - DOCUMENT ME!

classId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getIndexTriggerSelectReindexPureStmt

String getIndexTriggerSelectReindexPureStmt(int classId,
                                            int objectId)

DOCUMENT ME!

Parameters:

classId - DOCUMENT ME!

objectId - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectFactoryGetObjectStmt

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

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

Parameters:

tableName - DOCUMENT ME!

fieldname - DOCUMENT ME!

referenceKey - DOCUMENT ME!

orderByField - DOCUMENT ME!

Returns:

DOCUMENT ME!

getObjectFactoryAttrPermStmt

String getObjectFactoryAttrPermStmt(int classId,
                                    String implodedUserGroupIds)

DOCUMENT ME!

Parameters:

classId - DOCUMENT ME!

implodedUserGroupIds - DOCUMENT ME!

Returns:

DOCUMENT ME!