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 and Description
protected String	COL_FORMEINGANG
protected String	COL_FORMEINGANG_ID
protected String	COL_ID
protected String	COL_POSTFACH_ID
protected String	COL_PROJEKT_ID
protected String	COL_STATUS_FK
protected String	COL_STATUS_ID
protected String	COL_STATUS_NAME
protected char	ESC
protected static org.slf4j.Logger	LOG
protected String	TABLE_STATUS
protected String	TABLE_VORGANG
protected EProjectSpecificDBTable	tableType
protected String	VIEW_STATUS

Constructor Summary

Constructors

Constructor and Description
AVorgangsDataSQLBuilder(EProjectSpecificDBTable tableType)

Method Summary

Modifier and Type	Method and Description
protected void	appandSelectAllJoin(StringBuilder sb, Projekt projekt, Postfach pf)
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)
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)
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, Postfach pf, de.xima.cmn.criteria.QueryCriteriaManager qcm)
javax.persistence.Query	createDeleteQuery(IEntityContext ec, Projekt projekt, int formEingangID)
javax.persistence.Query	createInsertQuery(IEntityContext ec, Map<String,ITableColumn> columns, Projekt projekt, int formEingangID, Map<String,String> dataMap)
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, HashMap<String,Boolean> booleanFCs)
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)
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

TABLE_STATUS

protected final String TABLE_STATUS

TABLE_VORGANG

protected final String TABLE_VORGANG

COL_PROJEKT_ID

protected final String COL_PROJEKT_ID

COL_POSTFACH_ID

protected final String COL_POSTFACH_ID

COL_STATUS_ID

protected final String COL_STATUS_ID

COL_STATUS_NAME

protected final String COL_STATUS_NAME

COL_ID

protected final String COL_ID

COL_FORMEINGANG_ID

protected final String COL_FORMEINGANG_ID

COL_FORMEINGANG

protected final String COL_FORMEINGANG

COL_STATUS_FK

protected final String COL_STATUS_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)

createDeleteQuery

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

Specified by:

createDeleteQuery in interface IVorgangsDataSQLBuilder

projekt - Projekt

formEingangID - Integer

Returns:

a query for deleting an entry

createInsertQuery

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

Specified by:

createInsertQuery in interface IVorgangsDataSQLBuilder

projekt - Projekt

formEingangID - Integer

dataMap - Map

Returns:

a query for inserting data

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

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

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

appandSingleSelectAllJoin

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

appandSelectAllJoin

protected void appandSelectAllJoin(StringBuilder sb,
                                   Projekt projekt,
                                   Postfach pf)

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)

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,
                          HashMap<String,Boolean> booleanFCs)