org.jooq.util.sqlite.SQLiteDataType Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of jooq Show documentation
There is a newer version: 3.19.11
/**
 * Copyright (c) 2009-2016, Data Geekery GmbH (http://www.datageekery.com)
 * All rights reserved.
 *
 * 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.util.sqlite;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.UUID;

import org.jooq.DataType;
import org.jooq.SQLDialect;
import org.jooq.impl.DefaultDataType;
import org.jooq.impl.SQLDataType;
import org.jooq.types.UByte;
import org.jooq.types.UInteger;
import org.jooq.types.ULong;
import org.jooq.types.UShort;

/**
 * Supported data types for the {@link SQLDialect#SQLITE} dialect
 *
 * @author Lukas Eder
 * @see http://www.sqlite.org/datatype3.html
 */
public class SQLiteDataType {

    // -------------------------------------------------------------------------
    // Default SQL data types and synonyms thereof
    // -------------------------------------------------------------------------

    public static final DataType       TINYINT          = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.TINYINT, "tinyint");
    public static final DataType      SMALLINT         = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.SMALLINT, "smallint");
    public static final DataType      INT2             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.SMALLINT, "int2");
    public static final DataType    INT              = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.INTEGER, "int");
    public static final DataType    INTEGER          = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.INTEGER, "integer");
    public static final DataType    MEDIUMINT        = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.INTEGER, "mediumint");
    public static final DataType       INT8             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.BIGINT, "int8");
    public static final DataType       BIGINT           = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.BIGINT, "bigint");
    public static final DataType UNSIGNEDBIGINT   = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.DECIMAL_INTEGER, "unsigned big int");
    public static final DataType     DOUBLE           = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.DOUBLE, "double");
    public static final DataType     DOUBLEPRECISION  = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.DOUBLE, "double precision");
    public static final DataType      REAL             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.REAL, "real");
    public static final DataType      FLOAT            = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.REAL, "float");
    public static final DataType NUMERIC          = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.NUMERIC, "numeric");
    public static final DataType DECIMAL          = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.DECIMAL, "decimal");
    public static final DataType     LONGVARCHAR      = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.LONGVARCHAR, "longvarchar");
    public static final DataType     CHAR             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.CHAR, "char");
    public static final DataType     CHARACTER        = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.CHAR, "character");
    public static final DataType     VARCHAR          = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.VARCHAR, "varchar");
    public static final DataType     VARYINGCHARACTER = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.VARCHAR, "varying character");
    public static final DataType     NCHAR            = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.NCHAR, "nchar");
    public static final DataType     NATIVECHARACTER  = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.NCHAR, "native character");
    public static final DataType     NVARCHAR         = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.NVARCHAR, "nvarchar");
    public static final DataType     CLOB             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.CLOB, "clob");
    public static final DataType     TEXT             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.CLOB, "text");
    public static final DataType    BOOLEAN          = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.BOOLEAN, "boolean");
    public static final DataType       DATE             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.DATE, "date");
    public static final DataType  DATETIME         = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.TIMESTAMP, "datetime");
    public static final DataType     LONGVARBINARY    = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.LONGVARBINARY, "longvarbinary");
    public static final DataType     BLOB             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.BLOB, "blob");

    // -------------------------------------------------------------------------
    // Compatibility types for supported SQLDialect.SQLITE, SQLDataTypes
    // -------------------------------------------------------------------------

    protected static final DataType   __BINARY           = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.BINARY, "longvarbinary");
    protected static final DataType  __BIT              = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.BIT, "boolean");
    protected static final DataType   __FLOAT            = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.FLOAT, "double");
    protected static final DataType   __NCLOB            = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.NCLOB, "nclob");
    protected static final DataType   __LONGNVARCHAR     = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.LONGNVARCHAR, "nvarchar");
    protected static final DataType     __TIME             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.TIME, "datetime");
    protected static final DataType   __VARBINARY        = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.VARBINARY, "longvarbinary");
    protected static final DataType    __TINYINTUNSIGNED  = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.TINYINTUNSIGNED, "smallint");
    protected static final DataType   __SMALLINTUNSIGNED = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.SMALLINTUNSIGNED, "int");
    protected static final DataType __INTEGERUNSIGNED  = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.INTEGERUNSIGNED, "bigint");
    protected static final DataType    __BIGINTUNSIGNED   = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.BIGINTUNSIGNED, "numeric");

    // -------------------------------------------------------------------------
    // Compatibility types for supported Java types
    // -------------------------------------------------------------------------

    protected static final DataType     __UUID             = new DefaultDataType(SQLDialect.SQLITE, SQLDataType.UUID, "varchar");

    // -------------------------------------------------------------------------
    // Dialect-specific data types and synonyms thereof
    // -------------------------------------------------------------------------

    public static final DataType