net.datenwerke.rs.grideditor.service.grideditor.definition.db

Class DbGridEditorDefinitionAdapterImpl

java.lang.Object

net.datenwerke.rs.grideditor.service.grideditor.definition.db.DbGridEditorDefinitionAdapterImpl

All Implemented Interfaces:

DbGridEditorDefinitionAdapter, GridEditorDefinitionContainer

public class DbGridEditorDefinitionAdapterImpl
extends java.lang.Object
implements DbGridEditorDefinitionAdapter

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	TABLE_REPLACEMENT_IN_FK_EXPR

Constructor Summary

Constructors

Constructor and Description
DbGridEditorDefinitionAdapterImpl(HookHandlerService hookHandlerService)

Method Summary

Modifier and Type	Method and Description
void	adaptColumnConfig(GridEditorColumnConfig colConfig, Column column, int index)
void	adaptDataObject(GridEditorData data)
void	adaptRECs(java.util.List<ReportExecutionConfig> executionConfigs)
void	adaptTableReport(TableReport tableReport, GridEditorReloadConfig reloadConfig)
void	addAppendStatement(java.lang.String stmt)
DbGridEditorDefinitionAdapterImpl	addColumn(java.lang.String column)
DbGridEditorDefinitionAdapterImpl	addColumn(java.lang.String column, GridEditorColumnConfig config)
DbGridEditorDefinitionAdapterImpl	addColumns(java.lang.String... columns)
DbGridEditorDefinitionAdapterImpl	addForeignKeyColumn(java.lang.String column, java.lang.String fkTableName, java.lang.String fkColumn, java.lang.String displayExpression)
DbGridEditorDefinitionAdapterImpl	addForeignKeyColumn(java.lang.String column, java.lang.String fkTableName, java.lang.String fkColumn, java.lang.String displayExpression, GridEditorColumnConfig fkConfig)
DbGridEditorDefinitionAdapterImpl	addForeignKeyColumn(java.lang.String column, java.lang.String fkTableName, java.lang.String fkColumn, java.lang.String displayExpression, java.lang.String displayName)
void	addPrependStatement(java.lang.String stmt)
void	addPrimaryKey(java.lang.String key) Deprecated.
void	addPrimaryKeyColumn(java.lang.String key)
void	callAfterCommitHooks(TableReport tableReport, GridEditorReport report, User user, ParameterSet ps, java.util.List<GridEditorRecordDto> modified, java.util.List<GridEditorRecordDto> modifiedOriginals, java.util.List<GridEditorRecordDto> deletedRecords, java.util.List<GridEditorRecordDto> newRecords)
void	callBeforeCommitHooks(TableReport tableReport, GridEditorReport report, User user, ParameterSet ps, java.util.List<GridEditorRecordDto> modified, java.util.List<GridEditorRecordDto> modifiedOriginals, java.util.List<GridEditorRecordDto> deletedRecords, java.util.List<GridEditorRecordDto> newRecords)
void	commitChanges(java.sql.Connection connection, TableReport tableReport, GridEditorReport report, User user, ParameterSet ps, java.util.List<GridEditorRecordDto> modified, java.util.List<GridEditorRecordDto> modifiedOriginals, java.util.List<GridEditorRecordDto> deletedRecords, java.util.List<GridEditorRecordDto> newRecords)
DbGridEditorAdapterBuilder	configure(Report report)
DbGridEditorAdapterBuilder	configure(Report report, java.lang.String tableName)
java.util.List<java.lang.String>	getAppendStatements()
java.lang.String	getBaseTableAlias()
GridEditorColumnConfig	getColumnConfigFor(Column column)
GridEditorColumnConfig	getColumnConfigFor(java.lang.String column)
java.util.List<java.lang.String>	getColumns()
java.lang.String	getDeleteStmtOpener()
java.lang.String	getForeignKeyColumnDisplayPrefix()
GridEditorDefinition	getGridEditorDefinition()
java.lang.String	getInsertStmtOpener()
java.lang.String	getJoinTableAliasPrefix()
int	getMaxPageSize()
int	getPageSize()
java.util.List<java.lang.String>	getPrependStatements()
java.util.List<java.lang.String>	getPrimaryKey()
java.util.List<java.lang.String>	getPrimaryKeys() Deprecated.
java.lang.String	getSelectQuery()
java.lang.String	getTableName()
java.lang.String	getUpdateStmtOpener()
java.lang.String	getWhereClause()
boolean	isCanAddRecords()
boolean	isCanDuplicateRecords()
boolean	isCanRemoveRecords()
boolean	isDisableAutocommit()
boolean	isFilterable()
boolean	isHasForm()
boolean	isPaging()
boolean	isSorteable()
void	setAppendStatements(java.util.List<java.lang.String> appendStatements)
void	setBaseTableAlias(java.lang.String baseTableAlias) Controls the tableName prefix used in the creation of the SQL statement.
void	setCanAddRecords(boolean canAddRecords)
void	setCanDuplicateRecords(boolean canDuplicateRecords)
void	setCanRemoveRecords(boolean canRemoveRecords)
void	setColumnConfig(java.lang.String columnName, GridEditorColumnConfig colConfig)
void	setColumns(java.util.List<java.lang.String> columns)
void	setColumns(java.lang.String... columns)
void	setDefinition(DbGridEditorDefinition gridEditorDefinition)
void	setDeleteStmtOpener(java.lang.String deleteStmtOpener)
void	setDisableAutocommit(boolean disableAutocommit)
void	setFilterable(boolean filterable)
void	setForeignKeyColumnDisplayPrefix(java.lang.String foreignKeyColumnDisplayPrefix) Controls the column prefix used in the creation of the SQL statement.
void	setHasForm(boolean hasForm)
void	setInsertStmtOpener(java.lang.String insertStmtOpener)
void	setJoinTableAliasPrefix(java.lang.String joinTableAliasPrefix) Controls the tableName prefix used in the creation of the SQL statement.
void	setMaxPageSize(int maxPageSize)
void	setPageSize(int pageSize)
void	setPaging(boolean paging)
void	setPrependStatements(java.util.List<java.lang.String> prependStatements)
void	setPrimaryKey(java.util.List<java.lang.String> primaryKeys)
void	setPrimaryKey(java.lang.String... primaryKeys)
void	setPrimaryKeys(java.util.List<java.lang.String> primaryKeys) Deprecated.
void	setSelectQuery(java.lang.String query) Deprecated.
void	setSorteable(boolean sorteable)
void	setTableName(java.lang.String tableName)
void	setUpdateStmtOpener(java.lang.String updateStmtOpener)
void	setWhereClause(java.lang.String whereClause)

Methods inherited from class java.lang.Object

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

Field Detail

TABLE_REPLACEMENT_IN_FK_EXPR

public static final java.lang.String TABLE_REPLACEMENT_IN_FK_EXPR

See Also:

Constant Field Values

Constructor Detail

DbGridEditorDefinitionAdapterImpl

public DbGridEditorDefinitionAdapterImpl(HookHandlerService hookHandlerService)

Method Detail

adaptTableReport

public void adaptTableReport(TableReport tableReport,
                             GridEditorReloadConfig reloadConfig)

Specified by:

adaptTableReport in interface DbGridEditorDefinitionAdapter

adaptDataObject

public void adaptDataObject(GridEditorData data)

Specified by:

adaptDataObject in interface DbGridEditorDefinitionAdapter

adaptColumnConfig

public void adaptColumnConfig(GridEditorColumnConfig colConfig,
                              Column column,
                              int index)

Specified by:

adaptColumnConfig in interface DbGridEditorDefinitionAdapter

getColumnConfigFor

public GridEditorColumnConfig getColumnConfigFor(Column column)

Specified by:

getColumnConfigFor in interface DbGridEditorDefinitionAdapter

getColumnConfigFor

public GridEditorColumnConfig getColumnConfigFor(java.lang.String column)

adaptRECs

public void adaptRECs(java.util.List<ReportExecutionConfig> executionConfigs)

Specified by:

adaptRECs in interface DbGridEditorDefinitionAdapter

commitChanges

public void commitChanges(java.sql.Connection connection,
                          TableReport tableReport,
                          GridEditorReport report,
                          User user,
                          ParameterSet ps,
                          java.util.List<GridEditorRecordDto> modified,
                          java.util.List<GridEditorRecordDto> modifiedOriginals,
                          java.util.List<GridEditorRecordDto> deletedRecords,
                          java.util.List<GridEditorRecordDto> newRecords)
                   throws ValidationFailedException

Specified by:

commitChanges in interface DbGridEditorDefinitionAdapter

Throws:

ValidationFailedException

setTableName

public void setTableName(java.lang.String tableName)

getTableName

public java.lang.String getTableName()

setDeleteStmtOpener

public void setDeleteStmtOpener(java.lang.String deleteStmtOpener)

getDeleteStmtOpener

public java.lang.String getDeleteStmtOpener()

setUpdateStmtOpener

public void setUpdateStmtOpener(java.lang.String updateStmtOpener)

getUpdateStmtOpener

public java.lang.String getUpdateStmtOpener()

setInsertStmtOpener

public void setInsertStmtOpener(java.lang.String insertStmtOpener)

getInsertStmtOpener

public java.lang.String getInsertStmtOpener()

setColumns

public void setColumns(java.util.List<java.lang.String> columns)

setColumns

public void setColumns(java.lang.String... columns)

addColumns

public DbGridEditorDefinitionAdapterImpl addColumns(java.lang.String... columns)

addColumn

public DbGridEditorDefinitionAdapterImpl addColumn(java.lang.String column)

addColumn

public DbGridEditorDefinitionAdapterImpl addColumn(java.lang.String column,
                                                   GridEditorColumnConfig config)

addForeignKeyColumn

public DbGridEditorDefinitionAdapterImpl addForeignKeyColumn(java.lang.String column,
                                                             java.lang.String fkTableName,
                                                             java.lang.String fkColumn,
                                                             java.lang.String displayExpression)

addForeignKeyColumn

public DbGridEditorDefinitionAdapterImpl addForeignKeyColumn(java.lang.String column,
                                                             java.lang.String fkTableName,
                                                             java.lang.String fkColumn,
                                                             java.lang.String displayExpression,
                                                             java.lang.String displayName)

addForeignKeyColumn

public DbGridEditorDefinitionAdapterImpl addForeignKeyColumn(java.lang.String column,
                                                             java.lang.String fkTableName,
                                                             java.lang.String fkColumn,
                                                             java.lang.String displayExpression,
                                                             GridEditorColumnConfig fkConfig)

getColumns

public java.util.List<java.lang.String> getColumns()

setPrimaryKeys

@Deprecated
public void setPrimaryKeys(java.util.List<java.lang.String> primaryKeys)

Deprecated.

setPrimaryKey

public void setPrimaryKey(java.util.List<java.lang.String> primaryKeys)

setPrimaryKey

public void setPrimaryKey(java.lang.String... primaryKeys)

addPrimaryKeyColumn

public void addPrimaryKeyColumn(java.lang.String key)

getPrimaryKeys

@Deprecated
public java.util.List<java.lang.String> getPrimaryKeys()

Deprecated.

getPrimaryKey

public java.util.List<java.lang.String> getPrimaryKey()

Specified by:

getPrimaryKey in interface DbGridEditorDefinitionAdapter

addPrimaryKey

@Deprecated
public void addPrimaryKey(java.lang.String key)

Deprecated.

setSelectQuery

@Deprecated
public void setSelectQuery(java.lang.String query)

Deprecated.

Can be used to specify a custom select query. Should usually not be called but instead columns should be specified.

Parameters:

query -

See Also:

addColumns(String...), addColumn(String, GridEditorColumnConfig)

getSelectQuery

public java.lang.String getSelectQuery()

Specified by:

getSelectQuery in interface DbGridEditorDefinitionAdapter

getPageSize

public int getPageSize()

Specified by:

getPageSize in interface DbGridEditorDefinitionAdapter

setPageSize

public void setPageSize(int pageSize)

getMaxPageSize

public int getMaxPageSize()

Specified by:

getMaxPageSize in interface DbGridEditorDefinitionAdapter

setMaxPageSize

public void setMaxPageSize(int maxPageSize)

setPaging

public void setPaging(boolean paging)

isPaging

public boolean isPaging()

Specified by:

isPaging in interface DbGridEditorDefinitionAdapter

isHasForm

public boolean isHasForm()

Specified by:

isHasForm in interface DbGridEditorDefinitionAdapter

setHasForm

public void setHasForm(boolean hasForm)

isSorteable

public boolean isSorteable()

Specified by:

isSorteable in interface DbGridEditorDefinitionAdapter

setSorteable

public void setSorteable(boolean sorteable)

isFilterable

public boolean isFilterable()

Specified by:

isFilterable in interface DbGridEditorDefinitionAdapter

setFilterable

public void setFilterable(boolean filterable)

setColumnConfig

public void setColumnConfig(java.lang.String columnName,
                            GridEditorColumnConfig colConfig)

Specified by:

setColumnConfig in interface DbGridEditorDefinitionAdapter

getPrependStatements

public java.util.List<java.lang.String> getPrependStatements()

setPrependStatements

public void setPrependStatements(java.util.List<java.lang.String> prependStatements)

addPrependStatement

public void addPrependStatement(java.lang.String stmt)

getAppendStatements

public java.util.List<java.lang.String> getAppendStatements()

setAppendStatements

public void setAppendStatements(java.util.List<java.lang.String> appendStatements)

addAppendStatement

public void addAppendStatement(java.lang.String stmt)

isDisableAutocommit

public boolean isDisableAutocommit()

setDisableAutocommit

public void setDisableAutocommit(boolean disableAutocommit)

getBaseTableAlias

public java.lang.String getBaseTableAlias()

setBaseTableAlias

public void setBaseTableAlias(java.lang.String baseTableAlias)

Controls the tableName prefix used in the creation of the SQL statement. Changes need to be made before any column config object is created.

Parameters:

baseTableAlias -

getJoinTableAliasPrefix

public java.lang.String getJoinTableAliasPrefix()

setJoinTableAliasPrefix

public void setJoinTableAliasPrefix(java.lang.String joinTableAliasPrefix)

Controls the tableName prefix used in the creation of the SQL statement. Changes need to be made before any column config object is created.

Parameters:

joinTableAliasPrefix -

getForeignKeyColumnDisplayPrefix

public java.lang.String getForeignKeyColumnDisplayPrefix()

setForeignKeyColumnDisplayPrefix

public void setForeignKeyColumnDisplayPrefix(java.lang.String foreignKeyColumnDisplayPrefix)

Controls the column prefix used in the creation of the SQL statement. Changes need to be made before any column config object is created.

Parameters:

foreignKeyColumnDisplayPrefix -

setWhereClause

public void setWhereClause(java.lang.String whereClause)

getWhereClause

public java.lang.String getWhereClause()

configure

public DbGridEditorAdapterBuilder configure(Report report)

configure

public DbGridEditorAdapterBuilder configure(Report report,
                                            java.lang.String tableName)

getGridEditorDefinition

public GridEditorDefinition getGridEditorDefinition()

Specified by:

getGridEditorDefinition in interface GridEditorDefinitionContainer

setDefinition

public void setDefinition(DbGridEditorDefinition gridEditorDefinition)

Specified by:

setDefinition in interface DbGridEditorDefinitionAdapter

isCanAddRecords

public boolean isCanAddRecords()

Specified by:

isCanAddRecords in interface DbGridEditorDefinitionAdapter

setCanAddRecords

public void setCanAddRecords(boolean canAddRecords)

isCanDuplicateRecords

public boolean isCanDuplicateRecords()

Specified by:

isCanDuplicateRecords in interface DbGridEditorDefinitionAdapter

setCanDuplicateRecords

public void setCanDuplicateRecords(boolean canDuplicateRecords)

isCanRemoveRecords

public boolean isCanRemoveRecords()

Specified by:

isCanRemoveRecords in interface DbGridEditorDefinitionAdapter

setCanRemoveRecords

public void setCanRemoveRecords(boolean canRemoveRecords)

callBeforeCommitHooks

public void callBeforeCommitHooks(TableReport tableReport,
                                  GridEditorReport report,
                                  User user,
                                  ParameterSet ps,
                                  java.util.List<GridEditorRecordDto> modified,
                                  java.util.List<GridEditorRecordDto> modifiedOriginals,
                                  java.util.List<GridEditorRecordDto> deletedRecords,
                                  java.util.List<GridEditorRecordDto> newRecords)

Specified by:

callBeforeCommitHooks in interface DbGridEditorDefinitionAdapter

callAfterCommitHooks

public void callAfterCommitHooks(TableReport tableReport,
                                 GridEditorReport report,
                                 User user,
                                 ParameterSet ps,
                                 java.util.List<GridEditorRecordDto> modified,
                                 java.util.List<GridEditorRecordDto> modifiedOriginals,
                                 java.util.List<GridEditorRecordDto> deletedRecords,
                                 java.util.List<GridEditorRecordDto> newRecords)

Specified by:

callAfterCommitHooks in interface DbGridEditorDefinitionAdapter