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:

com.atlassian.bamboo.utils.db.DbmsBean

public class MsSqlDbmsBean
extends AbstractDbmsBean

Constructor Summary

Constructors

Constructor and Description
MsSqlDbmsBean()

Method Summary

Methods

Modifier and Type	Method and Description
protected void	dropConstraints(Statement statement, String tableName, String columnName, List<String> defaultConstraintNames)
protected void	dropIndex(Statement statement, String indexName)
String	getConcat(String... values)
String	getQuery(com.atlassian.bamboo.utils.db.SqlQueryProvider sqlQueryProvider)
boolean	isMsSqlServer()
PreparedStatement	prepareStatement(Connection connection, com.atlassian.bamboo.utils.db.PreparedStatementProvider preparedStatementProvider)
void	resizeVarcharColumn(Statement statement, String tableName, String columnName, int newSize, boolean isNullable, String defaultValue)

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

dropColumn, dropColumn, isColumnPresent, isColumnPresent, isHsqldb, isMySql, isOracle, isPostgreSql, isTablePresent, isTablePresent

Methods inherited from class java.lang.Object

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

Constructor Detail

MsSqlDbmsBean

public MsSqlDbmsBean()

Method Detail

getQuery

@NotNull
public String getQuery(@NotNull
                      com.atlassian.bamboo.utils.db.SqlQueryProvider sqlQueryProvider)

getConcat

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

prepareStatement

@NotNull
public PreparedStatement prepareStatement(@NotNull
                                         Connection connection,
                                         @NotNull
                                         com.atlassian.bamboo.utils.db.PreparedStatementProvider preparedStatementProvider)
                                   throws SQLException

Throws:

SQLException

resizeVarcharColumn

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

Throws:

SQLException

isMsSqlServer

public boolean isMsSqlServer()

Specified by:

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

Overrides:

isMsSqlServer in class AbstractDbmsBean

dropIndex

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

Overrides:

dropIndex in class AbstractDbmsBean

Throws:

SQLException

dropConstraints

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

Overrides:

dropConstraints in class AbstractDbmsBean