Package de.xima.fc.dao.interfaces.sqlbuilder

Interface IVorgangsDataSQLBuilder

All Known Implementing Classes:

AVorgangsDataSQLBuilder, DefaultVorgangsDataSQLBuilder, EncryptedVorgangsDataSQLBuilder, MySQLEncryptedVorgangsDataSQLBuilder, OracleVorgangsDataSQLBuilder

public interface IVorgangsDataSQLBuilder

Interface creating SQL-Queries for datatables

Author:

XIMA MEDIA GmbH

Method Summary

Modifier and Type	Method	Description
String	buildPropertyPathAlias(String... pathSegments)
javax.persistence.Query	createAllQuery(IEntityContext ec, Projekt projekt, de.xima.cmn.criteria.QueryCriteriaManager qcm, Postfach... inboxes)
default javax.persistence.Query	createAllQuery(IEntityContext ec, Map<String,ITableColumn> fieldMap, Projekt projekt, Postfach pf, de.xima.cmn.criteria.QueryCriteriaManager qcm)	Deprecated.
javax.persistence.Query	createBulkDeleteQueryInSystemDatabase(IEntityContext ec, Datatable datatable, List<Long> formEingangIDs)	Creates a bulk delete query for a datatable in the system database.
String	createBulkDeleteQuerySql(String tableName, List<Long> formEingangIDs)	Create a bulk delete SQL query.
javax.persistence.Query	createCountQuery(IEntityContext ec, Projekt projekt, de.xima.cmn.criteria.QueryCriteriaManager qcm, Postfach... inboxes)
default javax.persistence.Query	createCountQuery(IEntityContext ec, Map<String,ITableColumn> fieldMap, Projekt projekt, Postfach pf, de.xima.cmn.criteria.QueryCriteriaManager qcm)	Deprecated.
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	createDeleteQueryInSystemDatabase(IEntityContext ec, Datatable datatable, Long formEingangID)	Creates a delete query for a datatable in the system database.
String	createDeleteQuerySql(String tableName, long formEingangID)	Creates the SQL for a deletion query.
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> fieldMap, Projekt projekt, long formEingangID, Map<String,String> dataMap)	Deprecated. use createInsertQuery(IEntityContext, Projekt, long, Map, Integer)
PreparedStatement	createInsertQueryForDatatable(Connection connection, Datatable datatable, String tableName, Projekt project, long formEingangID, Map<String,String> dataMap, Integer maxValueSize)	Prepares a statement consisting of SQL and parameters for insertion into datatable.
javax.persistence.Query	createSingleQuery(IEntityContext ec, Projekt projekt, Vorgang v, de.xima.cmn.criteria.QueryCriteriaManager qcm)

Method Detail

createInsertQuery

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

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

createInsertQueryForDatatable

PreparedStatement createInsertQueryForDatatable(Connection connection,
                                                Datatable datatable,
                                                String tableName,
                                                Projekt project,
                                                long formEingangID,
                                                Map<String,String> dataMap,
                                                Integer maxValueSize)
                                         throws SQLException

Prepares a statement consisting of SQL and parameters for insertion into datatable.

Parameters:

connection - database connection

datatable - datatable

tableName - table name

project - project

formEingangID - form record ID

dataMap - data map

maxValueSize - maximum length of string values

Returns:

prepared statement

Throws:

SQLException - if an error during preparation of the statement occurs

createInsertQuery

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

Deprecated.

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

Parameters:

ec - the entity context to create the query for

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

createCountQuery

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

Deprecated.

Parameters:

projekt - Projekt

pf - Postfach may be null

qcm - QueryCriteriaManager

Returns:

a query for counting all found entries

createCountQuery

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

createAllQuery

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

Deprecated.

Parameters:

projekt - Projekt

pf - Postfach may be null

qcm - QueryCriteriaManager

Returns:

a query for all found entries

createAllQuery

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

createSingleQuery

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

Parameters:

ec - the entity context to create the query for

projekt - Projekt

v - Vorgang

qcm - QueryCriteriaManager

Returns:

a query for a single process

createDeleteQuery

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

Parameters:

ec - the entity context to create the query for

projekt - Projekt

formEingangID - Integer

Returns:

a query for deleting an entry

createDeleteQueryInSystemDatabase

javax.persistence.Query createDeleteQueryInSystemDatabase(IEntityContext ec,
                                                          Datatable datatable,
                                                          Long formEingangID)

Creates a delete query for a datatable in the system database.

Parameters:

ec - entity context

datatable - datatable

formEingangID - form record ID

Returns:

delete query

createBulkDeleteQueryInSystemDatabase

javax.persistence.Query createBulkDeleteQueryInSystemDatabase(IEntityContext ec,
                                                              Datatable datatable,
                                                              List<Long> formEingangIDs)

Creates a bulk delete query for a datatable in the system database.

Parameters:

ec - entity context

datatable - datatable

formEingangIDs - form record IDs

Returns:

delete query

createDeleteQuerySql

String createDeleteQuerySql(String tableName,
                            long formEingangID)

Creates the SQL for a deletion query.

Parameters:

tableName - table name

formEingangID - form record ID

Returns:

SQL

createBulkDeleteQuerySql

String createBulkDeleteQuerySql(String tableName,
                                List<Long> formEingangIDs)

Create a bulk delete SQL query.

Parameters:

tableName - table name

formEingangIDs - form record IDs

Returns:

SQL

createDeleteNotCurrentDataQuery

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

createDeleteDataWithoutEntityQuery

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

buildPropertyPathAlias

String buildPropertyPathAlias(String... pathSegments)