com.consol.citrus.actions

Class ExecuteSQLQueryAction

java.lang.Object

org.springframework.dao.support.DaoSupport

org.springframework.jdbc.core.support.JdbcDaoSupport

com.consol.citrus.actions.AbstractDatabaseConnectingTestAction

com.consol.citrus.actions.ExecuteSQLQueryAction

All Implemented Interfaces:

TestAction, org.springframework.beans.factory.InitializingBean

public class ExecuteSQLQueryAction
extends AbstractDatabaseConnectingTestAction

Action executes SQL queries and offers result set validation. The class enables you to query data result sets from a database. Validation will happen on column basis inside the result set.

Since:

2008

Author:

Christoph Deppisch, Jan Zahalka

Field Summary

Fields

Modifier and Type	Field and Description
protected Map<String,List<String>>	controlResultSet Map holding all column values to be validated, keys represent the column names

Fields inherited from class com.consol.citrus.actions.AbstractDatabaseConnectingTestAction

SQL_COMMENT, sqlResourcePath, statements

Fields inherited from class org.springframework.dao.support.DaoSupport

logger

Constructor Summary

Constructors

Constructor and Description
ExecuteSQLQueryAction() Default constructor.

Method Summary

Modifier and Type	Method and Description
void	doExecute(TestContext context) Subclasses may add custom execution logic here.
Map<String,List<String>>	getControlResultSet() Gets the controlResultSet.
Map<String,String>	getExtractVariables() Gets the extractVariables.
ScriptValidationContext	getScriptValidationContext() Gets the scriptValidationContext.
SqlResultSetScriptValidator	getValidator() Gets the validator.
ExecuteSQLQueryAction	setControlResultSet(Map<String,List<String>> controlResultSet) Set expected control result set.
ExecuteSQLQueryAction	setExtractVariables(Map<String,String> variablesMap) User can extract column values to test variables.
ExecuteSQLQueryAction	setScriptValidationContext(ScriptValidationContext scriptValidationContext) Sets the script validation context.
ExecuteSQLQueryAction	setValidator(SqlResultSetScriptValidator validator) Sets the validator.

Methods inherited from class com.consol.citrus.actions.AbstractDatabaseConnectingTestAction

createStatementsFromFileResource, decorateLastScriptLine, execute, getActor, getDescription, getName, getSqlResourcePath, getStatemendEndingCharacter, getStatements, isDisabled, setActor, setDescription, setName, setSqlResourcePath, setStatements

Methods inherited from class org.springframework.jdbc.core.support.JdbcDaoSupport

checkDaoConfig, createJdbcTemplate, getConnection, getDataSource, getExceptionTranslator, getJdbcTemplate, initTemplateConfig, releaseConnection, setDataSource, setJdbcTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet, initDao

Methods inherited from class java.lang.Object

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

Field Detail

controlResultSet

protected Map<String,List<String>> controlResultSet

Map holding all column values to be validated, keys represent the column names

Constructor Detail

ExecuteSQLQueryAction

public ExecuteSQLQueryAction()

Default constructor.

Method Detail

doExecute

public void doExecute(TestContext context)

Description copied from class: AbstractDatabaseConnectingTestAction

Subclasses may add custom execution logic here.

Specified by:

doExecute in class AbstractDatabaseConnectingTestAction

setControlResultSet

public ExecuteSQLQueryAction setControlResultSet(Map<String,List<String>> controlResultSet)

Set expected control result set. Keys represent the column names, values the expected values.

Parameters:

controlResultSet -

setExtractVariables

public ExecuteSQLQueryAction setExtractVariables(Map<String,String> variablesMap)

User can extract column values to test variables. Map holds column names (keys) and respective target variable names (values).

Parameters:

variablesMap - the variables to be created out of database values

setScriptValidationContext

public ExecuteSQLQueryAction setScriptValidationContext(ScriptValidationContext scriptValidationContext)

Sets the script validation context.

Parameters:

scriptValidationContext - the scriptValidationContext to set

getValidator

public SqlResultSetScriptValidator getValidator()

Gets the validator.

Returns:

the validator

setValidator

public ExecuteSQLQueryAction setValidator(SqlResultSetScriptValidator validator)

Sets the validator.

Parameters:

validator - the validator to set

getControlResultSet

public Map<String,List<String>> getControlResultSet()

Gets the controlResultSet.

Returns:

the controlResultSet

getExtractVariables

public Map<String,String> getExtractVariables()

Gets the extractVariables.

Returns:

the extractVariables

getScriptValidationContext

public ScriptValidationContext getScriptValidationContext()

Gets the scriptValidationContext.

Returns:

the scriptValidationContext