Package dao.container

Class CustomSqlFormDao

java.lang.Object

ru.cg.webbpm.modules.database.api.entity_graph.dao.DefaultGraphDao

database.dao.AbstractLoadDao<LoadOptions>

database.dao.DefaultLoadDao

dao.container.FormDaoImpl

dao.container.CustomSqlFormDao

All Implemented Interfaces:

FormDao, DeleteDao<Object>, ILoadDao<LoadOptions>, LoadDao, SaveDao, SaveLoadDeleteDao, WebbpmDao, TableProvider

public class CustomSqlFormDao
extends FormDaoImpl

Author:

Rinat Suleymanov

Field Summary

Fields

Modifier and Type	Field	Description
QueryParam[]	parameterVariables
String	saveSelectSql
String	sql

Fields inherited from class dao.container.FormDaoImpl

deleteDao, saveDao

Fields inherited from class database.dao.DefaultLoadDao

uniqueResult

Fields inherited from class database.dao.AbstractLoadDao

datasourceJndiName, MESSAGE_SOURCE

Fields inherited from class ru.cg.webbpm.modules.database.api.entity_graph.dao.DefaultGraphDao

conditionBuilder, databaseStructureManager, dslProvider, graph

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	CustomSqlFormDao(DefaultEntityGraph graph, org.jooq.DSLContext dsl, DslProvider dslProvider, SecurityContext securityContext, VariableService variableService)
	CustomSqlFormDao(SecurityContext securityContext, VariableService variableService)

Method Summary

Modifier and Type	Method	Description
protected void	afterPropertiesSet()
List<TableRow>	load(Set<EntityColumn> columns)
List<TableRow>	load(Set<EntityColumn> columns, LoadOptions loadOptions)
TableRow	loadByPK(Set<EntityColumn> columns, Object... keyValues)
Map<EntityColumn,Object>	loadGraphTablesPKValues(Object... keyValues)

Methods inherited from class dao.container.FormDaoImpl

delete, delete, save

Methods inherited from class database.dao.DefaultLoadDao

getSelectForUpdateStep, getTotalRowCount, getTotalRowCount, load, loadAggregations, loadAggregations, loadByPK, loadMultiFieldAggregations, recordListToTableRowListByAlias, selectByJooqColumns

Methods inherited from class database.dao.AbstractLoadDao

addJoins, buildGroupByStep, buildLoadByPkQuery, buildLoadByPkQuery, buildSelectCountWhere, buildSelectCountWhere, buildSelectStepWithAggregationColumns, buildWhereStep, buildWhereStep, buildWhereStep, convertAggregateFuncFieldToJooqFields, convertAggregateFuncMultiFieldToJooqFields, convertEntityColumnsToJooqFields, convertToAggregateFunction, convertToAggregateFunctionMultiColumns, defaultEntityColumnAlias, getAggregateFuncFieldSelectStep, getAggregateFuncMultiFieldSelectStep, getColumnSelectStep, getColumnWithAliasSelectStep, getDatasourceJndiName, getGraphConditions, getJooqTableByEntity, getMatrix, getOrderByStep, getPkFields, getSelectCountJoinStep, getSelectCountJoinStep, prepareResultListWithAggregateColumns, recordListToTableFieldDataList, recordToTableFieldData, recordToTableRowByAlias, toJooqFieldWithAlias

Methods inherited from class ru.cg.webbpm.modules.database.api.entity_graph.dao.DefaultGraphDao

getComplexCondition, getContainsCondition, getDsl, getDsl, getEndsWithCondition, getEqualCondition, getEqualIgnoreCaseCondition, getFilterCondition, getFilterCondition, getFilterCondition, getFilterCondition, getFilterConditions, getGraphNodeTablePkFields, getGreaterOrEqualCondition, getGreaterThanCondition, getLessOrEqualCondition, getLessThanCondition, getNotContainsCondition, getNotEqualCondition, getOperator, getSequence, getStartsWithCondition, getStructureTable, getTable, getTableWithAlias, getUsedTables, setDatabaseStructureManager, setDsl, setDslProvider, setGraph, toJooqField

Methods inherited from class java.lang.Object

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

Methods inherited from interface ru.cg.webbpm.modules.database.api.dao.ILoadDao

getTotalRowCount

Methods inherited from interface ru.cg.webbpm.modules.database.api.dao.LoadDao

getDatasourceJndiName, getPkFields, getTotalRowCount, loadAggregations, loadAggregations, loadByPK, loadMultiFieldAggregations

Methods inherited from interface ru.cg.webbpm.modules.database.api.TableProvider

getTableByAlias, getUsedTables

Field Details

sql

public String sql

parameterVariables

public QueryParam[] parameterVariables

saveSelectSql

public String saveSelectSql

Constructor Details

CustomSqlFormDao

@Autowired
public CustomSqlFormDao(SecurityContext securityContext,
 VariableService variableService)

CustomSqlFormDao

protected CustomSqlFormDao(DefaultEntityGraph graph,
 org.jooq.DSLContext dsl,
 DslProvider dslProvider,
 SecurityContext securityContext,
 VariableService variableService)

Method Details

afterPropertiesSet

@PostConstruct
protected void afterPropertiesSet()

Overrides:

afterPropertiesSet in class FormDaoImpl

load

public List<TableRow> load(Set<EntityColumn> columns,
 LoadOptions loadOptions)

Specified by:

load in interface ILoadDao<LoadOptions>

Specified by:

load in interface LoadDao

Overrides:

load in class DefaultLoadDao

load

public List<TableRow> load(Set<EntityColumn> columns)

Specified by:

load in interface ILoadDao<LoadOptions>

Specified by:

load in interface LoadDao

Overrides:

load in class AbstractLoadDao<LoadOptions>

loadByPK

public TableRow loadByPK(Set<EntityColumn> columns,
 Object... keyValues)

Specified by:

loadByPK in interface ILoadDao<LoadOptions>

Specified by:

loadByPK in interface LoadDao

Overrides:

loadByPK in class DefaultLoadDao

loadGraphTablesPKValues

public Map<EntityColumn,Object> loadGraphTablesPKValues(Object... keyValues)

Specified by:

loadGraphTablesPKValues in interface FormDao

Overrides:

loadGraphTablesPKValues in class FormDaoImpl