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 Wildcard expression
static Expression<java.lang.Long>	countAll Wilcard count expression

Method Summary

Methods

Modifier and Type	Method and Description
static <D extends java.lang.Comparable> DateExpression<D>	addDays(DateExpression<D> date, int days) Add the given amount of days to the date
static <D extends java.lang.Comparable> DateTimeExpression<D>	addDays(DateTimeExpression<D> date, int days) Add the given amount of days to the date
static <D extends java.lang.Comparable> DateTimeExpression<D>	addHours(DateTimeExpression<D> date, int hours) Add the given amount of hours to the date
static <D extends java.lang.Comparable> DateTimeExpression<D>	addMinutes(DateTimeExpression<D> date, int minutes) Add the given amount of minutes to the date
static <D extends java.lang.Comparable> DateExpression<D>	addMonths(DateExpression<D> date, int months) Add the given amount of months to the date
static <D extends java.lang.Comparable> DateTimeExpression<D>	addMonths(DateTimeExpression<D> date, int months) Add the given amount of months to the date
static <D extends java.lang.Comparable> DateTimeExpression<D>	addSeconds(DateTimeExpression<D> date, int seconds) Add the given amount of seconds to the date
static <D extends java.lang.Comparable> DateExpression<D>	addWeeks(DateExpression<D> date, int weeks) Add the given amount of weeks to the date
static <D extends java.lang.Comparable> DateTimeExpression<D>	addWeeks(DateTimeExpression<D> date, int weeks) Add the given amount of weeks to the date
static <D extends java.lang.Comparable> DateExpression<D>	addYears(DateExpression<D> date, int years) Add the given amount of years to the date
static <D extends java.lang.Comparable> DateTimeExpression<D>	addYears(DateTimeExpression<D> date, int years) Add the given amount of years to the date
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 <D extends java.lang.Comparable> DateExpression<D>	dateadd(DatePart unit, DateExpression<D> date, int amount) Get a dateadd(unit, date, amount) expression
static <D extends java.lang.Comparable> DateTimeExpression<D>	dateadd(DatePart unit, DateTimeExpression<D> date, int amount) Get a dateadd(unit, date, amount) expression
static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer>	datediff(DatePart unit, DateExpression<D> start, D end) Get a datediff(unit, start, end) expression
static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer>	datediff(DatePart unit, DateExpression<D> start, DateExpression<D> end) Get a datediff(unit, start, end) expression
static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer>	datediff(DatePart unit, DateTimeExpression<D> start, D end) Get a datediff(unit, start, end) expression
static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer>	datediff(DatePart unit, DateTimeExpression<D> start, DateTimeExpression<D> end) Get a datediff(unit, start, end) expression
static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer>	datediff(DatePart unit, D start, DateExpression<D> end) Get a datediff(unit, start, end) expression
static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer>	datediff(DatePart unit, D start, DateTimeExpression<D> end) Get a datediff(unit, start, end) expression
static <T extends java.lang.Number> SimpleExpression<T>	nextval(java.lang.Class<T> type, java.lang.String sequence) Get a nextval(sequence) expression of the given type
static SimpleExpression<java.lang.Long>	nextval(java.lang.String sequence) Get a nextval(sequence) expression

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

Wildcard expression

countAll

public static final Expression<java.lang.Long> countAll

Wilcard count expression

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)

Get a nextval(sequence) expression

Parameters:

sequence -

Returns:

nextval

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

Get a nextval(sequence) expression of the given type

Parameters:

type -

sequence -

Returns:

dateadd

public static <D extends java.lang.Comparable> DateTimeExpression<D> dateadd(DatePart unit,
                                                             DateTimeExpression<D> date,
                                                             int amount)

Get a dateadd(unit, date, amount) expression

Parameters:

unit -

date -

amount -

Returns:

dateadd

public static <D extends java.lang.Comparable> DateExpression<D> dateadd(DatePart unit,
                                                         DateExpression<D> date,
                                                         int amount)

Get a dateadd(unit, date, amount) expression

Parameters:

unit -

date -

amount -

Returns:

datediff

public static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer> datediff(DatePart unit,
                                                                            DateExpression<D> start,
                                                                            DateExpression<D> end)

Get a datediff(unit, start, end) expression

Parameters:

unit -

start -

end -

Returns:

datediff

public static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer> datediff(DatePart unit,
                                                                            D start,
                                                                            DateExpression<D> end)

Get a datediff(unit, start, end) expression

Parameters:

unit -

start -

end -

Returns:

datediff

public static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer> datediff(DatePart unit,
                                                                            DateExpression<D> start,
                                                                            D end)

Get a datediff(unit, start, end) expression

Parameters:

unit -

start -

end -

Returns:

datediff

public static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer> datediff(DatePart unit,
                                                                            DateTimeExpression<D> start,
                                                                            DateTimeExpression<D> end)

Get a datediff(unit, start, end) expression

Parameters:

unit -

start -

end -

Returns:

datediff

public static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer> datediff(DatePart unit,
                                                                            D start,
                                                                            DateTimeExpression<D> end)

Get a datediff(unit, start, end) expression

Parameters:

unit -

start -

end -

Returns:

datediff

public static <D extends java.lang.Comparable> NumberExpression<java.lang.Integer> datediff(DatePart unit,
                                                                            DateTimeExpression<D> start,
                                                                            D end)

Get a datediff(unit, start, end) expression

Parameters:

unit -

start -

end -

Returns:

addYears

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

Add the given amount of years to the date

Parameters:

date -

years -

Returns:

addMonths

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

Add the given amount of months to the date

Parameters:

date -

months -

Returns:

addWeeks

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

Add the given amount of weeks to the date

Parameters:

date -

weeks -

Returns:

addDays

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

Add the given amount of days to the date

Parameters:

date -

days -

Returns:

addHours

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

Add the given amount of hours to the date

Parameters:

date -

hours -

Returns:

addMinutes

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

Add the given amount of minutes to the date

Parameters:

date -

minutes -

Returns:

addSeconds

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

Add the given amount of seconds to the date

Parameters:

date -

seconds -

Returns:

addYears

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

Add the given amount of years to the date

Parameters:

date -

years -

Returns:

addMonths

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

Add the given amount of months to the date

Parameters:

date -

months -

Returns:

addWeeks

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

Add the given amount of weeks to the date

Parameters:

date -

weeks -

Returns:

addDays

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

Add the given amount of days to the date

Parameters:

date -

days -

Returns: