Package org.sqlite.parser

Class EnhancedPragma

java.lang.Object

org.sqlite.parser.EnhancedPragma

public class EnhancedPragma
extends Object

Constructor Summary

Constructors

Constructor	Description
EnhancedPragma()

Method Summary

Modifier and Type	Method	Description
static Select	getCrossReference(String parentCatalog, String parentTable, String foreignCatalog, String foreignTable, SchemaProvider schemaProvider)	Like PRAGMA catalog.foreign_key_list(tableName) but enhanced for DatabaseMetaData.getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)
static Select	getImportedKeys(String catalog, String tableName, SchemaProvider schemaProvider)	Like PRAGMA catalog.foreign_key_list(tableName) but enhanced for DatabaseMetaData.getImportedKeys(java.lang.String, java.lang.String, java.lang.String)
static Select	getPrimaryKeys(String catalog, String table, SchemaProvider schemaProvider)	Like PRAGMA catalog.table_info(tableName) but enhanced for DatabaseMetaData.getPrimaryKeys(java.lang.String, java.lang.String, java.lang.String)
static Select	tableInfo(String catalog, String tableNamePattern, String columnNamePattern, SchemaProvider schemaProvider)	Like PRAGMA catalog.table_info(tableName) but enhanced for DatabaseMetaData.getColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)

Methods inherited from class java.lang.Object

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

Constructor Detail

EnhancedPragma

public EnhancedPragma()

Method Detail

tableInfo

public static Select tableInfo(String catalog,
                               String tableNamePattern,
                               String columnNamePattern,
                               SchemaProvider schemaProvider)
                        throws SQLException

Like PRAGMA catalog.table_info(tableName) but enhanced for DatabaseMetaData.getColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)

Parameters:

catalog - Table catalog

tableNamePattern - LIKE pattern. May be null to retrieve all tables.

columnNamePattern - LIKE pattern. May be null to retrieve all columns.

schemaProvider - Given one table's name, returns its schema.

Returns:

Dynamic select that generates a ResultSet for DatabaseMetaData.getColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)

Throws:

SQLException

getPrimaryKeys

public static Select getPrimaryKeys(String catalog,
                                    String table,
                                    SchemaProvider schemaProvider)
                             throws SQLException

Like PRAGMA catalog.table_info(tableName) but enhanced for DatabaseMetaData.getPrimaryKeys(java.lang.String, java.lang.String, java.lang.String)

Parameters:

catalog - Table catalog

table - Name of the table where primary key(s) are declared.

schemaProvider - Given one table's name, returns its schema.

Returns:

Dynamic select that generates a ResultSet for DatabaseMetaData.getPrimaryKeys(java.lang.String, java.lang.String, java.lang.String)

Throws:

SQLException

getCrossReference

public static Select getCrossReference(String parentCatalog,
                                       String parentTable,
                                       String foreignCatalog,
                                       String foreignTable,
                                       SchemaProvider schemaProvider)
                                throws SQLException

Like PRAGMA catalog.foreign_key_list(tableName) but enhanced for DatabaseMetaData.getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)

Parameters:

parentCatalog - Parent table catalog

parentTable - Name of the parent table where primary/unique key(s) are declared.

foreignCatalog - Child table catalog

foreignTable - Name of the parent table where foreign key(s) are declared.

schemaProvider - Given one table's name, returns its schema.

Returns:

Dynamic select that generates a ResultSet for DatabaseMetaData.getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)

Throws:

SQLException

getImportedKeys

public static Select getImportedKeys(String catalog,
                                     String tableName,
                                     SchemaProvider schemaProvider)
                              throws SQLException

Like PRAGMA catalog.foreign_key_list(tableName) but enhanced for DatabaseMetaData.getImportedKeys(java.lang.String, java.lang.String, java.lang.String)

Parameters:

catalog - Tables catalog

tableName - Name of the table where foreign key(s) are declared.

schemaProvider - Given one parent table's name (that a foreign key constraint refers to), returns its schema.

Returns:

Dynamic select that generates a ResultSet for DatabaseMetaData.getImportedKeys(java.lang.String, java.lang.String, java.lang.String)

Throws:

SQLException