Class SqlSchemaAdapter

java.lang.Object

ch.nolix.system.sqlschema.adapter.SqlSchemaAdapter

All Implemented Interfaces:

Closeable, CloseStateRequestable, GroupCloseable, ChangeRequestable, IChangeSaver, IResettableChangeSaver, Resettable, ISchemaAdapter, ISchemaReader, ISchemaWriter, AutoCloseable

public final class SqlSchemaAdapter
extends Object
implements ISchemaAdapter

Author:

Silvan Wyss

Method Summary

Modifier and Type	Method	Description
void	addAdditionalSqlStatements(IContainer<String> additionalSqlStatements)
void	addColumn(TableIdentification table, ColumnDto column)
void	addColumns(TableIdentification table, IContainer<ColumnDto> columns)
void	addTable(TableDto table)
void	addTables(IContainer<TableDto> tables)
void	addTables(TableDto table, TableDto... tables)
boolean	columnIsEmpty(String tableName, String columnName)
void	deleteColumn(String tableName, String columnName)
void	deleteColumnIfExists(String tableName, String columnName)
void	deleteTable(String tableName)
static SqlSchemaAdapter	forDatabaseNameAndWithSqlConnectionPool(String databaseName, IResourcePool<ISqlConnection> sqlConnectionPool)
int	getSaveCount()
ICloseController	getStoredCloseController()
int	getTableCount()
boolean	hasChanges()
TableDto	loadTable(String tableName)
IContainer<TableDto>	loadTables()
void	noteClose()	Lets the current GroupCloseable note a close.
void	renameColumn(String tableName, String columnName, String newColumnName)
void	renameColumnIfExists(String tableName, String columnName, String newColumnName)
void	renameTable(String tableName, String newTableName)
void	reset()	Resets the current Resettable.
void	saveChanges()	Saves the changes of the current IChangeSaver.
boolean	tableExist()
boolean	tableExists(String tableName)

Methods inherited from class Object

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

Methods inherited from interface ChangeRequestable

isChangeFree

Methods inherited from interface CloseStateRequestable

isOpen

Methods inherited from interface GroupCloseable

close, createCloseDependencyTo, isClosed

Method Details

forDatabaseNameAndWithSqlConnectionPool

public static SqlSchemaAdapter forDatabaseNameAndWithSqlConnectionPool(String databaseName,
 IResourcePool<ISqlConnection> sqlConnectionPool)

addAdditionalSqlStatements

public void addAdditionalSqlStatements(IContainer<String> additionalSqlStatements)

Specified by:

addAdditionalSqlStatements in interface ISchemaWriter

addColumn

public void addColumn(TableIdentification table,
 ColumnDto column)

Specified by:

addColumn in interface ISchemaWriter

addColumns

public void addColumns(TableIdentification table,
 IContainer<ColumnDto> columns)

Specified by:

addColumns in interface ISchemaWriter

addTable

public void addTable(TableDto table)

Specified by:

addTable in interface ISchemaWriter

addTables

public void addTables(IContainer<TableDto> tables)

Specified by:

addTables in interface ISchemaWriter

addTables

public void addTables(TableDto table,
 TableDto... tables)

Specified by:

addTables in interface ISchemaWriter

columnIsEmpty

public boolean columnIsEmpty(String tableName,
 String columnName)

Specified by:

columnIsEmpty in interface ISchemaReader

deleteColumn

public void deleteColumn(String tableName,
 String columnName)

Specified by:

deleteColumn in interface ISchemaWriter

deleteColumnIfExists

public void deleteColumnIfExists(String tableName,
 String columnName)

Specified by:

deleteColumnIfExists in interface ISchemaWriter

deleteTable

public void deleteTable(String tableName)

Specified by:

deleteTable in interface ISchemaWriter

getStoredCloseController

public ICloseController getStoredCloseController()

Specified by:

getStoredCloseController in interface GroupCloseable

Returns:

the ICloseController of the current GroupCloseable.

getSaveCount

public int getSaveCount()

Specified by:

getSaveCount in interface IResettableChangeSaver

hasChanges

public boolean hasChanges()

Specified by:

hasChanges in interface ChangeRequestable

Returns:

true if the current ChangeRequestable has uncomitted changes, false otherwise.

loadTable

public TableDto loadTable(String tableName)

Specified by:

loadTable in interface ISchemaReader

getTableCount

public int getTableCount()

Specified by:

getTableCount in interface ISchemaReader

loadTables

public IContainer<TableDto> loadTables()

Specified by:

loadTables in interface ISchemaReader

noteClose

public void noteClose()

Lets the current GroupCloseable note a close.

Specified by:

noteClose in interface GroupCloseable

renameColumn

public void renameColumn(String tableName,
 String columnName,
 String newColumnName)

Specified by:

renameColumn in interface ISchemaWriter

renameColumnIfExists

public void renameColumnIfExists(String tableName,
 String columnName,
 String newColumnName)

Specified by:

renameColumnIfExists in interface ISchemaWriter

renameTable

public void renameTable(String tableName,
 String newTableName)

Specified by:

renameTable in interface ISchemaWriter

reset

public void reset()

Resets the current Resettable.

Specified by:

reset in interface Resettable

saveChanges

public void saveChanges()

Saves the changes of the current IChangeSaver.

Specified by:

saveChanges in interface IChangeSaver

tableExist

public boolean tableExist()

Specified by:

tableExist in interface ISchemaReader

tableExists

public boolean tableExists(String tableName)

Specified by:

tableExists in interface ISchemaReader