Package de.jaggl.sqlbuilder.columns.datetime

Class DateColumn

java.lang.Object

de.jaggl.sqlbuilder.columns.Column

de.jaggl.sqlbuilder.columns.datetime.DateColumn

All Implemented Interfaces:

Aliasable, Definable, Groupable, Selectable, Valuable

public class DateColumn
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
DateColumn(Table table, String name, String alias, ColumnDefinition columnDefinition)

Method Summary

Modifier and Type	Method	Description
DateColumn	as(String alias)
Condition	isAfter(Column otherColumn)
Condition	isAfter(LocalDate value)
Condition	isAfter(Date value)
Condition	isAfterOrEqualTo(Column otherColumn)
Condition	isAfterOrEqualTo(LocalDate value)
Condition	isAfterOrEqualTo(Date value)
Condition	isBefore(Column otherColumn)
Condition	isBefore(LocalDate value)
Condition	isBefore(Date value)
Condition	isBeforeOrEqualTo(Column otherColumn)
Condition	isBeforeOrEqualTo(LocalDate value)
Condition	isBeforeOrEqualTo(Date value)
Condition	isBetween(Column otherColumn1, Column otherColumn2)
Condition	isBetween(Column otherColumn, LocalDate value)
Condition	isBetween(Column otherColumn, Date value)
Condition	isBetween(LocalDate value, Column otherColumn)
Condition	isBetween(LocalDate value1, LocalDate value2)
Condition	isBetween(LocalDate value1, Date value2)
Condition	isBetween(Date value, Column otherColumn)
Condition	isBetween(Date value1, LocalDate value2)
Condition	isBetween(Date value1, Date value2)
Condition	isEqualTo(LocalDate value)
Condition	isEqualTo(Date value)
Condition	isLike(Column otherColumn)
Condition	isLike(CharSequence value)
Condition	isLike(CharSequence value, LikeType likeType)
Condition	isNotEqualTo(LocalDate value)
Condition	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

DateColumn

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

Method Detail

as

public DateColumn as(String alias)

isEqualTo

public Condition isEqualTo(LocalDate value)

isEqualTo

public Condition isEqualTo(Date value)

isNotEqualTo

public Condition isNotEqualTo(LocalDate value)

isNotEqualTo

public Condition isNotEqualTo(Date value)

isAfter

public Condition isAfter(LocalDate value)

isAfter

public Condition isAfter(Date value)

isAfter

public Condition isAfter(Column otherColumn)

isAfterOrEqualTo

public Condition isAfterOrEqualTo(LocalDate value)

isAfterOrEqualTo

public Condition isAfterOrEqualTo(Date value)

isAfterOrEqualTo

public Condition isAfterOrEqualTo(Column otherColumn)

isBefore

public Condition isBefore(LocalDate value)

isBefore

public Condition isBefore(Date value)

isBefore

public Condition isBefore(Column otherColumn)

isBeforeOrEqualTo

public Condition isBeforeOrEqualTo(LocalDate value)

isBeforeOrEqualTo

public Condition isBeforeOrEqualTo(Date value)

isBeforeOrEqualTo

public Condition isBeforeOrEqualTo(Column otherColumn)

isLike

public Condition isLike(CharSequence value)

isLike

public Condition isLike(CharSequence value,
                        LikeType likeType)

isLike

public Condition 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 Condition isBetween(LocalDate value1,
                           LocalDate value2)

isBetween

public Condition isBetween(Date value1,
                           Date value2)

isBetween

public Condition isBetween(LocalDate value1,
                           Date value2)

isBetween

public Condition isBetween(Date value1,
                           LocalDate value2)

isBetween

public Condition isBetween(Column otherColumn1,
                           Column otherColumn2)

isBetween

public Condition isBetween(LocalDate value,
                           Column otherColumn)

isBetween

public Condition isBetween(Date value,
                           Column otherColumn)

isBetween

public Condition isBetween(Column otherColumn,
                           LocalDate value)

isBetween

public Condition isBetween(Column otherColumn,
                           Date value)