All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.jooq.impl.CreateSequenceImpl Maven / Gradle / Ivy

There is a newer version: 3.19.15
Show newest version
/*
 * 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 startWith;
          Field incrementBy;
          Field minvalue;
          boolean                 noMinvalue;
          Field maxvalue;
          boolean                 noMaxvalue;
          CycleOption             cycle;
          Field 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 startWith,
        Field incrementBy,
        Field minvalue,
        boolean noMinvalue,
        Field maxvalue,
        boolean noMaxvalue,
        CycleOption cycle,
        Field 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 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 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 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 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 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 $startWith() {
        return startWith;
    }

    @Override
    public final Field $incrementBy() {
        return incrementBy;
    }

    @Override
    public final Field $minvalue() {
        return minvalue;
    }

    @Override
    public final boolean $noMinvalue() {
        return noMinvalue;
    }

    @Override
    public final Field $maxvalue() {
        return maxvalue;
    }

    @Override
    public final boolean $noMaxvalue() {
        return noMaxvalue;
    }

    @Override
    public final CycleOption $cycle() {
        return cycle;
    }

    @Override
    public final Field $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 newValue) {
        return $constructor().apply($sequence(), $ifNotExists(), newValue, $incrementBy(), $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
    }

    @Override
    public final QOM.CreateSequence $incrementBy(Field newValue) {
        return $constructor().apply($sequence(), $ifNotExists(), $startWith(), newValue, $minvalue(), $noMinvalue(), $maxvalue(), $noMaxvalue(), $cycle(), $cache(), $noCache());
    }

    @Override
    public final QOM.CreateSequence $minvalue(Field 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 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 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 Boolean, ? super Field, ? super Field, ? super Field, ? super Boolean, ? super Field, ? super Boolean, ? super CycleOption, ? super Field, ? 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);
    }




































}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy