io.micronaut.data.model.query.builder.sql

Class SqlQueryBuilder

java.lang.Object

io.micronaut.data.model.query.builder.AbstractSqlLikeQueryBuilder

io.micronaut.data.model.query.builder.sql.SqlQueryBuilder

All Implemented Interfaces:

QueryBuilder

public class SqlQueryBuilder
extends AbstractSqlLikeQueryBuilder
implements QueryBuilder

Implementation of QueryBuilder that builds SQL queries.

Since:

1.0.0

Author:

graemerocher

Nested Class Summary

Nested classes/interfaces inherited from class io.micronaut.data.model.query.builder.AbstractSqlLikeQueryBuilder

AbstractSqlLikeQueryBuilder.Placeholder, AbstractSqlLikeQueryBuilder.PropertyPath, AbstractSqlLikeQueryBuilder.QueryHandler, AbstractSqlLikeQueryBuilder.QueryPosition, AbstractSqlLikeQueryBuilder.QueryState

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	IN_EXPRESSION_START The start of an IN expression.

Fields inherited from class io.micronaut.data.model.query.builder.AbstractSqlLikeQueryBuilder

AND, AS_CLAUSE, AVG, CLOSE_BRACKET, COMMA, COUNT_DISTINCT, DELETE_CLAUSE, DISTINCT, DOT, EQUALS_FALSE, EQUALS_TRUE, FROM_CLAUSE, FUNCTION_COUNT, GREATER_THAN, GREATER_THAN_OR_EQUALS, IS_EMPTY, IS_NOT_EMPTY, IS_NOT_NULL, IS_NULL, LESS_THAN, LESS_THAN_OR_EQUALS, LOGICAL_AND, LOGICAL_OR, MAX, MIN, NOT_CLAUSE, NOT_EQUALS, OPEN_BRACKET, OR, ORDER_BY_CLAUSE, queryHandlers, SELECT_CLAUSE, SPACE, SUM, UPDATE_CLAUSE, WHERE_CLAUSE

Fields inherited from interface io.micronaut.data.model.query.builder.QueryBuilder

IN_VARIABLES_PATTERN, VARIABLE_PATTERN

Constructor Summary

Constructors

Constructor and Description
SqlQueryBuilder() Default constructor.
SqlQueryBuilder(io.micronaut.core.annotation.AnnotationMetadata annotationMetadata) Constructor with annotation metadata.
SqlQueryBuilder(Dialect dialect)

Method Summary

Modifier and Type	Method and Description
protected void	appendForUpdate(AbstractSqlLikeQueryBuilder.QueryPosition queryPosition, QueryModel query, java.lang.StringBuilder queryBuilder)
protected void	appendProjectionRowCount(java.lang.StringBuilder queryString, java.lang.String logicalName) Appends a row count projection to the query string.
protected void	appendUpdateSetParameter(java.lang.StringBuilder queryString, PersistentProperty prop, AbstractSqlLikeQueryBuilder.Placeholder param) Appends the SET=? call to the query string.
java.lang.String	buildBatchCreateTableStatement(PersistentEntity... entities) Builds a batch create tables statement.
java.lang.String	buildBatchDropTableStatement(PersistentEntity... entities) Builds a batch drop tables statement.
java.lang.String[]	buildCreateTableStatements(PersistentEntity entity) Builds the create table statement.
java.lang.String[]	buildDropTableStatements(PersistentEntity entity) Builds the drop table statement.
QueryResult	buildInsert(io.micronaut.core.annotation.AnnotationMetadata repositoryMetadata, PersistentEntity entity) Builds an insert statement for the given entity.
protected java.lang.String[]	buildJoin(java.lang.String alias, JoinPath joinPath, java.lang.String joinType, java.lang.StringBuilder target, java.util.Map<java.lang.String,java.lang.String> appliedJoinPaths, AbstractSqlLikeQueryBuilder.QueryState queryState) Build a join expression for the given alias, association, join type and builder.
java.lang.String	buildJoinTableInsert(PersistentEntity entity, Association association) Builds a join table insert statement for a given entity and association.
QueryResult	buildPagination(Pageable pageable) Encode the pageable.
protected boolean	computePropertyPaths() Whether property path expressions require computation by the implementation.
protected void	encodeInExpression(java.lang.StringBuilder whereClause, AbstractSqlLikeQueryBuilder.Placeholder placeholder) Placeholders for IN queries in SQL require special treatment.
protected java.lang.String	formatEndsWith()
protected AbstractSqlLikeQueryBuilder.Placeholder	formatParameter(int index) Format the parameter at the given index.
protected java.lang.String	formatStartsWith()
protected java.lang.String	formatStartsWithBeginning()
protected java.lang.String	formEndsWithEnd()
protected java.lang.String	getAliasName(PersistentEntity entity) Get an alias name for the given entity.
java.lang.String	getColumnName(PersistentProperty persistentProperty) Get the column name for the given property.
protected java.lang.String	getTableAsKeyword() Get the AS keyword to use for table aliases.
java.lang.String	getTableName(PersistentEntity entity) Get the table name for the given entity.
protected boolean	isAliasForBatch() Should aliases be used in batch statements.
protected boolean	isExpandEmbedded() Should embedded queries by expanded by the implementation.
static boolean	isForeignKeyWithJoinTable(Association association) Is the given association a foreign key reference that requires a join table.
protected java.lang.String	quote(java.lang.String persistedName) Quote a column name for the dialect.
java.lang.String	resolveJoinType(Join.Type jt) Resolves the join type.
protected void	selectAllColumns(AbstractSqlLikeQueryBuilder.QueryState queryState, java.lang.StringBuilder queryBuffer) Obtain the string that selects all columns from the entity.
void	selectAllColumns(PersistentEntity entity, java.lang.String alias, java.lang.StringBuilder stringBuffer) Selects all columns for the given entity and alias.
protected GeneratedValue.Type	selectAutoStrategy(PersistentProperty property) Selects the default fallback strategy.
boolean	shouldAliasProjections() Whether projections should be aliased.
boolean	supportsForUpdate() Whether FOR UPDATE queries are supported.

Methods inherited from class io.micronaut.data.model.query.builder.AbstractSqlLikeQueryBuilder

appendDeleteClause, buildDelete, buildOrderBy, buildQuery, buildUpdate, computeEmbeddedName, getAliasName, getPathOnlyAliasName, getUnescapedTableName, handleSubQuery, shouldEscape

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.micronaut.data.model.query.builder.QueryBuilder

buildDelete, buildDelete, buildOrderBy, buildQuery, buildQuery, buildUpdate, buildUpdate, newQueryBuilder

Field Detail

IN_EXPRESSION_START

public static final java.lang.String IN_EXPRESSION_START

The start of an IN expression.

See Also:

Constant Field Values

Constructor Detail

SqlQueryBuilder

@Creator
public SqlQueryBuilder(io.micronaut.core.annotation.AnnotationMetadata annotationMetadata)

Constructor with annotation metadata.

Parameters:

annotationMetadata - The annotation metadata

SqlQueryBuilder

public SqlQueryBuilder()

Default constructor.

SqlQueryBuilder

public SqlQueryBuilder(Dialect dialect)

Parameters:

dialect - The dialect

Method Detail

shouldAliasProjections

public boolean shouldAliasProjections()

Description copied from interface: QueryBuilder

Whether projections should be aliased.

Specified by:

shouldAliasProjections in interface QueryBuilder

Returns:

True if they should

isExpandEmbedded

protected boolean isExpandEmbedded()

Description copied from class: AbstractSqlLikeQueryBuilder

Should embedded queries by expanded by the implementation.

Overrides:

isExpandEmbedded in class AbstractSqlLikeQueryBuilder

Returns:

True if they should

buildBatchCreateTableStatement

@NonNull
public java.lang.String buildBatchCreateTableStatement(@NonNull
                                                                PersistentEntity... entities)

Builds a batch create tables statement. Designed for testing and not production usage. For production a SQL migration tool such as Flyway or Liquibase is recommended.

Parameters:

entities - the entities

Returns:

The table

buildBatchDropTableStatement

@NonNull
public java.lang.String buildBatchDropTableStatement(@NonNull
                                                              PersistentEntity... entities)

Builds a batch drop tables statement. Designed for testing and not production usage. For production a SQL migration tool such as Flyway or Liquibase is recommended.

Parameters:

entities - the entities

Returns:

The table

buildDropTableStatements

@NonNull
public java.lang.String[] buildDropTableStatements(@NonNull
                                                            PersistentEntity entity)

Builds the drop table statement. Designed for testing and not production usage. For production a SQL migration tool such as Flyway or Liquibase is recommended.

Parameters:

entity - The entity

Returns:

The tables for the give entity

buildJoinTableInsert

@NonNull
public java.lang.String buildJoinTableInsert(@NonNull
                                                      PersistentEntity entity,
                                                      @NonNull
                                                      Association association)

Builds a join table insert statement for a given entity and association.

Parameters:

entity - The entity

association - The association

Returns:

The join table insert statement

isForeignKeyWithJoinTable

public static boolean isForeignKeyWithJoinTable(@NonNull
                                                Association association)

Is the given association a foreign key reference that requires a join table.

Parameters:

association - The association.

Returns:

True if it is.

buildCreateTableStatements

@NonNull
public java.lang.String[] buildCreateTableStatements(@NonNull
                                                              PersistentEntity entity)

Builds the create table statement. Designed for testing and not production usage. For production a SQL migration tool such as Flyway or Liquibase is recommended.

Parameters:

entity - The entity

Returns:

The tables for the give entity

getTableAsKeyword

protected java.lang.String getTableAsKeyword()

Description copied from class: AbstractSqlLikeQueryBuilder

Get the AS keyword to use for table aliases.

Overrides:

getTableAsKeyword in class AbstractSqlLikeQueryBuilder

Returns:

The AS keyword if any

selectAllColumns

protected void selectAllColumns(AbstractSqlLikeQueryBuilder.QueryState queryState,
                                java.lang.StringBuilder queryBuffer)

Description copied from class: AbstractSqlLikeQueryBuilder

Obtain the string that selects all columns from the entity.

Specified by:

selectAllColumns in class AbstractSqlLikeQueryBuilder

Parameters:

queryState - The query state

selectAllColumns

public void selectAllColumns(PersistentEntity entity,
                             java.lang.String alias,
                             java.lang.StringBuilder stringBuffer)

Selects all columns for the given entity and alias.

Specified by:

selectAllColumns in class AbstractSqlLikeQueryBuilder

Parameters:

entity - The entity

alias - The alias

stringBuffer - The builder to add the columns

resolveJoinType

public java.lang.String resolveJoinType(Join.Type jt)

Description copied from class: AbstractSqlLikeQueryBuilder

Resolves the join type.

Specified by:

resolveJoinType in class AbstractSqlLikeQueryBuilder

Parameters:

jt - The join type

Returns:

The join type.

buildInsert

@NonNull
public QueryResult buildInsert(io.micronaut.core.annotation.AnnotationMetadata repositoryMetadata,
                                        PersistentEntity entity)

Description copied from interface: QueryBuilder

Builds an insert statement for the given entity.

Specified by:

buildInsert in interface QueryBuilder

Parameters:

repositoryMetadata - The repository annotation metadata

entity - The entity

Returns:

The insert statement or null if the implementation doesn't require insert statements

buildPagination

@NonNull
public QueryResult buildPagination(@NonNull
                                            Pageable pageable)

Description copied from interface: QueryBuilder

Encode the pageable.

Specified by:

buildPagination in interface QueryBuilder

Parameters:

pageable - The pageable

Returns:

The encoded query

encodeInExpression

protected void encodeInExpression(java.lang.StringBuilder whereClause,
                                  AbstractSqlLikeQueryBuilder.Placeholder placeholder)

Description copied from class: AbstractSqlLikeQueryBuilder

Placeholders for IN queries in SQL require special treatment. This is handled at runtime by some wrapper implementations like JPAQL. But for raw queries the placeholder needs to be expanded to factor in the size of the list or array.

Overrides:

encodeInExpression in class AbstractSqlLikeQueryBuilder

Parameters:

whereClause - The where clause

placeholder - The placeholder

getAliasName

protected java.lang.String getAliasName(PersistentEntity entity)

Description copied from class: AbstractSqlLikeQueryBuilder

Get an alias name for the given entity.

Overrides:

getAliasName in class AbstractSqlLikeQueryBuilder

Parameters:

entity - The entity

Returns:

The alias name

getTableName

public java.lang.String getTableName(PersistentEntity entity)

Description copied from class: AbstractSqlLikeQueryBuilder

Get the table name for the given entity.

Specified by:

getTableName in class AbstractSqlLikeQueryBuilder

Parameters:

entity - The entity

Returns:

The table name

formatStartsWith

protected java.lang.String formatStartsWith()

Overrides:

formatStartsWith in class AbstractSqlLikeQueryBuilder

Returns:

Formats the starts with expression.

formEndsWithEnd

protected java.lang.String formEndsWithEnd()

Overrides:

formEndsWithEnd in class AbstractSqlLikeQueryBuilder

Returns:

Formats end of an ends with expression

formatEndsWith

protected java.lang.String formatEndsWith()

Overrides:

formatEndsWith in class AbstractSqlLikeQueryBuilder

Returns:

Formats the ends with expression.

formatStartsWithBeginning

protected java.lang.String formatStartsWithBeginning()

Overrides:

formatStartsWithBeginning in class AbstractSqlLikeQueryBuilder

Returns:

Formats the beginning of an starts with expression

appendUpdateSetParameter

protected void appendUpdateSetParameter(java.lang.StringBuilder queryString,
                                        PersistentProperty prop,
                                        AbstractSqlLikeQueryBuilder.Placeholder param)

Description copied from class: AbstractSqlLikeQueryBuilder

Appends the SET=? call to the query string.

Overrides:

appendUpdateSetParameter in class AbstractSqlLikeQueryBuilder

Parameters:

queryString - The query string

prop - The property

param - the parameter

buildJoin

protected java.lang.String[] buildJoin(java.lang.String alias,
                                       JoinPath joinPath,
                                       java.lang.String joinType,
                                       java.lang.StringBuilder target,
                                       java.util.Map<java.lang.String,java.lang.String> appliedJoinPaths,
                                       AbstractSqlLikeQueryBuilder.QueryState queryState)

Description copied from class: AbstractSqlLikeQueryBuilder

Build a join expression for the given alias, association, join type and builder.

Specified by:

buildJoin in class AbstractSqlLikeQueryBuilder

Parameters:

alias - The alias

joinPath - The join path

joinType - The join type string

target - The target builder

appliedJoinPaths - The applied joins paths

queryState - The query state

Returns:

An array representing the aliases for each join association in the specified join path

quote

protected java.lang.String quote(java.lang.String persistedName)

Quote a column name for the dialect.

Overrides:

quote in class AbstractSqlLikeQueryBuilder

Parameters:

persistedName - The persisted name.

Returns:

The quoted name

getColumnName

public java.lang.String getColumnName(PersistentProperty persistentProperty)

Description copied from class: AbstractSqlLikeQueryBuilder

Get the column name for the given property.

Specified by:

getColumnName in class AbstractSqlLikeQueryBuilder

Parameters:

persistentProperty - The property

Returns:

The column name

appendProjectionRowCount

protected void appendProjectionRowCount(java.lang.StringBuilder queryString,
                                        java.lang.String logicalName)

Description copied from class: AbstractSqlLikeQueryBuilder

Appends a row count projection to the query string.

Specified by:

appendProjectionRowCount in class AbstractSqlLikeQueryBuilder

Parameters:

queryString - The query string

logicalName - The alias to the table name

appendForUpdate

protected void appendForUpdate(AbstractSqlLikeQueryBuilder.QueryPosition queryPosition,
                               QueryModel query,
                               java.lang.StringBuilder queryBuilder)

Overrides:

appendForUpdate in class AbstractSqlLikeQueryBuilder

computePropertyPaths

protected final boolean computePropertyPaths()

Description copied from class: AbstractSqlLikeQueryBuilder

Whether property path expressions require computation by the implementation. In a certain query dialects property paths are supported (such as JPA-QL where you can do select foo.bar) whilst for explicit SQL queries paths like this have to be computed into aliases / column name references.

Specified by:

computePropertyPaths in class AbstractSqlLikeQueryBuilder

Returns:

True if property path computation is required.

isAliasForBatch

protected boolean isAliasForBatch()

Description copied from class: AbstractSqlLikeQueryBuilder

Should aliases be used in batch statements.

Specified by:

isAliasForBatch in class AbstractSqlLikeQueryBuilder

Returns:

True if they should

formatParameter

protected AbstractSqlLikeQueryBuilder.Placeholder formatParameter(int index)

Description copied from class: AbstractSqlLikeQueryBuilder

Format the parameter at the given index.

Specified by:

formatParameter in class AbstractSqlLikeQueryBuilder

Parameters:

index - The parameter

Returns:

The index

selectAutoStrategy

protected GeneratedValue.Type selectAutoStrategy(PersistentProperty property)

Selects the default fallback strategy. For a generated value.

Parameters:

property - The Persistent property

Returns:

The generated value

supportsForUpdate

public boolean supportsForUpdate()

Description copied from interface: QueryBuilder

Whether FOR UPDATE queries are supported.

Specified by:

supportsForUpdate in interface QueryBuilder

Returns:

True if FOR UPDATE queries are supported