Package de.jaggl.sqlbuilder.columns.datetime

Class DateTimeColumn

java.lang.Object

de.jaggl.sqlbuilder.columns.Column

de.jaggl.sqlbuilder.columns.datetime.DateTimeColumn

All Implemented Interfaces:

Aliasable, Definable, Groupable, Selectable, Valuable

public class DateTimeColumn
extends Column

Since:

2.0.0

Author:

Martin Schumacher

Field Summary

Fields inherited from class de.jaggl.sqlbuilder.columns.Column

columnDefinition, name, table

Constructor Summary

Constructors

Constructor	Description
DateTimeColumn(Table table, String name, String alias, ColumnDefinition columnDefinition)

Method Summary

Modifier and Type	Method	Description
DateTimeColumn	as(String alias)
GenericCondition	isAfter(Column otherColumn)
GenericCondition	isAfter(LocalDateTime value)
GenericCondition	isAfter(Date value)
GenericCondition	isAfterOrEqualTo(Column otherColumn)
GenericCondition	isAfterOrEqualTo(LocalDateTime value)
GenericCondition	isAfterOrEqualTo(Date value)
GenericCondition	isBefore(Column otherColumn)
GenericCondition	isBefore(LocalDateTime value)
GenericCondition	isBefore(Date value)
GenericCondition	isBeforeOrEqualTo(Column otherColumn)
GenericCondition	isBeforeOrEqualTo(LocalDateTime value)
GenericCondition	isBeforeOrEqualTo(Date value)
GenericCondition	isBetween(Column otherColumn1, Column otherColumn2)
GenericCondition	isBetween(Column otherColumn, LocalDateTime value)
GenericCondition	isBetween(Column otherColumn, Date value)
GenericCondition	isBetween(LocalDateTime value, Column otherColumn)
GenericCondition	isBetween(LocalDateTime value1, LocalDateTime value2)
GenericCondition	isBetween(LocalDateTime value1, Date value2)
GenericCondition	isBetween(Date value, Column otherColumn)
GenericCondition	isBetween(Date value1, LocalDateTime value2)
GenericCondition	isBetween(Date value1, Date value2)
GenericCondition	isEqualTo(LocalDateTime value)
GenericCondition	isEqualTo(Date value)
IsLike	isLike(Column otherColumn)
Condition	isLike(CharSequence value)
Condition	isLike(CharSequence value, LikeType likeType)
GenericCondition	isNotEqualTo(LocalDateTime value)
GenericCondition	isNotEqualTo(Date value)
Condition	isNotLike(Column otherColumn)
Condition	isNotLike(CharSequence value)
Condition	isNotLike(CharSequence value, LikeType likeType)

Methods inherited from class de.jaggl.sqlbuilder.columns.Column

getFullName, getFullNameOrAlias, getValue, isEqualTo, isNotEqualTo, isNotNull, isNull

Methods inherited from class java.lang.Object

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

Methods inherited from interface de.jaggl.sqlbuilder.domain.Aliasable

getAlias

Methods inherited from interface de.jaggl.sqlbuilder.domain.Definable

getColumnDefinition

Constructor Detail

DateTimeColumn

public DateTimeColumn(Table table,
                      String name,
                      String alias,
                      ColumnDefinition columnDefinition)

Method Detail

as

public DateTimeColumn as(String alias)

isEqualTo

public GenericCondition isEqualTo(LocalDateTime value)

isEqualTo

public GenericCondition isEqualTo(Date value)

isNotEqualTo

public GenericCondition isNotEqualTo(LocalDateTime value)

isNotEqualTo

public GenericCondition isNotEqualTo(Date value)

isAfter

public GenericCondition isAfter(LocalDateTime value)

isAfter

public GenericCondition isAfter(Date value)

isAfter

public GenericCondition isAfter(Column otherColumn)

isAfterOrEqualTo

public GenericCondition isAfterOrEqualTo(LocalDateTime value)

isAfterOrEqualTo

public GenericCondition isAfterOrEqualTo(Date value)

isAfterOrEqualTo

public GenericCondition isAfterOrEqualTo(Column otherColumn)

isBefore

public GenericCondition isBefore(LocalDateTime value)

isBefore

public GenericCondition isBefore(Date value)

isBefore

public GenericCondition isBefore(Column otherColumn)

isBeforeOrEqualTo

public GenericCondition isBeforeOrEqualTo(LocalDateTime value)

isBeforeOrEqualTo

public GenericCondition isBeforeOrEqualTo(Date value)

isBeforeOrEqualTo

public GenericCondition isBeforeOrEqualTo(Column otherColumn)

isLike

public Condition isLike(CharSequence value)

isLike

public Condition isLike(CharSequence value,
                        LikeType likeType)

isLike

public IsLike isLike(Column otherColumn)

isNotLike

public Condition isNotLike(CharSequence value)

isNotLike

public Condition isNotLike(CharSequence value,
                           LikeType likeType)

isNotLike

public Condition isNotLike(Column otherColumn)

isBetween

public GenericCondition isBetween(LocalDateTime value1,
                                  LocalDateTime value2)

isBetween

public GenericCondition isBetween(Date value1,
                                  Date value2)

isBetween

public GenericCondition isBetween(LocalDateTime value1,
                                  Date value2)

isBetween

public GenericCondition isBetween(Date value1,
                                  LocalDateTime value2)

isBetween

public GenericCondition isBetween(Column otherColumn1,
                                  Column otherColumn2)

isBetween

public GenericCondition isBetween(LocalDateTime value,
                                  Column otherColumn)

isBetween

public GenericCondition isBetween(Date value,
                                  Column otherColumn)

isBetween

public GenericCondition isBetween(Column otherColumn,
                                  LocalDateTime value)

isBetween

public GenericCondition isBetween(Column otherColumn,
                                  Date value)