com.alibaba.alink.common.io.catalog.sqlite

Class SqliteCatalog

java.lang.Object

org.apache.flink.table.catalog.AbstractCatalog

com.alibaba.alink.common.io.catalog.BaseCatalog

com.alibaba.alink.common.io.catalog.JdbcCatalog

com.alibaba.alink.common.io.catalog.sqlite.SqliteCatalog

All Implemented Interfaces:

AutoCloseable, org.apache.flink.table.catalog.Catalog

public class SqliteCatalog
extends JdbcCatalog

Field Summary

Fields

Modifier and Type	Field and Description
static String	SQL_LITE_BIGINT
static String	SQL_LITE_BLOB
static String	SQL_LITE_BOOLEAN
static String	SQL_LITE_CHARACTER
static String	SQL_LITE_CLOB
static String	SQL_LITE_DATE
static String	SQL_LITE_DATETIME
static String	SQL_LITE_DECIMAL
static String	SQL_LITE_DOUBLE
static String	SQL_LITE_DOUBLE_PRECISION
static String	SQL_LITE_FLOAT
static String	SQL_LITE_INT Ref: https://www.sqlite.org/datatype3.html
static String	SQL_LITE_INT2
static String	SQL_LITE_INT8
static String	SQL_LITE_INTEGER
static String	SQL_LITE_MEDIUMINT
static String	SQL_LITE_NATIVE_CHARACTER
static String	SQL_LITE_NCHAR
static String	SQL_LITE_NO_DATATYPE_SPECIFIED
static String	SQL_LITE_NUMERIC
static String	SQL_LITE_NVARCHAR
static String	SQL_LITE_REAL
static String	SQL_LITE_SMALLINT
static String	SQL_LITE_TEXT
static String	SQL_LITE_TIME
static String	SQL_LITE_TIMESTAMP
static String	SQL_LITE_TINYINT
static String	SQL_LITE_UNSIGNED_BIG_INT
static String	SQL_LITE_VARBINARY
static String	SQL_LITE_VARCHAR
static String	SQL_LITE_VARYING_CHARACTER

Fields inherited from class com.alibaba.alink.common.io.catalog.JdbcCatalog

LEGACY_DEC_DATA_TYPE

Constructor Summary

Constructors

Constructor and Description
SqliteCatalog(Params params)
SqliteCatalog(String catalogName, String defaultDatabase, String[] dbUrls, String userName, String password)

Method Summary

Modifier and Type	Method and Description
void	alterDatabase(String name, org.apache.flink.table.catalog.CatalogDatabase newDatabase, boolean ignoreIfNotExists)
void	alterTable(org.apache.flink.table.catalog.ObjectPath tablePath, org.apache.flink.table.catalog.CatalogBaseTable newTable, boolean ignoreIfNotExists)
void	createDatabase(String name, org.apache.flink.table.catalog.CatalogDatabase database, boolean ignoreIfExists)
void	createTable(org.apache.flink.table.catalog.ObjectPath tablePath, org.apache.flink.table.catalog.CatalogBaseTable table, boolean ignoreIfExists)
boolean	databaseExists(String databaseName)
void	dropDatabase(String name, boolean ignoreIfNotExists)
void	dropTable(org.apache.flink.table.catalog.ObjectPath tablePath, boolean ignoreIfNotExists)
org.apache.flink.table.catalog.CatalogDatabase	getDatabase(String databaseName)
org.apache.flink.table.catalog.CatalogBaseTable	getTable(org.apache.flink.table.catalog.ObjectPath tablePath)
List<String>	listDatabases()
List<String>	listTables(String databaseName)
List<String>	listViews(String databaseName)
void	open()
static String	parseDbNameFromUrl(String url)
void	renameTable(org.apache.flink.table.catalog.ObjectPath tablePath, String newTableName, boolean ignoreIfNotExists)
boolean	tableExists(org.apache.flink.table.catalog.ObjectPath tablePath)

Methods inherited from class com.alibaba.alink.common.io.catalog.JdbcCatalog

alterFunction, alterPartition, alterPartitionColumnStatistics, alterPartitionStatistics, alterTableColumnStatistics, alterTableStatistics, close, createFunction, createPartition, dropDatabase, dropFunction, dropPartition, functionExists, getFunction, getPartition, getPartitionColumnStatistics, getPartitionStatistics, getTableColumnStatistics, getTableStatistics, listFunctions, listPartitions, listPartitions, listPartitionsByFilter, partitionExists, sinkBatch, sinkStream, sourceBatch, sourceStream

Methods inherited from class com.alibaba.alink.common.io.catalog.BaseCatalog

genRandomCatalogName, getParams, of

Methods inherited from class org.apache.flink.table.catalog.AbstractCatalog

getDefaultDatabase, getName

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.apache.flink.table.catalog.Catalog

getFactory, getFunctionDefinitionFactory, getTableFactory

Field Detail

SQL_LITE_INT

public static final String SQL_LITE_INT

Ref: https://www.sqlite.org/datatype3.html

See Also:

Constant Field Values

SQL_LITE_INTEGER

public static final String SQL_LITE_INTEGER

See Also:

Constant Field Values

SQL_LITE_TINYINT

public static final String SQL_LITE_TINYINT

See Also:

Constant Field Values

SQL_LITE_SMALLINT

public static final String SQL_LITE_SMALLINT

See Also:

Constant Field Values

SQL_LITE_MEDIUMINT

public static final String SQL_LITE_MEDIUMINT

See Also:

Constant Field Values

SQL_LITE_BIGINT

public static final String SQL_LITE_BIGINT

See Also:

Constant Field Values

SQL_LITE_UNSIGNED_BIG_INT

public static final String SQL_LITE_UNSIGNED_BIG_INT

See Also:

Constant Field Values

SQL_LITE_INT2

public static final String SQL_LITE_INT2

See Also:

Constant Field Values

SQL_LITE_INT8

public static final String SQL_LITE_INT8

See Also:

Constant Field Values

SQL_LITE_CHARACTER

public static final String SQL_LITE_CHARACTER

See Also:

Constant Field Values

SQL_LITE_VARCHAR

public static final String SQL_LITE_VARCHAR

See Also:

Constant Field Values

SQL_LITE_VARYING_CHARACTER

public static final String SQL_LITE_VARYING_CHARACTER

See Also:

Constant Field Values

SQL_LITE_NCHAR

public static final String SQL_LITE_NCHAR

See Also:

Constant Field Values

SQL_LITE_NATIVE_CHARACTER

public static final String SQL_LITE_NATIVE_CHARACTER

See Also:

Constant Field Values

SQL_LITE_NVARCHAR

public static final String SQL_LITE_NVARCHAR

See Also:

Constant Field Values

SQL_LITE_TEXT

public static final String SQL_LITE_TEXT

See Also:

Constant Field Values

SQL_LITE_CLOB

public static final String SQL_LITE_CLOB

See Also:

Constant Field Values

SQL_LITE_BLOB

public static final String SQL_LITE_BLOB

See Also:

Constant Field Values

SQL_LITE_NO_DATATYPE_SPECIFIED

public static final String SQL_LITE_NO_DATATYPE_SPECIFIED

See Also:

Constant Field Values

SQL_LITE_REAL

public static final String SQL_LITE_REAL

See Also:

Constant Field Values

SQL_LITE_DOUBLE

public static final String SQL_LITE_DOUBLE

See Also:

Constant Field Values

SQL_LITE_DOUBLE_PRECISION

public static final String SQL_LITE_DOUBLE_PRECISION

See Also:

Constant Field Values

SQL_LITE_FLOAT

public static final String SQL_LITE_FLOAT

See Also:

Constant Field Values

SQL_LITE_NUMERIC

public static final String SQL_LITE_NUMERIC

See Also:

Constant Field Values

SQL_LITE_DECIMAL

public static final String SQL_LITE_DECIMAL

See Also:

Constant Field Values

SQL_LITE_BOOLEAN

public static final String SQL_LITE_BOOLEAN

See Also:

Constant Field Values

SQL_LITE_DATE

public static final String SQL_LITE_DATE

See Also:

Constant Field Values

SQL_LITE_DATETIME

public static final String SQL_LITE_DATETIME

See Also:

Constant Field Values

SQL_LITE_VARBINARY

public static final String SQL_LITE_VARBINARY

See Also:

Constant Field Values

SQL_LITE_TIME

public static final String SQL_LITE_TIME

See Also:

Constant Field Values

SQL_LITE_TIMESTAMP

public static final String SQL_LITE_TIMESTAMP

See Also:

Constant Field Values

Constructor Detail

SqliteCatalog

public SqliteCatalog(String catalogName,
                     String defaultDatabase,
                     String[] dbUrls,
                     String userName,
                     String password)

SqliteCatalog

public SqliteCatalog(Params params)

Method Detail

parseDbNameFromUrl

public static String parseDbNameFromUrl(String url)

open

public void open()
          throws org.apache.flink.table.catalog.exceptions.CatalogException

Throws:

org.apache.flink.table.catalog.exceptions.CatalogException

getDatabase

public org.apache.flink.table.catalog.CatalogDatabase getDatabase(String databaseName)
                                                           throws org.apache.flink.table.catalog.exceptions.DatabaseNotExistException,
                                                                  org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

getDatabase in interface org.apache.flink.table.catalog.Catalog

Overrides:

getDatabase in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.DatabaseNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException

listDatabases

public List<String> listDatabases()
                           throws org.apache.flink.table.catalog.exceptions.CatalogException

Throws:

org.apache.flink.table.catalog.exceptions.CatalogException

createDatabase

public void createDatabase(String name,
                           org.apache.flink.table.catalog.CatalogDatabase database,
                           boolean ignoreIfExists)
                    throws org.apache.flink.table.catalog.exceptions.DatabaseAlreadyExistException,
                           org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

createDatabase in interface org.apache.flink.table.catalog.Catalog

Overrides:

createDatabase in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.DatabaseAlreadyExistException

org.apache.flink.table.catalog.exceptions.CatalogException

databaseExists

public boolean databaseExists(String databaseName)
                       throws org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

databaseExists in interface org.apache.flink.table.catalog.Catalog

Overrides:

databaseExists in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.CatalogException

dropDatabase

public void dropDatabase(String name,
                         boolean ignoreIfNotExists)
                  throws org.apache.flink.table.catalog.exceptions.DatabaseNotExistException,
                         org.apache.flink.table.catalog.exceptions.DatabaseNotEmptyException,
                         org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

dropDatabase in interface org.apache.flink.table.catalog.Catalog

Overrides:

dropDatabase in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.DatabaseNotExistException

org.apache.flink.table.catalog.exceptions.DatabaseNotEmptyException

org.apache.flink.table.catalog.exceptions.CatalogException

alterDatabase

public void alterDatabase(String name,
                          org.apache.flink.table.catalog.CatalogDatabase newDatabase,
                          boolean ignoreIfNotExists)
                   throws org.apache.flink.table.catalog.exceptions.DatabaseNotExistException,
                          org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

alterDatabase in interface org.apache.flink.table.catalog.Catalog

Overrides:

alterDatabase in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.DatabaseNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException

listTables

public List<String> listTables(String databaseName)
                        throws org.apache.flink.table.catalog.exceptions.DatabaseNotExistException,
                               org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

listTables in interface org.apache.flink.table.catalog.Catalog

Overrides:

listTables in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.DatabaseNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException

tableExists

public boolean tableExists(org.apache.flink.table.catalog.ObjectPath tablePath)
                    throws org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

tableExists in interface org.apache.flink.table.catalog.Catalog

Overrides:

tableExists in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.CatalogException

createTable

public void createTable(org.apache.flink.table.catalog.ObjectPath tablePath,
                        org.apache.flink.table.catalog.CatalogBaseTable table,
                        boolean ignoreIfExists)
                 throws org.apache.flink.table.catalog.exceptions.TableAlreadyExistException,
                        org.apache.flink.table.catalog.exceptions.DatabaseNotExistException,
                        org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

createTable in interface org.apache.flink.table.catalog.Catalog

Overrides:

createTable in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.TableAlreadyExistException

org.apache.flink.table.catalog.exceptions.DatabaseNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException

getTable

public org.apache.flink.table.catalog.CatalogBaseTable getTable(org.apache.flink.table.catalog.ObjectPath tablePath)
                                                         throws org.apache.flink.table.catalog.exceptions.TableNotExistException,
                                                                org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

getTable in interface org.apache.flink.table.catalog.Catalog

Overrides:

getTable in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.TableNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException

dropTable

public void dropTable(org.apache.flink.table.catalog.ObjectPath tablePath,
                      boolean ignoreIfNotExists)
               throws org.apache.flink.table.catalog.exceptions.TableNotExistException,
                      org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

dropTable in interface org.apache.flink.table.catalog.Catalog

Overrides:

dropTable in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.TableNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException

renameTable

public void renameTable(org.apache.flink.table.catalog.ObjectPath tablePath,
                        String newTableName,
                        boolean ignoreIfNotExists)
                 throws org.apache.flink.table.catalog.exceptions.TableNotExistException,
                        org.apache.flink.table.catalog.exceptions.TableAlreadyExistException,
                        org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

renameTable in interface org.apache.flink.table.catalog.Catalog

Overrides:

renameTable in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.TableNotExistException

org.apache.flink.table.catalog.exceptions.TableAlreadyExistException

org.apache.flink.table.catalog.exceptions.CatalogException

alterTable

public void alterTable(org.apache.flink.table.catalog.ObjectPath tablePath,
                       org.apache.flink.table.catalog.CatalogBaseTable newTable,
                       boolean ignoreIfNotExists)
                throws org.apache.flink.table.catalog.exceptions.TableNotExistException,
                       org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

alterTable in interface org.apache.flink.table.catalog.Catalog

Overrides:

alterTable in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.TableNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException

listViews

public List<String> listViews(String databaseName)
                       throws org.apache.flink.table.catalog.exceptions.DatabaseNotExistException,
                              org.apache.flink.table.catalog.exceptions.CatalogException

Specified by:

listViews in interface org.apache.flink.table.catalog.Catalog

Overrides:

listViews in class JdbcCatalog

Throws:

org.apache.flink.table.catalog.exceptions.DatabaseNotExistException

org.apache.flink.table.catalog.exceptions.CatalogException