org.mycontroller.standalone.db.migration

Interface IMigrationClient

All Known Implementing Classes:

ClientH2DB, ClientMysql, ClientPostgreSql

public interface IMigrationClient

Since:

0.0.3

Author:

Jeeva Kandasamy (jkandasa)

Method Summary

Modifier and Type	Method and Description
void	addColumn(String tableName, String columnName, String columnDefinition)
void	alterColumn(String tableName, String columnName, String columnDefinition)
void	createIndex(String indexSuffix, String tableName, String columnName)
void	createTable(Class<?> entity)
void	dropColumn(String tableName, String columnName)
void	dropSequence(String sequenceName)
void	dropTable(Class<?> entity)
void	dropTable(String tableName)
void	executeRaw(String rawQuery)
User	getAdminUser()
String	getColumnName(String columnName)
String	getDatabaseSchemaVersion()
int	getDatabaseSchemaVersionInt()
HashMap<String,String>	getRow(List<HashMap<String,String>> rows, String column, String value)
HashMap<String,String>	getRow(String tableName, String column, String value)
List<HashMap<String,String>>	getRows(String tableName)
String	getTableName(String tableName)
boolean	hasColumn(String tableName, String columnName)
boolean	hasTable(String tableName)
void	renameColumn(String tableName, String oldColumnName, String newColumnName)
void	renameSequence(String sequenceName, String newSequenceName)
void	renameTable(String tableName, String newTableName)

Method Detail

hasColumn

boolean hasColumn(String tableName,
                  String columnName)
           throws SQLException

Throws:

SQLException

dropColumn

void dropColumn(String tableName,
                String columnName)
         throws SQLException

Throws:

SQLException

renameColumn

void renameColumn(String tableName,
                  String oldColumnName,
                  String newColumnName)
           throws SQLException

Throws:

SQLException

alterColumn

void alterColumn(String tableName,
                 String columnName,
                 String columnDefinition)
          throws SQLException

Throws:

SQLException

addColumn

void addColumn(String tableName,
               String columnName,
               String columnDefinition)
        throws SQLException

Throws:

SQLException

hasTable

boolean hasTable(String tableName)
          throws SQLException

Throws:

SQLException

renameTable

void renameTable(String tableName,
                 String newTableName)
          throws SQLException

Throws:

SQLException

dropTable

void dropTable(String tableName)
        throws SQLException

Throws:

SQLException

renameSequence

void renameSequence(String sequenceName,
                    String newSequenceName)
             throws SQLException

Throws:

SQLException

dropSequence

void dropSequence(String sequenceName)
           throws SQLException

Throws:

SQLException

createIndex

void createIndex(String indexSuffix,
                 String tableName,
                 String columnName)
          throws SQLException

Throws:

SQLException

dropTable

void dropTable(Class<?> entity)
        throws SQLException

Throws:

SQLException

createTable

void createTable(Class<?> entity)
          throws SQLException

Throws:

SQLException

getRows

List<HashMap<String,String>> getRows(String tableName)

getRow

HashMap<String,String> getRow(String tableName,
                              String column,
                              String value)

getRow

HashMap<String,String> getRow(List<HashMap<String,String>> rows,
                              String column,
                              String value)
                       throws SQLException

Throws:

SQLException

getColumnName

String getColumnName(String columnName)

getTableName

String getTableName(String tableName)

getAdminUser

User getAdminUser()

executeRaw

void executeRaw(String rawQuery)
         throws SQLException

Throws:

SQLException

getDatabaseSchemaVersion

String getDatabaseSchemaVersion()

getDatabaseSchemaVersionInt

int getDatabaseSchemaVersionInt()