com.atlassian.bamboo.utils.db

Interface DbmsBean

public interface DbmsBean

Method Summary

Methods

Modifier and Type	Method and Description
boolean	dropColumn(Connection connection, String tableName, String columnName) Checks whether given table contains the specified column and drops it
boolean	dropColumn(Connection connection, String tableName, String columnName, List<String> defaultConstraintNames, String indexName) Checks whether given table contains the specified column and drops it, as well as foreign key constraints and index on the column.
String	getConcat(String... values) Provide a different SQL concatenation operator depending on SQL engine used.
String	getQuery(SqlQueryProvider sqlQueryProvider) Provide a different SQL query depending on SQL engine used.
boolean	isColumnPresent(Connection connection, String tableName, String columnName) Checks whether given table contains the specified column.
boolean	isColumnPresent(Statement statement, String tableName, String columnName) Checks whether given table contains the specified column.
boolean	isHsqldb()
boolean	isMsSqlServer()
boolean	isMySql()
boolean	isOracle()
boolean	isPostgreSql()
boolean	isTablePresent(Connection connection, String tableName) Checks whether given table is present in the database
boolean	isTablePresent(Statement statement, String tableName) Checks whether given table is present in the database
PreparedStatement	prepareStatement(Connection connection, PreparedStatementProvider preparedStatementProvider) Provide a different PreparedStatement depending on SQL engine used.
void	resizeVarcharColumn(Statement statement, String tableName, String columnName, int newSize, boolean isNullable, String defaultValue)

Method Detail

getQuery

@NotNull
String getQuery(@NotNull
                      SqlQueryProvider sqlQueryProvider)

Provide a different SQL query depending on SQL engine used.

Parameters:

sqlQueryProvider -

Returns:

getConcat

@NotNull
String getConcat(String... values)

Provide a different SQL concatenation operator depending on SQL engine used.

Parameters:

values - the values to concatenate.

Returns:

the concatenation SQL to append to a query.

prepareStatement

@NotNull
PreparedStatement prepareStatement(@NotNull
                                         Connection connection,
                                         @NotNull
                                         PreparedStatementProvider preparedStatementProvider)
                                   throws SQLException

Provide a different PreparedStatement depending on SQL engine used.

Parameters:

connection -

preparedStatementProvider -

Returns:

Throws:

SQLException

isColumnPresent

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

Checks whether given table contains the specified column.

Parameters:

connection -

tableName -

columnName -

Returns:

Throws:

SQLException

isColumnPresent

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

Checks whether given table contains the specified column.

Parameters:

statement -

tableName -

columnName -

Returns:

Throws:

SQLException

dropColumn

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

Checks whether given table contains the specified column and drops it

Parameters:

connection -

tableName -

columnName -

Returns:

Throws:

SQLException

dropColumn

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

Checks whether given table contains the specified column and drops it, as well as foreign key constraints and index on the column. The method will automatically detect constraint names on DBMS that supports it or use provided names on DBMS that don't.

Parameters:

connection -

tableName -

columnName -

defaultConstraintNames -

indexName -

Returns:

Throws:

SQLException

isTablePresent

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

Checks whether given table is present in the database

Parameters:

statement - statement used to verify DB table existence

tableName - name of DB table

Returns:

true if database is accessible and table exists, false otherwise

isTablePresent

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

Checks whether given table is present in the database

Parameters:

connection - connection used to verify DB table existence

tableName - name of DB table

Returns:

true if database is accessible and table exists, false otherwise

Throws:

SQLException - if a database error occurs or connection is closed

resizeVarcharColumn

void resizeVarcharColumn(@NotNull
                       Statement statement,
                       String tableName,
                       String columnName,
                       int newSize,
                       boolean isNullable,
                       @Nullable
                       String defaultValue)
                         throws SQLException

Throws:

SQLException

isMySql

boolean isMySql()

Returns:

true if db configured in Hibernate is MySQL

isOracle

boolean isOracle()

Returns:

true if db configured in Hibernate is Oracle

isHsqldb

boolean isHsqldb()

Returns:

true if db configured in Hibernate is HSQL

isPostgreSql

boolean isPostgreSql()

Returns:

true if db configured in Hibernate is PostgreSQL

isMsSqlServer

boolean isMsSqlServer()

Returns:

true if db configured in Hibernate is Microsoft SQL Server