Package de.xima.fc.dao.impl.sqlbuilder

Class AVorgangsDataSQLBuilder

java.lang.Object

de.xima.fc.dao.impl.sqlbuilder.AVorgangsDataSQLBuilder

All Implemented Interfaces:

IVorgangsDataSQLBuilder

Direct Known Subclasses:

DefaultVorgangsDataSQLBuilder

public class AVorgangsDataSQLBuilder
extends Object
implements IVorgangsDataSQLBuilder

Field Summary

Fields

Modifier and Type	Field	Description
protected String	COL_ATTACHMENT_COUNT
protected String	COL_FORMEINGANG
protected String	COL_FORMEINGANG_ID
protected String	COL_ID
protected String	COL_MANDANT_ID
protected String	COL_POSTFACH_FK
protected String	COL_POSTFACH_ID
protected String	COL_POSTFACH_NAME
protected String	COL_PROCESS_FK
protected String	COL_PROCESS_ID
protected String	COL_PROJECT_ID
protected String	COL_PROJEKT_ID
protected String	COL_STATUS_DELETABLE
protected String	COL_STATUS_FK
protected String	COL_STATUS_ID
protected String	COL_STATUS_NAME
protected String	COL_VERSION_ID
protected String	COL_VORGANG
protected String	COL_WF_STATE_DELETABLE
protected String	COL_WF_STATE_FK
protected String	COL_WF_STATE_ID
protected String	COL_WF_STATE_NAME
protected String	COL_WF_STATE_TYPE
protected String	COL_WF_STATE_VERSION
protected String	COL_WF_VERSION_FK
protected static String	CTE_ATTACHMENT_COUNTS
protected static String	CTE_FORM_RECORD_DATA
protected static String	CTE_POSTBOX
protected static String	CTE_STATUS
protected static String	CTE_SUBMISSIONS
protected static String	CTE_WORKFLOW_STATUS
protected EDatenbankTyp	dbType
protected char	ESC
protected static String	INTERNAL
protected static org.slf4j.Logger	LOG
protected String	TABLE_ATTACHMENT
protected String	TABLE_FORMEINGANG
protected String	TABLE_POSTFACH
protected String	TABLE_STATUS
protected String	TABLE_VORGANG
protected String	TABLE_WF_STATE
protected EProjectSpecificDBTable	tableType
protected String	VIEW_ATTACHMENTS
protected String	VIEW_POSTFACH
protected String	VIEW_STATUS
protected String	VIEW_WF_STATE

Constructor Summary

Constructors

Constructor	Description
AVorgangsDataSQLBuilder(EProjectSpecificDBTable tableType, EDatenbankTyp dbType)

Method Summary

Modifier and Type	Method	Description
protected void	appendAdditionalColumnsForInsert(StringBuilder colSb, StringBuilder valSb, Map<String,Object> paramMap)
protected StringBuilder	appendFilterStatement(StringBuilder sb, String tableName, String column, String operator, String filterValue, boolean isCustomColumn)
protected void	appendInsertKeyStatement(StringBuilder sb, String column, boolean isCustomColumn)
protected void	appendInsertValueStatement(StringBuilder sb, String parameter, boolean isCustomColumn)
protected StringBuilder	appendOrderStatement(StringBuilder sb, String column, String direction, boolean isCustomColumn)
String	buildPropertyPathAlias(String... pathSegments)
javax.persistence.Query	createAllQuery(IEntityContext ec, Projekt project, de.xima.cmn.criteria.QueryCriteriaManager qcm, Postfach... inboxes)
javax.persistence.Query	createAllQuery(IEntityContext ec, Map<String,ITableColumn> columnMap, Projekt projekt, Postfach pf, de.xima.cmn.criteria.QueryCriteriaManager qcm)
javax.persistence.Query	createCountQuery(IEntityContext ec, Projekt project, de.xima.cmn.criteria.QueryCriteriaManager qcm, Postfach... inboxes)
javax.persistence.Query	createCountQuery(IEntityContext ec, Map<String,ITableColumn> columnMap, Projekt projekt, Postfach pf, de.xima.cmn.criteria.QueryCriteriaManager qcm)
javax.persistence.Query	createDeleteDataWithoutEntityQuery(IEntityContext ec, Projekt project)
javax.persistence.Query	createDeleteNotCurrentDataQuery(IEntityContext ec, Projekt project)
javax.persistence.Query	createDeleteQuery(IEntityContext ec, Projekt projekt, long formEingangID)
javax.persistence.Query	createInsertQuery(IEntityContext ec, Projekt projekt, long formEingangID, Map<String,String> dataMap, Integer maxValueSize)
javax.persistence.Query	createInsertQuery(IEntityContext ec, Map<String,ITableColumn> columns, Projekt projekt, long formEingangID, Map<String,String> dataMap)	Deprecated. use IVorgangsDataSQLBuilder.createInsertQuery(IEntityContext, Projekt, long, Map, Integer)
javax.persistence.Query	createSingleQuery(IEntityContext ec, Projekt project, Vorgang v, de.xima.cmn.criteria.QueryCriteriaManager qcm)
protected String	escapePath(String path)
protected void	fillParams(javax.persistence.Query query, Map<String,Object> params)
protected String	getOrderByClause(Projekt project, Map<String,ITableColumn> fieldMap, de.xima.cmn.criteria.SortingCriterion sorting)
protected String	getTableName(Projekt projekt)
String	transformColumn(String name)
protected String	transformCustomColumnForRead(String tableName, String column)
String	transformTableName(String name)

Methods inherited from class java.lang.Object

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

Field Detail

LOG

protected static final org.slf4j.Logger LOG

CTE_SUBMISSIONS

protected static final String CTE_SUBMISSIONS

See Also:

Constant Field Values

CTE_ATTACHMENT_COUNTS

protected static final String CTE_ATTACHMENT_COUNTS

See Also:

Constant Field Values

CTE_STATUS

protected static final String CTE_STATUS

See Also:

Constant Field Values

CTE_WORKFLOW_STATUS

protected static final String CTE_WORKFLOW_STATUS

See Also:

Constant Field Values

CTE_POSTBOX

protected static final String CTE_POSTBOX

See Also:

Constant Field Values

CTE_FORM_RECORD_DATA

protected static final String CTE_FORM_RECORD_DATA

See Also:

Constant Field Values

INTERNAL

protected static final String INTERNAL

See Also:

Constant Field Values

VIEW_STATUS

protected final String VIEW_STATUS

VIEW_WF_STATE

protected final String VIEW_WF_STATE

VIEW_POSTFACH

protected final String VIEW_POSTFACH

VIEW_ATTACHMENTS

protected final String VIEW_ATTACHMENTS

TABLE_STATUS

protected final String TABLE_STATUS

TABLE_WF_STATE

protected final String TABLE_WF_STATE

TABLE_POSTFACH

protected final String TABLE_POSTFACH

TABLE_VORGANG

protected final String TABLE_VORGANG

TABLE_ATTACHMENT

protected final String TABLE_ATTACHMENT

TABLE_FORMEINGANG

protected final String TABLE_FORMEINGANG

COL_PROJECT_ID

protected final String COL_PROJECT_ID

COL_PROJEKT_ID

protected final String COL_PROJEKT_ID

COL_VERSION_ID

protected final String COL_VERSION_ID

COL_MANDANT_ID

protected final String COL_MANDANT_ID

COL_POSTFACH_ID

protected final String COL_POSTFACH_ID

COL_PROCESS_ID

protected final String COL_PROCESS_ID

COL_STATUS_ID

protected final String COL_STATUS_ID

COL_STATUS_NAME

protected final String COL_STATUS_NAME

COL_STATUS_DELETABLE

protected final String COL_STATUS_DELETABLE

COL_WF_VERSION_FK

protected final String COL_WF_VERSION_FK

COL_WF_STATE_ID

protected final String COL_WF_STATE_ID

COL_WF_STATE_NAME

protected final String COL_WF_STATE_NAME

COL_WF_STATE_TYPE

protected final String COL_WF_STATE_TYPE

COL_WF_STATE_DELETABLE

protected final String COL_WF_STATE_DELETABLE

COL_WF_STATE_VERSION

protected final String COL_WF_STATE_VERSION

COL_POSTFACH_NAME

protected final String COL_POSTFACH_NAME

COL_ATTACHMENT_COUNT

protected final String COL_ATTACHMENT_COUNT

COL_ID

protected final String COL_ID

COL_FORMEINGANG_ID

protected final String COL_FORMEINGANG_ID

COL_FORMEINGANG

protected final String COL_FORMEINGANG

COL_VORGANG

protected final String COL_VORGANG

COL_STATUS_FK

protected final String COL_STATUS_FK

COL_WF_STATE_FK

protected final String COL_WF_STATE_FK

COL_POSTFACH_FK

protected final String COL_POSTFACH_FK

COL_PROCESS_FK

protected final String COL_PROCESS_FK

tableType

protected final EProjectSpecificDBTable tableType

dbType

protected final EDatenbankTyp dbType

ESC

protected final char ESC

Constructor Detail

AVorgangsDataSQLBuilder

public AVorgangsDataSQLBuilder(EProjectSpecificDBTable tableType,
                               EDatenbankTyp dbType)

Method Detail

transformTableName

public String transformTableName(String name)

transformColumn

public String transformColumn(String name)

transformCustomColumnForRead

protected String transformCustomColumnForRead(String tableName,
                                              String column)

createDeleteQuery

public javax.persistence.Query createDeleteQuery(IEntityContext ec,
                                                 Projekt projekt,
                                                 long formEingangID)

Specified by:

createDeleteQuery in interface IVorgangsDataSQLBuilder

Parameters:

ec - the entity context to create the query for

projekt - Projekt

formEingangID - Integer

Returns:

a query for deleting an entry

createInsertQuery

@Deprecated
public javax.persistence.Query createInsertQuery(IEntityContext ec,
                                                 Map<String,ITableColumn> columns,
                                                 Projekt projekt,
                                                 long formEingangID,
                                                 Map<String,String> dataMap)

Deprecated.

use IVorgangsDataSQLBuilder.createInsertQuery(IEntityContext, Projekt, long, Map, Integer)

Specified by:

createInsertQuery in interface IVorgangsDataSQLBuilder

Parameters:

ec - the entity context to create the query for

columns - an Map of table columns

projekt - the project to create the query for

formEingangID - to form record data to create the query for

dataMap - the Map of data to insert

Returns:

an Query to perform the insert

createInsertQuery

public javax.persistence.Query createInsertQuery(IEntityContext ec,
                                                 Projekt projekt,
                                                 long formEingangID,
                                                 Map<String,String> dataMap,
                                                 Integer maxValueSize)

Specified by:

createInsertQuery in interface IVorgangsDataSQLBuilder

Parameters:

ec - the entity context to create the query for

projekt - the project to create the query for

formEingangID - to form record data to create the query for

dataMap - the Map of data to insert

maxValueSize - the max size of the data to insert

Returns:

an Query to perform the insert

createSingleQuery

public javax.persistence.Query createSingleQuery(IEntityContext ec,
                                                 Projekt project,
                                                 Vorgang v,
                                                 de.xima.cmn.criteria.QueryCriteriaManager qcm)

Specified by:

createSingleQuery in interface IVorgangsDataSQLBuilder

Parameters:

ec - the entity context to create the query for

project - Projekt

v - Vorgang

qcm - QueryCriteriaManager

Returns:

a query for a single process

createAllQuery

public javax.persistence.Query createAllQuery(IEntityContext ec,
                                              Map<String,ITableColumn> columnMap,
                                              Projekt projekt,
                                              Postfach pf,
                                              de.xima.cmn.criteria.QueryCriteriaManager qcm)

Specified by:

createAllQuery in interface IVorgangsDataSQLBuilder

projekt - Projekt

pf - Postfach may be null

qcm - QueryCriteriaManager

Returns:

a query for all found entries

createAllQuery

public javax.persistence.Query createAllQuery(IEntityContext ec,
                                              Projekt project,
                                              de.xima.cmn.criteria.QueryCriteriaManager qcm,
                                              Postfach... inboxes)

Specified by:

createAllQuery in interface IVorgangsDataSQLBuilder

createCountQuery

public javax.persistence.Query createCountQuery(IEntityContext ec,
                                                Map<String,ITableColumn> columnMap,
                                                Projekt projekt,
                                                Postfach pf,
                                                de.xima.cmn.criteria.QueryCriteriaManager qcm)

Specified by:

createCountQuery in interface IVorgangsDataSQLBuilder

projekt - Projekt

pf - Postfach may be null

qcm - QueryCriteriaManager

Returns:

a query for counting all found entries

createCountQuery

public javax.persistence.Query createCountQuery(IEntityContext ec,
                                                Projekt project,
                                                de.xima.cmn.criteria.QueryCriteriaManager qcm,
                                                Postfach... inboxes)

Specified by:

createCountQuery in interface IVorgangsDataSQLBuilder

createDeleteNotCurrentDataQuery

public javax.persistence.Query createDeleteNotCurrentDataQuery(IEntityContext ec,
                                                               Projekt project)

Specified by:

createDeleteNotCurrentDataQuery in interface IVorgangsDataSQLBuilder

createDeleteDataWithoutEntityQuery

public javax.persistence.Query createDeleteDataWithoutEntityQuery(IEntityContext ec,
                                                                  Projekt project)

Specified by:

createDeleteDataWithoutEntityQuery in interface IVorgangsDataSQLBuilder

appendFilterStatement

protected StringBuilder appendFilterStatement(StringBuilder sb,
                                              String tableName,
                                              String column,
                                              String operator,
                                              String filterValue,
                                              boolean isCustomColumn)

appendInsertKeyStatement

protected void appendInsertKeyStatement(StringBuilder sb,
                                        String column,
                                        boolean isCustomColumn)

appendInsertValueStatement

protected void appendInsertValueStatement(StringBuilder sb,
                                          String parameter,
                                          boolean isCustomColumn)

appendAdditionalColumnsForInsert

protected void appendAdditionalColumnsForInsert(StringBuilder colSb,
                                                StringBuilder valSb,
                                                Map<String,Object> paramMap)

appendOrderStatement

protected StringBuilder appendOrderStatement(StringBuilder sb,
                                             String column,
                                             String direction,
                                             boolean isCustomColumn)

escapePath

protected String escapePath(String path)

fillParams

protected void fillParams(javax.persistence.Query query,
                          Map<String,Object> params)

getOrderByClause

protected String getOrderByClause(Projekt project,
                                  Map<String,ITableColumn> fieldMap,
                                  de.xima.cmn.criteria.SortingCriterion sorting)

getTableName

protected String getTableName(Projekt projekt)

buildPropertyPathAlias

public String buildPropertyPathAlias(String... pathSegments)

Specified by:

buildPropertyPathAlias in interface IVorgangsDataSQLBuilder