com.todoroo.andlib.sql
Class Field

java.lang.Object
  com.todoroo.andlib.sql.DBObject<Field>
      com.todoroo.andlib.sql.Field

All Implemented Interfaces:

java.lang.Cloneable

Direct Known Subclasses:

Property

public class Field
extends DBObject<Field>

Method Summary

Criterion	between(java.lang.Object lower, java.lang.Object upper)
Criterion	eq(java.lang.Object value)
Criterion	eqCaseInsensitive(java.lang.String value) Adds the criterion that the field must be equal to the given string, ignoring case.
static Field	field(java.lang.String expression)
Criterion	gt(java.lang.Object value)
Criterion	in(Query query)
<T> Criterion	in(T[] value)
Criterion	isNotNull()
Criterion	isNull()
Criterion	like(java.lang.String value)
Criterion	like(java.lang.String value, java.lang.String escape)
Criterion	lt(java.lang.Object value)
Criterion	lte(java.lang.Object value)
Criterion	neq(java.lang.Object value)

Methods inherited from class com.todoroo.andlib.sql.DBObject

as, equals, hasAlias, hashCode, toString, toStringInSelect

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Method Detail

field

public static Field field(java.lang.String expression)

eq

public Criterion eq(java.lang.Object value)

eqCaseInsensitive

public Criterion eqCaseInsensitive(java.lang.String value)

Adds the criterion that the field must be equal to the given string, ignoring case. Thanks to a sqlite bug, this will only work for ASCII values.

Parameters:

value - string which field must equal

Returns:

the criterion

neq

public Criterion neq(java.lang.Object value)

gt

public Criterion gt(java.lang.Object value)

lt

public Criterion lt(java.lang.Object value)

lte

public Criterion lte(java.lang.Object value)

isNull

public Criterion isNull()

isNotNull

public Criterion isNotNull()

between

public Criterion between(java.lang.Object lower,
                         java.lang.Object upper)

like

public Criterion like(java.lang.String value)

like

public Criterion like(java.lang.String value,
                      java.lang.String escape)

in

public <T> Criterion in(T[] value)

in

public Criterion in(Query query)