Package nz.co.gregs.dbvolution.expressions

Class BooleanExpression.LocalDateTimeIfThenElseExpression

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<LocalDateTime,LocalDateTimeResult,DBLocalDateTime>

nz.co.gregs.dbvolution.expressions.LocalDateTimeExpression

nz.co.gregs.dbvolution.expressions.BooleanExpression.LocalDateTimeIfThenElseExpression

All Implemented Interfaces:

Serializable, DBExpression, ExpressionColumn<DBLocalDateTime>, HasSQLString, AnyComparable<LocalDateTime,LocalDateTimeResult>, AnyResult<LocalDateTime>, EqualComparable<LocalDateTime,LocalDateTimeResult>, EqualResult<LocalDateTime>, ExpressionCanHaveNullValues, ExpressionHasStandardStringResult, InComparable<LocalDateTime,LocalDateTimeResult>, InResult<LocalDateTime>, LocalDateTimeResult, NullCapableResult<LocalDateTime>, RangeComparable<LocalDateTime,LocalDateTimeResult>, RangeResult<LocalDateTime>

Enclosing class:

BooleanExpression

protected class BooleanExpression.LocalDateTimeIfThenElseExpression
extends LocalDateTimeExpression

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.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.LocalDateTimeExpression

LocalDateTimeExpression.CurrentLocalDateLocalDateTimeExpression, LocalDateTimeExpression.FirstValueExpression, LocalDateTimeExpression.LagExpression, LocalDateTimeExpression.LastValueExpression, LocalDateTimeExpression.LeadExpression, LocalDateTimeExpression.LocalDateTimeAddDaysExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerDaysExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerHoursExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerMinutesExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerMonthsExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerSecondsExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerWeeksExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerYearsExpression, LocalDateTimeExpression.LocalDateTimeAddMonthsExpression, LocalDateTimeExpression.LocalDateTimeAddSecondsExpression, LocalDateTimeExpression.LocalDateTimeCurrentLocalDateTimeExpression, LocalDateTimeExpression.LocalDateTimeCurrentTimeExpression, LocalDateTimeExpression.LocalDateTimeDayExpression, LocalDateTimeExpression.LocalDateTimeDayOfWeekExpression, LocalDateTimeExpression.LocalDateTimeDaysFromExpression, LocalDateTimeExpression.LocalDateTimeEndOfMonthExpression, LocalDateTimeExpression.LocalDateTimeGetDateRepeatFromExpression, LocalDateTimeExpression.LocalDateTimeGreatestOfExpression, LocalDateTimeExpression.LocalDateTimeHourExpression, LocalDateTimeExpression.LocalDateTimeHoursFromExpression, LocalDateTimeExpression.LocalDateTimeIfDBNullExpression, LocalDateTimeExpression.LocalDateTimeIsExpression, LocalDateTimeExpression.LocalDateTimeIsGreaterThanExpression, LocalDateTimeExpression.LocalDateTimeIsGreaterThanOrEqualExpression, LocalDateTimeExpression.LocalDateTimeIsInExpression, LocalDateTimeExpression.LocalDateTimeIsLessThanExpression, LocalDateTimeExpression.LocalDateTimeIsLessThanOrEqualExpression, LocalDateTimeExpression.LocalDateTimeIsNotExpression, LocalDateTimeExpression.LocalDateTimeIsNotInExpression, LocalDateTimeExpression.LocalDateTimeLeastOfExpression, LocalDateTimeExpression.LocalDateTimeMaxExpression, LocalDateTimeExpression.LocalDateTimeMinExpression, LocalDateTimeExpression.LocalDateTimeMinusDateRepeatExpression, LocalDateTimeExpression.LocalDateTimeMinuteExpression, LocalDateTimeExpression.LocalDateTimeMinutesFromExpression, LocalDateTimeExpression.LocalDateTimeMonthExpression, LocalDateTimeExpression.LocalDateTimeMonthsFromExpression, LocalDateTimeExpression.LocalDateTimePlusDateRepeatExpression, LocalDateTimeExpression.LocalDateTimeSecondAndSubsecondExpression, LocalDateTimeExpression.LocalDateTimeSecondExpression, LocalDateTimeExpression.LocalDateTimeSecondsFromExpression, LocalDateTimeExpression.LocalDateTimeSubsecondExpression, LocalDateTimeExpression.LocalDateTimeWeeksFromExpression, LocalDateTimeExpression.LocalDateTimeYearExpression, LocalDateTimeExpression.LocalDateTimeYearsFromExpression, LocalDateTimeExpression.NthValueExpression

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.LocalDateTimeExpression

FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, WEDNESDAY

Constructor Summary

Constructors

Constructor	Description
LocalDateTimeIfThenElseExpression(BooleanExpression only, LocalDateTimeExpression first, LocalDateTimeExpression second)

Method Summary

Modifier and Type	Method	Description
BooleanExpression.LocalDateTimeIfThenElseExpression	copy()	A Complete Copy Of This DBValue.
boolean	getIncludesNull()	Returns TRUE if this expression requires support for possible NULL database values.
String	toSQLString(DBDefinition db)	Produces the snippet provided by this class.

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.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 nz.co.gregs.dbvolution.expressions.LocalDateTimeExpression

addDays, addDays, addDays, addDays, addDays, addHours, addHours, addMinutes, addMinutes, addMonths, addMonths, addMonths, addMonths, addMonths, addSeconds, addSeconds, addSeconds, addWeeks, addWeeks, addYears, addYears, asExpressionColumn, currentLocalDate, currentLocalDateTime, currentTime, day, dayIs, dayIs, dayIs, dayIs, dayIs, dayOfWeek, daysFrom, daysFrom, endOfMonth, expression, expression, expression, firstOfMonth, firstValue, getDateRepeatFrom, getDateRepeatFrom, getQueryableDatatypeForExpressionValue, greatestOf, greatestOf, greatestOf, hour, hourIs, hourIs, hourIs, hourIs, hourIs, hoursFrom, hoursFrom, ifDBNull, ifDBNull, internalGreatestOf, internalLeastOf, is, is, isBetween, isBetween, isBetween, isBetween, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isEarlierThan, isEarlierThan, isGreaterThan, isGreaterThan, isGreaterThan, isGreaterThan, isGreaterThanOrEqual, isGreaterThanOrEqual, isIn, isInCollection, isLaterThan, isLaterThan, isLessThan, isLessThan, isLessThan, isLessThan, isLessThanOrEqual, isLessThanOrEqual, isNot, isNot, isNotInCollection, isNotNull, isNull, lag, lag, lag, lag, lag, lastValue, lead, lead, lead, leastOf, leastOf, leastOf, max, min, minus, minus, minute, minuteIs, minuteIs, minuteIs, minuteIs, minuteIs, minutesFrom, minutesFrom, month, monthIs, monthIs, monthIs, monthIs, monthIs, monthsFrom, monthsFrom, newLocalDateTime, nextRowValue, now, nthValue, nullExpression, overlaps, overlaps, overlaps, plus, plus, previousRowValue, second, secondAndSubSecond, secondIs, secondIs, secondIs, secondIs, secondIs, secondsFrom, secondsFrom, setDay, setDay, setHour, setHour, setMinute, setMinute, setMonth, setMonth, setMonth, setSecond, setSecond, setYear, setYear, stringResult, stringResultCommonFormat, stringResultISOFormat, stringResultUSAFormat, subsecond, toLocalDateTime, weeksFrom, weeksFrom, year, yearIs, yearIs, yearIs, yearIs, yearIs, yearsFrom, yearsFrom

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, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenExclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isBetweenInclusive, isGreaterThan, isGreaterThan, isGreaterThanOrEqual, isLessThan, isLessThan, isLessThanOrEqual

Constructor Detail

LocalDateTimeIfThenElseExpression

public LocalDateTimeIfThenElseExpression(BooleanExpression only,
                                         LocalDateTimeExpression first,
                                         LocalDateTimeExpression second)

Method Detail

getIncludesNull

public boolean getIncludesNull()

Description copied from interface: ExpressionCanHaveNullValues

Returns TRUE if this expression requires support for possible NULL database values.

Support DBvolution at Patreon

Specified by:

getIncludesNull in interface ExpressionCanHaveNullValues

Overrides:

getIncludesNull in class AnyExpression<LocalDateTime,LocalDateTimeResult,DBLocalDateTime>

Returns:

TRUE if the expression should check for NULLs, FALSE otherwise.

toSQLString

public String toSQLString(DBDefinition db)

Description copied from interface: HasSQLString

Produces the snippet provided by this class.

This is only used internally.

If you are extending DBvolution and adding a new function this is the place to format the information for use in SQL. A DBDefinition instance is provided to supply context and so your SQL can used on multiple database engines.

Specified by:

toSQLString in interface HasSQLString

Parameters:

db - the target database

Support DBvolution at Patreon

Returns:

the DBValue formatted as a SQL snippet

copy

public BooleanExpression.LocalDateTimeIfThenElseExpression 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 DBExpression

Specified by:

copy in interface LocalDateTimeResult

Overrides:

copy in class LocalDateTimeExpression

Returns:

a copy of this DBValue