org.mycontroller.standalone.db.migration

Class ClientMysql

java.lang.Object

org.mycontroller.standalone.db.migration.ClientBase

org.mycontroller.standalone.db.migration.ClientMysql

All Implemented Interfaces:

IMigrationClient

public class ClientMysql
extends ClientBase
implements IMigrationClient

Since:

0.0.3

Author:

Jeeva Kandasamy (jkandasa)

Constructor Summary

Constructors

Constructor and Description
ClientMysql()

Method Summary

Modifier and Type	Method and Description
void	alterColumn(String tableName, String columnName, String columnDefinition)
void	createIndex(String indexSuffix, String tableName, String columnName)
void	dropSequence(String sequenceName)
void	renameColumn(String tableName, String oldColumnName, String newColumnName)
void	renameTable(String tableName, String newTableName)

Methods inherited from class org.mycontroller.standalone.db.migration.ClientBase

addColumn, createTable, dropColumn, dropTable, dropTable, executeRaw, getAdminUser, getColumnName, getDatabaseSchemaVersion, getDatabaseSchemaVersionInt, getIndexName, getRow, getRow, getRows, getRowsByQuery, getSequenceName, getTableName, hasColumn, hasTable, renameSequence

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.mycontroller.standalone.db.migration.IMigrationClient

addColumn, createTable, dropColumn, dropTable, dropTable, executeRaw, getAdminUser, getColumnName, getDatabaseSchemaVersion, getDatabaseSchemaVersionInt, getRow, getRow, getRows, getTableName, hasColumn, hasTable, renameSequence

Constructor Detail

ClientMysql

public ClientMysql()

Method Detail

renameColumn

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

Specified by:

renameColumn in interface IMigrationClient

Throws:

SQLException

alterColumn

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

Specified by:

alterColumn in interface IMigrationClient

Throws:

SQLException

renameTable

public void renameTable(String tableName,
                        String newTableName)
                 throws SQLException

Specified by:

renameTable in interface IMigrationClient

Throws:

SQLException

createIndex

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

Specified by:

createIndex in interface IMigrationClient

Overrides:

createIndex in class ClientBase

Throws:

SQLException

dropSequence

public void dropSequence(String sequenceName)
                  throws SQLException

Specified by:

dropSequence in interface IMigrationClient

Throws:

SQLException