Package database.dao

Class CustomSqlLoadDao

java.lang.Object

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

database.dao.AbstractLoadDao<LoadOptions>

database.dao.DefaultLoadDao

database.dao.CustomSqlLoadDao

All Implemented Interfaces:

ILoadDao<LoadOptions>, LoadDao, WebbpmDao, TableProvider

public class CustomSqlLoadDao
extends DefaultLoadDao

Author:

Rinat Suleymanov

Field Summary

Fields

Modifier and Type	Field	Description
BpmnVariable[]	parameterVariables	Deprecated.
QueryParam[]	queryParameterVariables
String	sql

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

Constructor	Description
CustomSqlLoadDao(DefaultEntityGraph graph, org.jooq.DSLContext dsl, DslProvider dslProvider, String sql, QueryParam[] parameterVariables, SecurityContext securityContext, VariableService variableService)
CustomSqlLoadDao(SecurityContext securityContext, VariableService variableService)

Method Summary

Modifier and Type	Method	Description
protected List<TableRow>	getTableRows(Set<EntityColumn> columns, SQLParameters sqlParameters)
List<TableRow>	load(Set<EntityColumn> columns)
List<TableRow>	load(Set<EntityColumn> columns, LoadOptions loadOptions)
TableRow	loadByPK(Set<EntityColumn> columns, Object... keyValues)
protected TableRow	recordToTableFieldData(org.jooq.Record record, Set<EntityColumn> tableFields)

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, 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.LoadDao

getDatasourceJndiName, getPkFields

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

getTableByAlias, getUsedTables

Field Details

sql

public String sql

parameterVariables

@Deprecated
public BpmnVariable[] parameterVariables

Deprecated.

queryParameterVariables

public QueryParam[] queryParameterVariables

Constructor Details

CustomSqlLoadDao

@Autowired
public CustomSqlLoadDao(SecurityContext securityContext,
 VariableService variableService)

CustomSqlLoadDao

public CustomSqlLoadDao(DefaultEntityGraph graph,
 org.jooq.DSLContext dsl,
 DslProvider dslProvider,
 String sql,
 QueryParam[] parameterVariables,
 SecurityContext securityContext,
 VariableService variableService)

Method Details

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>

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

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

getTableRows

protected List<TableRow> getTableRows(Set<EntityColumn> columns,
 SQLParameters sqlParameters)

recordToTableFieldData

protected TableRow recordToTableFieldData(org.jooq.Record record,
 Set<EntityColumn> tableFields)

Overrides:

recordToTableFieldData in class AbstractLoadDao<LoadOptions>