public class Constraints
extends java.lang.Object
Constructor and Description |
---|
Constraints() |
Modifier and Type | Method and Description |
---|---|
static Constraint |
eq(Column value)
Constrain to equal the value in another column
|
static Constraint |
eq(java.util.Date value)
Constrain to equal a particular data value
|
static Constraint |
eq(java.lang.Number value)
Constrain to equal a particular number value
|
static Constraint |
eq(java.lang.String value)
Constrain to equal a particular string value
|
static Constraint |
gcd(Column latcol,
Column loncol,
float lat,
float lon,
float range,
float radius)
Great Circle Distance constraint
|
static Constraint |
gt(Column value)
Constrain to be greater than the values in another column
|
static Constraint |
gt(java.lang.Number value)
Constrain to be greater than a particular number value
|
static Constraint |
gt(java.lang.String value)
Constrain to be greater (alphabetically) than a particular string value
|
static Constraint |
gte(Column value)
Constrain to be greater than or equal to the values in another column
|
static Constraint |
gte(java.util.Date value)
Constrain to be after a particular time
|
static Constraint |
gte(float value)
Constrain to be greater than or equal to a particular float value
|
static Constraint |
gte(int value)
Constrain to be greater than or equal to a particular integer
|
static Constraint |
gte(java.lang.Number value)
Constrain to be greater than or equal to a particular number value
|
static Constraint |
gte(java.lang.String value)
Constrain to be greater than or equal to (alphabetically) a particular string value
|
static Constraint |
in(int... value)
Constrain to be in one or more integer values
|
static Constraint |
in(java.lang.String... value)
Constrain to be in one or more string values
|
static Constraint |
isnotnull()
Constrain to non-null values
|
static Constraint |
isnull()
Constrain to null values
|
static Constraint |
like(java.lang.String value)
Constrain to be like a particular string value (may contain wildcards)
|
static Constraint |
lt(Column value)
Constrain to be less than the values in another column
|
static Constraint |
lt(java.util.Date value)
Constrain to be before a particular time
|
static Constraint |
lt(java.lang.Number value)
Constrain to be less than a particular number value
|
static Constraint |
lt(java.lang.String value)
Constrain to be less (alphabetically) than a particular string value
|
static Constraint |
lte(Column value)
Constrain to be less than or equal to the values in another column
|
static Constraint |
lte(float value)
Constrain to be less than or equal to a particular float value
|
static Constraint |
lte(int value)
Constrain to be less than or equal to a particular integer
|
static Constraint |
lte(java.lang.Number value)
Constrain to be less than or equal to a particular number value
|
static Constraint |
lte(java.lang.String value)
Constrain to be less than or equal to (alphabetically) a particular string value
|
static Constraint |
ne(Column value)
Constrain to not equal the value in another column
|
static Constraint |
ne(java.util.Date value)
Constrain to not equal a particular date value
|
static Constraint |
ne(java.lang.Number value)
Constrain to not equal a particular number value
|
static Constraint |
ne(java.lang.String value)
Constrain to not equal a particular date value
|
static Constraint |
notin(int... value)
Constrain to be not in one or more integer values
|
static Constraint |
notin(java.lang.String... value)
Constrain to be not in one or more string values
|
static Constraint |
notlike(java.lang.String value)
Constrain to be unlike a particular string value (may contain wildcards)
|
static Constraint |
notrlike(java.lang.String value)
Constrain to be regex-unlike a particular string value (may contain wildcards and regex)
|
static Constraint |
rlike(java.lang.String value)
Constrain to be regex-like a particular string value (may contain wildcards and regex)
|
public static Constraint eq(Column value)
value
- the columnpublic static Constraint eq(java.lang.String value)
value
- the valuepublic static Constraint eq(java.lang.Number value)
value
- the valuepublic static Constraint eq(java.util.Date value)
value
- the valuepublic static Constraint ne(Column value)
value
- the columnpublic static Constraint ne(java.lang.String value)
value
- the valuepublic static Constraint ne(java.lang.Number value)
value
- the valuepublic static Constraint ne(java.util.Date value)
value
- the valuepublic static Constraint isnull()
public static Constraint isnotnull()
public static Constraint like(java.lang.String value)
value
- the valuepublic static Constraint rlike(java.lang.String value)
value
- the valuepublic static Constraint notlike(java.lang.String value)
value
- the valuepublic static Constraint notrlike(java.lang.String value)
value
- the valuepublic static Constraint lt(java.lang.String value)
value
- the valuepublic static Constraint lte(java.lang.String value)
value
- the valuepublic static Constraint gt(java.lang.String value)
value
- the valuepublic static Constraint gte(java.lang.String value)
value
- the valuepublic static Constraint lt(java.lang.Number value)
value
- the valuepublic static Constraint lte(java.lang.Number value)
value
- the valuepublic static Constraint gt(java.lang.Number value)
value
- the valuepublic static Constraint gte(java.lang.Number value)
value
- the valuepublic static Constraint lt(Column value)
value
- the columnpublic static Constraint lte(Column value)
value
- the columnpublic static Constraint gt(Column value)
value
- the columnpublic static Constraint gte(Column value)
value
- the columnpublic static Constraint in(java.lang.String... value)
value
- the value(s)public static Constraint in(int... value)
value
- the value(s)public static Constraint notin(java.lang.String... value)
value
- the value(s)public static Constraint notin(int... value)
value
- the value(s)public static Constraint lte(float value)
value
- the valuepublic static Constraint gte(float value)
value
- the valuepublic static Constraint lte(int value)
value
- the integerpublic static Constraint gte(int value)
value
- the integerpublic static Constraint lt(java.util.Date value)
value
- the timepublic static Constraint gte(java.util.Date value)
value
- the timepublic static Constraint gcd(Column latcol, Column loncol, float lat, float lon, float range, float radius)
latcol
- latitude columnloncol
- longitude columnlat
- latitude center of querylon
- longitude center of queryrange
- distance of range (must be in same units as radius)radius
- planetary radius (must be in same units as range)Copyright \ (C) Arizona Board of Regents on behalf of the \ Planetary Image Research Laboratory, Lunar and \ Planetary Laboratory at the University of Arizona