org.specrunner.sql.database

Class SqlWrapper

java.lang.Object

org.specrunner.sql.database.SqlWrapper

public class SqlWrapper
extends Object

Wrapper of SQL commands.

Author:

Thiago Santos

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	SqlWrapper(CommandType type) Default constructor.

Method Summary

Modifier and Type	Method and Description
static SqlWrapper	delete(String sql, Map<String,Integer> namesToIndexes, int expectedCount) Set delete.
int	getExpectedCount() get the expected count.
Map<String,Integer>	getNamesToIndexes() A column name to index in SQL mapping.
String	getSql() Get the SQL result.
CommandType	getType() Get command type.
static SqlWrapper	insert(String sql, Map<String,Integer> namesToIndexes, int expectedCount) Set insert.
static SqlWrapper	newWrapper(CommandType type, String sql, Map<String,Integer> namesToIndexes, int expectedCount) Get a new wrapper.
protected static SqlWrapper	prepare(SqlWrapper type, String sql, Map<String,Integer> namesToIndexes, int expectedCount) Prepare any instance.
static SqlWrapper	update(String sql, Map<String,Integer> namesToIndexes, int expectedCount) Set update.

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlWrapper

protected SqlWrapper(CommandType type)

Default constructor.

Parameters:

type - The command type.

Method Detail

getType

public CommandType getType()

Get command type.

Returns:

A command type.

getSql

public String getSql()

Get the SQL result.

Returns:

The result.

getNamesToIndexes

public Map<String,Integer> getNamesToIndexes()

A column name to index in SQL mapping.

Returns:

The mapping.

getExpectedCount

public int getExpectedCount()

get the expected count.

Returns:

The count.

insert

public static SqlWrapper insert(String sql,
                                Map<String,Integer> namesToIndexes,
                                int expectedCount)

Set insert.

Parameters:

sql - The command.

namesToIndexes - A mapping from column name to placeholder index.

expectedCount - The expected count result.

Returns:

The wrapper.

update

public static SqlWrapper update(String sql,
                                Map<String,Integer> namesToIndexes,
                                int expectedCount)

Set update.

Parameters:

sql - The command.

namesToIndexes - A mapping from column name to placeholder index.

expectedCount - The expected result count.

Returns:

The wrapper.

delete

public static SqlWrapper delete(String sql,
                                Map<String,Integer> namesToIndexes,
                                int expectedCount)

Set delete.

Parameters:

sql - The command.

namesToIndexes - A mapping from column name to placeholder index.

expectedCount - The expected result count.

Returns:

The wrapper.

newWrapper

public static SqlWrapper newWrapper(CommandType type,
                                    String sql,
                                    Map<String,Integer> namesToIndexes,
                                    int expectedCount)

Get a new wrapper.

Parameters:

type - A command type.

sql - The command.

namesToIndexes - A mapping from column name to placeholder index.

expectedCount - The expected result count.

Returns:

The wrapper.

prepare

protected static SqlWrapper prepare(SqlWrapper type,
                                    String sql,
                                    Map<String,Integer> namesToIndexes,
                                    int expectedCount)

Prepare any instance.

Parameters:

type - The instance.

sql - The command.

namesToIndexes - A mapping from column name to placeholder index.

expectedCount - The expected result count.

Returns:

The wrapper.