Please wait. This can take some minutes ...
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
org.jooq.impl.CreateSequenceImpl Maven / Gradle / Ivy
/*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* Other licenses:
* -----------------------------------------------------------------------------
* Commercial licenses for this work are available. These replace the above
* ASL 2.0 and offer limited warranties, support, maintenance, and commercial
* database integrations.
*
* For more information, please visit: https://www.jooq.org/legal/licensing
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*/
package org.jooq.impl;
import static org.jooq.impl.DSL.*;
import static org.jooq.impl.Internal.*;
import static org.jooq.impl.Keywords.*;
import static org.jooq.impl.Names.*;
import static org.jooq.impl.SQLDataType.*;
import static org.jooq.impl.Tools.*;
import static org.jooq.impl.Tools.BooleanDataKey.*;
import static org.jooq.impl.Tools.ExtendedDataKey.*;
import static org.jooq.impl.Tools.SimpleDataKey.*;
import static org.jooq.SQLDialect.*;
import org.jooq.*;
import org.jooq.Function1;
import org.jooq.Record;
import org.jooq.conf.ParamType;
import org.jooq.impl.QOM.CycleOption;
import org.jooq.tools.StringUtils;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.HashSet;
import java.util.LinkedHashSet;
import java.util.List;
import java.util.Set;
/**
* The CREATE SEQUENCE
statement.
*/
@SuppressWarnings({ "hiding", "rawtypes", "unused" })
final class CreateSequenceImpl
extends
AbstractDDLQuery
implements
QOM.CreateSequence,
CreateSequenceFlagsStep,
CreateSequenceFinalStep
{
final Sequence> sequence;
final boolean ifNotExists;
Field extends Number> startWith;
Field extends Number> incrementBy;
Field extends Number> minvalue;
boolean noMinvalue;
Field extends Number> maxvalue;
boolean noMaxvalue;
CycleOption cycle;
Field extends Number> cache;
boolean noCache;
CreateSequenceImpl(
Configuration configuration,
Sequence> sequence,
boolean ifNotExists
) {
this(
configuration,
sequence,
ifNotExists,
null,
null,
null,
false,
null,
false,
null,
null,
false
);
}
CreateSequenceImpl(
Configuration configuration,
Sequence> sequence,
boolean ifNotExists,
Field extends Number> startWith,
Field extends Number> incrementBy,
Field extends Number> minvalue,
boolean noMinvalue,
Field extends Number> maxvalue,
boolean noMaxvalue,
CycleOption cycle,
Field extends Number> cache,
boolean noCache
) {
super(configuration);
this.sequence = sequence;
this.ifNotExists = ifNotExists;
this.startWith = startWith;
this.incrementBy = incrementBy;
this.minvalue = minvalue;
this.noMinvalue = noMinvalue;
this.maxvalue = maxvalue;
this.noMaxvalue = noMaxvalue;
this.cycle = cycle;
this.cache = cache;
this.noCache = noCache;
}
// -------------------------------------------------------------------------
// XXX: DSL API
// -------------------------------------------------------------------------
@Override
public final CreateSequenceImpl startWith(Number startWith) {
return startWith(Tools.field(startWith, sequence.getDataType()));
}
@Override
public final CreateSequenceImpl startWith(Field extends Number> startWith) {
this.startWith = startWith;
return this;
}
@Override
public final CreateSequenceImpl incrementBy(Number incrementBy) {
return incrementBy(Tools.field(incrementBy, sequence.getDataType()));
}
@Override
public final CreateSequenceImpl incrementBy(Field extends Number> incrementBy) {
this.incrementBy = incrementBy;
return this;
}
@Override
public final CreateSequenceImpl minvalue(Number minvalue) {
return minvalue(Tools.field(minvalue, sequence.getDataType()));
}
@Override
public final CreateSequenceImpl minvalue(Field extends Number> minvalue) {
this.minvalue = minvalue;
return this;
}
@Override
public final CreateSequenceImpl noMinvalue() {
this.noMinvalue = true;
return this;
}
@Override
public final CreateSequenceImpl maxvalue(Number maxvalue) {
return maxvalue(Tools.field(maxvalue, sequence.getDataType()));
}
@Override
public final CreateSequenceImpl maxvalue(Field extends Number> maxvalue) {
this.maxvalue = maxvalue;
return this;
}
@Override
public final CreateSequenceImpl noMaxvalue() {
this.noMaxvalue = true;
return this;
}
@Override
public final CreateSequenceImpl cycle() {
this.cycle = CycleOption.CYCLE;
return this;
}
@Override
public final CreateSequenceImpl noCycle() {
this.cycle = CycleOption.NO_CYCLE;
return this;
}
@Override
public final CreateSequenceImpl cache(Number cache) {
return cache(Tools.field(cache, sequence.getDataType()));
}
@Override
public final CreateSequenceImpl cache(Field extends Number> cache) {
this.cache = cache;
return this;
}
@Override
public final CreateSequenceImpl noCache() {
this.noCache = true;
return this;
}
// -------------------------------------------------------------------------
// XXX: QueryPart API
// -------------------------------------------------------------------------
static final Clause[] CLAUSES = { Clause.CREATE_SEQUENCE };
static final Set NO_SUPPORT_IF_NOT_EXISTS = SQLDialect.supportedUntil(DERBY, FIREBIRD);
static final Set REQUIRES_START_WITH = SQLDialect.supportedBy(DERBY);
static final Set NO_SUPPORT_CACHE = SQLDialect.supportedBy(DERBY, FIREBIRD, HSQLDB);
static final Set NO_SEPARATOR = SQLDialect.supportedBy(CUBRID, MARIADB);
static final Set OMIT_NO_CACHE = SQLDialect.supportedBy(FIREBIRD, POSTGRES, YUGABYTEDB);
static final Set OMIT_NO_CYCLE = SQLDialect.supportedBy(FIREBIRD);
static final Set OMIT_NO_MINVALUE = SQLDialect.supportedBy(FIREBIRD);
static final Set OMIT_NO_MAXVALUE = SQLDialect.supportedBy(FIREBIRD);
private final boolean supportsIfNotExists(Context> ctx) {
return !NO_SUPPORT_IF_NOT_EXISTS.contains(ctx.dialect());
}
@Override
public final void accept(Context> ctx) {
if (ifNotExists && !supportsIfNotExists(ctx))
tryCatch(ctx, DDLStatementType.CREATE_SEQUENCE, c -> accept0(c));
else
accept0(ctx);
}
private final void accept0(Context> ctx) {
ctx.start(Clause.CREATE_SEQUENCE_SEQUENCE)
.visit(K_CREATE)
.sql(' ')
.visit(ctx.family() == CUBRID ? K_SERIAL : K_SEQUENCE)
.sql(' ');
if (ifNotExists && supportsIfNotExists(ctx))
ctx.visit(K_IF_NOT_EXISTS)
.sql(' ');
ctx.visit(sequence);
String noSeparator = NO_SEPARATOR.contains(ctx.dialect()) ? "" : " ";
// Some databases default to sequences starting with MIN_VALUE
if (startWith == null && REQUIRES_START_WITH.contains(ctx.dialect()))
ctx.sql(' ').visit(K_START_WITH).sql(" 1");
else if (startWith != null)
ctx.sql(' ').visit(K_START_WITH).sql(' ').visit(startWith);
if (incrementBy != null)
ctx.sql(' ').visit(K_INCREMENT_BY).sql(' ').visit(incrementBy);
if (minvalue != null)
ctx.sql(' ').visit(K_MINVALUE).sql(' ').visit(minvalue);
else if (noMinvalue && !OMIT_NO_MINVALUE.contains(ctx.dialect()))
ctx.sql(' ').visit(K_NO).sql(noSeparator).visit(K_MINVALUE);
if (maxvalue != null)
ctx.sql(' ').visit(K_MAXVALUE).sql(' ').visit(maxvalue);
else if (noMaxvalue && !OMIT_NO_MAXVALUE.contains(ctx.dialect()))
ctx.sql(' ').visit(K_NO).sql(noSeparator).visit(K_MAXVALUE);
if (cycle == CycleOption.CYCLE)
ctx.sql(' ').visit(K_CYCLE);
else if (cycle == CycleOption.NO_CYCLE && !OMIT_NO_CYCLE.contains(ctx.dialect()))
ctx.sql(' ').visit(K_NO).sql(noSeparator).visit(K_CYCLE);
if (!NO_SUPPORT_CACHE.contains(ctx.dialect()))
if (cache != null)
ctx.sql(' ').visit(K_CACHE).sql(' ').visit(cache);
else if (noCache && !OMIT_NO_CACHE.contains(ctx.dialect()))
ctx.sql(' ').visit(K_NO).sql(noSeparator).visit(K_CACHE);
ctx.end(Clause.CREATE_SEQUENCE_SEQUENCE);
}
@Override
public final Clause[] clauses(Context> ctx) {
return CLAUSES;
}
// -------------------------------------------------------------------------
// XXX: Query Object Model
// -------------------------------------------------------------------------
@Override
public final Sequence> $sequence() {
return sequence;
}
@Override
public final boolean $ifNotExists() {
return ifNotExists;
}
@Override
public final Field extends Number> $startWith() {
return startWith;
}
@Override
public final Field extends Number> $incrementBy() {
return incrementBy;
}
@Override
public final Field extends Number> $minvalue() {
return minvalue;
}
@Override
public final boolean $noMinvalue() {
return noMinvalue;
}
@Override
public final Field extends Number> $maxvalue() {
return maxvalue;
}
@Override
public final boolean $noMaxvalue() {
return noMaxvalue;
}
@Override
public final CycleOption $cycle() {
return cycle;
}
@Override
public final Field extends Number> $cache() {
return cache;
}
@Override
public final boolean $noCache() {
return noCache;
}
@Override
public final QOM.CreateSequence $sequence(Sequence> newValue) {
return $constructor().apply(newValue, $ifNotExists(), $startWith(), $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $ifNotExists(boolean newValue) {
return $constructor().apply($sequence(), newValue, $startWith(), $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $startWith(Field extends Number> newValue) {
return $constructor().apply($sequence(), $ifNotExists(), newValue, $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $incrementBy(Field extends Number> newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), newValue, $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $minvalue(Field extends Number> newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), $incrementBy(), newValue, $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $noMinvalue(boolean newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), $incrementBy(), $minvalue(), newValue, $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $maxvalue(Field extends Number> newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), $incrementBy(), $minvalue(), $noMinvalue(), newValue, $noMaxvalue(), $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $noMaxvalue(boolean newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), newValue, $cycle(), $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $cycle(CycleOption newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), newValue, $cache(), $noCache());
}
@Override
public final QOM.CreateSequence $cache(Field extends Number> newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), newValue, $noCache());
}
@Override
public final QOM.CreateSequence $noCache(boolean newValue) {
return $constructor().apply($sequence(), $ifNotExists(), $startWith(), $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), newValue);
}
public final Function11 super Sequence>, ? super Boolean, ? super Field extends Number>, ? super Field extends Number>, ? super Field extends Number>, ? super Boolean, ? super Field extends Number>, ? super Boolean, ? super CycleOption, ? super Field extends Number>, ? super Boolean, ? extends QOM.CreateSequence> $constructor() {
return (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) -> new CreateSequenceImpl(configuration(), a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11);
}
}