com.atlassian.bamboo.utils.db

Interface SqlQueryProvider

public interface SqlQueryProvider

Used to provide proper SQL query for a given database.

See Also:

DbmsBean.getQuery(SqlQueryProvider)

Method Summary

Modifier and Type	Method and Description
String	getDefaultQuery()
default String	getH2Query()
default String	getMsSqlQuery()
default String	getMySqlQuery()
default String	getOracleQuery()
default String	getPostgreSqlQuery()

Method Detail

getDefaultQuery

@NotNull
String getDefaultQuery()

Returns:

default SQL query

getH2Query

@NotNull
default String getH2Query()

Returns:

specialized/optimised SQL query for H2 engine

getMsSqlQuery

@NotNull
default String getMsSqlQuery()

Returns:

specialized/optimised SQL query for SQL Server engine

getMySqlQuery

@NotNull
default String getMySqlQuery()

Returns:

specialized/optimised SQL query for MySQL engine

getOracleQuery

@NotNull
default String getOracleQuery()

Returns:

specialized/optimised SQL query for Oracle engine

getPostgreSqlQuery

@NotNull
default String getPostgreSqlQuery()

Returns:

specialized/optimised SQL query for PostgreSQL engine