com.metamatrix.common.jdbc.syntax
Class ExpressionOperator

java.lang.Object
  extended by com.metamatrix.common.jdbc.syntax.ExpressionOperator
All Implemented Interfaces:
java.io.Serializable

public class ExpressionOperator
extends java.lang.Object
implements java.io.Serializable

ADVANCED: The expression operator is used internally to define SQL operations and functions. It is possible for an advanced user to define their own operators.

See Also:
Serialized Form

Field Summary
protected static java.util.Hashtable allOperators
           
static java.lang.String Ascending
          Ordering functions
static java.lang.String Average
           
static java.lang.String Count
          Aggregate functions
protected  java.lang.String[] databaseStrings
           
static java.lang.String Descending
           
protected  java.lang.String expression
           
protected static java.util.Hashtable inverses
           
protected  boolean isPrefix
           
protected  boolean isRepeating
           
static java.lang.String Maximum
           
static java.lang.String Minimum
           
protected  java.lang.Class nodeClass
           
protected  java.util.List selectors
           
static java.lang.String Sum
           
static java.lang.String ToLowerCase
           
static java.lang.String ToUpperCase
          Field functions
 
Constructor Summary
ExpressionOperator()
           
ExpressionOperator(java.util.List newSelectors, java.util.List newDatabaseStrings)
           
 
Method Summary
static ExpressionOperator abs()
           
static ExpressionOperator acos()
           
static ExpressionOperator addMonths()
           
static void addOperator(ExpressionOperator op)
           
 void addSelector(java.lang.String selector)
           
static ExpressionOperator and()
           
 java.lang.Object applyTo(java.lang.Object arg)
           
static ExpressionOperator ascending()
           
static ExpressionOperator ascii()
           
static ExpressionOperator asin()
           
static ExpressionOperator atan()
           
static ExpressionOperator average()
           
 void bePostfix()
           
 void bePrefix()
           
 void beRepeating()
           
static ExpressionOperator between()
           
static java.util.List binaryRelationOperators()
           
 java.lang.String buildExpression(java.lang.String value)
           
static ExpressionOperator ceil()
           
static ExpressionOperator chr()
           
static ExpressionOperator concat()
           
static ExpressionOperator cos()
           
static ExpressionOperator cosh()
           
static ExpressionOperator count()
           
static ExpressionOperator dateToString()
           
static ExpressionOperator deref()
           
static ExpressionOperator descending()
           
static ExpressionOperator equalOuterJoin()
           
 boolean equals(java.lang.Object arg)
           
static ExpressionOperator exp()
           
static ExpressionOperator floor()
           
static java.util.Hashtable getAllOperators()
           
 java.util.List getDatabaseStrings()
           
 java.lang.String getExpression()
           
static ExpressionOperator getInverse(ExpressionOperator operator)
           
static java.util.Hashtable getInverses()
           
 java.lang.Class getNodeClass()
           
static ExpressionOperator getOperator(java.lang.String name)
           
 java.util.List getSelectors()
           
static ExpressionOperator greatest()
           
static ExpressionOperator hexToRaw()
           
static ExpressionOperator in()
           
static ExpressionOperator initcap()
           
protected static void initializeAggregateFunctionOperators()
           
protected static void initializeFunctionOperators()
           
protected static void initializeLogicalOperators()
           
static java.util.Hashtable initializeOperators()
           
protected static void initializeRelationOperators()
           
static ExpressionOperator instring()
           
 boolean isComplete()
           
static ExpressionOperator isNull()
           
 boolean isPrefix()
           
static ExpressionOperator lastDay()
           
static ExpressionOperator least()
           
static ExpressionOperator leftPad()
           
static ExpressionOperator leftTrim()
           
static ExpressionOperator length()
           
static ExpressionOperator like()
           
static ExpressionOperator ln()
           
static ExpressionOperator log()
           
static ExpressionOperator maximum()
           
static ExpressionOperator minimum()
           
static ExpressionOperator mod()
           
static ExpressionOperator monthsBetween()
           
static ExpressionOperator nextDay()
           
 ExpressionOperator not()
           
static ExpressionOperator notEqual()
           
static ExpressionOperator notIn()
           
static ExpressionOperator notLike()
           
static ExpressionOperator notNull()
           
static ExpressionOperator notOperator()
           
static ExpressionOperator or()
           
static ExpressionOperator power()
           
 void printsAs(java.util.List dbStrings)
           
 void printsAs(java.lang.String s)
           
static ExpressionOperator ref()
           
static ExpressionOperator refToHex()
           
static ExpressionOperator refToValue()
           
static ExpressionOperator replace()
           
 boolean representsEqualToNull(java.util.List arguments)
           
 boolean representsEqualToNull(java.lang.Object singleArgument)
           
 boolean representsNotEqualToNull(java.util.List arguments)
           
 boolean representsNotEqualToNull(java.lang.Object singleArgument)
           
static void resetOperators()
           
static ExpressionOperator rightPad()
           
static ExpressionOperator rightTrim()
           
static ExpressionOperator round()
           
static ExpressionOperator roundDate()
           
 void setExpression(java.lang.String exp)
           
 void setNodeClass(java.lang.Class aClass)
           
static ExpressionOperator sign()
           
static ExpressionOperator simpleFunction(java.lang.String name)
           
static ExpressionOperator simpleFunction(java.lang.String selector, java.lang.String dbString)
           
static ExpressionOperator simpleRelation(java.lang.String name)
           
static ExpressionOperator simpleThreeArgumentFunction(java.lang.String selector, java.lang.String dbString)
           
static ExpressionOperator simpleTwoArgumentFunction(java.lang.String selector, java.lang.String dbString)
           
static ExpressionOperator sin()
           
static ExpressionOperator sinh()
           
static ExpressionOperator soundex()
           
static ExpressionOperator sqrt()
           
static ExpressionOperator standardDeviation()
           
static ExpressionOperator substring()
           
static ExpressionOperator sum()
           
static ExpressionOperator tan()
           
static ExpressionOperator tanh()
           
static ExpressionOperator toDate()
           
static ExpressionOperator today()
           
static ExpressionOperator toLowerCase()
           
static ExpressionOperator toNumber()
           
 java.lang.String toString()
           
static ExpressionOperator toUpperCase()
           
static ExpressionOperator translate()
           
static ExpressionOperator trim()
           
static ExpressionOperator trunc()
           
static ExpressionOperator variance()
           
protected  void writeField(java.io.StringWriter writer, java.lang.String fieldName)
          Called from FunctionExpression.writeField(StringWriter, String) so that function strings can also be added.
 
Methods inherited from class java.lang.Object
clone, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

selectors

protected java.util.List selectors

databaseStrings

protected java.lang.String[] databaseStrings

expression

protected java.lang.String expression

isPrefix

protected boolean isPrefix

isRepeating

protected boolean isRepeating

nodeClass

protected java.lang.Class nodeClass

allOperators

protected static java.util.Hashtable allOperators

inverses

protected static java.util.Hashtable inverses

Count

public static final java.lang.String Count
Aggregate functions

See Also:
Constant Field Values

Sum

public static final java.lang.String Sum
See Also:
Constant Field Values

Average

public static final java.lang.String Average
See Also:
Constant Field Values

Maximum

public static final java.lang.String Maximum
See Also:
Constant Field Values

Minimum

public static final java.lang.String Minimum
See Also:
Constant Field Values

Ascending

public static final java.lang.String Ascending
Ordering functions

See Also:
Constant Field Values

Descending

public static final java.lang.String Descending
See Also:
Constant Field Values

ToUpperCase

public static final java.lang.String ToUpperCase
Field functions

See Also:
Constant Field Values

ToLowerCase

public static final java.lang.String ToLowerCase
See Also:
Constant Field Values
Constructor Detail

ExpressionOperator

public ExpressionOperator()

ExpressionOperator

public ExpressionOperator(java.util.List newSelectors,
                          java.util.List newDatabaseStrings)
Method Detail

abs

public static ExpressionOperator abs()

acos

public static ExpressionOperator acos()

addMonths

public static ExpressionOperator addMonths()

addOperator

public static void addOperator(ExpressionOperator op)

addSelector

public void addSelector(java.lang.String selector)

and

public static ExpressionOperator and()

applyTo

public java.lang.Object applyTo(java.lang.Object arg)

ascending

public static ExpressionOperator ascending()

ascii

public static ExpressionOperator ascii()

asin

public static ExpressionOperator asin()

atan

public static ExpressionOperator atan()

average

public static ExpressionOperator average()

bePostfix

public void bePostfix()

bePrefix

public void bePrefix()

beRepeating

public void beRepeating()

between

public static ExpressionOperator between()

binaryRelationOperators

public static java.util.List binaryRelationOperators()

ceil

public static ExpressionOperator ceil()

chr

public static ExpressionOperator chr()

concat

public static ExpressionOperator concat()

cos

public static ExpressionOperator cos()

cosh

public static ExpressionOperator cosh()

count

public static ExpressionOperator count()

dateToString

public static ExpressionOperator dateToString()

deref

public static ExpressionOperator deref()

descending

public static ExpressionOperator descending()

equalOuterJoin

public static ExpressionOperator equalOuterJoin()

equals

public boolean equals(java.lang.Object arg)
Overrides:
equals in class java.lang.Object

exp

public static ExpressionOperator exp()

floor

public static ExpressionOperator floor()

getAllOperators

public static java.util.Hashtable getAllOperators()

getDatabaseStrings

public java.util.List getDatabaseStrings()

getInverse

public static ExpressionOperator getInverse(ExpressionOperator operator)

getInverses

public static java.util.Hashtable getInverses()

getNodeClass

public java.lang.Class getNodeClass()

getOperator

public static ExpressionOperator getOperator(java.lang.String name)

getSelectors

public java.util.List getSelectors()

greatest

public static ExpressionOperator greatest()

hexToRaw

public static ExpressionOperator hexToRaw()

in

public static ExpressionOperator in()

initcap

public static ExpressionOperator initcap()

initializeAggregateFunctionOperators

protected static void initializeAggregateFunctionOperators()

initializeFunctionOperators

protected static void initializeFunctionOperators()

initializeLogicalOperators

protected static void initializeLogicalOperators()

initializeOperators

public static java.util.Hashtable initializeOperators()

initializeRelationOperators

protected static void initializeRelationOperators()

instring

public static ExpressionOperator instring()

isComplete

public boolean isComplete()

isNull

public static ExpressionOperator isNull()

isPrefix

public boolean isPrefix()

lastDay

public static ExpressionOperator lastDay()

least

public static ExpressionOperator least()

leftPad

public static ExpressionOperator leftPad()

leftTrim

public static ExpressionOperator leftTrim()

length

public static ExpressionOperator length()

like

public static ExpressionOperator like()

ln

public static ExpressionOperator ln()

log

public static ExpressionOperator log()

maximum

public static ExpressionOperator maximum()

minimum

public static ExpressionOperator minimum()

mod

public static ExpressionOperator mod()

monthsBetween

public static ExpressionOperator monthsBetween()

nextDay

public static ExpressionOperator nextDay()

not

public ExpressionOperator not()

notEqual

public static ExpressionOperator notEqual()

notIn

public static ExpressionOperator notIn()

notLike

public static ExpressionOperator notLike()

notNull

public static ExpressionOperator notNull()

notOperator

public static ExpressionOperator notOperator()

or

public static ExpressionOperator or()

power

public static ExpressionOperator power()

getExpression

public java.lang.String getExpression()

setExpression

public void setExpression(java.lang.String exp)

printsAs

public void printsAs(java.lang.String s)

printsAs

public void printsAs(java.util.List dbStrings)

ref

public static ExpressionOperator ref()

refToHex

public static ExpressionOperator refToHex()

refToValue

public static ExpressionOperator refToValue()

replace

public static ExpressionOperator replace()

representsEqualToNull

public boolean representsEqualToNull(java.lang.Object singleArgument)

representsEqualToNull

public boolean representsEqualToNull(java.util.List arguments)

representsNotEqualToNull

public boolean representsNotEqualToNull(java.lang.Object singleArgument)

representsNotEqualToNull

public boolean representsNotEqualToNull(java.util.List arguments)

resetOperators

public static void resetOperators()

rightPad

public static ExpressionOperator rightPad()

rightTrim

public static ExpressionOperator rightTrim()

round

public static ExpressionOperator round()

roundDate

public static ExpressionOperator roundDate()

setNodeClass

public void setNodeClass(java.lang.Class aClass)

sign

public static ExpressionOperator sign()

buildExpression

public java.lang.String buildExpression(java.lang.String value)

simpleFunction

public static ExpressionOperator simpleFunction(java.lang.String name)

simpleFunction

public static ExpressionOperator simpleFunction(java.lang.String selector,
                                                java.lang.String dbString)

simpleRelation

public static ExpressionOperator simpleRelation(java.lang.String name)

simpleThreeArgumentFunction

public static ExpressionOperator simpleThreeArgumentFunction(java.lang.String selector,
                                                             java.lang.String dbString)

simpleTwoArgumentFunction

public static ExpressionOperator simpleTwoArgumentFunction(java.lang.String selector,
                                                           java.lang.String dbString)

sin

public static ExpressionOperator sin()

sinh

public static ExpressionOperator sinh()

soundex

public static ExpressionOperator soundex()

sqrt

public static ExpressionOperator sqrt()

standardDeviation

public static ExpressionOperator standardDeviation()

substring

public static ExpressionOperator substring()

sum

public static ExpressionOperator sum()

tan

public static ExpressionOperator tan()

tanh

public static ExpressionOperator tanh()

toDate

public static ExpressionOperator toDate()

today

public static ExpressionOperator today()

toLowerCase

public static ExpressionOperator toLowerCase()

toNumber

public static ExpressionOperator toNumber()

toString

public java.lang.String toString()
Overrides:
toString in class java.lang.Object

toUpperCase

public static ExpressionOperator toUpperCase()

translate

public static ExpressionOperator translate()

trim

public static ExpressionOperator trim()

trunc

public static ExpressionOperator trunc()

variance

public static ExpressionOperator variance()

writeField

protected void writeField(java.io.StringWriter writer,
                          java.lang.String fieldName)
Called from FunctionExpression.writeField(StringWriter, String) so that function strings can also be added.



Copyright © 2009. All Rights Reserved.