Module org.jooq

Package org.jooq

Interface Period<T>

All Superinterfaces:

Named, QueryPart, Serializable, Typed<T>

@Pro
public interface Period<T>
extends Named, Typed<T>

A period specification for usage in temporal tables.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull PeriodSpecification	all()	Create a period specification for all timestamps.
@NotNull PeriodSpecification	asOf(Field<T> field)	Create a period specification for a given timestamp.
@NotNull PeriodSpecification	asOf(T value)	Create a period specification for a given timestamp.
@NotNull PeriodSpecificationBetweenAndStep<T>	between(Field<T> start)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecification	between(Field<T> start, Field<T> end)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecificationBetweenAndStep<T>	between(T start)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecification	between(T start, T end)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecification	containedIn(Field<T> start, Field<T> end)	Create a period specification for a given timestamp range containing this period.
@NotNull PeriodSpecification	containedIn(T start, T end)	Create a period specification for a given timestamp range containing this period.
@NotNull PeriodSpecificationFromToStep<T>	from(Field<T> start)	Create a period specification for a given timestamp range overlapping with this period, excluding the end value.
@NotNull PeriodSpecificationFromToStep<T>	from(T start)	Create a period specification for a given timestamp range overlapping with this period, excluding the end value.
@Nullable Field<T>	getEnd()	The expression specifying the end of the period.
@Nullable Field<T>	getStart()	The expression specifying the start of the period.

Methods inherited from interface org.jooq.Named

getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Typed

getBinding, getConverter, getDataType, getDataType, getType

Method Details

getStart

@Nullable
@Nullable Field<T> getStart()

The expression specifying the start of the period.

getEnd

@Nullable
@Nullable Field<T> getEnd()

The expression specifying the end of the period.

asOf

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification asOf(T value)

Create a period specification for a given timestamp.

asOf

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification asOf(Field<T> field)

Create a period specification for a given timestamp.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecificationBetweenAndStep<T> between(T start)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecificationBetweenAndStep<T> between(Field<T> start)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification between(T start,
 T end)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification between(Field<T> start,
 Field<T> end)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

from

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,SQLSERVER2016})
@NotNull PeriodSpecificationFromToStep<T> from(T start)

Create a period specification for a given timestamp range overlapping with this period, excluding the end value.

from

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,SQLSERVER2016})
@NotNull PeriodSpecificationFromToStep<T> from(Field<T> start)

Create a period specification for a given timestamp range overlapping with this period, excluding the end value.

containedIn

@NotNull
@Support(SQLSERVER2016)
@NotNull PeriodSpecification containedIn(T start,
 T end)

Create a period specification for a given timestamp range containing this period.

containedIn

@NotNull
@Support(SQLSERVER2016)
@NotNull PeriodSpecification containedIn(Field<T> start,
 Field<T> end)

Create a period specification for a given timestamp range containing this period.

all

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification all()

Create a period specification for all timestamps.