HiRISE.HiReport.sql

Class Constraints

java.lang.Object

HiRISE.HiReport.sql.Constraints

public class Constraints
extends java.lang.Object

Predefined constraints

Constructor Summary

Constructors

Constructor and Description
Constraints()

Method Summary

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)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Constraints

public Constraints()

Method Detail

eq

public static Constraint eq(Column value)

Constrain to equal the value in another column

Parameters:

value - the column

Returns:

the constraint

eq

public static Constraint eq(java.lang.String value)

Constrain to equal a particular string value

Parameters:

value - the value

Returns:

the constraint

eq

public static Constraint eq(java.lang.Number value)

Constrain to equal a particular number value

Parameters:

value - the value

Returns:

the constraint

eq

public static Constraint eq(java.util.Date value)

Constrain to equal a particular data value

Parameters:

value - the value

Returns:

the constraint

ne

public static Constraint ne(Column value)

Constrain to not equal the value in another column

Parameters:

value - the column

Returns:

the constraint

ne

public static Constraint ne(java.lang.String value)

Constrain to not equal a particular date value

Parameters:

value - the value

Returns:

the constraint

ne

public static Constraint ne(java.lang.Number value)

Constrain to not equal a particular number value

Parameters:

value - the value

Returns:

the constraint

ne

public static Constraint ne(java.util.Date value)

Constrain to not equal a particular date value

Parameters:

value - the value

Returns:

the constraint

isnull

public static Constraint isnull()

Constrain to null values

Returns:

the constraint

isnotnull

public static Constraint isnotnull()

Constrain to non-null values

Returns:

the constraint

like

public static Constraint like(java.lang.String value)

Constrain to be like a particular string value (may contain wildcards)

Parameters:

value - the value

Returns:

the constraint

rlike

public static Constraint rlike(java.lang.String value)

Constrain to be regex-like a particular string value (may contain wildcards and regex)

Parameters:

value - the value

Returns:

the constraint

notlike

public static Constraint notlike(java.lang.String value)

Constrain to be unlike a particular string value (may contain wildcards)

Parameters:

value - the value

Returns:

the constraint

notrlike

public static Constraint notrlike(java.lang.String value)

Constrain to be regex-unlike a particular string value (may contain wildcards and regex)

Parameters:

value - the value

Returns:

the constraint

lt

public static Constraint lt(java.lang.String value)

Constrain to be less (alphabetically) than a particular string value

Parameters:

value - the value

Returns:

the constraint

lte

public static Constraint lte(java.lang.String value)

Constrain to be less than or equal to (alphabetically) a particular string value

Parameters:

value - the value

Returns:

the constraint

gt

public static Constraint gt(java.lang.String value)

Constrain to be greater (alphabetically) than a particular string value

Parameters:

value - the value

Returns:

the constraint

gte

public static Constraint gte(java.lang.String value)

Constrain to be greater than or equal to (alphabetically) a particular string value

Parameters:

value - the value

Returns:

the constraint

lt

public static Constraint lt(java.lang.Number value)

Constrain to be less than a particular number value

Parameters:

value - the value

Returns:

the constraint

lte

public static Constraint lte(java.lang.Number value)

Constrain to be less than or equal to a particular number value

Parameters:

value - the value

Returns:

the constraint

gt

public static Constraint gt(java.lang.Number value)

Constrain to be greater than a particular number value

Parameters:

value - the value

Returns:

the constraint

gte

public static Constraint gte(java.lang.Number value)

Constrain to be greater than or equal to a particular number value

Parameters:

value - the value

Returns:

the constraint

lt

public static Constraint lt(Column value)

Constrain to be less than the values in another column

Parameters:

value - the column

Returns:

the constraint

lte

public static Constraint lte(Column value)

Constrain to be less than or equal to the values in another column

Parameters:

value - the column

Returns:

the constraint

gt

public static Constraint gt(Column value)

Constrain to be greater than the values in another column

Parameters:

value - the column

Returns:

the constraint

gte

public static Constraint gte(Column value)

Constrain to be greater than or equal to the values in another column

Parameters:

value - the column

Returns:

the constraint

in

public static Constraint in(java.lang.String... value)

Constrain to be in one or more string values

Parameters:

value - the value(s)

Returns:

the constraint

in

public static Constraint in(int... value)

Constrain to be in one or more integer values

Parameters:

value - the value(s)

Returns:

the constraint

notin

public static Constraint notin(java.lang.String... value)

Constrain to be not in one or more string values

Parameters:

value - the value(s)

Returns:

the constraint

notin

public static Constraint notin(int... value)

Constrain to be not in one or more integer values

Parameters:

value - the value(s)

Returns:

the constraint

lte

public static Constraint lte(float value)

Constrain to be less than or equal to a particular float value

Parameters:

value - the value

Returns:

the constraint

gte

public static Constraint gte(float value)

Constrain to be greater than or equal to a particular float value

Parameters:

value - the value

Returns:

the constraint

lte

public static Constraint lte(int value)

Constrain to be less than or equal to a particular integer

Parameters:

value - the integer

Returns:

the constraint

gte

public static Constraint gte(int value)

Constrain to be greater than or equal to a particular integer

Parameters:

value - the integer

Returns:

the constraint

lt

public static Constraint lt(java.util.Date value)

Constrain to be before a particular time

Parameters:

value - the time

Returns:

the constraint

gte

public static Constraint gte(java.util.Date value)

Constrain to be after a particular time

Parameters:

value - the time

Returns:

the constraint

gcd

public static Constraint gcd(Column latcol,
                             Column loncol,
                             float lat,
                             float lon,
                             float range,
                             float radius)

Great Circle Distance constraint

Parameters:

latcol - latitude column

loncol - longitude column

lat - latitude center of query

lon - longitude center of query

range - distance of range (must be in same units as radius)

radius - planetary radius (must be in same units as range)

Returns:

distance constraint