public class MsSqlDbmsBean extends AbstractDbmsBean
Constructor and Description |
---|
MsSqlDbmsBean() |
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)
Provide a different SQL concatenation operator depending on SQL engine used.
|
DatabaseType |
getDatabaseType()
Detect used database type
|
String |
getQuery(SqlQueryProvider sqlQueryProvider)
Provide a different SQL query depending on SQL engine used.
|
boolean |
isMsSqlServer() |
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) |
dropColumn, dropColumn, isColumnPresent, isColumnPresent, isHsqldb, isMySql, isOracle, isPostgreSql, isTablePresent, isTablePresent
@NotNull public String getQuery(@NotNull SqlQueryProvider sqlQueryProvider)
DbmsBean
@NotNull public String getConcat(String... values)
DbmsBean
values
- the values to concatenate.@NotNull public PreparedStatement prepareStatement(@NotNull Connection connection, @NotNull PreparedStatementProvider preparedStatementProvider) throws SQLException
DbmsBean
PreparedStatement
depending on SQL engine used.SQLException
public void resizeVarcharColumn(@NotNull Statement statement, String tableName, String columnName, int newSize, boolean isNullable, @Nullable String defaultValue) throws SQLException
SQLException
public boolean isMsSqlServer()
isMsSqlServer
in interface DbmsBean
isMsSqlServer
in class AbstractDbmsBean
public DatabaseType getDatabaseType()
DbmsBean
protected void dropIndex(Statement statement, String indexName) throws SQLException
dropIndex
in class AbstractDbmsBean
SQLException
protected void dropConstraints(Statement statement, String tableName, String columnName, List<String> defaultConstraintNames)
dropConstraints
in class AbstractDbmsBean
Copyright © 2016 Atlassian Software Systems Pty Ltd. All rights reserved.