ru.biosoft.access
Interface SqlTransformer

All Known Implementing Classes:

SqlTransformerSupport

public interface SqlTransformer

Adapter for storing/extracting data elements to/from SQL DBMS.

See Also: SqlDataCollection

public void addDeleteCommands(Statement statement, String name)
                        throws java.lang.Exception

Adds set of SQL commands to the statement to remove data element from the table.

Parameters:

statement - - statement to which SQL commands should be added.

de - - object for which DELETE statements will be generated.

public void addInsertCommands(Statement statement, DataElement de)
                        throws java.lang.Exception

Adds set of SQL commands to the statement to insert data element into the table.

Parameters:

statement - - statement to which SQL commands should be added.

de - - object for which INSERT statements will be generated.

public void addUpdateCommands(Statement statement, DataElement de)
                        throws java.lang.Exception

Adds set of SQL commands to the statement to update data element in the table.

Parameters:

statement - - statement to which SQL commands should be added.

de - - object for which UPDATE statements will be generated.

public DataElement create(ResultSet resultSet, Connection connection)
                    throws java.lang.Exception

Extracts all needed fields from resultSet, and create instance of DataElement. If necessary the method can use additional queries to get needed data using the specified connection.

Parameters:

resultSet - ResultSet from DBMS.

connection - to be used if additional query is needed.

Returns: created data element.

See Also:

getTemplateClass()

public String getCountQuery()

Creates SQL query for extracting count of data elements in the table.

Returns: SQL query for extracting count of data elements in the table.

public String getElementExistsQuery(String name)

Creates SQL query for test is data element with specified name exists in the table.

Parameters:

name - Name (PK) of needed data element.

Returns: SQL query for testing data element with specified name in the table.

public String getElementQuery(String name)

Creates SQL query for extracting data element with specified name from table.

Parameters:

name - Name (PK) of needed data element.

Returns: SQL query for extracting data element with specified name from table.

public String getNameListQuery()

Creates SQL query for extracting names for all data elements. Data element names should be sorted alphabetically.

Returns: SQL query for extracting count of data elements in the table.

public String getSelectQuery()

Creates SQL query for extracting all data elements from table.

Returns: SQL query for extracting all data elements from table.

public String getTable()

Returns main database table used by this transformer. Generally main table is table that is used in FROM clause.

public Class getTemplateClass()

Returns class of object.

Returns: Class of transformed object.

See Also:

#create(java.sql.ResultSet)

public boolean init(DataCollection owner)

Initialize transformer. Must be called by client after SqlTransformer's constructor, and before using instance of SqlTransformer.

Returns: true - if succeeded, false - otherwise.