|
SAP BI Java SDK | |||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
The WHERE
condition represented in tree form to simplify manipulation
and SQL
code generation. The tree contains a stack to support
its use in the Relational Command Processor
.
Method Summary | |
void |
clear()
Removes the contents. |
List |
getPredicateList()
Returns the list of predicates of the WHERE tree. |
IBIWhereTreeNode |
getRoot()
Gets the root of the tree. |
boolean |
isInCNF()
Checks if the WHERE tree is in conjunctive normal form (CNF). |
boolean |
isInMDX()
Checks if translation of the WHERE tree to MDX is possible. |
boolean |
isInSelectOptions()
Checks if translation of the WHERE tree to SELECT-OPTIONS is possible. |
void |
normalize()
Normalizes the WHERE tree (CNF). |
IBIWhereTreeNode |
peek()
Returns the top node of the stack. |
void |
peekRoot()
Sets the root node to the top node of the stack. |
IBIWhereTreeNode |
pop()
Pops the top node off the stack. |
void |
popRoot()
Pops the top node off the stack and assigns it to the root node. |
void |
push(Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper)
Pushes a node comprised of the column column and the logical
operator oper on to the stack. |
void |
push(Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
Object value)
Pushes a node comprised of the column column , the logical
operator oper , and the value value on to the stack. |
void |
push(Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
Object[] values)
Pushes a node comprised of the column column , the logical
operator oper , and the array of values values
on to the stack. |
void |
push(Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
Object lowValue,
Object highValue)
Pushes a node comprised of the column column ,
the logical operator oper , and the values lowValue
and highValue on to the stack. |
void |
push(com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLLogicalOperator oper)
Pushes the logical operator oper on to the stack. |
void |
push(String tableRef,
Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper)
Pushes a node comprised of the table reference tableRef ,
the column column , and the logical operator oper
on to the stack. |
void |
push(String tableRef,
Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
IBIQuery subQuery)
Pushes a node comprised of the table reference tableRef ,
the column column , the logical operator oper ,
and the query subQuery on to the stack. |
void |
push(String tableRef,
Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
Object value)
Pushes a node comprised of the table reference tableRef ,
the column column , the logical operator oper ,
and the value value on to the stack. |
void |
push(String tableRef,
Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
Object[] values)
Pushes a node comprised of the table reference tableRef ,
the column column , the logical operator oper ,
and the array of values values on to the stack. |
void |
push(String tableRef,
Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
Object lowValue,
Object highValue)
Pushes a node comprised of the table reference tableRef ,
the column column , the logical operator oper ,
and the values lowValue and highValue on to the stack. |
void |
push(String tableRef,
Column column,
com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper,
String tabRef2,
Column column2)
Pushes a node comprised of the table reference tableRef ,
the column column , the logical operator oper ,
and the 2nd table reference tabRef2 and column column2
on to the stack (left and right hand side of a join). |
void |
pushRoot()
Pushes the root node on to the stack. |
void |
setRoot(IBIWhereTreeNode node)
Sets the root of the tree to node . |
String |
toString()
Returns a string representation of the WHERE tree. |
Method Detail |
public void clear()
public void setRoot(IBIWhereTreeNode node)
node
.node
- the root of the treegetRoot()
public IBIWhereTreeNode getRoot()
setRoot(IBIWhereTreeNode)
public IBIWhereTreeNode pop()
public IBIWhereTreeNode peek()
public void pushRoot()
public void popRoot()
public void peekRoot()
public void push(String tableRef, Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper)
tableRef
,
the column column
, and the logical operator oper
on to the stack.tableRef
- the table referencecolumn
- the columnoper
- the logical operatorpublic void push(String tableRef, Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, IBIQuery subQuery)
tableRef
,
the column column
, the logical operator oper
,
and the query subQuery
on to the stack.tableRef
- the table referencecolumn
- the columnoper
- the logical operatorsubQuery
- the sub-querypublic void push(String tableRef, Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, String tabRef2, Column column2)
tableRef
,
the column column
, the logical operator oper
,
and the 2nd table reference tabRef2
and column column2
on to the stack (left and right hand side of a join).tableRef
- the left table referencecolumn
- the left columnoper
- the logical operatortabRef2
- the right table referencecolumn2
- the right columnpublic void push(String tableRef, Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, Object lowValue, Object highValue)
tableRef
,
the column column
, the logical operator oper
,
and the values lowValue
and highValue
on to the stack.tableRef
- the table referencecolumn
- the columnoper
- the logical operatorlowValue
- the low valuehighValue
- the high valuepublic void push(String tableRef, Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, Object[] values)
tableRef
,
the column column
, the logical operator oper
,
and the array of values values
on to the stack.tableRef
- the table referencecolumn
- the columnoper
- the logical operatorvalues
- the valuespublic void push(String tableRef, Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, Object value)
tableRef
,
the column column
, the logical operator oper
,
and the value value
on to the stack.tableRef
- the table referencecolumn
- the columnoper
- the logical operatorvalue
- the valuepublic void push(Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, Object lowValue, Object highValue)
column
,
the logical operator oper
, and the values lowValue
and highValue
on to the stack.column
- the columnoper
- the logical operatorlowValue
- the low valuehighValue
- the high valuepublic void push(Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, Object[] values)
column
, the logical
operator oper
, and the array of values values
on to the stack.column
- the columnoper
- the logical operatorvalues
- the valuespublic void push(Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper, Object value)
column
, the logical
operator oper
, and the value value
on to the stack.column
- the columnoper
- the logical operatorvalue
- the valuepublic void push(Column column, com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLComparisonOperator oper)
column
and the logical
operator oper
on to the stack.column
- the columnoper
- the logical operatorpublic void push(com.sap.ip.bi.sdk.dac.relational.query.sql.IBISQLLogicalOperator oper)
oper
on to the stack.oper
- the logical operatorpublic String toString()
WHERE
tree.toString
in class Object
WHERE
tree.public boolean isInCNF()
WHERE
tree is in conjunctive normal form (CNF).true
if the WHERE
tree is in CNF, otherwise false
public boolean isInSelectOptions()
WHERE
tree to SELECT-OPTIONS
is possible.true
if the translation of the WHERE
tree to SELECT-OPTIONS
is possible, otherwise false
public boolean isInMDX()
WHERE
tree to MDX
is possible.true
if the translation of the WHERE
tree to MDX
is possible, otherwise false
public List getPredicateList()
WHERE
tree.WHERE
tree.public void normalize()
WHERE
tree (CNF).
|
SAP BI Java SDK | |||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |