com.mysema.query.sql

Class SQLExpressions

java.lang.Object

com.mysema.query.sql.SQLExpressions

public final class SQLExpressions
extends java.lang.Object

Common SQL expressions

Author:

tiwe

Field Summary

Fields

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

Method Summary

Methods

Modifier and Type	Method and Description
static <D extends java.lang.Comparable> DateExpression<D>	addDays(DateExpression<D> date, int days)
static <D extends java.lang.Comparable> DateTimeExpression<D>	addDays(DateTimeExpression<D> date, int days)
static <D extends java.lang.Comparable> DateExpression<D>	addHours(DateExpression<D> date, int days)
static <D extends java.lang.Comparable> DateTimeExpression<D>	addHours(DateTimeExpression<D> date, int days)
static <D extends java.lang.Comparable> DateExpression<D>	addMinutes(DateExpression<D> date, int days)
static <D extends java.lang.Comparable> DateTimeExpression<D>	addMinutes(DateTimeExpression<D> date, int days)
static <D extends java.lang.Comparable> DateExpression<D>	addMonths(DateExpression<D> date, int days)
static <D extends java.lang.Comparable> DateTimeExpression<D>	addMonths(DateTimeExpression<D> date, int days)
static <D extends java.lang.Comparable> DateExpression<D>	addSeconds(DateExpression<D> date, int days)
static <D extends java.lang.Comparable> DateTimeExpression<D>	addSeconds(DateTimeExpression<D> date, int days)
static <D extends java.lang.Comparable> DateExpression<D>	addWeeks(DateExpression<D> date, int days)
static <D extends java.lang.Comparable> DateTimeExpression<D>	addWeeks(DateTimeExpression<D> date, int days)
static <D extends java.lang.Comparable> DateExpression<D>	addYears(DateExpression<D> date, int days)
static <D extends java.lang.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 java.lang.Number> SimpleExpression<T>	nextval(java.lang.Class<T> type, java.lang.String sequence)
static SimpleExpression<java.lang.Long>	nextval(java.lang.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<java.lang.Object[]> all

countAll

public static final Expression<java.lang.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<java.lang.Long> nextval(java.lang.String sequence)

Parameters:

sequence -

Returns:

nextval

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

Parameters:

type -

sequence -

Returns:

addYears

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

Parameters:

date -

days -

Returns:

addMonths

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

Parameters:

date -

days -

Returns:

addWeeks

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

Parameters:

date -

days -

Returns:

addDays

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

Parameters:

date -

days -

Returns:

addHours

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

Parameters:

date -

days -

Returns:

addMinutes

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

Parameters:

date -

days -

Returns:

addSeconds

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

Parameters:

date -

days -

Returns:

addYears

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

Parameters:

date -

days -

Returns:

addMonths

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

Parameters:

date -

days -

Returns:

addWeeks

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

Parameters:

date -

days -

Returns:

addDays

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

Parameters:

date -

days -

Returns:

addHours

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

Parameters:

date -

days -

Returns:

addMinutes

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

Parameters:

date -

days -

Returns:

addSeconds

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

Parameters:

date -

days -

Returns: