Package de.xima.fc.liquibase

Class LiquibaseDBUtils

  • public class LiquibaseDBUtils
extends Object

    • Constructor Detail

      • LiquibaseDBUtils

        public LiquibaseDBUtils()

    • Method Detail

      • dropTable

        public static void dropTable​(IEntityContext ec,
                             String tableName)
                      throws Exception
        Method to drop a table while using the underlying database connection. In order for the deletion to take place, the system first checks whether the table exists. If the table does not exist a log-entry is being written and processing is aborted.
        Parameters:
        ec - the entity context for the database-connection to use
        tableName - the name of the table to delete
        Throws:
        Exception - on errors while dropping the table

      • createTable

        public static void createTable​(IEntityContext ec,
                               String tableName,
                               ArrayList<String> colNames,
                               String colType)
                        throws Exception
        Method to create a table while using the underlying database connection. In order for the table to be created, it is first checked whether the table does not exist. If the table already exists, a log message is displayed and processing is aborted.
        Parameters:
        ec - the entity context for the database-connection to use
        tableName - the name of the table to create
        colNames - the names of the columns to use for this table
        colType - the type of the columns to use for this table
        Throws:
        Exception

      • getTableExistsPrecondition

        public static liquibase.precondition.core.TableExistsPrecondition getTableExistsPrecondition​(liquibase.database.Database db,
                                                                                             String tableName)
                                                                                      throws liquibase.exception.DatabaseException
        Method to create a TableExistsPrecondition to checks if a table exists.
        Parameters:
        db - the database to check the table existence for
        tableName - the name of the table to check for
        Returns:
        TableExistsPrecondition the resulting check
        Throws:
        liquibase.exception.DatabaseException

      • getForeignKeyExistsPrecondition

        public static liquibase.precondition.core.ForeignKeyExistsPrecondition getForeignKeyExistsPrecondition​(liquibase.database.Database db,
                                                                                                       String tableName,
                                                                                                       String foreignKey)
                                                                                                throws liquibase.exception.DatabaseException
        Method to create a ForeignKeyExistsPrecondition check if a foreign key exists
        Parameters:
        db - the database to use
        tableName - the name of the table to check for the foreign key
        foreignKey - the name of the foreign key to check
        Returns:
        ForeignKeyExistsPrecondition the resulting check
        Throws:
        liquibase.exception.DatabaseException

      • getAddForeignKeyConstraintStatement

        public static liquibase.sql.Sql[] getAddForeignKeyConstraintStatement​(liquibase.database.Database db,
                                                                      String tableName)

      • getForeignKeyName

        public static String getForeignKeyName​(String tableName)

      • getPrimaryKeyName

        public static String getPrimaryKeyName​(String tableName)