/*
 * 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
 *
 *  http://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: http://www.jooq.org/licenses
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 */

package org.jooq;

import org.jetbrains.annotations.*;


// ...
// ...
// ...
// ...
// ...
// ...
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
import static org.jooq.SQLDialect.MARIADB;
// ...
import static org.jooq.SQLDialect.MYSQL;
// ...
import static org.jooq.SQLDialect.POSTGRES;
// ...
import static org.jooq.SQLDialect.SQLITE;
// ...
// ...

import java.time.temporal.ChronoField;

import org.jooq.impl.DSL;

A date part can be used with SQL functions such as extract(). It describes a
part of a date / datetime value
Author:
Lukas Eder/**
 * A date part can be used with SQL functions such as extract(). It describes a
 * part of a date / datetime value
 *
 * @author Lukas Eder
 */
public enum DatePart {

    // ------------------------------------------------------------------------
    // XXX: SQL standard date parts
    // ------------------------------------------------------------------------

    
The year. Corresponds to ChronoField.YEAR semantics. /**
     * The year. Corresponds to {@link ChronoField#YEAR} semantics.
     */
    @NotNull
    @Support
    YEAR("year"),

    
The month. Corresponds to ChronoField.MONTH_OF_YEAR semantics. /**
     * The month. Corresponds to {@link ChronoField#MONTH_OF_YEAR} semantics.
     */
    @NotNull
    @Support
    MONTH("month"),

    
The day. Corresponds to ChronoField.DAY_OF_MONTH semantics. /**
     * The day. Corresponds to {@link ChronoField#DAY_OF_MONTH} semantics.
     */
    @NotNull
    @Support
    DAY("day"),

    
The hour. Corresponds to ChronoField.HOUR_OF_DAY semantics. /**
     * The hour. Corresponds to {@link ChronoField#HOUR_OF_DAY} semantics.
     */
    @NotNull
    @Support
    HOUR("hour"),

    
The minute. Corresponds to ChronoField.MINUTE_OF_HOUR semantics. /**
     * The minute. Corresponds to {@link ChronoField#MINUTE_OF_HOUR} semantics.
     */
    @NotNull
    @Support
    MINUTE("minute"),

    
The second. Corresponds to ChronoField.SECOND_OF_MINUTE semantics. /**
     * The second. Corresponds to {@link ChronoField#SECOND_OF_MINUTE} semantics.
     */
    @NotNull
    @Support
    SECOND("second"),

    // ------------------------------------------------------------------------
    // XXX: Vendor-specific date parts
    // ------------------------------------------------------------------------

    
The millisecond.
/**
     * The millisecond.
     */
    @NotNull
    @Support({ H2, HSQLDB, POSTGRES })
    MILLISECOND("millisecond"),

    
The microsecond.
/**
     * The microsecond.
     */
    @NotNull
    @Support({ H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    MICROSECOND("microsecond"),

    
The nanosecond.
/**
     * The nanosecond.
     */
    @NotNull
    @Support({ H2, HSQLDB })
    NANOSECOND("nanosecond"),

    
The millennium. The year 2000 is in the 2nd millennium, the year 2001 in
the 3rd.
/**
     * The millennium. The year 2000 is in the 2nd millennium, the year 2001 in
     * the 3rd.
     */
    @NotNull
    @Support
    MILLENNIUM("millennium"),

    
The century. The year 2000 is in the 20th century, the year 2001 in the
21st.
/**
     * The century. The year 2000 is in the 20th century, the year 2001 in the
     * 21st.
     */
    @NotNull
    @Support
    CENTURY("century"),

    
The decade. The year divided by 10.
/**
     * The decade. The year divided by 10.
     */
    @NotNull
    @Support
    DECADE("decade"),

    
The epoch in seconds since 1970-01-01.
/**
     * The epoch in seconds since 1970-01-01.
     */
    @NotNull
    @Support({ H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    EPOCH("epoch"),

    
The quarter. Jan-Mar = 1, Apr-Jun = 2, Jul-Sep = 3, Oct-Dec = 4.
/**
     * The quarter. Jan-Mar = 1, Apr-Jun = 2, Jul-Sep = 3, Oct-Dec = 4.
     */
    @NotNull
    @Support
    QUARTER("quarter"),

    
The week of the year.
/**
     * The week of the year.
     */
    @NotNull
    @Support({ H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    WEEK("week"),

    
The day of the year. Corresponds to ChronoField.DAY_OF_YEAR. /**
     * The day of the year. Corresponds to {@link ChronoField#DAY_OF_YEAR}.
     */
    @NotNull
    @Support({ H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    DAY_OF_YEAR("day_of_year"),

    
The day of the week. 1 = Sunday, 2 = Monday, ..., 7 = Saturday. Corresponds to ChronoField.DAY_OF_WEEK, shifted by one day. /**
     * The day of the week. 1 = Sunday, 2 = Monday, ..., 7 = Saturday.
     * Corresponds to {@link ChronoField#DAY_OF_WEEK}, shifted by one day.
     */
    @NotNull
    @Support({ H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    DAY_OF_WEEK("day_of_week"),

    
The ISO day of the week. 1 = Monday, 2 = Tuesday, ..., 7 = Sunday. Corresponds to ChronoField.DAY_OF_WEEK. /**
     * The ISO day of the week. 1 = Monday, 2 = Tuesday, ..., 7 = Sunday.
     * Corresponds to {@link ChronoField#DAY_OF_WEEK}.
     */
    @NotNull
    @Support({ H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    ISO_DAY_OF_WEEK("iso_day_of_week"),

    
The timezone offset in seconds. Corresponds to ChronoField.OFFSET_SECONDS. /**
     * The timezone offset in seconds. Corresponds to
     * {@link ChronoField#OFFSET_SECONDS}.
     */
    @NotNull
    @Support({ H2, HSQLDB, POSTGRES })
    TIMEZONE("timezone"),

    
The time zone offset's hour part.
/**
     * The time zone offset's hour part.
     */
    @NotNull
    @Support({ H2, HSQLDB, POSTGRES })
    TIMEZONE_HOUR("timezone_hour"),

    
The time zone offset's minute part.
/**
     * The time zone offset's minute part.
     */
    @NotNull
    @Support({ H2, HSQLDB, POSTGRES })
    TIMEZONE_MINUTE("timezone_minute"),

    ;

    private final String  sql;
    private final Keyword keyword;
    private final Name    name;

    private DatePart(String sql) {
        this.sql = sql;
        this.keyword = DSL.keyword(sql);
        this.name = DSL.unquotedName(sql);
    }

    public final String toSQL() {
        return sql;
    }

    public final Keyword toKeyword() {
        return keyword;
    }

    public final Name toName() {
        return name;
    }
}