Package nz.co.gregs.dbvolution.results

Interface EqualComparable<B,A extends DBExpression>

Type Parameters:

B - the base Java type produced and manipulated by this class

A - the class that can be compared using the "=" operator

All Superinterfaces:

AnyComparable<B,A>, DBExpression, ExpressionCanHaveNullValues, HasSQLString

All Known Subinterfaces:

InComparable<B,A>, RangeComparable<B,A>, Spatial2DComparable<B,A>

All Known Implementing Classes:

AnyExpression.CountAllExpression, AnyExpression.CountDistinctExpression, AnyExpression.CountExpression, AnyExpression.NTileExpression, AnyExpression.PercentageExpression, AnyExpression.RankExpression, BooleanArrayColumn, BooleanArrayExpression, BooleanColumn, 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, CaseExpression.BooleanExpressionNonStatement, DateColumn, DateExpression, DateExpression.DateAddDaysExpression, DateExpression.DateAddIntegerDaysExpression, DateExpression.DateAddIntegerHoursExpression, DateExpression.DateAddIntegerMinutesExpression, DateExpression.DateAddIntegerMonthsExpression, DateExpression.DateAddIntegerSecondsExpression, DateExpression.DateAddIntegerWeeksExpression, DateExpression.DateAddIntegerYearsExpression, DateExpression.DateAddMonthsExpression, DateExpression.DateAddSecondsExpression, DateExpression.DateCurrentDateExpression, DateExpression.DateCurrentTimeExpression, DateExpression.DateDayExpression, DateExpression.DateDayOfWeekExpression, DateExpression.DateDaysFromExpression, DateExpression.DateEndOfMonthExpression, DateExpression.DateGetDateRepeatFromExpression, DateExpression.DateGetDurationFromExpression, DateExpression.DateGreatestOfExpression, DateExpression.DateHourExpression, DateExpression.DateHoursFromExpression, DateExpression.DateIfDBNullExpression, DateExpression.DateIsExpression, DateExpression.DateIsGreaterThanExpression, DateExpression.DateIsGreaterThanOrEqualExpression, DateExpression.DateIsInExpression, DateExpression.DateIsLessThanExpression, DateExpression.DateIsLessThanOrEqualExpression, DateExpression.DateIsNotExpression, DateExpression.DateIsNotInExpression, DateExpression.DateLeastOfExpression, DateExpression.DateMaxExpression, DateExpression.DateMinExpression, DateExpression.DateMinusDateRepeatExpression, DateExpression.DateMinusDurationExpression, DateExpression.DateMinuteExpression, DateExpression.DateMinutesFromExpression, DateExpression.DateMonthExpression, DateExpression.DateMonthsFromExpression, DateExpression.DateOnlyCurrentDateExpression, DateExpression.DatePlusDateRepeatExpression, DateExpression.DatePlusDurationExpression, DateExpression.DateSecondAndSubsecondExpression, DateExpression.DateSecondExpression, DateExpression.DateSecondsFromExpression, DateExpression.DateSubsecondExpression, DateExpression.DateWeeksFromExpression, DateExpression.DateYearExpression, DateExpression.DateYearsFromExpression, DateExpression.FirstValueExpression, DateExpression.LastValueExpression, DateExpression.NthValueExpression, DateRepeatColumn, DateRepeatExpression, DateRepeatExpression.Comparison, DateRepeatExpression.FirstValueExpression, DateRepeatExpression.GetYearsExpression, DateRepeatExpression.IsExpression, DateRepeatExpression.IsGreaterThanOrEqualExpression, DateRepeatExpression.LagExpression, DateRepeatExpression.LastValueExpression, DateRepeatExpression.LeadExpression, DateRepeatExpression.NthValueExpression, DurationColumn, DurationExpression, DurationExpression.FirstValueExpression, DurationExpression.IsExpression, DurationExpression.IsGreaterThanOrEqualExpression, DurationExpression.LagExpression, DurationExpression.LastValueExpression, DurationExpression.LeadExpression, DurationExpression.NthValueExpression, EqualExpression, EqualExpression.DBUnaryFunction, EqualExpression.ModeSimpleExpression, EqualExpression.ModeStrictExpression, ExistsExpression, InExpression, InstantColumn, InstantExpression, InstantExpression.AddDaysExpression, InstantExpression.AddIntegerDaysExpression, InstantExpression.AddIntegerHoursExpression, InstantExpression.AddIntegerMinutesExpression, InstantExpression.AddIntegerMonthsExpression, InstantExpression.AddIntegerSecondsExpression, InstantExpression.AddIntegerWeeksExpression, InstantExpression.AddIntegerYearsExpression, InstantExpression.AddMonthsExpression, InstantExpression.AddSecondsExpression, InstantExpression.CurrentInstantDateOnlyExpression, InstantExpression.CurrentInstantExpression, InstantExpression.CurrentTimeExpression, InstantExpression.DayOfWeekExpression, InstantExpression.DaysFromExpression, InstantExpression.EndOfMonthExpression, InstantExpression.FirstValueExpression, InstantExpression.GreatestOfExpression, InstantExpression.HoursFromExpression, InstantExpression.InstantDayExpression, InstantExpression.InstantGetDateRepeatFromExpression, InstantExpression.InstantHourExpression, InstantExpression.InstantIfDBNullExpression, InstantExpression.InstantInstantIsGreaterThanOrEqualExpression, InstantExpression.InstantIsExpression, InstantExpression.InstantIsGreaterThanExpression, InstantExpression.InstantIsInExpression, InstantExpression.InstantIsLessThanExpression, InstantExpression.InstantIsLessThanOrEqualExpression, InstantExpression.InstantIsNotExpression, InstantExpression.InstantIsNotInExpression, InstantExpression.InstantMaxExpression, InstantExpression.InstantMinExpression, InstantExpression.InstantMinusDateRepeatExpression, InstantExpression.InstantMinuteExpression, InstantExpression.InstantMonthExpression, InstantExpression.InstantPlusDateRepeatExpression, InstantExpression.InstantSecondAndSubsecondExpression, InstantExpression.InstantSecondExpression, InstantExpression.InstantSubsecondExpression, InstantExpression.InstantYearExpression, InstantExpression.LagExpression, InstantExpression.LastValueExpression, InstantExpression.LeadExpression, InstantExpression.LeastOfExpression, InstantExpression.MinutesFromExpression, InstantExpression.MonthsFromExpression, InstantExpression.NthValueExpression, InstantExpression.SecondsFromExpression, InstantExpression.WeeksFromExpression, InstantExpression.YearsFromExpression, IntegerColumn, IntegerExpression, IntegerExpression.FirstValueExpression, IntegerExpression.LagExpression, IntegerExpression.LastValueExpression, IntegerExpression.LeadExpression, IntegerExpression.MaxUnaryFunction, IntegerExpression.MinUnaryFunction, IntegerExpression.NthValueExpression, IntegerExpression.SinhFunction, IntegerExpression.SumFunction, Line2DColumn, Line2DExpression, Line2DExpression.BoundingBoxExpression, Line2DExpression.HasMagnitudeExpression, Line2DExpression.IntersectionPointsExpression, Line2DExpression.IntersectionWithExpression, Line2DExpression.IntersectsExpression, Line2DExpression.IsExpression, Line2DExpression.IsNotExpression, Line2DExpression.MagnitudeExpression, Line2DExpression.MaxXExpression, Line2DExpression.MaxYExpression, Line2DExpression.MeasurableDimensionsExpression, Line2DExpression.MinXExpression, Line2DExpression.MinYExpression, Line2DExpression.SpatialDimensionsExpression, Line2DExpression.StringResultExpression, LineSegment2DColumn, LineSegment2DExpression, LineSegment2DExpression.BoundingBoxExpression, LineSegment2DExpression.HasMagnitudeExpression, LineSegment2DExpression.IntersectionWithExpression, LineSegment2DExpression.IntersectsExpression, LineSegment2DExpression.IsExpression, LineSegment2DExpression.MagnitudeExpression, LineSegment2DExpression.MaxXExpression, LineSegment2DExpression.MaxYExpression, LineSegment2DExpression.MeasurableDimensionsExpression, LineSegment2DExpression.MinXExpression, LineSegment2DExpression.MinYExpression, LineSegment2DExpression.SpatialDimensionsExpression, LocalDateColumn, LocalDateExpression, LocalDateExpression.DateAddDaysExpression, LocalDateExpression.DateAddIntegerDaysExpression, LocalDateExpression.DateAddIntegerHoursExpression, LocalDateExpression.DateAddIntegerMinutesExpression, LocalDateExpression.DateAddIntegerMonthsExpression, LocalDateExpression.DateAddIntegerSecondsExpression, LocalDateExpression.DateAddIntegerWeeksExpression, LocalDateExpression.DateAddIntegerYearsExpression, LocalDateExpression.DateAddMonthsExpression, LocalDateExpression.DateAddSecondsExpression, LocalDateExpression.DateCurrentDateExpression, LocalDateExpression.DateCurrentTimeExpression, LocalDateExpression.DateDayExpression, LocalDateExpression.DateDayOfWeekExpression, LocalDateExpression.DateDaysFromExpression, LocalDateExpression.DateEndOfMonthExpression, LocalDateExpression.DateGetDateRepeatFromExpression, LocalDateExpression.DateGreatestOfExpression, LocalDateExpression.DateHourExpression, LocalDateExpression.DateHoursFromExpression, LocalDateExpression.DateIfDBNullExpression, LocalDateExpression.DateIsExpression, LocalDateExpression.DateIsGreaterThanExpression, LocalDateExpression.DateIsGreaterThanOrEqualExpression, LocalDateExpression.DateIsInExpression, LocalDateExpression.DateIsLessThanExpression, LocalDateExpression.DateIsLessThanOrEqualExpression, LocalDateExpression.DateIsNotExpression, LocalDateExpression.DateIsNotInExpression, LocalDateExpression.DateLeastOfExpression, LocalDateExpression.DateMaxExpression, LocalDateExpression.DateMinExpression, LocalDateExpression.DateMinusDateRepeatExpression, LocalDateExpression.DateMinuteExpression, LocalDateExpression.DateMinutesFromExpression, LocalDateExpression.DateMonthExpression, LocalDateExpression.DateMonthsFromExpression, LocalDateExpression.DateOnlyCurrentDateExpression, LocalDateExpression.DatePlusDateRepeatExpression, LocalDateExpression.DateSecondExpression, LocalDateExpression.DateSecondsFromExpression, LocalDateExpression.DateSubsecondExpression, LocalDateExpression.DateWeeksFromExpression, LocalDateExpression.DateYearExpression, LocalDateExpression.DateYearsFromExpression, LocalDateExpression.FirstValueExpression, LocalDateExpression.LagExpression, LocalDateExpression.LastValueExpression, LocalDateExpression.LeadExpression, LocalDateExpression.NthValueExpression, LocalDateTimeColumn, 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, MultiPoint2DColumn, MultiPoint2DExpression, NumberColumn, NumberExpression, NumberExpression.AbsoluteValueExpression, NumberExpression.AverageExpression, NumberExpression.ChooseFromStringsExpression, NumberExpression.CosineExpression, NumberExpression.CotangentExpression, NumberExpression.DegreesExpression, NumberExpression.DivideByExpression, NumberExpression.ExponentialExpression, NumberExpression.FirstValueExpression, NumberExpression.GreatestOfExpression, NumberExpression.HyperbolicCosineExpression, NumberExpression.HyperbolicSineExpression, NumberExpression.HyperbolicTangentExpression, NumberExpression.IfDBNullExpression, NumberExpression.IntegerResultExpression, NumberExpression.InverseCosineExpression, NumberExpression.InverseSineExpression, NumberExpression.InverseTangent2Expression, NumberExpression.InverseTangentExpression, NumberExpression.IsLessThanExpression, NumberExpression.LagExpression, NumberExpression.LastValueExpression, NumberExpression.LeadExpression, NumberExpression.LogBase10Expression, NumberExpression.MaxUnaryFunction, NumberExpression.MinUnaryFunction, NumberExpression.ModulusRemainderExpression, NumberExpression.NaturalLogExpression, NumberExpression.NthValueExpression, NumberExpression.PlusExpression, NumberExpression.PowerExpression, NumberExpression.RadiansExpression, NumberExpression.RandomNumberExpression, NumberExpression.RoundDownExpression, NumberExpression.RoundExpression, NumberExpression.RoundToNumberofDecimalPlaces, NumberExpression.RoundUpExpression, NumberExpression.SignExpression, NumberExpression.SineExpression, NumberExpression.SquareRootExpression, NumberExpression.StandardDeviationExpression, NumberExpression.SumExpression, NumberExpression.TangentExpression, NumberExpression.TimesExpression, NumberExpression.TruncateExpression, Point2DColumn, Point2DExpression, Point2DExpression.BoundingBoxExpression, Point2DExpression.DistanceToExpression, Point2DExpression.GetXExpression, Point2DExpression.GetYExpression, Point2DExpression.HasMagnitudeExpression, Point2DExpression.IsExpression, Point2DExpression.MagnitudeExpression, Point2DExpression.MeasurableDimensionsExpression, Point2DExpression.SpatialDimensionsExpression, Polygon2DColumn, Polygon2DExpression, RangeExpression, RangeExpression.MedianExpression, RangeExpression.UniqueRankingExpression, RecursiveQueryDepthIncreaseExpression, SimpleNumericExpression, Spatial2DExpression, StringColumn, StringExpression, StringExpression.DBBinaryStringFunction, StringExpression.FirstValueExpression, StringExpression.IntegerLengthExpression, StringExpression.LagExpression, StringExpression.LastValueExpression, StringExpression.LeadExpression, StringExpression.NthValueExpression, StringExpression.StringAggregateExpression, StringExpression.StringAggregateWithOrderByExpression, StringExpression.StringAppendExpression, StringExpression.StringBracketExpression, StringExpression.StringCurrentUserExpression, StringExpression.StringFirstIntegerAsSubstringExpression, StringExpression.StringFirstNumberAsSubstringExpression, StringExpression.StringIfDBNullExpression, StringExpression.StringIsExpression, StringExpression.StringIsGreaterThanExpression, StringExpression.StringIsGreaterThanOrEqualExpression, StringExpression.StringIsInExpression, StringExpression.StringIsLessThanExpression, StringExpression.StringIsLessThanOrEqualExpression, StringExpression.StringIsLikeExpression, StringExpression.StringIsNotExpression, StringExpression.StringIsNotInExpression, StringExpression.StringLeftTrimExpression, StringExpression.StringLocationOfExpression, StringExpression.StringLowercaseExpression, StringExpression.StringMaxExpression, StringExpression.StringMinExpression, StringExpression.StringNumberResultExpression, StringExpression.StringReplaceExpression, StringExpression.StringRightTrimExpression, StringExpression.StringSubstringAfterExpression, StringExpression.StringSubstringBeforeExpression, StringExpression.StringTrimExpression, StringExpression.StringUppercaseExpression, StringLiteral, UUIDColumn, UUIDExpression

public interface EqualComparable<B,A extends DBExpression>
extends AnyComparable<B,A>

Indicates that the class can be compared to other instances of this class as if the instances were equivalent.

EqualsComparable expressions must have an equivalent to the EQUALS (=) operation.

Support DBvolution at Patreon

Author:

Gregory Graham

Method Summary

Modifier and Type	Method	Description
BooleanExpression	is(A anotherInstance)	Creates a BooleanExpression that compares the 2 values using the EQUALS operation.
BooleanExpression	is(B anotherInstance)	Creates a BooleanExpression that compares the 2 values using the EQUALS operation.
BooleanExpression	isNot(A anotherInstance)	Creates a BooleanExpression that compares the 2 values using the NOT EQUALS operation.
BooleanExpression	isNot(B anotherInstance)	Creates a BooleanExpression that compares the 2 values using the NOT EQUALS operation.

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

isNotNull, isNull

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

copy, createSQLForFromClause, createSQLForGroupByClause, getQueryableDatatypeForExpressionValue, getTablesInvolved, isAggregator, isComplexExpression, isPurelyFunctional, isWindowingFunction

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

getIncludesNull

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

toSQLString

Method Detail

is

BooleanExpression is(A anotherInstance)

Creates a BooleanExpression that compares the 2 values using the EQUALS operation.

Parameters:

anotherInstance - an instance to compare to

Support DBvolution at Patreon

Returns:

a BooleanExpression

isNot

BooleanExpression isNot(A anotherInstance)

Creates a BooleanExpression that compares the 2 values using the NOT EQUALS operation.

Parameters:

anotherInstance - and instance to compare to

Support DBvolution at Patreon

Returns:

a BooleanExpression

is

BooleanExpression is(B anotherInstance)

Creates a BooleanExpression that compares the 2 values using the EQUALS operation.

Parameters:

anotherInstance - an instance to compare to

Support DBvolution at Patreon

Returns:

a BooleanExpression

isNot

BooleanExpression isNot(B anotherInstance)

Creates a BooleanExpression that compares the 2 values using the NOT EQUALS operation.

Parameters:

anotherInstance - and instance to compare to

Support DBvolution at Patreon

Returns:

a BooleanExpression