org.nuxeo.ecm.directory.sql

Class SQLQueryBuilder

java.lang.Object

org.nuxeo.ecm.core.query.sql.model.DefaultQueryVisitor

org.nuxeo.ecm.directory.sql.SQLQueryBuilder

All Implemented Interfaces:

IVisitor

public class SQLQueryBuilder
extends DefaultQueryVisitor

Builds the database-level WHERE query from the AST, and collects parameters associated to free variables along with the database column to which they correspond.

Since:

10.3

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLQueryBuilder.ColumnAndValue

Field Summary

Fields

Modifier and Type	Field and Description
StringBuilder	clause
protected SQLDirectory	directory
List<SQLQueryBuilder.ColumnAndValue>	params
protected Column	visitedColumn

Constructor Summary

Constructors

Constructor and Description
SQLQueryBuilder(SQLDirectory directory)

Method Summary

Modifier and Type	Method and Description
protected void	addLikeEscaping()
protected Operand	getBooleanLiteral(Operand rvalue)
protected Column	getColumn(String name)
void	visitBooleanLiteral(BooleanLiteral node)
protected void	visitColumn(Column column)
void	visitDateLiteral(DateLiteral node)
void	visitDoubleLiteral(DoubleLiteral node)
protected void	visitExpression(Column column, Operator op, Operand rvalue)
void	visitExpression(Expression node)
protected void	visitExpressionBetween(Column column, Operator op, LiteralList list)
protected void	visitExpressionILike(Column column, Operator op, Operand rvalue)
protected void	visitExpressionLike(Column column, Operator op, Operand rvalue)
void	visitFunction(Function node)
void	visitIntegerLiteral(IntegerLiteral node)
void	visitLiteralList(LiteralList node)
void	visitMultiExpression(MultiExpression node)
void	visitOperator(Operator node)
void	visitReference(Reference node)
void	visitStringLiteral(StringLiteral node)

Methods inherited from class org.nuxeo.ecm.core.query.sql.model.DefaultQueryVisitor

visitFromClause, visitGroupByClause, visitHavingClause, visitLiteral, visitOperandList, visitOrderByClause, visitOrderByExpr, visitOrderByList, visitQuery, visitReferenceList, visitSelectClause, visitWhereClause

Methods inherited from class java.lang.Object

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

Field Detail

directory

protected final SQLDirectory directory

clause

public final StringBuilder clause

params

public final List<SQLQueryBuilder.ColumnAndValue> params

visitedColumn

protected Column visitedColumn

Constructor Detail

SQLQueryBuilder

public SQLQueryBuilder(SQLDirectory directory)

Method Detail

visitMultiExpression

public void visitMultiExpression(MultiExpression node)

Specified by:

visitMultiExpression in interface IVisitor

Overrides:

visitMultiExpression in class DefaultQueryVisitor

visitExpression

public void visitExpression(Expression node)

Specified by:

visitExpression in interface IVisitor

Overrides:

visitExpression in class DefaultQueryVisitor

visitExpressionBetween

protected void visitExpressionBetween(Column column,
                                      Operator op,
                                      LiteralList list)

visitExpressionLike

protected void visitExpressionLike(Column column,
                                   Operator op,
                                   Operand rvalue)

visitExpressionILike

protected void visitExpressionILike(Column column,
                                    Operator op,
                                    Operand rvalue)

addLikeEscaping

protected void addLikeEscaping()

visitExpression

protected void visitExpression(Column column,
                               Operator op,
                               Operand rvalue)

visitOperator

public void visitOperator(Operator node)

Specified by:

visitOperator in interface IVisitor

Overrides:

visitOperator in class DefaultQueryVisitor

visitReference

public void visitReference(Reference node)

Specified by:

visitReference in interface IVisitor

Overrides:

visitReference in class DefaultQueryVisitor

visitColumn

protected void visitColumn(Column column)

visitLiteralList

public void visitLiteralList(LiteralList node)

Specified by:

visitLiteralList in interface IVisitor

Overrides:

visitLiteralList in class DefaultQueryVisitor

visitDateLiteral

public void visitDateLiteral(DateLiteral node)

Specified by:

visitDateLiteral in interface IVisitor

Overrides:

visitDateLiteral in class DefaultQueryVisitor

visitStringLiteral

public void visitStringLiteral(StringLiteral node)

Specified by:

visitStringLiteral in interface IVisitor

Overrides:

visitStringLiteral in class DefaultQueryVisitor

visitDoubleLiteral

public void visitDoubleLiteral(DoubleLiteral node)

Specified by:

visitDoubleLiteral in interface IVisitor

Overrides:

visitDoubleLiteral in class DefaultQueryVisitor

visitIntegerLiteral

public void visitIntegerLiteral(IntegerLiteral node)

Specified by:

visitIntegerLiteral in interface IVisitor

Overrides:

visitIntegerLiteral in class DefaultQueryVisitor

visitBooleanLiteral

public void visitBooleanLiteral(BooleanLiteral node)

Specified by:

visitBooleanLiteral in interface IVisitor

Overrides:

visitBooleanLiteral in class DefaultQueryVisitor

visitFunction

public void visitFunction(Function node)

Specified by:

visitFunction in interface IVisitor

Overrides:

visitFunction in class DefaultQueryVisitor

getColumn

protected Column getColumn(String name)

getBooleanLiteral

protected Operand getBooleanLiteral(Operand rvalue)