Top Description Inners Fields Constructors Methods
org.jooq.impl

public Class SequenceImpl<T extends java.lang.Number>

extends AbstractTypedNamed<T extends Number>
implements Sequence<T extends Number>, UNotYetImplemented
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UNotYetImplemented, org.jooq.impl.QOM.UEmpty, org.jooq.QueryPart, java.io.Serializable, org.jooq.Sequence, org.jooq.Typed, org.jooq.Qualified, org.jooq.Named
Known Direct Subclasses
org.jooq.impl.InformationSchemaMetaImpl.InformationSchemaSequence, org.jooq.impl.Interpreter.MutableSequence.InterpretedSequence, org.jooq.impl.Snapshot.SnapshotSequence
Annotations
@Internal
Static Imports
org.jooq.Clause.SEQUENCE, .Clause.SEQUENCE_REFERENCE, .SQLDialect.CUBRID, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.MARIADB, org.jooq.impl.DSL.generateSeries, .DSL.select, .DefaultMetaProvider.meta, .Keywords.K_CURRENT_VALUE_FOR, .Keywords.K_CURRVAL, .Keywords.K_NEXTVAL, .Keywords.K_NEXT_VALUE_FOR, .Keywords.K_PREVIOUS_VALUE_FOR, .Names.N_CURRVAL, .Names.N_GENERATE_SERIES, .Names.N_GEN_ID, .Names.N_NEXTVAL, .Tools.getMappedSchema

Deprecated

as a consequence of QOM.UNotYetImplemented being deprecated. See corresponding docs for further information.

A common base class for sequences

This type is for JOOQ INTERNAL USE only. Do not reference directly

Author
Lukas Eder

Nested and Inner Type Summary

Modifier and TypeClass and Description
private static class
SequenceImpl.SequenceFunction<T extends Number>

Deprecated as a consequence of AbstractField and QOM.UNotYetImplemented being deprecated.
private static enum
SequenceImpl.SequenceMethod

Field Summary

Modifier and TypeField and Description
private final Field<T>
cache

Deprecated as a consequence of Field being deprecated.
private static final Clause[]
CLAUSES

Deprecated as a consequence of Clause being deprecated.
private final SequenceImpl.SequenceFunction<T>
currval

Deprecated as a consequence of SequenceImpl.SequenceFunction being deprecated.
private final boolean
cycle

private final Field<T>
incrementBy

Deprecated as a consequence of Field being deprecated.
private final Field<T>
maxvalue

Deprecated as a consequence of Field being deprecated.
private final Field<T>
minvalue

Deprecated as a consequence of Field being deprecated.
private final boolean
nameIsPlainSQL

private final SequenceImpl.SequenceFunction<T>
nextval

Deprecated as a consequence of SequenceImpl.SequenceFunction being deprecated.
private final Schema
schema

private final Field<T>
startWith

Deprecated as a consequence of Field being deprecated.

Constructor Summary

AccessConstructor and Description
public
SequenceImpl(String name, Schema schema, DataType<T> type)

Deprecated
pack-priv
SequenceImpl(String name, Schema schema, DataType<T> type, boolean nameIsPlainSQL)

pack-priv
SequenceImpl(Name name, Schema schema, DataType<T> type, boolean nameIsPlainSQL)

pack-priv
SequenceImpl(Name name, Schema schema, DataType<T> type, boolean nameIsPlainSQL, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, Field<T> maxvalue, boolean cycle, Field<T> cache)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final Schema
$schema()

Implements org.jooq.Qualified.$schema.

Experimental query object model accessor method, see also QOM.
public final void
accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
public final Clause[]
clauses(Context<?> ctx)

Overrides org.jooq.impl.AbstractQueryPart.clauses.

Implements org.jooq.QueryPartInternal.clauses.

Deprecated as a consequence of Clause being deprecated.
The Clauses that are represented by this query part.
public final Field<T>
currval()

Implements org.jooq.Sequence.currval.

Deprecated as a consequence of Field being deprecated.
An expression to get the current value of this sequence.
public boolean
equals(Object
The other QueryPart
that)

Overrides org.jooq.impl.AbstractNamed.equals.

Implements org.jooq.QueryPart.equals.

Check whether this QueryPart can be considered equal to another QueryPart.
public final Field<T>
getCache()

Implements org.jooq.Sequence.getCache.

Deprecated as a consequence of Field being deprecated.
Get the number of sequence values to cache for this sequence or null, if no such value is specified.
public final Catalog
getCatalog()

Implements org.jooq.Qualified.getCatalog.

Get the object's catalog.
public final boolean
getCycle()

Implements org.jooq.Sequence.getCycle.

Returns true if this sequence cycles to getMinvalue() when it reaches getMaxvalue().
public final Field<T>
getIncrementBy()

Implements org.jooq.Sequence.getIncrementBy.

Deprecated as a consequence of Field being deprecated.
Get the increment for this sequence or null, if no such value is specified.
public final Field<T>
getMaxvalue()

Implements org.jooq.Sequence.getMaxvalue.

Deprecated as a consequence of Field being deprecated.
Get the maximum value for this sequence or null, if no such value is specified.
public final Field<T>
getMinvalue()

Implements org.jooq.Sequence.getMinvalue.

Deprecated as a consequence of Field being deprecated.
Get the minimum value for this sequence or null, if no such value is specified.
public final Schema
getSchema()

Implements org.jooq.Qualified.getSchema.

Get the object's schema.
public final Field<T>
getStartWith()

Implements org.jooq.Sequence.getStartWith.

Deprecated as a consequence of Field being deprecated.
Get the start value for this sequence or null, if no such value is specified.
public final Field<T>
nextval()

Implements org.jooq.Sequence.nextval.

Deprecated as a consequence of Field being deprecated.
An expression to increment the sequence and get the next value.
public final Select<Record1<T>>
nextvals(int size)

Implements org.jooq.Sequence.nextvals.

An expression to increment the sequence and get the next values.
Inherited from org.jooq.impl.AbstractTypedNamed:
$dataTypegetBindinggetConvertergetDataTypegetDataTypegetExpressionDataTypegetType

Field Detail

cacheback to summary
private final Field<T> cache

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

CLAUSESback to summary
private static final Clause[] CLAUSES

Deprecated

as a consequence of Clause being deprecated. See corresponding docs for further information.

currvalback to summary
private final SequenceImpl.SequenceFunction<T> currval

Deprecated

as a consequence of SequenceImpl.SequenceFunction being deprecated. See corresponding docs for further information.

cycleback to summary
private final boolean cycle
incrementByback to summary
private final Field<T> incrementBy

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

maxvalueback to summary
private final Field<T> maxvalue

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

minvalueback to summary
private final Field<T> minvalue

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

nameIsPlainSQLback to summary
private final boolean nameIsPlainSQL
nextvalback to summary
private final SequenceImpl.SequenceFunction<T> nextval

Deprecated

as a consequence of SequenceImpl.SequenceFunction being deprecated. See corresponding docs for further information.

schemaback to summary
private final Schema schema
startWithback to summary
private final Field<T> startWith

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Constructor Detail

SequenceImplback to summary
public SequenceImpl(String name, Schema schema, DataType<T> type)

Deprecated

Annotations
@Deprecated
SequenceImplback to summary
pack-priv SequenceImpl(String name, Schema schema, DataType<T> type, boolean nameIsPlainSQL)
SequenceImplback to summary
pack-priv SequenceImpl(Name name, Schema schema, DataType<T> type, boolean nameIsPlainSQL)
SequenceImplback to summary
pack-priv SequenceImpl(Name name, Schema schema, DataType<T> type, boolean nameIsPlainSQL, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, Field<T> maxvalue, boolean cycle, Field<T> cache)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Method Detail

$schemaback to summary
public final Schema $schema()

Implements org.jooq.Qualified.$schema.

Doc from org.jooq.Qualified.$schema.

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations
@Override
acceptback to summary
public final void accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override
clausesback to summary
public final Clause[] clauses(Context<?> ctx)

Overrides org.jooq.impl.AbstractQueryPart.clauses.

Implements org.jooq.QueryPartInternal.clauses.

Doc from org.jooq.QueryPartInternal.clauses.

Deprecated

as a consequence of Clause being deprecated. See corresponding docs for further information.

The Clauses that are represented by this query part.

QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context#visit(QueryPart)

This method is for JOOQ INTERNAL USE only. Do not reference directly

Returns:Clause[]

The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.

Annotations
@Override
currvalback to summary
public final Field<T> currval()

Implements org.jooq.Sequence.currval.

Doc from org.jooq.Sequence.currval.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

An expression to get the current value of this sequence.

Annotations
@Override
equalsback to summary
public boolean equals(Object that)

Overrides org.jooq.impl.AbstractNamed.equals.

Implements org.jooq.QueryPart.equals.

Doc from org.jooq.QueryPart.equals.

Check whether this QueryPart can be considered equal to another QueryPart.

In general, QueryPart equality is defined in terms of toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.

Some QueryPart implementations may choose to override this behaviour for improved performance, as toString() is an expensive operation, if called many times.

Parameters
that:Object

The other QueryPart

Returns:boolean

Whether the two query parts are equal

Annotations
@Override
getCacheback to summary
public final Field<T> getCache()

Implements org.jooq.Sequence.getCache.

Doc from org.jooq.Sequence.getCache.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

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

Annotations
@Override
getCatalogback to summary
public final Catalog getCatalog()

Implements org.jooq.Qualified.getCatalog.

Doc from org.jooq.Qualified.getCatalog.

Get the object's catalog.

Annotations
@Override
getCycleback to summary
public final boolean getCycle()

Implements org.jooq.Sequence.getCycle.

Doc from org.jooq.Sequence.getCycle.

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

Annotations
@Override
getIncrementByback to summary
public final Field<T> getIncrementBy()

Implements org.jooq.Sequence.getIncrementBy.

Doc from org.jooq.Sequence.getIncrementBy.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

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

Annotations
@Override
getMaxvalueback to summary
public final Field<T> getMaxvalue()

Implements org.jooq.Sequence.getMaxvalue.

Doc from org.jooq.Sequence.getMaxvalue.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

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

Annotations
@Override
getMinvalueback to summary
public final Field<T> getMinvalue()

Implements org.jooq.Sequence.getMinvalue.

Doc from org.jooq.Sequence.getMinvalue.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

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

Annotations
@Override
getSchemaback to summary
public final Schema getSchema()

Implements org.jooq.Qualified.getSchema.

Doc from org.jooq.Qualified.getSchema.

Get the object's schema.

Annotations
@Override
getStartWithback to summary
public final Field<T> getStartWith()

Implements org.jooq.Sequence.getStartWith.

Doc from org.jooq.Sequence.getStartWith.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

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

Annotations
@Override
nextvalback to summary
public final Field<T> nextval()

Implements org.jooq.Sequence.nextval.

Doc from org.jooq.Sequence.nextval.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

An expression to increment the sequence and get the next value.

Annotations
@Override
nextvalsback to summary
public final Select<Record1<T>> nextvals(int size)

Implements org.jooq.Sequence.nextvals.

Doc from org.jooq.Sequence.nextvals.

An expression to increment the sequence and get the next values.

This is done using DSL#generateSeries(int, int).

Annotations
@Override
org.jooq.impl back to summary

private Class SequenceImpl.SequenceFunction<T extends java.lang.Number>

extends AbstractField<T extends Number>
implements UNotYetImplemented
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UNotYetImplemented, org.jooq.impl.QOM.UEmpty, org.jooq.QueryPart, java.io.Serializable

Deprecated

as a consequence of AbstractField and QOM.UNotYetImplemented being deprecated. See corresponding docs for further information.

Field Summary

Modifier and TypeField and Description
private final SequenceImpl.SequenceMethod
method

private final SequenceImpl<T>
sequence

Deprecated as a consequence of SequenceImpl being deprecated.

Constructor Summary

AccessConstructor and Description
pack-priv
SequenceFunction(SequenceImpl.SequenceMethod method, SequenceImpl<T> sequence)

Deprecated as a consequence of SequenceImpl being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final void
accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
public boolean
equals(Object
The other QueryPart
that)

Overrides org.jooq.impl.AbstractNamed.equals.

Implements org.jooq.QueryPart.equals, org.jooq.Field.equals.

Check whether this QueryPart can be considered equal to another QueryPart.
Inherited from org.jooq.impl.AbstractField:
$alias$aliasedabsacosaddaddasasasasascasciiasinatanatan2atan2avgavgOverbetweenbetweenbetweenbetweenbetweenSymmetricbetweenSymmetricbetweenSymmetricbetweenSymmetricbitAndbitAndbitLengthbitNandbitNandbitNorbitNorbitNotbitOrbitOrbitXNorbitXNorbitXorbitXorcastcastcastceilchangedcharLengthclausescoalescecoalescecoercecoercecoercecollatecollatecollatecommentcommentcomparecomparecomparecompareconcatconcatconcatcontainscontainscontainsIgnoreCasecontainsIgnoreCaseconvertconvertconvertconvertFromconvertFromconvertToconvertTocoscoshcotcothcountcountDistinctcountOverdecodedecodedecodedecodedegdescdivdivdividedivideendsWithendsWithendsWithIgnoreCaseendsWithIgnoreCaseeqeqeqeqequalequalequalequalequalIgnoreCaseequalIgnoreCaseexpextractfieldfirstValuefloorfromgegegegegetgetValuegreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterThangreaterThangreaterThangreaterThangreatestgreatestgtgtgtgtinininininisDistinctFromisDistinctFromisDistinctFromisDocumentisFalseisJsonisNotDistinctFromisNotDistinctFromisNotDistinctFromisNotDocumentisNotJsonisNotNullisNullisNullableisPossiblyNullableisTruelaglaglaglaglastValueleleleleleadleadleadleadleastleastlengthlessOrEquallessOrEquallessOrEquallessOrEquallessThanlessThanlessThanlessThanlikelikelikelikelikelikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeRegexlikeRegexlnloglowerlpadlpadlpadlpadltltltltltrimmaxmaxOvermedianminminOverminusminusmodmodmodulomodulomulmulmultiplymultiplynenenenenegnotBetweennotBetweennotBetweennotBetweennotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotContainsnotContainsnotContainsIgnoreCasenotContainsIgnoreCasenotEqualnotEqualnotEqualnotEqualnotEqualIgnoreCasenotEqualIgnoreCasenotInnotInnotInnotInnotInnotLikenotLikenotLikenotLikenotLikenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeRegexnotLikeRegexnotSimilarTonotSimilarTonotSimilarTonotSimilarTonotSimilarTonullifnullifnullsFirstnullsLastnvlnvlnvl2nvl2octetLengthoriginalparenthesisedpluspluspositionpositionpowpowpowerpowerprojectionSizeradremremrepeatrepeatreplacereplacereplacereplaceresetroundroundrpadrpadrpadrpadrtrimshlshlshrshrsignsimilarTosimilarTosimilarTosimilarTosimilarTosinsinhsortsortsortAscsortAscsortDefaultsortDescsortDescsqrtstartsWithstartsWithstartsWithIgnoreCasestartsWithIgnoreCasestddevPopstddevPopOverstddevSampstddevSampOversubsubsubstringsubstringsubstringsubstringsubtractsubtractsumsumOvertantanhtimestimestrimunaryMinusunaryPlusuppervarPopvarPopOvervarSampvarSampOver

Field Detail

methodback to summary
private final SequenceImpl.SequenceMethod method
sequenceback to summary
private final SequenceImpl<T> sequence

Deprecated

as a consequence of SequenceImpl being deprecated. See corresponding docs for further information.

Constructor Detail

SequenceFunctionback to summary
pack-priv SequenceFunction(SequenceImpl.SequenceMethod method, SequenceImpl<T> sequence)

Deprecated

as a consequence of SequenceImpl being deprecated. See corresponding docs for further information.

Method Detail

acceptback to summary
public final void accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override
equalsback to summary
public boolean equals(Object that)

Overrides org.jooq.impl.AbstractNamed.equals.

Implements org.jooq.QueryPart.equals, org.jooq.Field.equals.

Doc from org.jooq.QueryPart.equals.

Check whether this QueryPart can be considered equal to another QueryPart.

In general, QueryPart equality is defined in terms of toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.

Some QueryPart implementations may choose to override this behaviour for improved performance, as toString() is an expensive operation, if called many times.

Parameters
that:Object

The other QueryPart

Returns:boolean

Whether the two query parts are equal

Annotations
@Override
org.jooq.impl back to summary

private final Enum SequenceImpl.SequenceMethod

extends Enum<SequenceImpl.SequenceMethod>
Class Inheritance

Field Summary

Modifier and TypeField and Description
public static final SequenceImpl.SequenceMethod
CURRVAL

pack-priv final Keyword
keyword

pack-priv final Name
name

Hides java.lang.Enum.name.

public static final SequenceImpl.SequenceMethod
NEXTVAL

Constructor Summary

AccessConstructor and Description
private
SequenceMethod(Keyword keyword, Name name)

Method Summary

Modifier and TypeMethod and Description
public static SequenceImpl.SequenceMethod
valueOf(String name)

public static SequenceImpl.SequenceMethod[]
values()

Inherited from java.lang.Enum:
clonecompareTodescribeConstableequalsfinalizegetDeclaringClasshashCodenameordinaltoStringvalueOf

Field Detail

CURRVALback to summary
public static final SequenceImpl.SequenceMethod CURRVAL
keywordback to summary
pack-priv final Keyword keyword
nameback to summary
pack-priv final Name name

Hides java.lang.Enum.name.

NEXTVALback to summary
public static final SequenceImpl.SequenceMethod NEXTVAL

Constructor Detail

SequenceMethodback to summary
private SequenceMethod(Keyword keyword, Name name)

Method Detail

valueOfback to summary
public static SequenceImpl.SequenceMethod valueOf(String name)
valuesback to summary
public static SequenceImpl.SequenceMethod[] values()