• Home
• io.qinarmy
• army-postgre
• 0.6.0
• source code
• Postgres.java

×

Project download

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.

io.army.criteria.impl.Postgres Maven / Gradle / Ivy

package io.army.criteria.impl;


import io.army.criteria.*;
import io.army.criteria.dialect.ReturningDelete;
import io.army.criteria.dialect.ReturningUpdate;
import io.army.criteria.postgre.*;
import io.army.mapping.*;

import java.util.function.BiFunction;
import java.util.function.Consumer;

/**
 * 

 * This class is Postgre SQL syntax utils.
*
 * @since 1.0
 */
public abstract class Postgres extends PostgreSyntax {


    /**
     * private constructor
     */
    private Postgres() {
    }

    public static final Modifier ALL = PostgreWords.SelectModifier.ALL;
    public static final WordDistinct DISTINCT = PostgreWords.KeyWordDistinct.DISTINCT;
    public static final WordMaterialized MATERIALIZED = PostgreWords.KeyWordMaterialized.MATERIALIZED;
    public static final WordMaterialized NOT_MATERIALIZED = PostgreWords.KeyWordMaterialized.NOT_MATERIALIZED;
    public static final SQLs.BooleanTestWord FROM_NORMALIZED = PostgreWords.FromNormalizedWord.FROM_NORMALIZED;
    public static final SQLs.BooleanTestWord NORMALIZED = PostgreWords.FromNormalizedWord.NORMALIZED;


    public static final WordName NAME = PostgreWords.KeyWordName.NAME;

    public static final WordVersion VERSION = PostgreWords.KeyWordVersion.VERSION;

    public static final WordStandalone STANDALONE = PostgreWords.KeyWordStandalone.STANDALONE;

    public static final StandaloneOption YES = PostgreWords.KeyWordStandaloneOption.YES;

    public static final StandaloneOption NO = PostgreWords.KeyWordStandaloneOption.NO;

    public static final WordsNoValue NO_VALUE = PostgreWords.KeyWordsNoValue.NO_VALUE;

    public static final SQLs.WordDocument DOCUMENT = SqlWords.KeyWordDocument.DOCUMENT;

    public static final SQLs.WordContent CONTENT = SqlWords.KeyWordContent.CONTENT;

    public static final WordPassing PASSING = PostgreWords.KeyWordPassing.PASSING;

    public static final PassingOption BY_REF = PostgreWords.WordPassingOption.BY_REF;

    public static final PassingOption BY_VALUE = PostgreWords.WordPassingOption.BY_VALUE;

    public static final SQLs.NullOption NOT_NULL = SqlWords.KeyWordNotNull.NOT_NULL;

    public static final SQLs.WordPath PATH = SqlWords.KeyWordPath.PATH;

    public static final SQLs.WordsForOrdinality FOR_ORDINALITY = SqlWords.KeyWordsForOrdinality.FOR_ORDINALITY;

    public static final NullTreatMode RAISE_EXCEPTION = PostgreWords.NullTreatModeExpression.RAISE_EXCEPTION;

    public static final NullTreatMode USE_JSON_NULL = PostgreWords.NullTreatModeExpression.USE_JSON_NULL;

    public static final NullTreatMode DELETE_KEY = PostgreWords.NullTreatModeExpression.DELETE_KEY;

    public static final NullTreatMode RETURN_TARGET = PostgreWords.NullTreatModeExpression.RETURN_TARGET;

    public static final DoubleColon DOUBLE_COLON = PostgreWords.SymbolDoubleColon.DOUBLE_COLON;


    public static final ExtractTimeField CENTURY = PostgreWords.WordExtractTimeField.CENTURY;
    public static final ExtractTimeField DAY = PostgreWords.WordExtractTimeField.DAY;
    public static final ExtractTimeField DECADE = PostgreWords.WordExtractTimeField.DECADE;
    public static final ExtractTimeField DOW = PostgreWords.WordExtractTimeField.DOW;
    public static final ExtractTimeField DOY = PostgreWords.WordExtractTimeField.DOY;
    public static final ExtractTimeField EPOCH = PostgreWords.WordExtractTimeField.EPOCH;
    public static final ExtractTimeField HOUR = PostgreWords.WordExtractTimeField.HOUR;
    public static final ExtractTimeField ISODOW = PostgreWords.WordExtractTimeField.ISODOW;
    public static final ExtractTimeField ISOYEAR = PostgreWords.WordExtractTimeField.ISOYEAR;
    public static final ExtractTimeField JULIAN = PostgreWords.WordExtractTimeField.JULIAN;
    public static final ExtractTimeField MICROSECONDS = PostgreWords.WordExtractTimeField.MICROSECONDS;
    public static final ExtractTimeField MILLENNIUM = PostgreWords.WordExtractTimeField.MILLENNIUM;
    public static final ExtractTimeField MILLISECONDS = PostgreWords.WordExtractTimeField.MILLISECONDS;
    public static final ExtractTimeField MINUTE = PostgreWords.WordExtractTimeField.MINUTE;
    public static final ExtractTimeField MONTH = PostgreWords.WordExtractTimeField.MONTH;
    public static final ExtractTimeField QUARTER = PostgreWords.WordExtractTimeField.QUARTER;
    public static final ExtractTimeField SECOND = PostgreWords.WordExtractTimeField.SECOND;
    public static final ExtractTimeField TIMEZONE = PostgreWords.WordExtractTimeField.TIMEZONE;
    public static final ExtractTimeField TIMEZONE_HOUR = PostgreWords.WordExtractTimeField.TIMEZONE_HOUR;
    public static final ExtractTimeField TIMEZONE_MINUTE = PostgreWords.WordExtractTimeField.TIMEZONE_MINUTE;
    public static final ExtractTimeField WEEK = PostgreWords.WordExtractTimeField.WEEK;
    public static final ExtractTimeField YEAR = PostgreWords.WordExtractTimeField.YEAR;
    /**
     * 

     * The {@link MappingType} of function return type: {@link  LocalDateType}
     *
     *
     * @see current_date → date
     */
    public static final SimpleExpression CURRENT_DATE = FunctionUtils.noParensFunc("current_date", LocalDateType.INSTANCE);
    /**
     * 

     * The {@link MappingType} of function return type: {@link  OffsetTimeType}
     *
     *
     * @see current_time
     */
    public static final SimpleExpression CURRENT_TIME = FunctionUtils.noParensFunc("current_time", OffsetTimeType.INSTANCE);
    /**
     * 

     * The {@link MappingType} of function return type: {@link  OffsetDateTimeType}
     *
     *
     * @see current_timestamp → timestamp with time zone
     */
    public static final SimpleExpression CURRENT_TIMESTAMP = FunctionUtils.noParensFunc("current_timestamp", OffsetDateTimeType.INSTANCE);
    /**
     * 

     * The {@link MappingType} of function return type: {@link  LocalTimeType}
     *
     *
     * @see localtime → time
     */
    public static final SimpleExpression LOCALTIME = FunctionUtils.noParensFunc("localtime", LocalTimeType.INSTANCE);
    /**
     * 

     * The {@link MappingType} of function return type: {@link  LocalDateTimeType}
     *
     *
     * @see localtimestamp → timestamp
     */
    public static final SimpleExpression LOCALTIMESTAMP = FunctionUtils.noParensFunc("localtimestamp", LocalDateTimeType.INSTANCE);

    /**
     * 

     * The {@link MappingType} of function return type: {@link  TextType}
     *
     *
     * @see current_catalog → name
     */
    public static final SimpleExpression CURRENT_CATALOG = FunctionUtils.noParensFunc("current_catalog", TextType.INSTANCE);

    /**
     * 

     * The {@link MappingType} of function return type: {@link  TextType}
     *
     *
     * @see current_user → name
     */
    public static final SimpleExpression CURRENT_USER = FunctionUtils.noParensFunc("current_user", TextType.INSTANCE);


    /**
     * 

     * The {@link MappingType} of function return type: {@link  TextType}
     *
     *
     * @see session_user → name
     */
    public static final SimpleExpression SESSION_USER = FunctionUtils.noParensFunc("session_user", TextType.INSTANCE);

    /**
     * 

     * The {@link MappingType} of function return type: {@link  TextType}
     *
     *
     * @see user → name
     */
    public static final SimpleExpression USER = FunctionUtils.noParensFunc("user", TextType.INSTANCE);

    /**
     * 

     * create single-table INSERT statement that is primary statement.
     *
     */
    public static PostgreInsert._PrimaryOptionSpec singleInsert() {
        return PostgreInserts.singleInsert();
    }

    /**
     * 

     * create simple(non-batch) SELECT statement that is primary statement.
     *
     */
    public static PostgreQuery._WithSpec query() {
        return PostgreQueries.simpleQuery();
    }

    /**
     * 

     * create batch SELECT statement that is primary statement.
     *
     */
    public static PostgreQuery._WithSpec batchQuery() {
        return PostgreQueries.batchQuery();
    }


    /**
     * 

     * create SUB-SELECT statement that is sub query statement.
     *
     */
    public static PostgreQuery._WithSpec subQuery() {
        return PostgreQueries.subQuery(ContextStack.peek(), SQLs::identity);
    }

    /**
     * 

     * create SUB-SELECT statement that is sub query statement and would be converted to {@link Expression}.
     *
     */
    public static PostgreQuery._WithSpec scalarSubQuery() {
        return PostgreQueries.subQuery(ContextStack.peek(), Expressions::scalarExpression);
    }

    /**
     * 

     * create simple(non-batch) single-table UPDATE statement that is primary statement.
     *
     */
    public static PostgreUpdate._SingleWithSpec singleUpdate() {
        return PostgreUpdates.simple();
    }

    /**
     * 

     * create batch single-table UPDATE statement that is primary statement.
     *
     */
    public static PostgreUpdate._SingleWithSpec batchSingleUpdate() {
        return PostgreUpdates.batchUpdate();
    }

    /**
     * 

     * create simple(non-batch) single-table DELETE statement that is primary statement.
     *
     */
    public static PostgreDelete._SingleWithSpec singleDelete() {
        return PostgreDeletes.simpleDelete();
    }

    /**
     * 

     * create batch single-table DELETE statement that is primary statement.
     *
     */
    public static PostgreDelete._SingleWithSpec batchSingleDelete() {
        return PostgreDeletes.batchDelete();
    }

    public static PostgreValues._WithSpec simpleValues() {
        return PostgreSimpleValues.simpleValues();
    }

    public static PostgreValues._WithSpec subValues() {
        return PostgreSimpleValues.subValues(ContextStack.peek(), SQLs::identity);
    }

    public interface _XmlNamedElementClause {

        _XmlNamedElementClause accept(Expression value, SQLs.WordAs as, String name);

        _XmlNamedElementClause accept(BiFunction funcRef, String value, SQLs.WordAs as, String name);

    }

    public interface _XmlNamedElementFieldClause extends _XmlNamedElementClause {

        _XmlNamedElementFieldClause accept(SqlField field);

        _XmlNamedElementFieldClause accept(Expression value, SQLs.WordAs as, String name);

        _XmlNamedElementFieldClause accept(BiFunction funcRef, String value, SQLs.WordAs as, String name);

    }


    public interface _XmlTableColumnsClause {

        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordPath path, Expression columnExp, SQLs.WordDefault wordDefault, Expression defaultExp, SQLs.NullOption nullOption);

        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordDefault wordDefault, Expression defaultExp, SQLs.NullOption nullOption);

        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordPath path, Expression columnExp, SQLs.NullOption nullOption);

        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordPath path, Expression columnExp, SQLs.WordDefault wordDefault, Expression defaultExp);

        XmlTableCommaClause columns(String name, MappingType type, SQLs.NullOption nullOption);

        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordDefault wordDefault, Expression defaultExp);

        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordPath path, Expression columnExp);

        XmlTableCommaClause columns(String name, MappingType type);

        XmlTableCommaClause columns(String name, SQLs.WordsForOrdinality forOrdinality);


        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordPath path, BiFunction funcRefForColumnExp, String columnExp, SQLs.WordDefault wordDefault, Expression defaultExp, SQLs.NullOption nullOption);


        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordPath path, BiFunction funcRefForColumnExp, String columnExp, SQLs.NullOption nullOption);

        XmlTableCommaClause columns(String name, MappingType type, SQLs.WordPath path, BiFunction funcRefForColumnExp, String columnExp, SQLs.WordDefault wordDefault, Expression defaultExp);


    }

    /**
     * 

     * This interface not start with underscore, so this interface can present in application developer code.
     *
     *
     * @since 1.0
     */
    public interface XmlTableCommaClause {

        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordPath path, Expression columnExp, SQLs.WordDefault wordDefault, Expression defaultExp, SQLs.NullOption nullOption);

        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordDefault wordDefault, Expression defaultExp, SQLs.NullOption nullOption);

        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordPath path, Expression columnExp, SQLs.NullOption nullOption);

        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordPath path, Expression columnExp, SQLs.WordDefault wordDefault, Expression defaultExp);

        XmlTableCommaClause comma(String name, MappingType type, SQLs.NullOption nullOption);

        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordDefault wordDefault, Expression defaultExp);

        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordPath path, Expression columnExp);

        XmlTableCommaClause comma(String name, MappingType type);

        XmlTableCommaClause comma(String name, SQLs.WordsForOrdinality forOrdinality);


        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordPath path, BiFunction funcRefForColumnExp, String columnExp, SQLs.WordDefault wordDefault, Expression defaultExp, SQLs.NullOption nullOption);


        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordPath path, BiFunction funcRefForColumnExp, String columnExp, SQLs.NullOption nullOption);

        XmlTableCommaClause comma(String name, MappingType type, SQLs.WordPath path, BiFunction funcRefForColumnExp, String columnExp, SQLs.WordDefault wordDefault, Expression defaultExp);


    }


    public interface _RowsFromAsClause {

        _RowsFromCommaClause as(Consumer consumer);

    }

    public interface _RowsFromSpaceClause {

        _RowsFromCommaClause space(SimpleExpression func);

        _RowsFromCommaClause space(SimplePredicate func);

        _RowsFromCommaClause space(_TabularFunction func);

        _RowsFromAsClause space(UndoneFunction func);

    }


    /**
     * 

     * This interface not start with underscore, so this interface can present in application developer code.
     *
     *
     * @since 1.0
     */
    public interface _RowsFromCommaClause {

        _RowsFromCommaClause comma(SimpleExpression func);

        _RowsFromCommaClause comma(SimplePredicate func);

        _RowsFromCommaClause comma(_TabularFunction func);

        _RowsFromAsClause comma(UndoneFunction func);

    }

    public interface _RowsFromConsumerAsClause {

        RowFromConsumer as(Consumer consumer);

    }

    public interface RowFromConsumer {

        RowFromConsumer accept(SimpleExpression func);

        RowFromConsumer accept(SimplePredicate func);

        RowFromConsumer accept(_TabularFunction func);

        _RowsFromConsumerAsClause accept(UndoneFunction func);

    }


    public interface Modifier extends Query.SelectModifier {

    }

    public interface WordDistinct extends Modifier, SQLs.ArgDistinct {

    }

    public interface WordMaterialized extends SQLWords {

    }

    public interface WordName extends SQLWords {

    }

    public interface DoubleColon {

    }

    public interface _PeriodOverlapsClause {

        IPredicate overlaps(Expression start, Expression endOrLength);

         IPredicate overlaps(Expression start, BiFunction valueOperator, T value);

         IPredicate overlaps(BiFunction valueOperator, T value, Expression endOrLength);

        IPredicate overlaps(TypeInfer type, BiFunction valueOperator, Object start, Object endOrLength);


    }
}
    

    







    
© 2015 - 2025 Weber Informatics LLC | Privacy Policy