com.atlassian.bamboo.utils.db

Class AbstractDbmsBean

java.lang.Object

com.atlassian.bamboo.utils.db.AbstractDbmsBean

All Implemented Interfaces:

com.atlassian.bamboo.utils.db.DbmsBean

Direct Known Subclasses:

HsqlDbmsBean, MsSqlDbmsBean, MySqlDbmsBean, OracleDbmsBean, PostgreSqlDbmsBean

public abstract class AbstractDbmsBean
extends Object
implements com.atlassian.bamboo.utils.db.DbmsBean

Constructor Summary

Constructors

Constructor and Description
AbstractDbmsBean()

Method Summary

Methods

Modifier and Type	Method and Description
boolean	dropColumn(Connection connection, String tableName, String columnName)
boolean	dropColumn(Connection connection, String tableName, String columnName, List<String> defaultConstraintNames, String indexName)
protected void	dropConstraints(Statement statement, String tableName, String columnName, List<String> defaultConstraintNames)
protected void	dropIndex(Statement statement, String indexName)
boolean	isColumnPresent(Connection connection, String tableName, String columnName)
boolean	isColumnPresent(Statement statement, String tableName, String columnName)
boolean	isHsqldb()
boolean	isMsSqlServer()
boolean	isMySql()
boolean	isOracle()
boolean	isPostgreSql()
boolean	isTablePresent(Connection connection, String tableName)
boolean	isTablePresent(Statement statement, String tableName)

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.atlassian.bamboo.utils.db.DbmsBean

getConcat, getQuery, prepareStatement, resizeVarcharColumn

Constructor Detail

AbstractDbmsBean

public AbstractDbmsBean()

Method Detail

isColumnPresent

public boolean isColumnPresent(@NotNull
                      Connection connection,
                      @NotNull
                      String tableName,
                      @NotNull
                      String columnName)
                        throws SQLException

Specified by:

isColumnPresent in interface com.atlassian.bamboo.utils.db.DbmsBean

Throws:

SQLException

isColumnPresent

public boolean isColumnPresent(@NotNull
                      Statement statement,
                      @NotNull
                      String tableName,
                      @NotNull
                      String columnName)
                        throws SQLException

Specified by:

isColumnPresent in interface com.atlassian.bamboo.utils.db.DbmsBean

Throws:

SQLException

dropColumn

public boolean dropColumn(@NotNull
                 Connection connection,
                 @NotNull
                 String tableName,
                 @NotNull
                 String columnName,
                 @NotNull
                 List<String> defaultConstraintNames,
                 @Nullable
                 String indexName)
                   throws SQLException

Specified by:

dropColumn in interface com.atlassian.bamboo.utils.db.DbmsBean

Throws:

SQLException

dropConstraints

protected void dropConstraints(Statement statement,
                   String tableName,
                   String columnName,
                   List<String> defaultConstraintNames)

dropIndex

protected void dropIndex(Statement statement,
             String indexName)
                  throws SQLException

Throws:

SQLException

dropColumn

public boolean dropColumn(@NotNull
                 Connection connection,
                 @NotNull
                 String tableName,
                 @NotNull
                 String columnName)
                   throws SQLException

Specified by:

dropColumn in interface com.atlassian.bamboo.utils.db.DbmsBean

Throws:

SQLException

isTablePresent

public boolean isTablePresent(@NotNull
                     Connection connection,
                     @NotNull
                     String tableName)
                       throws SQLException

Specified by:

isTablePresent in interface com.atlassian.bamboo.utils.db.DbmsBean

Throws:

SQLException

isTablePresent

public boolean isTablePresent(@NotNull
                     Statement statement,
                     @NotNull
                     String tableName)

Specified by:

isTablePresent in interface com.atlassian.bamboo.utils.db.DbmsBean

isHsqldb

public boolean isHsqldb()

Specified by:

isHsqldb in interface com.atlassian.bamboo.utils.db.DbmsBean

isMsSqlServer

public boolean isMsSqlServer()

Specified by:

isMsSqlServer in interface com.atlassian.bamboo.utils.db.DbmsBean

isMySql

public boolean isMySql()

Specified by:

isMySql in interface com.atlassian.bamboo.utils.db.DbmsBean

isOracle

public boolean isOracle()

Specified by:

isOracle in interface com.atlassian.bamboo.utils.db.DbmsBean

isPostgreSql

public boolean isPostgreSql()

Specified by:

isPostgreSql in interface com.atlassian.bamboo.utils.db.DbmsBean