fr.ifremer.adagio.core.service.technical.synchro

Class ReferentialSynchroTableMetadata

Object

ReferentialSynchroTableMetadata

Deprecated.

Use fr.ifremer.adagio.synchro.meta.SynchroTableMetadata

public class ReferentialSynchroTableMetadata
extends Object

Overrides of the TableMetadata with some improvements:

• Obtains number of columns via getColumnsCount()
• Obtains all columns names available via getColumnNames()
• Obtains primary key column names via getPkNames()

And others methods used to synchronize referentials:

• Obtains query to update a row of the table (column names order is the one introduced by method getColumnNames(): getUpdateQuery()
• Obtains query to insert a row in the table (column names order is the one introduced by method getColumnNames(): getInsertQuery()

Created on 1/14/14.

Since:

3.0

Author:

Tony Chemit

Field Summary

Fields

Modifier and Type	Field and Description
protected List<String>	columnNames Deprecated.
protected Map<String,ColumnMetadata>	columns Deprecated.
protected String	countDataToUpdateQuery Deprecated.
protected String	countQuery Deprecated.
protected TableMetadata	delegate Deprecated.
protected String	insertQuery Deprecated.
static String	PK_SEPARATOR Deprecated.
protected int[]	pkIndexs Deprecated.
protected Set<String>	pkNames Deprecated.
protected String	selectAllQuery Deprecated.
protected String	selectDataQueryFromPk Deprecated.
protected String	selectDataToUpdateQuery Deprecated.
protected String	selectMaxUpdateDateQuery Deprecated.
protected String	selectPrimaryKeysQuery Deprecated.
protected String	updateQuery Deprecated.
protected boolean	withUpdateDateColumn Deprecated.

Constructor Summary

Constructors

Constructor and Description
ReferentialSynchroTableMetadata(TableMetadata delegate, DatabaseMetaData meta) Deprecated.

Method Summary

Methods

Modifier and Type	Method and Description
static void	closeSilently(ResultSet statement) Deprecated.
protected String	createCountDataToUpdateQuery() Deprecated.
protected String	createCountQuery() Deprecated.
protected String	createInsertQuery() Deprecated.
protected int[]	createPkIndex() Deprecated.
protected String	createPkWhereClause() Deprecated.
protected String	createSelectAllQuery() Deprecated.
protected String	createSelectDataFromPkQuery() Deprecated.
protected String	createSelectDataToUpdateQuery() Deprecated.
protected String	createSelectMaxUpdateDateQuery() Deprecated.
protected String	createSelectParams() Deprecated.
protected String	createSelectPrimaryKeysQuery() Deprecated.
protected String	createUpdateQuery() Deprecated.
protected String	createWithUpdateDateWhereClause() Deprecated.
List<Object>	fromPkStr(String pk) Deprecated.
String	getCatalog() Deprecated.
int	getColumnIndex(String name) Deprecated.
ColumnMetadata	getColumnMetadata(String columnName) Deprecated.
Set<String>	getColumnNames() Deprecated.
int	getColumnsCount() Deprecated.
String	getCountDataToUpdateQuery(Date fromDate) Deprecated.
String	getCountQuery() Deprecated.
ForeignKeyMetadata	getForeignKeyMetadata(ForeignKey fk) Deprecated.
ForeignKeyMetadata	getForeignKeyMetadata(String keyName) Deprecated.
IndexMetadata	getIndexMetadata(String indexName) Deprecated.
String	getInsertQuery() Deprecated.
String	getName() Deprecated.
List<Object>	getPk(ResultSet incomingData) Deprecated.
int[]	getPkIndexs() Deprecated.
Set<String>	getPkNames() Deprecated.
String	getSchema() Deprecated.
String	getSelectDataQueryFromPk() Deprecated.
String	getSelectDataToUpdateQuery(Date fromDate) Deprecated.
String	getSelectMaxUpdateDateQuery() Deprecated.
String	getSelectPrimaryKeysQuery() Deprecated.
String	getTableLogPrefix() Deprecated.
String	getUpdateQuery() Deprecated.
protected List<String>	initColumnNames(Map<String,ColumnMetadata> columns) Deprecated.
protected Set<String>	initPrimaryKeys(DatabaseMetaData meta) Deprecated.
boolean	isSimpleKey() Deprecated.
boolean	isWithUpdateDateColumn() Deprecated.
String	toPkStr(List<Object> pkList) Deprecated.

Methods inherited from class Object

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

Field Detail

PK_SEPARATOR

public static final String PK_SEPARATOR

Deprecated.

See Also:

Constant Field Values

selectPrimaryKeysQuery

protected final String selectPrimaryKeysQuery

Deprecated.

selectMaxUpdateDateQuery

protected final String selectMaxUpdateDateQuery

Deprecated.

countQuery

protected final String countQuery

Deprecated.

delegate

protected final TableMetadata delegate

Deprecated.

columns

protected final Map<String,ColumnMetadata> columns

Deprecated.

columnNames

protected final List<String> columnNames

Deprecated.

pkNames

protected final Set<String> pkNames

Deprecated.

pkIndexs

protected final int[] pkIndexs

Deprecated.

insertQuery

protected final String insertQuery

Deprecated.

updateQuery

protected final String updateQuery

Deprecated.

withUpdateDateColumn

protected final boolean withUpdateDateColumn

Deprecated.

countDataToUpdateQuery

protected final String countDataToUpdateQuery

Deprecated.

selectDataToUpdateQuery

protected final String selectDataToUpdateQuery

Deprecated.

selectAllQuery

protected final String selectAllQuery

Deprecated.

selectDataQueryFromPk

protected final String selectDataQueryFromPk

Deprecated.

Constructor Detail

ReferentialSynchroTableMetadata

public ReferentialSynchroTableMetadata(TableMetadata delegate,
                               DatabaseMetaData meta)

Deprecated.

Method Detail

getPkNames

public Set<String> getPkNames()

Deprecated.

isWithUpdateDateColumn

public boolean isWithUpdateDateColumn()

Deprecated.

getColumnsCount

public int getColumnsCount()

Deprecated.

getColumnNames

public Set<String> getColumnNames()

Deprecated.

getColumnIndex

public int getColumnIndex(String name)

Deprecated.

getName

public String getName()

Deprecated.

getForeignKeyMetadata

public ForeignKeyMetadata getForeignKeyMetadata(ForeignKey fk)

Deprecated.

getColumnMetadata

public ColumnMetadata getColumnMetadata(String columnName)

Deprecated.

getSchema

public String getSchema()

Deprecated.

getCatalog

public String getCatalog()

Deprecated.

getForeignKeyMetadata

public ForeignKeyMetadata getForeignKeyMetadata(String keyName)

Deprecated.

getIndexMetadata

public IndexMetadata getIndexMetadata(String indexName)

Deprecated.

getInsertQuery

public String getInsertQuery()

Deprecated.

getUpdateQuery

public String getUpdateQuery()

Deprecated.

getSelectPrimaryKeysQuery

public String getSelectPrimaryKeysQuery()

Deprecated.

getSelectMaxUpdateDateQuery

public String getSelectMaxUpdateDateQuery()

Deprecated.

getSelectDataQueryFromPk

public String getSelectDataQueryFromPk()

Deprecated.

getSelectDataToUpdateQuery

public String getSelectDataToUpdateQuery(Date fromDate)

Deprecated.

getCountQuery

public String getCountQuery()

Deprecated.

getCountDataToUpdateQuery

public String getCountDataToUpdateQuery(Date fromDate)

Deprecated.

getPkIndexs

public int[] getPkIndexs()

Deprecated.

isSimpleKey

public boolean isSimpleKey()

Deprecated.

getPk

public List<Object> getPk(ResultSet incomingData)
                   throws SQLException

Deprecated.

Throws:

SQLException

toPkStr

public String toPkStr(List<Object> pkList)

Deprecated.

fromPkStr

public List<Object> fromPkStr(String pk)

Deprecated.

initColumnNames

protected List<String> initColumnNames(Map<String,ColumnMetadata> columns)

Deprecated.

initPrimaryKeys

protected Set<String> initPrimaryKeys(DatabaseMetaData meta)
                               throws SQLException

Deprecated.

Throws:

SQLException

createPkIndex

protected int[] createPkIndex()

Deprecated.

createInsertQuery

protected String createInsertQuery()

Deprecated.

createUpdateQuery

protected String createUpdateQuery()

Deprecated.

createSelectDataFromPkQuery

protected String createSelectDataFromPkQuery()

Deprecated.

createSelectPrimaryKeysQuery

protected String createSelectPrimaryKeysQuery()

Deprecated.

createSelectAllQuery

protected String createSelectAllQuery()

Deprecated.

createSelectMaxUpdateDateQuery

protected String createSelectMaxUpdateDateQuery()

Deprecated.

createSelectDataToUpdateQuery

protected String createSelectDataToUpdateQuery()

Deprecated.

createCountQuery

protected String createCountQuery()

Deprecated.

createCountDataToUpdateQuery

protected String createCountDataToUpdateQuery()

Deprecated.

createPkWhereClause

protected String createPkWhereClause()

Deprecated.

createWithUpdateDateWhereClause

protected String createWithUpdateDateWhereClause()

Deprecated.

createSelectParams

protected String createSelectParams()

Deprecated.

getTableLogPrefix

public String getTableLogPrefix()

Deprecated.

closeSilently

public static void closeSilently(ResultSet statement)

Deprecated.