org.jooq

Interface Sequence<T extends Number>

All Superinterfaces:

Named, QueryPart, Serializable, Typed<T>

All Known Implementing Classes:

SequenceImpl

public interface Sequence<T extends Number>
extends Named, Typed<T>

A sequence.

Instances can be created using DSL.sequence(Name) and overloads.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
Field<T>	currval() Get the current value of this sequence
Field<T>	getCache() Get the number of sequence values to cache for this sequence or null, if no such value is specified.
Catalog	getCatalog() Get the sequence catalog.
boolean	getCycle() Returns true if this sequence cycles to getMinvalue() when it reaches getMaxvalue().
Field<T>	getIncrementBy() Get the increment for this sequence or null, if no such value is specified.
Field<T>	getMaxvalue() Get the maximum value for this sequence or null, if no such value is specified.
Field<T>	getMinvalue() Get the minimum value for this sequence or null, if no such value is specified.
Schema	getSchema() Get the sequence schema.
Field<T>	getStartWith() Get the start value for this sequence or null, if no such value is specified.
Field<T>	nextval() Increment the sequence and get the next value

Methods inherited from interface org.jooq.Named

getComment, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.Typed

getBinding, getConverter, getDataType, getDataType, getType

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

getCatalog

Catalog getCatalog()

Get the sequence catalog.

getSchema

Schema getSchema()

Get the sequence schema.

getStartWith

Field<T> getStartWith()

Get the start value for this sequence or null, if no such value is specified.

getIncrementBy

Field<T> getIncrementBy()

Get the increment for this sequence or null, if no such value is specified.

getMinvalue

Field<T> getMinvalue()

Get the minimum value for this sequence or null, if no such value is specified.

getMaxvalue

Field<T> getMaxvalue()

Get the maximum value for this sequence or null, if no such value is specified.

getCycle

boolean getCycle()

Returns true if this sequence cycles to getMinvalue() when it reaches getMaxvalue().

getCache

Field<T> getCache()

Get the number of sequence values to cache for this sequence or null, if no such value is specified.

currval

@Support(value={CUBRID,FIREBIRD,H2,HSQLDB,MARIADB,POSTGRES})
Field<T> currval()

Get the current value of this sequence

nextval

@Support(value={CUBRID,DERBY,FIREBIRD,H2,HSQLDB,MARIADB,POSTGRES})
Field<T> nextval()

Increment the sequence and get the next value