Package nz.co.gregs.dbvolution.expressions

Class BooleanExpression.IsNotNullExpression

java.lang.Object

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

nz.co.gregs.dbvolution.expressions.EqualExpression<Boolean,BooleanResult,DBBoolean>

nz.co.gregs.dbvolution.expressions.BooleanExpression

nz.co.gregs.dbvolution.expressions.BooleanExpression.IsNotNullExpression

All Implemented Interfaces:

Serializable, DBExpression, ExpressionColumn<DBBoolean>, HasSQLString, AnyComparable<Boolean,BooleanResult>, AnyResult<Boolean>, BooleanResult, EqualComparable<Boolean,BooleanResult>, EqualResult<Boolean>, ExpressionCanHaveNullValues, ExpressionHasStandardStringResult, NullCapableResult<Boolean>

Enclosing class:

BooleanExpression

protected static class BooleanExpression.IsNotNullExpression
extends BooleanExpression

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

BooleanExpression.AllOfExpression, BooleanExpression.AnyOfExpression, BooleanExpression.BooleanIfThenElseExpression, BooleanExpression.DateIfThenElseExpression, BooleanExpression.FirstValueExpression, BooleanExpression.InstantIfThenElseExpression, BooleanExpression.IntegerIfThenElseExpression, BooleanExpression.IsExpression, BooleanExpression.IsNotExpression, BooleanExpression.IsNotNullExpression, BooleanExpression.IsNotNullStringExpression, BooleanExpression.IsNullExpression, BooleanExpression.IsNullStringExpression, BooleanExpression.LagExpression, BooleanExpression.LastValueExpression, BooleanExpression.LeadExpression, BooleanExpression.LocalDateIfThenElseExpression, BooleanExpression.LocalDateTimeIfThenElseExpression, BooleanExpression.NegateExpression, BooleanExpression.NthValueExpression, BooleanExpression.NumberIfThenElseExpression, BooleanExpression.Polygon2DIfThenElseExpression, BooleanExpression.StringIfThenElseExpression, BooleanExpression.XorExpression

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

Constructor Summary

Constructors

Constructor	Description
IsNotNullExpression(DBExpression bool)

Method Summary

Modifier and Type	Method	Description
BooleanExpression.IsNotNullExpression	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, createSQLForFromClause, createSQLForGroupByClause, denseRank, descending, getInnerResult, getTablesInvolved, highestFirst, highestLast, isAggregator, isComplexExpression, isNullSafetyTerminator, isPurelyFunctional, 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 class nz.co.gregs.dbvolution.expressions.BooleanExpression

allOf, and, anyOf, asExpressionColumn, countNotNull, expression, expression, expression, falseExpression, firstValue, getComparableBooleanSQL, getComparableBooleanSQL, getQueryableDatatypeForExpressionValue, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifThenElse, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, ifTrueFalseNull, integerValue, is, is, is, isBooleanStatement, isFalse, isNot, isNot, isNotNull, isNotNull, isNotNull, isNotNull, isNull, isNull, isNull, isNull, isRelationship, isTrue, lag, lag, lag, lastValue, lead, lead, lead, modeSimple, modeStrict, negate, nextRowValue, noneOf, not, notAllOf, nthValue, nullExpression, numberValue, or, previousRowValue, seekGreaterThan, seekGreaterThan, seekGreaterThan, seekGreaterThan, seekLessThan, seekLessThan, seekLessThan, seekLessThan, someButNotAllOf, stringResult, trueExpression, xor

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

createSQLForFromClause, createSQLForGroupByClause, getTablesInvolved, isAggregator, isComplexExpression, isPurelyFunctional, 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 class java.lang.Object

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

Constructor Detail

IsNotNullExpression

public IsNotNullExpression(DBExpression bool)

Method Detail

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

Overrides:

toSQLString in class AnyExpression<Boolean,BooleanResult,DBBoolean>

Parameters:

db - the target database

Support DBvolution at Patreon

Returns:

the DBValue formatted as a SQL snippet

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<Boolean,BooleanResult,DBBoolean>

Returns:

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

copy

public BooleanExpression.IsNotNullExpression 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 BooleanResult

Specified by:

copy in interface DBExpression

Overrides:

copy in class BooleanExpression

Returns:

a copy of this DBValue