com.atlassian.bamboo.utils.db

Class MsSqlDbmsBean

java.lang.Object

com.atlassian.bamboo.utils.db.AbstractDbmsBean

com.atlassian.bamboo.utils.db.MsSqlDbmsBean

All Implemented Interfaces:

DbmsBean

public class MsSqlDbmsBean
extends AbstractDbmsBean

Nested Class Summary

Nested classes/interfaces inherited from interface com.atlassian.bamboo.utils.db.DbmsBean

DbmsBean.ColumnDefinition, DbmsBean.ConstraintDefinition, DbmsBean.IndexDefinition

Field Summary

Fields inherited from class com.atlassian.bamboo.utils.db.AbstractDbmsBean

LARGE_STRING_TYPE

Constructor Summary

Constructors

Constructor and Description
MsSqlDbmsBean()

Method Summary

Modifier and Type	Method and Description
void	actuallyChangeColumnToNotNull(Connection c, String tableName, String columnName)
protected void	changeColumnDefinition(Connection c, String table, String column, String sqlType, boolean isNullable)
void	changeTableNameToUpperCase(Connection connection, String oldName) Rename table from lower case to upper case.
String	clobEquals(String columnName) Comparison string for CLOB column.
protected void	dropConstraints(Connection connection, String tableName, String columnName)
void	dropIndex(Connection c, String table, String index)
void	dropPrimaryKey(Connection connection, String tableName) Drops the primary key on a table.
String	getConcat(String... values) Provide a different SQL concatenation operator depending on SQL engine used.
Collection<DbmsBean.ConstraintDefinition>	getConstraints(Connection connection, String table, String column) Fetch information about constraints
DatabaseType	getDatabaseType() Detect used database type
String	getQuery(SqlQueryProvider sqlQueryProvider) Provide a different SQL query depending on SQL engine used.
protected String	getSqlTypeName(int type)
boolean	isColumnPresent(Statement statement, String tableName, String columnName) Checks whether given table contains the specified column.
boolean	isMsSqlServer()
protected DbmsBean.ColumnDefinition	newColumnDefinition(String columnName, int dataType, String dataTypeName, OptionalInt columnSize, Optional<Boolean> isNullable)
void	renameColumn(Connection c, String tableName, String oldName, String newName) Rename columns.
void	resizeVarcharColumn(Connection connection, String tableName, String columnName, int newSize, boolean isNullable, String defaultValue)

Methods inherited from class com.atlassian.bamboo.utils.db.AbstractDbmsBean

addColumn, changeColumnToNotNull, changeColumnType, createColumn, createIndex, createPrimaryKey, createUniqueConstraint, dropColumn, dropConstraint, dropForeignKeyConstraint, dropIndexIfExists, dropTable, getColumnDefinition, getColumns, getConstraintDefinitions, getConstraintType, getIndexNames, getIndices, getSchema, getSchemaUncached, getTables, isColumnPresent, isColumnPresent, isH2, isHsqldb, isMySql, isOracle, isPostgreSql, isTable, isTablePresent, migrateColumnType, quote, quoteIfNeeded

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

getCatalog

Constructor Detail

MsSqlDbmsBean

public MsSqlDbmsBean()

Method Detail

getQuery

@NotNull
public String getQuery(@NotNull
                                SqlQueryProvider sqlQueryProvider)

Description copied from interface: DbmsBean

Provide a different SQL query depending on SQL engine used.

Returns:

getConcat

@NotNull
public String getConcat(String... values)

Description copied from interface: DbmsBean

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.

resizeVarcharColumn

public void resizeVarcharColumn(@NotNull
                                Connection connection,
                                String tableName,
                                String columnName,
                                int newSize,
                                boolean isNullable,
                                @Nullable
                                String defaultValue)
                         throws SQLException

Throws:

SQLException

isMsSqlServer

public boolean isMsSqlServer()

Specified by:

isMsSqlServer in interface DbmsBean

Overrides:

isMsSqlServer in class AbstractDbmsBean

Returns:

true if db configured in Hibernate is Microsoft SQL Server

getDatabaseType

public DatabaseType getDatabaseType()

Description copied from interface: DbmsBean

Detect used database type

Returns:

database type

dropIndex

public void dropIndex(Connection c,
                      String table,
                      String index)
               throws SQLException

Specified by:

dropIndex in interface DbmsBean

Overrides:

dropIndex in class AbstractDbmsBean

Throws:

SQLException

dropConstraints

protected void dropConstraints(Connection connection,
                               String tableName,
                               String columnName)

Overrides:

dropConstraints in class AbstractDbmsBean

isColumnPresent

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

Description copied from interface: DbmsBean

Checks whether given table contains the specified column.

Specified by:

isColumnPresent in interface DbmsBean

Overrides:

isColumnPresent in class AbstractDbmsBean

Returns:

true if given table contains the specified column or false when either column or table doesn't exist

Throws:

SQLException

dropPrimaryKey

public void dropPrimaryKey(Connection connection,
                           String tableName)
                    throws SQLException

Description copied from interface: DbmsBean

Drops the primary key on a table.

Throws:

SQLException

getConstraints

@NotNull
public Collection<DbmsBean.ConstraintDefinition> getConstraints(Connection connection,
                                                                         @NotNull
                                                                         String table,
                                                                         @Nullable
                                                                         String column)
                                                                  throws SQLException

Description copied from interface: DbmsBean

Fetch information about constraints

Throws:

SQLException

changeTableNameToUpperCase

public void changeTableNameToUpperCase(Connection connection,
                                       String oldName)
                                throws SQLException

Description copied from interface: DbmsBean

Rename table from lower case to upper case. No-op if database is table names are case insensitive.

Specified by:

changeTableNameToUpperCase in interface DbmsBean

Overrides:

changeTableNameToUpperCase in class AbstractDbmsBean

Throws:

SQLException

renameColumn

public void renameColumn(Connection c,
                         String tableName,
                         String oldName,
                         String newName)
                  throws SQLException

Description copied from interface: DbmsBean

Rename columns.

Specified by:

renameColumn in interface DbmsBean

Specified by:

renameColumn in class AbstractDbmsBean

Throws:

SQLException

clobEquals

@NotNull
public String clobEquals(@NotNull
                                  String columnName)

Description copied from interface: DbmsBean

Comparison string for CLOB column.

Specified by:

clobEquals in interface DbmsBean

Overrides:

clobEquals in class AbstractDbmsBean

Parameters:

columnName - column name

Returns:

string for prepared statement

newColumnDefinition

protected DbmsBean.ColumnDefinition newColumnDefinition(String columnName,
                                                        int dataType,
                                                        String dataTypeName,
                                                        OptionalInt columnSize,
                                                        Optional<Boolean> isNullable)

Overrides:

newColumnDefinition in class AbstractDbmsBean

actuallyChangeColumnToNotNull

public void actuallyChangeColumnToNotNull(Connection c,
                                          String tableName,
                                          String columnName)
                                   throws SQLException

Overrides:

actuallyChangeColumnToNotNull in class AbstractDbmsBean

Throws:

SQLException

changeColumnDefinition

protected void changeColumnDefinition(Connection c,
                                      String table,
                                      String column,
                                      String sqlType,
                                      boolean isNullable)
                               throws SQLException

Overrides:

changeColumnDefinition in class AbstractDbmsBean

Throws:

SQLException

getSqlTypeName

@NotNull
protected String getSqlTypeName(int type)

Overrides:

getSqlTypeName in class AbstractDbmsBean