public class PostgreSqlDbmsBean extends AbstractDbmsBean
Constructor and Description |
---|
PostgreSqlDbmsBean() |
Modifier and Type | Method and Description |
---|---|
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.
|
DatabaseType |
getDatabaseType()
Detect used database type
|
String |
getQuery(SqlQueryProvider sqlQueryProvider)
Provide a different SQL query depending on SQL engine used.
|
boolean |
isPostgreSql() |
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) |
changeTableNameToUpperCase, dropColumn, dropColumn, dropConstraints, dropIndex, isColumnPresent, isColumnPresent, isHsqldb, isMsSqlServer, isMySql, isOracle, isTablePresent, isTablePresent, renameColumn
@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 isPostgreSql()
isPostgreSql
in interface DbmsBean
isPostgreSql
in class AbstractDbmsBean
public DatabaseType getDatabaseType()
DbmsBean
public void dropPrimaryKey(Connection connection, String tableName) throws SQLException
DbmsBean
SQLException
Copyright © 2017 Atlassian Software Systems Pty Ltd. All rights reserved.