com.mysema.query.sql

Class SQLExpressions

java.lang.Object

com.mysema.query.sql.SQLExpressions

public final class SQLExpressions
extends Object

Common SQL expressions

Author:

tiwe

Field Summary

Fields

Modifier and Type	Field and Description
static Expression<Object[]>	all
static Expression<Long>	countAll

Method Summary

Methods

Modifier and Type	Method and Description
static <D extends Comparable> DateExpression<D>	addDays(DateExpression<D> date, int days)
static <D extends Comparable> DateTimeExpression<D>	addDays(DateTimeExpression<D> date, int days)
static <D extends Comparable> DateExpression<D>	addHours(DateExpression<D> date, int days)
static <D extends Comparable> DateTimeExpression<D>	addHours(DateTimeExpression<D> date, int days)
static <D extends Comparable> DateExpression<D>	addMinutes(DateExpression<D> date, int days)
static <D extends Comparable> DateTimeExpression<D>	addMinutes(DateTimeExpression<D> date, int days)
static <D extends Comparable> DateExpression<D>	addMonths(DateExpression<D> date, int days)
static <D extends Comparable> DateTimeExpression<D>	addMonths(DateTimeExpression<D> date, int days)
static <D extends Comparable> DateExpression<D>	addSeconds(DateExpression<D> date, int days)
static <D extends Comparable> DateTimeExpression<D>	addSeconds(DateTimeExpression<D> date, int days)
static <D extends Comparable> DateExpression<D>	addWeeks(DateExpression<D> date, int days)
static <D extends Comparable> DateTimeExpression<D>	addWeeks(DateTimeExpression<D> date, int days)
static <D extends Comparable> DateExpression<D>	addYears(DateExpression<D> date, int days)
static <D extends Comparable> DateTimeExpression<D>	addYears(DateTimeExpression<D> date, int days)
static BooleanExpression	all(BooleanExpression expr) Get an aggregate all expression for the given boolean expression
static BooleanExpression	any(BooleanExpression expr) Get an aggregate any expression for the given boolean expression
static <T extends Number> SimpleExpression<T>	nextval(Class<T> type, String sequence)
static SimpleExpression<Long>	nextval(String sequence)

Methods inherited from class java.lang.Object

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

Field Detail

all

public static final Expression<Object[]> all

countAll

public static final Expression<Long> countAll

Method Detail

any

public static BooleanExpression any(BooleanExpression expr)

Get an aggregate any expression for the given boolean expression

all

public static BooleanExpression all(BooleanExpression expr)

Get an aggregate all expression for the given boolean expression

nextval

public static final SimpleExpression<Long> nextval(String sequence)

Parameters:

sequence -

Returns:

nextval

public static final <T extends Number> SimpleExpression<T> nextval(Class<T> type,
                                             String sequence)

Parameters:

type -

sequence -

Returns:

addYears

public static <D extends Comparable> DateTimeExpression<D> addYears(DateTimeExpression<D> date,
                                                    int days)

Parameters:

date -

days -

Returns:

addMonths

public static <D extends Comparable> DateTimeExpression<D> addMonths(DateTimeExpression<D> date,
                                                     int days)

Parameters:

date -

days -

Returns:

addWeeks

public static <D extends Comparable> DateTimeExpression<D> addWeeks(DateTimeExpression<D> date,
                                                    int days)

Parameters:

date -

days -

Returns:

addDays

public static <D extends Comparable> DateTimeExpression<D> addDays(DateTimeExpression<D> date,
                                                   int days)

Parameters:

date -

days -

Returns:

addHours

public static <D extends Comparable> DateTimeExpression<D> addHours(DateTimeExpression<D> date,
                                                    int days)

Parameters:

date -

days -

Returns:

addMinutes

public static <D extends Comparable> DateTimeExpression<D> addMinutes(DateTimeExpression<D> date,
                                                      int days)

Parameters:

date -

days -

Returns:

addSeconds

public static <D extends Comparable> DateTimeExpression<D> addSeconds(DateTimeExpression<D> date,
                                                      int days)

Parameters:

date -

days -

Returns:

addYears

public static <D extends Comparable> DateExpression<D> addYears(DateExpression<D> date,
                                                int days)

Parameters:

date -

days -

Returns:

addMonths

public static <D extends Comparable> DateExpression<D> addMonths(DateExpression<D> date,
                                                 int days)

Parameters:

date -

days -

Returns:

addWeeks

public static <D extends Comparable> DateExpression<D> addWeeks(DateExpression<D> date,
                                                int days)

Parameters:

date -

days -

Returns:

addDays

public static <D extends Comparable> DateExpression<D> addDays(DateExpression<D> date,
                                               int days)

Parameters:

date -

days -

Returns:

addHours

public static <D extends Comparable> DateExpression<D> addHours(DateExpression<D> date,
                                                int days)

Parameters:

date -

days -

Returns:

addMinutes

public static <D extends Comparable> DateExpression<D> addMinutes(DateExpression<D> date,
                                                  int days)

Parameters:

date -

days -

Returns:

addSeconds

public static <D extends Comparable> DateExpression<D> addSeconds(DateExpression<D> date,
                                                  int days)

Parameters:

date -

days -

Returns: