net.proteusframework.core.automation

Class ValidationStatement

java.lang.Object

net.proteusframework.core.automation.SQLStatement

net.proteusframework.core.automation.ValidationStatement

All Implemented Interfaces:

Loggable

public class ValidationStatement
extends SQLStatement

Validation SQL. This can be used for simple tests that are used to determine if the results of a query match expectations.

Limitations: the query must expect to receive an empty result set or a result set with a single column and a single row.

Author:

Russ Tennant (russ@i2rd.com)

Nested Class Summary

Nested classes/interfaces inherited from class net.proteusframework.core.automation.SQLStatement

SQLStatement.Parameter

Field Summary

Fields

Modifier and Type	Field and Description
static Object	EMPTY_RESULT Empty Result.

Constructor Summary

Constructors

Constructor and Description
ValidationStatement() Constructor.
ValidationStatement(String sql, String description, Object expectedValue) Constructor.

Method Summary

Modifier and Type	Method and Description
boolean	equals(Object o)
int	hashCode()
String	validate(ResultSet result) Validate the result.

Methods inherited from class net.proteusframework.core.automation.SQLStatement

applyParameters, getDescription, getLog, getParameters, getSource, getSql, hasParameters, setBoolean, setDescription, setDouble, setInteger, setLong, setParameter, setSource, setSql, setString, setTimestamp, setXMLString, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

EMPTY_RESULT

public static final Object EMPTY_RESULT

Empty Result.

Constructor Detail

ValidationStatement

public ValidationStatement()

Constructor.

ValidationStatement

public ValidationStatement(String sql,
                           String description,
                           Object expectedValue)

Constructor.

Parameters:

sql - the SQL to run.

description - the description of the test.

expectedValue - the expected value or EMPTY_RESULT if the result set should be empty.

Method Detail

equals

public boolean equals(Object o)

Overrides:

equals in class SQLStatement

hashCode

public int hashCode()

Overrides:

hashCode in class SQLStatement

validate

@Nullable
public String validate(ResultSet result)
                          throws SQLException

Validate the result. The ResultSet will be reset to the beginning.

Parameters:

result - the result from running the SQL.

Returns:

the message on failure. Null on success.

Throws:

SQLException - on error.