HiRISE

HiRISE.HiReport.sql
Class Constraints

java.lang.Object
  extended by HiRISE.HiReport.sql.Constraints

public class Constraints
extends Object

Predefined constraints


Constructor Summary
Constraints()
           
 
Method Summary
static Constraint eq(Column value)
          Constrain to equal the value in another column
static Constraint eq(Date value)
          Constrain to equal a particular data value
static Constraint eq(Number value)
          Constrain to equal a particular number value
static Constraint eq(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(Number value)
          Constrain to be greater than a particular number value
static Constraint gt(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(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(Number value)
          Constrain to be greater than or equal to a particular number value
static Constraint gte(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(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(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(Date value)
          Constrain to be before a particular time
static Constraint lt(Number value)
          Constrain to be less than a particular number value
static Constraint lt(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(Number value)
          Constrain to be less than or equal to a particular number value
static Constraint lte(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(Date value)
          Constrain to not equal a particular date value
static Constraint ne(Number value)
          Constrain to not equal a particular number value
static Constraint ne(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(String... value)
          Constrain to be not in one or more string values
static Constraint notlike(String value)
          Constrain to be unlike a particular string value (may contain wildcards)
static Constraint notrlike(String value)
          Constrain to be regex-unlike a particular string value (may contain wildcards and regex)
static Constraint rlike(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(String value)
Constrain to equal a particular string value

Parameters:
value - the value
Returns:
the constraint

eq

public static Constraint eq(Number value)
Constrain to equal a particular number value

Parameters:
value - the value
Returns:
the constraint

eq

public static Constraint eq(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(String value)
Constrain to not equal a particular date value

Parameters:
value - the value
Returns:
the constraint

ne

public static Constraint ne(Number value)
Constrain to not equal a particular number value

Parameters:
value - the value
Returns:
the constraint

ne

public static Constraint ne(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(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(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(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(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(String value)
Constrain to be less (alphabetically) than a particular string value

Parameters:
value - the value
Returns:
the constraint

lte

public static Constraint lte(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(String value)
Constrain to be greater (alphabetically) than a particular string value

Parameters:
value - the value
Returns:
the constraint

gte

public static Constraint gte(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(Number value)
Constrain to be less than a particular number value

Parameters:
value - the value
Returns:
the constraint

lte

public static Constraint lte(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(Number value)
Constrain to be greater than a particular number value

Parameters:
value - the value
Returns:
the constraint

gte

public static Constraint gte(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(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(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(Date value)
Constrain to be before a particular time

Parameters:
value - the time
Returns:
the constraint

gte

public static Constraint gte(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

HiRISE

Copyright (C) Arizona Board of Regents on behalf of the Planetary Image Research Laboratory, Lunar and Planetary Laboratory at the University of Arizona