Class PostgreSQLSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

org.hibernate.dialect.sql.ast.spi.AbstractSqlAstTranslator<T>

org.hibernate.dialect.sql.ast.spi.SqlAstTranslatorWithMerge<T>

org.hibernate.dialect.sql.ast.spi.PostgreSQLFamilySqlAstTranslator<T>

org.hibernate.dialect.sql.ast.spi.PostgreSQLSqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAstWalker, SqlAstTranslator<T>, SqlAppender

@SPI({USE,IMPLEMENT})
public class PostgreSQLSqlAstTranslator<T extends JdbcOperation>
extends PostgreSQLFamilySqlAstTranslator<T>

A SQL AST translator for PostgreSQL.

Nested Class Summary

Nested classes/interfaces inherited from class AbstractSqlAstTranslator

AbstractSqlAstTranslator.LockStrategy, AbstractSqlAstTranslator.SubQueryRelationalRestrictionEmulationRenderer<X>

Field Summary

Fields inherited from interface SqlAppender

CLOSE_PARENTHESIS, COMMA_SEPARATOR, COMMA_SEPARATOR_CHAR, NO_SEPARATOR, NULL_KEYWORD, OPEN_PARENTHESIS, PARAM_MARKER, WHITESPACE

Constructor Summary

Constructors

Constructor	Description
PostgreSQLSqlAstTranslator(SqlAstTranslationRequest<? extends Statement, T> request)

Method Summary

Modifier and Type	Method	Description
protected String	getArrayContainsFunction()	Returns the name of the array_contains(array, element) function, which is used for emulating the cycle clause.
protected SelectItemReferenceStrategy	getGroupBySelectItemReferenceStrategy()	Select how this translator refers to select items in a group by clause.
protected InsertConflictRenderingSupport	getInsertConflictRenderingSupport()	Supplies the strategy which selects insert-conflict rendering plans.
protected PaginationRenderingSupport	getPaginationRenderingSupport()	Supplies the strategy which selects SQL AST pagination plans.
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderCycleUsingClause(CteStatement cte)	Render the optional path column of a standard CTE cycle clause.
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderFromClauseAfterUpdateSet(UpdateStatement statement)
protected void	renderInsertIntoNoColumns(TableInsertStandard tableInsert)	Render a complete insert into statement for an insert with no column value bindings.
protected void	renderLikePredicate(LikePredicate likePredicate)
protected void	renderMaterializationHint(CteMaterialization materialization)
protected void	renderPartitionItem(Expression expression)
protected void	renderStandardTableInsert(TableInsertStandard tableInsert)
void	visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)
void	visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)
void	visitInArrayPredicate(InArrayPredicate inArrayPredicate)
void	visitNullnessPredicate(NullnessPredicate nullnessPredicate)

Methods inherited from class PostgreSQLFamilySqlAstTranslator

expectation, renderMergeStatement, renderTableReferenceAlias

Methods inherited from class SqlAstTranslatorWithMerge

createMergeOperation, renderMergeDelete, renderMergeInsert, renderMergeInto, renderMergeOn, renderMergeSourceAlias, renderMergeTargetAlias, renderMergeUpdate, renderMergeUsing, renderMergeUsingQuery, renderMergeUsingQuerySelection

Methods inherited from class AbstractSqlAstTranslator

addAdditionalWherePredicate, addAffectedTableName, addParameterBinder, addParameterBinder, afterQueryGroup, append, append, append, appendBackslashEscapedLikeLiteral, appendDoubleQuoteEscapedString, appendSingleQuoteEscapedString, appendSql, appendSql, appendSql, appendSql, appendSql, appendSql, appendSql, applySqlComment, areAllResultsParameters, areAllResultsParameters, assertRowsOnlyFetchClauseType, beforeQueryGroup, castFunction, castNumberToString, determineColumnReferenceQualifier, determineCyclePathColumnName, determineLateralEmulationPredicate, determineLockingStrategy, determinePaginationRenderingPlan, determineUniqueConstraintNameThatMayFail, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, getAffectedTableNames, getBooleanType, getClauseStack, getCteParameterRenderingMode, getCteStatement, getCurrentClauseStack, getCurrentDmlStatement, getCurrentQueryPart, getDerivedTableRenderingSupport, getDialect, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getIntegerType, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLiteralValue, getLockingClauseStrategy, getLockOptions, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryMutationRenderingSupport, getQueryPartForRowNumbering, getQueryPartStack, getReturningRenderingSupport, getSelectItemReference, getSelectOnlyFromClause, getSessionFactory, getSetReturningFunctionRenderingSupport, getSingleRowTableExpression, getSortSpecificationsRowNumbering, getSql, getSqlAst, getSqlBuffer, getStatement, getStatementStack, getStringType, getTableJoinRenderingSupport, getTranslationRequest, getVersionSeedMapping, getWrapperOptions, hasAggregateFunctions, hasFrom, hasLimit, hasLimit, hasNestedOrTargetTableCorrelation, hasNonTrivialFromClause, hasOffset, hasTargetTableCorrelation, hasWhere, inOverOrWithinGroupClause, interpretExpression, isInRecursiveQueryPart, isInSubquery, isIntegerDivisionEmulationRequired, isLiteral, isLob, isParameter, isParameterInterpretation, isRenderingCorrelatedDerivedTable, isRenderingDerivedTable, isRenderingLateralDerivedTable, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, preferUnionQueryForTupleInListPredicate, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderAssignmentColumn, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderColumnWrite, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteSelectHint, renderCycleClause, renderDeleteClause, renderDeleteStatementDirect, renderDeleteStatementWithJoinEmulation, renderDerivedTableReferenceIdentificationVariable, renderEmptyOrderBy, renderEscapeCharacter, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderExpressionsAsValuesSubquery, renderFetch, renderFetchExpression, renderFetchFirstRow, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertInto, renderInsertStatementAsMerge, renderInterval, renderIntervalLiteral, renderIntoIntoAndTable, renderLegacyReturningInsert, renderLikePattern, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMergeUpdateClause, renderNamedSetReturningFunction, renderNull, renderOffset, renderOffsetExpression, renderOffsetFetchClause, renderOffsetFetchClause, renderOnDuplicateKeyConflictClause, renderOrderByClause, renderParameterAsParameter, renderPrimaryTableReferencePrefix, renderQuantifiedEmulationSubQuery, renderQueryGroupWithoutOrderByAndOffsetFetch, renderQueryPartTableReferenceWithSelectListAliases, renderRecursiveCteVirtualSelections, renderRelationalEmulationSubQuery, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectItems, renderSelectSimpleComparison, renderSelectStatement, renderSelectTupleComparison, renderSetAssignment, renderSetAssignmentEmulateJoin, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardConflictClause, renderStandardCycleClause, renderStandardSearchClause, renderStandardTableUpdate, renderStatementPrefix, renderStringContainsExactlyPredicate, renderTableReferenceIdentificationVariable, renderTenantRestriction, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderUpdateClause, renderUpdateStatementAsInlineView, renderUpdateStatementAsMerge, renderUpdateStatementAsScalarSubquery, renderUpdateStatementAsTupleSet, renderUpdateStatementDirect, renderValuesListAsSelectUnion, renderValuesListStandard, renderValuesTableReferenceWithSelectListAliases, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLockingTarget, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, translate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAnsiCaseSearchedExpression, visitAnsiCaseSimpleExpression, visitAny, visitArithmeticOperand, visitAssignment, visitBetweenPredicate, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, visitCollation, visitColumnReference, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteClause, visitDeleteStatement, visitDeleteStatementOnly, visitDistinct, visitDuration, visitDurationUnit, visitEmbeddableTypeLiteral, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitFunctionTableReference, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInListPredicate, visitInsertStatement, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitOffsetFetchClause, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryClauses, visitQueryGroup, visitQueryLiteral, visitQueryPartTableReference, visitQuerySpec, visitRecursivePath, visitRelationalPredicate, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignment, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitThruthnessPredicate, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUnparsedNumericLiteral, visitUpdateClause, visitUpdateStatement, visitUpdateStatementOnly, visitValuesList, visitValuesTableReference, visitWhereClause, withoutLateralDerivedTableContext, withParameterRenderingMode, withRowNumbering

Methods inherited from class Object

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

Constructor Details

PostgreSQLSqlAstTranslator

@SPI(IMPLEMENT)
public PostgreSQLSqlAstTranslator(SqlAstTranslationRequest<? extends Statement, T> request)

Method Details

getGroupBySelectItemReferenceStrategy

@SPI({IMPLEMENT,SUPPLY})
protected SelectItemReferenceStrategy getGroupBySelectItemReferenceStrategy()

Description copied from class: AbstractSqlAstTranslator

Select how this translator refers to select items in a group by clause.

Return one non-null stable choice without mutating the request or renderer state. Override this focused hook instead of replacing group-by traversal.

Overrides:

getGroupBySelectItemReferenceStrategy in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

the select-item reference strategy

See Also:

• SelectItemReferenceStrategy

visitInArrayPredicate

public void visitInArrayPredicate(InArrayPredicate inArrayPredicate)

Specified by:

visitInArrayPredicate in interface SqlAstWalker

Overrides:

visitInArrayPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

getArrayContainsFunction

protected String getArrayContainsFunction()

Description copied from class: AbstractSqlAstTranslator

Returns the name of the array_contains(array, element) function, which is used for emulating the cycle clause.

Overrides:

getArrayContainsFunction in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderStandardTableInsert

protected void renderStandardTableInsert(TableInsertStandard tableInsert)

Overrides:

renderStandardTableInsert in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderInsertIntoNoColumns

protected void renderInsertIntoNoColumns(TableInsertStandard tableInsert)

Description copied from class: AbstractSqlAstTranslator

Render a complete insert into statement for an insert with no column value bindings.

Override this method when the database uses syntax other than the generic values ( ) form. Call AbstractSqlAstTranslator.renderIntoIntoAndTable(TableInsertStandard) when the standard table rendering and affected-table registration are appropriate, then append the database-specific no-column syntax. If the database cannot express this operation, throw a MappingException which identifies the affected table and Dialect.

Overrides:

renderInsertIntoNoColumns in class AbstractSqlAstTranslator<T extends JdbcOperation>

Parameters:

tableInsert - the supported model insert to render

getInsertConflictRenderingSupport

protected InsertConflictRenderingSupport getInsertConflictRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects insert-conflict rendering plans.

Override this hook when the database's native or emulated conflict syntax differs from StandardInsertConflictRenderingSupport.CONSTRAINT_VIOLATION. The returned support must be non-null and must not retain supplied requests or translator state.

Overrides:

getInsertConflictRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDmlTargetTableExpression

protected void renderDmlTargetTableExpression(NamedTableReference tableReference)

Overrides:

renderDmlTargetTableExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderFromClauseAfterUpdateSet

protected void renderFromClauseAfterUpdateSet(UpdateStatement statement)

Overrides:

renderFromClauseAfterUpdateSet in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderExpressionAsClauseItem

protected void renderExpressionAsClauseItem(Expression expression)

Overrides:

renderExpressionAsClauseItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

protected void renderComparison(Expression lhs,
 ComparisonOperator operator,
 Expression rhs)

Overrides:

renderComparison in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitBooleanExpressionPredicate

public void visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)

Specified by:

visitBooleanExpressionPredicate in interface SqlAstWalker

Overrides:

visitBooleanExpressionPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitNullnessPredicate

public void visitNullnessPredicate(NullnessPredicate nullnessPredicate)

Specified by:

visitNullnessPredicate in interface SqlAstWalker

Overrides:

visitNullnessPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderMaterializationHint

protected void renderMaterializationHint(CteMaterialization materialization)

Overrides:

renderMaterializationHint in class AbstractSqlAstTranslator<T extends JdbcOperation>

getPaginationRenderingSupport

protected PaginationRenderingSupport getPaginationRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects SQL AST pagination plans.

This hook controls pagination represented in the SQL AST. It is distinct from LimitHandler, which rewrites already-rendered SQL for execution-time query limits. The returned support must be non-null and must not retain supplied requests.

Overrides:

getPaginationRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderCycleUsingClause

protected void renderCycleUsingClause(CteStatement cte)

Description copied from class: AbstractSqlAstTranslator

Render the optional path column of a standard CTE cycle clause.

Overrides:

renderCycleUsingClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderPartitionItem

protected void renderPartitionItem(Expression expression)

Overrides:

renderPartitionItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderLikePredicate

protected void renderLikePredicate(LikePredicate likePredicate)

Overrides:

renderLikePredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitBinaryArithmeticExpression

public void visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)

Specified by:

visitBinaryArithmeticExpression in interface SqlAstWalker

Overrides:

visitBinaryArithmeticExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>