DBConditionItem (MMBase 1.9-SNAPSHOT

java.lang.Object
- org.mmbase.storage.search.legacy.ParseItem
- - org.mmbase.storage.search.legacy.DBConditionItem

```
class DBConditionItem
extends ParseItem
```
Class for conversion of boolean xpressions to their SQL equivalent. This class converts the following conditional operators encountered in the parameter passed to the constructor :
'=='' or '=E' to '='
'=N' to '<>'
'=G' to '>'
'=g' to '>='
'=S' to '<'
'=s' to '<='
It also wraps string values with the SQL lower() function, and uses LIKE when wildcards are used in a stringvalue.

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`EQUAL`
`(package private) String`	`fieldName` The fieldname.
`static int`	`GREATER`
`static int`	`GREATEREQUAL`
`(package private) String`	`identifier` The field identifier as it appears in SQL expressions, with table alias prefix (if present), and the fieldname converted to an allowed fieldname.
`static int`	`NOTEQUAL`
`(package private) int`	`operator` The comparison operator, must be one of the constants defined in this class.
`(package private) String`	`prefix` The table alias prefix (if present).
`static int`	`SMALLER`
`static int`	`SMALLEREQUAL`
`(package private) DBValue`	`value` The value to compare to.

Constructor Summary

Constructors
Constructor and Description

DBConditionItem(String item)
Creates the boolean expression

Constructors
Constructor and Description
`DBConditionItem(String item)` Creates the boolean expression

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type Method and Description

void sqlConversion(StringBuffer result)
Appends the converted expression to the stringbuffer.
- Methods inherited from class org.mmbase.storage.search.legacy.ParseItem
  toString
- Methods inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`sqlConversion(StringBuffer result)` Appends the converted expression to the stringbuffer.

- Field Detail
  - NOTEQUAL
```
public static final int NOTEQUAL
```
    See Also:
    
    Constant Field Values
  - EQUAL
```
public static final int EQUAL
```
    See Also:
    
    Constant Field Values
  - GREATER
```
public static final int GREATER
```
    See Also:
    
    Constant Field Values
  - SMALLER
```
public static final int SMALLER
```
    See Also:
    
    Constant Field Values
  - GREATEREQUAL
```
public static final int GREATEREQUAL
```
    See Also:
    
    Constant Field Values
  - SMALLEREQUAL
```
public static final int SMALLEREQUAL
```
    See Also:
    
    Constant Field Values
  - fieldName
```
String fieldName
```
    The fieldname.
  - prefix
```
String prefix
```
    The table alias prefix (if present).
  - identifier
```
String identifier
```
    The field identifier as it appears in SQL expressions, with table alias prefix (if present), and the fieldname converted to an allowed fieldname.
  - operator
```
int operator
```
    The comparison operator, must be one of the constants defined in this class.
  - value
```
DBValue value
```
    The value to compare to.
- Constructor Detail
  - DBConditionItem
```
public DBConditionItem(String item)
```
    Creates the boolean expression
- Method Detail
  - sqlConversion
```
public void sqlConversion(StringBuffer result)
```
    Appends the converted expression to the stringbuffer.
    
    Overrides:
    
    sqlConversion in class ParseItem
    
    Parameters:
    
    result - the stringbuffer to which to add the expression

Class DBConditionItem

Field Summary

Constructor Summary

Method Summary

Methods inherited from class org.mmbase.storage.search.legacy.ParseItem

Methods inherited from class java.lang.Object

Field Detail

NOTEQUAL

EQUAL

GREATER

SMALLER

GREATEREQUAL

SMALLEREQUAL

fieldName

prefix

identifier

operator

value

Constructor Detail

DBConditionItem

Method Detail

sqlConversion