Package nz.co.gregs.dbvolution.expressions

Class DateRepeatExpression.LagExpression

java.lang.Object

nz.co.gregs.dbvolution.expressions.AnyExpression<B,R,D>

nz.co.gregs.dbvolution.expressions.EqualExpression<B,R,D>

nz.co.gregs.dbvolution.expressions.InExpression<B,R,D>

nz.co.gregs.dbvolution.expressions.RangeExpression<org.joda.time.Period,DateRepeatResult,DBDateRepeat>

nz.co.gregs.dbvolution.expressions.DateRepeatExpression

nz.co.gregs.dbvolution.expressions.DateRepeatExpression.LagExpression

All Implemented Interfaces:

Serializable, DBExpression, ExpressionColumn<DBDateRepeat>, HasSQLString, CanBeWindowingFunctionWithFrame<DateRepeatExpression>, AnyComparable<org.joda.time.Period,DateRepeatResult>, AnyResult<org.joda.time.Period>, DateRepeatResult, EqualComparable<org.joda.time.Period,DateRepeatResult>, EqualResult<org.joda.time.Period>, ExpressionCanHaveNullValues, ExpressionHasStandardStringResult, InComparable<org.joda.time.Period,DateRepeatResult>, InResult<org.joda.time.Period>, NullCapableResult<org.joda.time.Period>, RangeComparable<org.joda.time.Period,DateRepeatResult>, RangeResult<org.joda.time.Period>

Enclosing class:

DateRepeatExpression

public class DateRepeatExpression.LagExpression
extends DateRepeatExpression

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class nz.co.gregs.dbvolution.expressions.AnyExpression

AnyExpression.CountAllExpression, AnyExpression.CountDistinctExpression, AnyExpression.CountExpression, AnyExpression.NTileExpression, AnyExpression.PercentageExpression, AnyExpression.RankExpression

Nested classes/interfaces inherited from class nz.co.gregs.dbvolution.expressions.DateRepeatExpression

DateRepeatExpression.Comparison, DateRepeatExpression.FirstValueExpression, DateRepeatExpression.GetYearsExpression, DateRepeatExpression.IsExpression, DateRepeatExpression.IsGreaterThanOrEqualExpression, DateRepeatExpression.LagExpression, DateRepeatExpression.LastValueExpression, DateRepeatExpression.LeadExpression, DateRepeatExpression.NthValueExpression

Nested classes/interfaces inherited from class nz.co.gregs.dbvolution.expressions.EqualExpression

EqualExpression.DBUnaryFunction<B,R extends EqualResult<B>,D extends QueryableDatatype<B>,X extends EqualExpression<B,R,D>>, EqualExpression.ModeSimpleExpression<B,R extends EqualResult<B>,D extends QueryableDatatype<B>,X extends EqualExpression<B,R,D>>, EqualExpression.ModeStrictExpression<B,R extends EqualResult<B>,D extends QueryableDatatype<B>,X extends EqualExpression<B,R,D>>

Nested classes/interfaces inherited from class nz.co.gregs.dbvolution.expressions.RangeExpression

RangeExpression.MedianExpression<B,R extends EqualResult<B>,D extends QueryableDatatype<B>,X extends EqualExpression<B,R,D>>, RangeExpression.UniqueRankingExpression<B,R extends EqualResult<B>,D extends QueryableDatatype<B>,X extends EqualExpression<B,R,D>>

Field Summary

Fields inherited from class nz.co.gregs.dbvolution.expressions.DateRepeatExpression

DAY_SUFFIX, HOUR_SUFFIX, INTERVAL_PREFIX, MINUTE_SUFFIX, MONTH_SUFFIX, SECOND_SUFFIX, YEAR_SUFFIX

Constructor Summary

Constructors

Constructor	Description
LagExpression(DateRepeatExpression first, IntegerExpression second, DateRepeatExpression third)

Method Summary

Modifier and Type	Method	Description
DateRepeatExpression.LagExpression	copy()	A Complete Copy Of This DBValue.

Methods inherited from class nz.co.gregs.dbvolution.expressions.AnyExpression

ascending, asResult, count, countAll, countDistinctValues, countNotNull, createSQLForFromClause, createSQLForGroupByClause, denseRank, descending, getInnerResult, highestFirst, highestLast, isComplexExpression, isNullSafetyTerminator, isWindowingFunction, lowestFirst, lowestLast, nTile, nTile, nTile, nullBoolean, nullDate, nullDateRepeat, nullDuration, nullInstant, nullInteger, nullLine2D, nullLineSegment2D, nullLocalDate, nullLocalDateTime, nullMultiPoint2D, nullNumber, nullPoint2D, nullPolygon2D, nullString, percentageRank, rank, rowNumber, runningCount, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value

Methods inherited from interface nz.co.gregs.dbvolution.expressions.windows.CanBeWindowingFunctionWithFrame

window

Methods inherited from class nz.co.gregs.dbvolution.expressions.DateRepeatExpression

approximateDurationInSeconds, asExpressionColumn, comparison, expression, expression, expression, firstValue, getDays, getHours, getMinutes, getMonths, getSeconds, getYears, is, is, isBetween, isBetweenExclusive, isBetweenInclusive, isGreaterThan, isGreaterThan, isGreaterThan, isGreaterThan, isGreaterThanOrEqual, isGreaterThanOrEqual, isInCollection, isLessThan, isLessThan, isLessThan, isLessThan, isLessThanOrEqual, isLessThanOrEqual, isNot, isNot, isNotInCollection, isNotNull, isNull, lag, lag, lag, lastValue, lead, lead, lead, modeSimple, modeStrict, nthValue, nullExpression, stringResult

Methods inherited from interface nz.co.gregs.dbvolution.expressions.DBExpression

createSQLForFromClause, createSQLForGroupByClause, isComplexExpression, isWindowingFunction

Methods inherited from class nz.co.gregs.dbvolution.expressions.EqualExpression

countIf, is, isNot

Methods inherited from interface nz.co.gregs.dbvolution.expressions.ExpressionColumn

toExpressionColumn

Methods inherited from interface nz.co.gregs.dbvolution.results.InComparable

isIn

Methods inherited from class nz.co.gregs.dbvolution.expressions.InExpression

isIn, isIn, isIn, isNotIn, isNotIn, isNotIn

Methods inherited from class java.lang.Object

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

Methods inherited from class nz.co.gregs.dbvolution.expressions.RangeExpression

isBetween, isBetween, isBetween, isBetween, isBetween, isBetween, isBetween, isBetween, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isGreaterThan, isGreaterThan, isGreaterThanOrEqual, isLessThan, isLessThan, isLessThanOrEqual

Constructor Detail

LagExpression

public LagExpression(DateRepeatExpression first,
                     IntegerExpression second,
                     DateRepeatExpression third)

Method Detail

copy

public DateRepeatExpression.LagExpression copy()

Description copied from interface: DBExpression

A Complete Copy Of This DBValue.

Immutability in DBvolution is maintain by internally copying objects.

This method enables immutability by performing a deep copy of the object.

Singletons may return themselves but all other objects must return a new instance with copies of all mutable fields.

Support DBvolution at Patreon

Specified by:

copy in interface DateRepeatResult

Specified by:

copy in interface DBExpression

Overrides:

copy in class DateRepeatExpression

Returns:

a copy of this DBValue