Package org.hibernate.dialect.sql.ast

Class MySQLSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

org.hibernate.sql.ast.spi.SqlAstTranslatorWithUpsert<T>

org.hibernate.dialect.sql.ast.SqlAstTranslatorWithOnDuplicateKeyUpdate<T>

org.hibernate.dialect.sql.ast.MySQLSqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

public class MySQLSqlAstTranslator<T extends JdbcOperation>
extends SqlAstTranslatorWithOnDuplicateKeyUpdate<T>

A SQL AST translator for MySQL.

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.sql.ast.spi.AbstractSqlAstTranslator

AbstractSqlAstTranslator.LockStrategy, AbstractSqlAstTranslator.SubQueryRelationalRestrictionEmulationRenderer<X extends Expression>

Field Summary

Fields inherited from interface org.hibernate.sql.ast.spi.SqlAppender

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

Constructor Summary

Constructors

Constructor	Description
MySQLSqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement, MySQLDialect dialect)

Method Summary

Modifier and Type	Method	Description
protected void	appendAssignmentColumn(ColumnReference column)
protected String	determineColumnReferenceQualifier(ColumnReference columnReference)
MySQLDialect	getDialect()
static String	getSqlType(CastTarget castTarget, SessionFactoryImplementor factory)
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderDeleteClause(DeleteStatement statement)
protected void	renderDerivedTableReference(DerivedTableReference tableReference)
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderNewRowAlias()
protected void	renderPartitionItem(Expression expression)
protected void	renderStringContainsExactlyPredicate(Expression haystack, Expression needle)
protected void	renderUpdateClause(UpdateStatement updateStatement)
protected void	renderUpdatevalue(ColumnValueBinding columnValueBinding)
protected boolean	shouldEmulateFetchClause(QueryPart queryPart)
void	visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)
void	visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)
void	visitCastTarget(CastTarget castTarget)
void	visitColumnReference(ColumnReference columnReference)
protected void	visitConflictClause(ConflictClause conflictClause)
protected void	visitInsertSource(InsertSelectStatement statement)
void	visitLikePredicate(LikePredicate likePredicate)
void	visitOffsetFetchClause(QueryPart queryPart)
void	visitQueryGroup(QueryGroup queryGroup)
void	visitQuerySpec(QuerySpec querySpec)
protected void	visitRecursivePath(Expression recursivePath, int sizeEstimate)	Renders the recursive path, possibly wrapping a cast expression around it, to make sure a type with proper size is chosen.
void	visitValuesTableReference(ValuesTableReference tableReference)

Methods inherited from class org.hibernate.dialect.sql.ast.SqlAstTranslatorWithOnDuplicateKeyUpdate

createMergeOperation, renderInsertInto, renderOnDuplicateKeyUpdate, renderUpsertStatement

Methods inherited from class org.hibernate.sql.ast.spi.SqlAstTranslatorWithUpsert

renderMergeInsert, renderMergeInto, renderMergeOn, renderMergeSource, renderMergeSourceAlias, renderMergeTargetAlias, renderMergeUpdate, renderMergeUsing, wrapMergeSourceExpression

Methods inherited from class org.hibernate.sql.ast.spi.AbstractSqlAstTranslator

addAdditionalWherePredicate, addAffectedTableName, addAppliedParameterBinding, addParameterBinder, addParameterBinder, afterQueryGroup, append, append, append, appendBackslashEscapedLikeLiteral, appendDoubleQuoteEscapedString, appendSingleQuoteEscapedString, appendSql, appendSql, appendSql, appendSql, appendSql, areAllResultsParameters, areAllResultsParameters, assertRowsOnlyFetchClauseType, beforeQueryGroup, castFunction, castNumberToString, cleanup, createRowMatchingPredicate, determineCyclePathColumnName, determineLateralEmulationPredicate, determineLockingStrategy, determineWhereClauseRestrictionWithJoinEmulation, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getArrayContainsFunction, getBooleanType, getCastTypeName, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDual, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getFromDualForSelectOnly, getIntegerType, getJdbcLockStrategy, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLiteralValue, getLockingClauseStrategy, getLockOptions, getMaxRows, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryPartForRowNumbering, getQueryPartStack, getRowsToSkip, getSelectItemReference, getSessionFactory, getSortSpecificationsRowNumbering, getSql, getSqlAppender, getSqlAst, getSqlBuffer, getSqlTypeName, getStatement, getStatementStack, getStringType, getUniqueConstraintNameThatMayFail, getWrapperOptions, hasAggregateFunctions, hasFrom, hasLimit, hasLimit, hasNestedTableGroupsToRender, hasNonTrivialFromClause, hasOffset, hasWhere, inlineCteTableGroup, inOverOrWithinGroupClause, interpretExpression, isCorrelated, isInRecursiveQueryPart, isInSubquery, isIntegerDivisionEmulationRequired, isLiteral, isParameter, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, needsMaxRows, needsParenthesesAroundQueryGroup, needsRecursiveKeywordInWithClause, needsRowsToSkip, prepareLimitOffsetParameters, prependSql, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDerivedTableReferenceIdentificationVariable, renderDmlTargetTableGroup, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchExpression, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderFromClauseAfterUpdateSet, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertIntoNoColumns, renderInterval, renderIntervalLiteral, renderIntoIntoAndTable, renderJoinedTableGroup, renderLikePredicate, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderMergeUpdateClause, renderNamedSetReturningFunction, renderNamedTableReference, renderNull, renderOffset, renderOffsetExpression, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderParameterAsParameter, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSelectTupleComparison, renderSetClause, renderSimpleNamedFunction, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardCycleClause, renderStandardSearchClause, renderTableGroupJoin, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setLockingTarget, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsRecursiveClauseArrayAndRowEmulation, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAnsiCaseSearchedExpression, visitAnsiCaseSimpleExpression, visitAny, visitArithmeticOperand, visitAssignment, visitBetweenPredicate, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCollation, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCteDefinition, visitCteObject, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteStatement, visitDeleteStatementOnly, visitDistinct, visitDuration, visitDurationUnit, visitEmbeddableTypeLiteral, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitFunctionTableReference, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInArrayPredicate, visitInListPredicate, visitInsertStatement, visitInsertStatementEmulateMerge, visitInsertStatementOnly, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitNullnessPredicate, visitOnDuplicateKeyConflictClause, visitOnDuplicateKeyConflictClauseWithDoNothing, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryClauses, visitQueryLiteral, visitQueryPartTableReference, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignment, visitSetAssignmentEmulateJoin, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitSqlSelections, visitStandardConflictClause, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitThruthnessPredicate, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUnparsedNumericLiteral, visitUpdateStatement, visitUpdateStatementEmulateInlineView, visitUpdateStatementEmulateMerge, visitUpdateStatementEmulateTupleSet, visitUpdateStatementOnly, visitValuesList, visitValuesListEmulateSelectUnion, visitValuesListStandard, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

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

Constructor Details

MySQLSqlAstTranslator

public MySQLSqlAstTranslator(SessionFactoryImplementor sessionFactory,
 Statement statement,
 MySQLDialect dialect)

Method Details

getSqlType

public static String getSqlType(CastTarget castTarget,
 SessionFactoryImplementor factory)

visitBinaryArithmeticExpression

public void visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)

Specified by:

visitBinaryArithmeticExpression in interface SqlAstWalker

Overrides:

visitBinaryArithmeticExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitInsertSource

protected void visitInsertSource(InsertSelectStatement statement)

Overrides:

visitInsertSource in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitColumnReference

public void visitColumnReference(ColumnReference columnReference)

Specified by:

visitColumnReference in interface SqlAstWalker

Overrides:

visitColumnReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDeleteClause

protected void renderDeleteClause(DeleteStatement statement)

Overrides:

renderDeleteClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderUpdateClause

protected void renderUpdateClause(UpdateStatement updateStatement)

Overrides:

renderUpdateClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDmlTargetTableExpression

protected void renderDmlTargetTableExpression(NamedTableReference tableReference)

Overrides:

renderDmlTargetTableExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitConflictClause

protected void visitConflictClause(ConflictClause conflictClause)

Overrides:

visitConflictClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

determineColumnReferenceQualifier

protected String determineColumnReferenceQualifier(ColumnReference columnReference)

Overrides:

determineColumnReferenceQualifier in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderExpressionAsClauseItem

protected void renderExpressionAsClauseItem(Expression expression)

Overrides:

renderExpressionAsClauseItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitRecursivePath

protected void visitRecursivePath(Expression recursivePath,
 int sizeEstimate)

Description copied from class: AbstractSqlAstTranslator

Renders the recursive path, possibly wrapping a cast expression around it, to make sure a type with proper size is chosen.

Overrides:

visitRecursivePath 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>

shouldEmulateFetchClause

protected boolean shouldEmulateFetchClause(QueryPart queryPart)

visitQueryGroup

public void visitQueryGroup(QueryGroup queryGroup)

Specified by:

visitQueryGroup in interface SqlAstWalker

Overrides:

visitQueryGroup in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitQuerySpec

public void visitQuerySpec(QuerySpec querySpec)

Specified by:

visitQuerySpec in interface SqlAstWalker

Overrides:

visitQuerySpec in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitValuesTableReference

public void visitValuesTableReference(ValuesTableReference tableReference)

Specified by:

visitValuesTableReference in interface SqlAstWalker

Overrides:

visitValuesTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDerivedTableReference

protected void renderDerivedTableReference(DerivedTableReference tableReference)

Overrides:

renderDerivedTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitOffsetFetchClause

public void visitOffsetFetchClause(QueryPart queryPart)

Specified by:

visitOffsetFetchClause in interface SqlAstWalker

Overrides:

visitOffsetFetchClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

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

Overrides:

renderComparison in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderPartitionItem

protected void renderPartitionItem(Expression expression)

Overrides:

renderPartitionItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitLikePredicate

public void visitLikePredicate(LikePredicate likePredicate)

Specified by:

visitLikePredicate in interface SqlAstWalker

Overrides:

visitLikePredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

getDialect

public MySQLDialect getDialect()

Overrides:

getDialect in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitCastTarget

public void visitCastTarget(CastTarget castTarget)

Specified by:

visitCastTarget in interface SqlAstWalker

Overrides:

visitCastTarget in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderStringContainsExactlyPredicate

protected void renderStringContainsExactlyPredicate(Expression haystack,
 Expression needle)

Overrides:

renderStringContainsExactlyPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderNewRowAlias

protected void renderNewRowAlias()

Overrides:

renderNewRowAlias in class SqlAstTranslatorWithOnDuplicateKeyUpdate<T extends JdbcOperation>

renderUpdatevalue

protected void renderUpdatevalue(ColumnValueBinding columnValueBinding)

Overrides:

renderUpdatevalue in class SqlAstTranslatorWithOnDuplicateKeyUpdate<T extends JdbcOperation>

appendAssignmentColumn

protected void appendAssignmentColumn(ColumnReference column)

Overrides:

appendAssignmentColumn in class AbstractSqlAstTranslator<T extends JdbcOperation>