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_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_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 char	ESC
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)

Method Summary

Modifier and Type	Method	Description
protected void	appandSelectAllJoin(StringBuilder sb, Projekt projekt, Postfach... inboxes)
protected void	appandSingleSelectAllJoin(StringBuilder sb, Projekt projekt, Vorgang v)
protected void	appendCountPost(StringBuilder sb, Map<String,ITableColumn> columnMap)
protected void	appendCountPre(StringBuilder sb, Map<String,ITableColumn> columnMap)
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, Map<String,ITableColumn> fieldMap)
protected StringBuilder	appendOrderStatement(StringBuilder sb, String column, String direction, boolean isCustomColumn)
protected javax.persistence.Query	appendQueryCriterias(StringBuilder sb, IEntityContext ec, Map<String,ITableColumn> columnMap, de.xima.cmn.criteria.QueryCriteriaManager qcm, boolean withOrder)
protected void	appendSelectPost(StringBuilder sb, Map<String,ITableColumn> coulumns)
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, Map<String,ITableColumn> columnMap, Projekt projekt, 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, Map<String,ITableColumn> columnMap, 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, Map<String,ITableColumn> columns, Projekt projekt, long formEingangID, Map<String,String> dataMap)	Deprecated. use createInsertQuery(IEntityContext, Map, Projekt, long, Map, Integer)
javax.persistence.Query	createInsertQuery(IEntityContext ec, Map<String,ITableColumn> columns, Projekt projekt, long formEingangID, Map<String,String> dataMap, Integer maxValueSize)
javax.persistence.Query	createSingleQuery(IEntityContext ec, Map<String,ITableColumn> columnMap, Projekt projekt, Vorgang v, de.xima.cmn.criteria.QueryCriteriaManager qcm)
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, Map<String,ITableColumn> fieldMap)
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)
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

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_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_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

ESC

protected final char ESC

Constructor Detail

AVorgangsDataSQLBuilder

public AVorgangsDataSQLBuilder(EProjectSpecificDBTable tableType)

Method Detail

transformTableName

public String transformTableName(String name)

transformColumn

public String transformColumn(String name)

isBooleanColumn

protected boolean isBooleanColumn(String column)

isDateColumn

protected boolean isDateColumn(String column)

isIntegerColumn

protected boolean isIntegerColumn(String column)

isLongColumn

protected boolean isLongColumn(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 createInsertQuery(IEntityContext, Map, 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,
                                                 Map<String,ITableColumn> columns,
                                                 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

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

maxValueSize - the max size of the data to insert

Returns:

an Query to perform the insert

createSingleQuery

public javax.persistence.Query createSingleQuery(IEntityContext ec,
                                                 Map<String,ITableColumn> columnMap,
                                                 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

columnMap - an Map of table columns

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,
                                              Map<String,ITableColumn> columnMap,
                                              Projekt projekt,
                                              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,
                                                Map<String,ITableColumn> columnMap,
                                                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

appandSingleSelectAllJoin

protected void appandSingleSelectAllJoin(StringBuilder sb,
                                         Projekt projekt,
                                         Vorgang v)

appandSelectAllJoin

protected void appandSelectAllJoin(StringBuilder sb,
                                   Projekt projekt,
                                   Postfach... inboxes)

appendQueryCriterias

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

appendOrderByClauses

public StringBuilder appendOrderByClauses(StringBuilder sb,
                                          de.xima.cmn.criteria.SortingCriterion[] sortingCriterions,
                                          Map<String,ITableColumn> fieldMap)

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)

appendNonCustomColumnsForInsert

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

appendOrderStatement

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

appendFilterStatement

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

appendInsertValueStatement

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

appendInsertKeyStatement

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

getTableName

protected String getTableName(Projekt projekt)

appendSelectPost

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

appendSelectPre

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

appendCountPost

protected void appendCountPost(StringBuilder sb,
                               Map<String,ITableColumn> columnMap)

appendCountPre

protected void appendCountPre(StringBuilder sb,
                              Map<String,ITableColumn> columnMap)

getWhereClause

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

getOrderByClause

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

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)