de.must.dataobj

Class DbModifier

java.lang.Object

de.must.dataobj.DbModifier

public class DbModifier
extends java.lang.Object

Utility for modifying database tables. Part of the concept of database independence as described in DataObject. To stay compatible with low budget databases like MS Access it provides an alternative to alter table functions by rescue of data and reload into the newly created structure.

See Also:

DataObject

Field Summary

Fields

Modifier and Type	Field and Description
static int	MODIFY_CREATE
static int	MODIFY_DELETE
static int	MODIFY_UPDATE

Constructor Summary

Constructors

Constructor and Description
DbModifier()

Method Summary

Modifier and Type	Method and Description
boolean	createTable(java.sql.Connection dbConnection, EntityInfo entityInfo)
boolean	createTable(java.sql.Connection dbConnection, java.lang.String tableName, AbstractAttribute[] attributes, Index[] indices, ForeignKey[] foreignKeys)
static boolean	deleteTable(java.sql.Connection dbConnection, java.lang.String tableName) Drops a table.
boolean	dropTable(java.sql.Connection dbConnection, java.lang.String tableName, Index[] indices) Drop table.
static java.lang.String	getCreateIndexStatement(Index index, java.lang.String tableName, int nbr)
static java.lang.String	getCreateStatement(int databaseType, EntityInfo entityInfo)
static java.lang.String	getCreateStatement(int databaseType, java.lang.String tableName, AbstractAttribute[] attributes, Index[] indices, ForeignKey[] foreignKeys)
static SqlDialect	getSqlDialect(int databaseType)
int	getStartIndexForSeperateIndices(java.sql.Connection connection) Returns the start index for indices to build in addition to the primary key.
int	getStartIndexForSeperateIndices(int databaseType)
void	setDropBeforeCreation(boolean newDropBeforeCreation)
boolean	supportsPrimaryKey(int databaseType)
boolean	updateTable(ConnectionSpecification connSpec, EntityInfo entityInfo) Updates a tables structure without loosing its data content.
boolean	updateTable(ConnectionSpecification connSpec, java.lang.String tableName, AbstractAttribute[] attributes, Index[] indices, ForeignKey[] foreignKeys)

Methods inherited from class java.lang.Object

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

Field Detail

MODIFY_CREATE

public static final int MODIFY_CREATE

See Also:

Constant Field Values

MODIFY_UPDATE

public static final int MODIFY_UPDATE

See Also:

Constant Field Values

MODIFY_DELETE

public static final int MODIFY_DELETE

See Also:

Constant Field Values

Constructor Detail

DbModifier

public DbModifier()

Method Detail

setDropBeforeCreation

public void setDropBeforeCreation(boolean newDropBeforeCreation)

dropTable

public boolean dropTable(java.sql.Connection dbConnection,
                         java.lang.String tableName,
                         Index[] indices)

Drop table.

Parameters:

dbConnection - the database connection to use

tableName - the table name

indices - the indices of the table

Returns:

true if no error occurred

createTable

public boolean createTable(java.sql.Connection dbConnection,
                           EntityInfo entityInfo)

createTable

public boolean createTable(java.sql.Connection dbConnection,
                           java.lang.String tableName,
                           AbstractAttribute[] attributes,
                           Index[] indices,
                           ForeignKey[] foreignKeys)

Parameters:

dbConnection - the database connection to use

tableName - the table name

attributes - the attributes of the table

indices - the indices of the table

Returns:

true if no error occurred

getStartIndexForSeperateIndices

public int getStartIndexForSeperateIndices(java.sql.Connection connection)

Returns the start index for indices to build in addition to the primary key.

Parameters:

connection - the connection to identify the database type

Returns:

the start index for indices to build in addition to the primary key

getStartIndexForSeperateIndices

public int getStartIndexForSeperateIndices(int databaseType)

supportsPrimaryKey

public boolean supportsPrimaryKey(int databaseType)

getCreateIndexStatement

public static java.lang.String getCreateIndexStatement(Index index,
                                                       java.lang.String tableName,
                                                       int nbr)

updateTable

public boolean updateTable(ConnectionSpecification connSpec,
                           EntityInfo entityInfo)

Updates a tables structure without loosing its data content.

Parameters:

dbConnection - the database connection to use

tableName - the table name

attributes - the attributes of the table

indices - the indices of the table

Returns:

true if no error occurred

updateTable

public boolean updateTable(ConnectionSpecification connSpec,
                           java.lang.String tableName,
                           AbstractAttribute[] attributes,
                           Index[] indices,
                           ForeignKey[] foreignKeys)

getCreateStatement

public static java.lang.String getCreateStatement(int databaseType,
                                                  EntityInfo entityInfo)

getCreateStatement

public static java.lang.String getCreateStatement(int databaseType,
                                                  java.lang.String tableName,
                                                  AbstractAttribute[] attributes,
                                                  Index[] indices,
                                                  ForeignKey[] foreignKeys)

getSqlDialect

public static SqlDialect getSqlDialect(int databaseType)

deleteTable

public static boolean deleteTable(java.sql.Connection dbConnection,
                                  java.lang.String tableName)

Drops a table.

Parameters:

dbConnection - the database connection to use

tableName - the table name

Returns:

true if no error occurred