Package ortus.boxlang.compiler.ast.sql.select.expression

Class SQLCase

java.lang.Object

ortus.boxlang.compiler.ast.BoxNode

ortus.boxlang.compiler.ast.sql.SQLNode

ortus.boxlang.compiler.ast.sql.select.expression.SQLExpression

ortus.boxlang.compiler.ast.sql.select.expression.SQLCase

All Implemented Interfaces:

BoxVisitable

public class SQLCase
extends SQLExpression

Abstract Node class representing SQL case expression

Field Summary

Fields inherited from class ortus.boxlang.compiler.ast.BoxNode

parent, position

Constructor Summary

Constructors

Constructor	Description
SQLCase(SQLExpression inputExpression, List<SQLCaseWhenThen> whenThens, SQLExpression elseExpression, Position position, String sourceText)	Constructor

Method Summary

Modifier and Type	Method	Description
BoxNode	accept(ReplacingBoxVisitor v)	Accept method for replacing visitor support.
void	accept(VoidBoxVisitor v)	Accept method for visitor support.
Object	evaluate(QoQSelectExecution QoQExec, int[] intersection)	Evaluate the expression
Object	evaluateAggregate(QoQSelectExecution QoQExec, List<int[]> intersections)	Evaluate the expression aginst a partition of data
SQLExpression	getElseExpression()	Get the else expression
SQLExpression	getInputExpression()	Get the input expression
QueryColumnType	getType(QoQSelectExecution QoQExec)	What type does this expression evaluate to
List<SQLCaseWhenThen>	getWhenThens()	Get the when clauses
boolean	isBoolean(QoQSelectExecution QoQExec)	Runtime check if the expression evaluates to a boolean value and works for columns as well
boolean	isNumeric(QoQSelectExecution QoQExec)	Runtime check if the expression evaluates to a numeric value and works for columns as well
void	setElseExpression(SQLExpression elseExpression)	Set the else expression
void	setInputExpression(SQLExpression inputExpression)	Set the input expression
void	setWhenThens(List<SQLCaseWhenThen> whenThens)	Set the when clauses
Map<String,Object>	toMap()

Methods inherited from class ortus.boxlang.compiler.ast.sql.select.expression.SQLExpression

isLiteral

Methods inherited from class ortus.boxlang.compiler.ast.BoxNode

addComment, associateComments, endsOnSameLineAs, enumToMap, getAncestors, getChildren, getComments, getDescendants, getDescendantsOfType, getDescendantsOfType, getDescription, getDocComment, getFirstAncestorOfType, getFirstAncestorOfType, getFirstNodeOfType, getFirstNodeOfType, getFirstNodeOfTypes, getParent, getPosition, getSourceText, isAfter, isBefore, isInside, replaceChildren, replaceChildren, setComments, setParent, setPosition, setSourceText, startsOnEndLineOf, toJSON, toString

Methods inherited from class java.lang.Object

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

Constructor Details

SQLCase

public SQLCase(SQLExpression inputExpression,
 List<SQLCaseWhenThen> whenThens,
 SQLExpression elseExpression,
 Position position,
 String sourceText)

Constructor

Parameters:

position - position of the statement in the source code

sourceText - source code of the statement

Method Details

getInputExpression

public SQLExpression getInputExpression()

Get the input expression

setInputExpression

public void setInputExpression(SQLExpression inputExpression)

Set the input expression

getWhenThens

public List<SQLCaseWhenThen> getWhenThens()

Get the when clauses

setWhenThens

public void setWhenThens(List<SQLCaseWhenThen> whenThens)

Set the when clauses

getElseExpression

public SQLExpression getElseExpression()

Get the else expression

setElseExpression

public void setElseExpression(SQLExpression elseExpression)

Set the else expression

isBoolean

public boolean isBoolean(QoQSelectExecution QoQExec)

Runtime check if the expression evaluates to a boolean value and works for columns as well

Overrides:

isBoolean in class SQLExpression

Parameters:

QoQExec - Query execution state

Returns:

true if the expression evaluates to a boolean value

isNumeric

public boolean isNumeric(QoQSelectExecution QoQExec)

Runtime check if the expression evaluates to a numeric value and works for columns as well

Overrides:

isNumeric in class SQLExpression

Parameters:

QoQExec - Query execution state

Returns:

true if the expression evaluates to a numeric value

getType

public QueryColumnType getType(QoQSelectExecution QoQExec)

What type does this expression evaluate to

Overrides:

getType in class SQLExpression

evaluate

public Object evaluate(QoQSelectExecution QoQExec,
 int[] intersection)

Evaluate the expression

Specified by:

evaluate in class SQLExpression

evaluateAggregate

public Object evaluateAggregate(QoQSelectExecution QoQExec,
 List<int[]> intersections)

Evaluate the expression aginst a partition of data

Specified by:

evaluateAggregate in class SQLExpression

accept

public void accept(VoidBoxVisitor v)

Description copied from interface: BoxVisitable

Accept method for visitor support.

Parameters:

v - the visitor implementation

accept

public BoxNode accept(ReplacingBoxVisitor v)

Description copied from interface: BoxVisitable

Accept method for replacing visitor support. Each accept returns the node, or a replacement node.

Parameters:

v - the visitor implementation

toMap

public Map<String,Object> toMap()

Overrides:

toMap in class BoxNode