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_RANKED_SUBMISSIONS
protected EDatenbankTyp	dbType
protected char	ESC
protected static org.slf4j.Logger	LOG
protected static String	SUBMISSION_RANK_ASC
protected static String	SUBMISSION_RANK_DESC
protected String	TABLE_ATTACHMENT
protected String	TABLE_FORMEINGANG
protected String	TABLE_POSTFACH
protected String	TABLE_STATUS
protected static String	TABLE_SUBMISSION
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 StringBuilder	appendFilterStatement(StringBuilder sb, String column, String operator, String filterValue, boolean isCustomColumn)
protected StringBuilder	appendInsertKeyStatement(StringBuilder sb, String column, boolean isCustomColumn)
protected StringBuilder	appendInsertValueStatement(StringBuilder sb, String key, boolean isCustomColumn)
protected void	appendNonCustomColumnsForInsert(StringBuilder colSb, StringBuilder valSb, Map<String,String> paramMap)
StringBuilder	appendOrderByClauses(StringBuilder sb, de.xima.cmn.criteria.SortingCriterion[] sortingCriterions, Projekt project)
protected StringBuilder	appendOrderStatement(StringBuilder sb, String column, String direction, boolean isCustomColumn)
protected javax.persistence.Query	appendQueryCriterias(StringBuilder sb, IEntityContext ec, Map<String,ITableColumn> columnMap, Projekt project, de.xima.cmn.criteria.QueryCriteriaManager qcm, boolean withOrder)
protected void	appendSelectPre(StringBuilder sb, Map<String,ITableColumn> coulumns)
int	appendWhereClause(StringBuilder sb, int paramIndex, de.xima.cmn.criteria.FilterCriterion fc, Map<String,ITableColumn> fieldMap, Map<String,String> stringFCs, Map<String,Date> dateFCs, Map<String,Boolean> booleanFCs, Map<String,Integer> integerFCs, Map<String,Long> longFCs, Map<String,List<Long>> longListFCs)
StringBuilder	appendWhereClauses(StringBuilder sb, de.xima.cmn.criteria.FilterCriterion[] filterCriterions, Map<String,ITableColumn> fieldMap, Map<String,String> stringFCs, Map<String,Date> dateFCs, Map<String,Boolean> booleanFCs, Map<String,Integer> integerFCs, Map<String,Long> longFCs, Map<String,List<Long>> longListFCs)
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 projekt, 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 projekt, 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 void	fillParams(javax.persistence.Query query, Map<String,String> stringFCs, Map<String,Date> dateFCs, Map<String,Boolean> booleanFCs, Map<String,Integer> integerFCs, Map<String,Long> longFCs, Map<String,List<Long>> longListFCs)
protected String	getOrderByClause(de.xima.cmn.criteria.SortingCriterion sorting, Projekt project)
protected String	getTableName(Projekt projekt)
protected String	getWhereClause(String column, de.xima.cmn.criteria.FilterCriterion.Operator operator, String parameter, Map<String,ITableColumn> fieldMap)
protected boolean	isBooleanColumn(String column)
protected boolean	isDateColumn(String column)
protected boolean	isIntegerColumn(String column)
protected boolean	isLongColumn(String column)
String	transformColumn(String name)
protected String	transformEncryptedColumn(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_RANKED_SUBMISSIONS

protected static final String CTE_RANKED_SUBMISSIONS

See Also:

Constant Field Values

CTE_ATTACHMENT_COUNTS

protected static final String CTE_ATTACHMENT_COUNTS

See Also:

Constant Field Values

SUBMISSION_RANK_ASC

protected static final String SUBMISSION_RANK_ASC

See Also:

Constant Field Values

SUBMISSION_RANK_DESC

protected static final String SUBMISSION_RANK_DESC

See Also:

Constant Field Values

TABLE_SUBMISSION

protected static final String TABLE_SUBMISSION

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)

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 projekt,
                                                 Vorgang v,
                                                 de.xima.cmn.criteria.QueryCriteriaManager qcm)

Specified by:

createSingleQuery in interface IVorgangsDataSQLBuilder

Parameters:

ec - the entity context to create the query for

projekt - 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 projekt,
                                                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

appendOrderByClauses

public StringBuilder appendOrderByClauses(StringBuilder sb,
                                          de.xima.cmn.criteria.SortingCriterion[] sortingCriterions,
                                          Projekt project)

appendWhereClauses

public StringBuilder appendWhereClauses(StringBuilder sb,
                                        de.xima.cmn.criteria.FilterCriterion[] filterCriterions,
                                        Map<String,ITableColumn> fieldMap,
                                        Map<String,String> stringFCs,
                                        Map<String,Date> dateFCs,
                                        Map<String,Boolean> booleanFCs,
                                        Map<String,Integer> integerFCs,
                                        Map<String,Long> longFCs,
                                        Map<String,List<Long>> longListFCs)

appendWhereClause

public int appendWhereClause(StringBuilder sb,
                             int paramIndex,
                             de.xima.cmn.criteria.FilterCriterion fc,
                             Map<String,ITableColumn> fieldMap,
                             Map<String,String> stringFCs,
                             Map<String,Date> dateFCs,
                             Map<String,Boolean> booleanFCs,
                             Map<String,Integer> integerFCs,
                             Map<String,Long> longFCs,
                             Map<String,List<Long>> longListFCs)

appendFilterStatement

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

appendInsertKeyStatement

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

appendInsertValueStatement

protected StringBuilder appendInsertValueStatement(StringBuilder sb,
                                                   String key,
                                                   boolean isCustomColumn)

appendNonCustomColumnsForInsert

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

appendOrderStatement

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

appendQueryCriterias

protected javax.persistence.Query appendQueryCriterias(StringBuilder sb,
                                                       IEntityContext ec,
                                                       Map<String,ITableColumn> columnMap,
                                                       Projekt project,
                                                       de.xima.cmn.criteria.QueryCriteriaManager qcm,
                                                       boolean withOrder)

appendSelectPre

protected void appendSelectPre(StringBuilder sb,
                               Map<String,ITableColumn> coulumns)

escapePath

protected String escapePath(String path)

fillParams

protected void fillParams(javax.persistence.Query query,
                          Map<String,String> stringFCs,
                          Map<String,Date> dateFCs,
                          Map<String,Boolean> booleanFCs,
                          Map<String,Integer> integerFCs,
                          Map<String,Long> longFCs,
                          Map<String,List<Long>> longListFCs)

fillParams

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

getOrderByClause

protected String getOrderByClause(de.xima.cmn.criteria.SortingCriterion sorting,
                                  Projekt project)

getTableName

protected String getTableName(Projekt projekt)

getWhereClause

protected String getWhereClause(String column,
                                de.xima.cmn.criteria.FilterCriterion.Operator operator,
                                String parameter,
                                Map<String,ITableColumn> fieldMap)

isBooleanColumn

protected boolean isBooleanColumn(String column)

isDateColumn

protected boolean isDateColumn(String column)

isIntegerColumn

protected boolean isIntegerColumn(String column)

isLongColumn

protected boolean isLongColumn(String column)

transformEncryptedColumn

protected String transformEncryptedColumn(String column)