org.mycontroller.standalone.db.migration

Class ClientBase

java.lang.Object

org.mycontroller.standalone.db.migration.ClientBase

Direct Known Subclasses:

ClientH2DB, ClientMysql, ClientPostgreSql

public class ClientBase
extends Object

Since:

0.0.3

Author:

Jeeva Kandasamy (jkandasa)

Constructor Summary

Constructors

Constructor and Description
ClientBase()

Method Summary

Modifier and Type	Method and Description
void	addColumn(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	dropTable(Class<?> entity)
void	dropTable(String tableName)
void	executeRaw(String rawQuery)
User	getAdminUser()
String	getColumnName(String columnName)
String	getDatabaseSchemaVersion()
int	getDatabaseSchemaVersionInt()
protected String	getIndexName(String indexSuffix, String tableName, String columnName)
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)
List<HashMap<String,String>>	getRowsByQuery(String query)
String	getSequenceName(String sequence)
String	getTableName(String tableName)
boolean	hasColumn(String tableName, String columnName)
boolean	hasTable(String tableName)
void	renameSequence(String sequenceName, String newSequenceName)

Methods inherited from class java.lang.Object

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

Constructor Detail

ClientBase

public ClientBase()

Method Detail

addColumn

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

Throws:

SQLException

hasColumn

public boolean hasColumn(String tableName,
                         String columnName)
                  throws SQLException

Throws:

SQLException

dropColumn

public void dropColumn(String tableName,
                       String columnName)
                throws SQLException

Throws:

SQLException

hasTable

public boolean hasTable(String tableName)

dropTable

public void dropTable(String tableName)
               throws SQLException

Throws:

SQLException

dropTable

public void dropTable(Class<?> entity)
               throws SQLException

Throws:

SQLException

createTable

public void createTable(Class<?> entity)
                 throws SQLException

Throws:

SQLException

getRows

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

getRowsByQuery

public List<HashMap<String,String>> getRowsByQuery(String query)

getRow

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

getRow

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

getColumnName

public String getColumnName(String columnName)

getTableName

public String getTableName(String tableName)

getSequenceName

public String getSequenceName(String sequence)

getAdminUser

public User getAdminUser()

executeRaw

public void executeRaw(String rawQuery)
                throws SQLException

Throws:

SQLException

getIndexName

protected String getIndexName(String indexSuffix,
                              String tableName,
                              String columnName)

createIndex

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

Throws:

SQLException

getDatabaseSchemaVersion

public String getDatabaseSchemaVersion()

getDatabaseSchemaVersionInt

public int getDatabaseSchemaVersionInt()

renameSequence

public void renameSequence(String sequenceName,
                           String newSequenceName)
                    throws SQLException

Throws:

SQLException