org.specrunner.sql.database.impl

Class IdManagerDefault

java.lang.Object

org.specrunner.sql.database.impl.IdManagerDefault

All Implemented Interfaces:

IIdManager

public class IdManagerDefault
extends Object
implements IIdManager

Manage tables and columns key fields.

Author:

Thiago Santos.

Field Summary

Fields

Modifier and Type	Field and Description
protected String	table Local table name.
protected String	value Local value.
protected Map<String,Object>	valuesToIds Mapping from values to IDs.

Fields inherited from interface org.specrunner.sql.database.IIdManager

SEPARATOR

Constructor Summary

Constructors

Constructor and Description
IdManagerDefault()

Method Summary

Modifier and Type	Method and Description
void	append(String table, String value) Add a table alias to processing.
protected void	bind(Object obj) Bind value to current context information.
protected void	bind(String value, Object id) Bind data to specific mappings.
void	clear() Clear manager local variables.
protected String	createSelect(Table table) Create select SQL.
Object	find(String tableOrAlias, String value, Column column, Connection connection, IStatementFactory statementFactory) Find a value by its table and alias, or by columns values.
boolean	hasKeys() Check if manager has keys to read.
Object	lookup(String table, String value) Lookup for a ID based on a reference.
protected String	makeKey(String table, Object value) Create data key.
void	readKeys(SqlWrapper wrapper, Table table, IRegister register, PreparedStatement pstmt) Read keys from a prepared statement.
void	reset() Reset ID manager.

Methods inherited from class java.lang.Object

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

Field Detail

valuesToIds

protected Map<String,Object> valuesToIds

Mapping from values to IDs.

table

protected String table

Local table name.

value

protected String value

Local value.

Constructor Detail

IdManagerDefault

public IdManagerDefault()

Method Detail

reset

public void reset()

Description copied from interface: IIdManager

Reset ID manager.

Specified by:

reset in interface IIdManager

clear

public void clear()

Description copied from interface: IIdManager

Clear manager local variables.

Specified by:

clear in interface IIdManager

append

public void append(String table,
                   String value)

Description copied from interface: IIdManager

Add a table alias to processing.

Specified by:

append in interface IIdManager

Parameters:

table - Table to append reference value.

value - A reference value.

hasKeys

public boolean hasKeys()

Description copied from interface: IIdManager

Check if manager has keys to read.

Specified by:

hasKeys in interface IIdManager

Returns:

true, if reading is required, false, otherwise.

readKeys

public void readKeys(SqlWrapper wrapper,
                     Table table,
                     IRegister register,
                     PreparedStatement pstmt)
              throws SQLException

Description copied from interface: IIdManager

Read keys from a prepared statement.

Specified by:

readKeys in interface IIdManager

Parameters:

wrapper - A wrapper.

table - A table.

register - A register.

pstmt - A statement.

Throws:

SQLException - On reading errors.

bind

protected void bind(Object obj)

Bind value to current context information.

Parameters:

obj - An object.

bind

protected void bind(String value,
                    Object id)

Bind data to specific mappings.

Parameters:

value - Value.

id - Id value.

lookup

public Object lookup(String table,
                     String value)

Description copied from interface: IIdManager

Lookup for a ID based on a reference.

Specified by:

lookup in interface IIdManager

Parameters:

table - Table alias to lookup.

value - A object value to transform/recover.

Returns:

ID corresponding to the object.

makeKey

protected String makeKey(String table,
                         Object value)

Create data key.

Parameters:

table - Table name.

value - Value.

Returns:

A key.

find

public Object find(String tableOrAlias,
                   String value,
                   Column column,
                   Connection connection,
                   IStatementFactory statementFactory)
            throws DatabaseException,
                   SQLException

Description copied from interface: IIdManager

Find a value by its table and alias, or by columns values.

Specified by:

find in interface IIdManager

Parameters:

tableOrAlias - Table name.

value - The value to be found.

column - The reference column.

connection - A connection.

statementFactory - A statement factory.

Returns:

The database object corresponding to the specified parameters, if found, null, otherwise.

Throws:

DatabaseException - On reading errors.

SQLException - On select errors.

createSelect

protected String createSelect(Table table)

Create select SQL.

Parameters:

table - A table.

Returns:

A select SQL.