Package com.atlassian.bamboo.utils.db

Class MySqlDbmsBean

java.lang.Object

com.atlassian.bamboo.utils.db.AbstractDbmsBean

com.atlassian.bamboo.utils.db.MySqlDbmsBean

All Implemented Interfaces:

BambooDatabaseTypeProvider, DbmsBean

public class MySqlDbmsBean
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	Description
MySqlDbmsBean()

Method Summary

Modifier and Type	Method	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.
void	dropConstraint(Connection c, String tableName, String constraint)	Drop constraint
protected void	dropConstraints(Connection connection, String tableName, String columnName)
void	dropForeignKeyConstraint(Connection c, String tableName, String foreignKey)
void	dropPrimaryKey(Connection connection, String tableName)	Drops the primary key on a table.
@NotNull String	getConcat(String... values)	Provide a different SQL concatenation operator depending on SQL engine used.
@NotNull Collection<DbmsBean.ConstraintDefinition>	getConstraints(Connection connection, @NotNull String table, @Nullable String column)	Fetch information about constraints
DatabaseType	getDatabaseType()	Detect used database type
@NotNull String	getQuery(@NotNull SqlQueryProvider sqlQueryProvider)	Provide a different SQL query depending on SQL engine used.
boolean	isMySql()
protected DbmsBean.ColumnDefinition	newColumnDefinition(String columnName, int dataType, String dataTypeName, OptionalInt columnSize, Optional<Boolean> isNullable)
String	quote(String name)	Quotes the supplied name according to the quoting rules of the underlying DBMS.
void	renameColumn(Connection c, String tableName, String oldName, String newName)	Rename columns.
void	resizeVarcharColumn(@NotNull Connection connection, String tableName, String columnName, int newSize, boolean isNullable, @Nullable String defaultValue)

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

addColumn, changeColumnToNotNull, changeColumnType, clobEquals, createColumn, createIndex, createPrimaryKey, createUniqueConstraint, dropColumn, dropIndex, dropIndexIfExists, dropTable, getColumnDefinition, getColumnDefinitionString, getColumns, getConstraintDefinitions, getConstraintType, getIndexNames, getIndices, getLargeTextTypeName, getSchema, getSchemaUncached, getSqlTypeName, getTables, isColumnPresent, isColumnPresent, isColumnPresent, isH2, isHsqldb, isMsSqlServer, isOracle, isPostgreSql, isTable, isTablePresent, migrateColumnType, quoteIfNeeded, toLowerCase

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

MySqlDbmsBean

public MySqlDbmsBean()

Method Detail

getQuery

@NotNull
public @NotNull String getQuery(@NotNull
                                @NotNull SqlQueryProvider sqlQueryProvider)

Description copied from interface: DbmsBean

Provide a different SQL query depending on SQL engine used.

Returns:

getConstraints

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

Description copied from interface: DbmsBean

Fetch information about constraints

Throws:

SQLException

getConcat

@NotNull
public @NotNull 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
                                @NotNull Connection connection,
                                String tableName,
                                String columnName,
                                int newSize,
                                boolean isNullable,
                                @Nullable
                                @Nullable String defaultValue)
                         throws SQLException

Throws:

SQLException

isMySql

public boolean isMySql()

Specified by:

isMySql in interface DbmsBean

Overrides:

isMySql in class AbstractDbmsBean

Returns:

true if db configured in Hibernate is MySQL

getDatabaseType

public DatabaseType getDatabaseType()

Description copied from interface: BambooDatabaseTypeProvider

Detect used database type

Returns:

database type

changeColumnDefinition

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

Overrides:

changeColumnDefinition in class AbstractDbmsBean

Throws:

SQLException

dropConstraints

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

Overrides:

dropConstraints in class AbstractDbmsBean

dropConstraint

public void dropConstraint(Connection c,
                           String tableName,
                           String constraint)
                    throws SQLException

Description copied from interface: DbmsBean

Drop constraint

Specified by:

dropConstraint in interface DbmsBean

Overrides:

dropConstraint in class AbstractDbmsBean

Throws:

SQLException - if constraint does not exist

dropForeignKeyConstraint

public void dropForeignKeyConstraint(Connection c,
                                     String tableName,
                                     String foreignKey)
                              throws SQLException

Specified by:

dropForeignKeyConstraint in interface DbmsBean

Overrides:

dropForeignKeyConstraint in class AbstractDbmsBean

Throws:

SQLException

actuallyChangeColumnToNotNull

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

Overrides:

actuallyChangeColumnToNotNull in class AbstractDbmsBean

Throws:

SQLException

quote

public String quote(String name)

Description copied from interface: DbmsBean

Quotes the supplied name according to the quoting rules of the underlying DBMS.

Specified by:

quote in interface DbmsBean

Overrides:

quote in class AbstractDbmsBean

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

dropPrimaryKey

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

Description copied from interface: DbmsBean

Drops the primary key on a table.

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

newColumnDefinition

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

Overrides:

newColumnDefinition in class AbstractDbmsBean