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 parentDbName, String parentTable, String foreignDbName, String foreignTable, SchemaProvider schemaProvider)	Like PRAGMA dbName.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 dbName, String tableName, SchemaProvider schemaProvider)	Like PRAGMA dbName.foreign_key_list(tableName) but enhanced for DatabaseMetaData.getImportedKeys(java.lang.String, java.lang.String, java.lang.String)
static Select	getPrimaryKeys(String dbName, String table, SchemaProvider schemaProvider)	Like PRAGMA dbName.table_info(tableName) but enhanced for DatabaseMetaData.getPrimaryKeys(java.lang.String, java.lang.String, java.lang.String)
static Select	tableInfo(String dbName, String tableNamePattern, String columnNamePattern, SchemaProvider schemaProvider)	Like PRAGMA dbName.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 Details

EnhancedPragma

public EnhancedPragma()

Method Details

tableInfo

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

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

Parameters:

dbName - Table dbName

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 dbName,
 String table,
 SchemaProvider schemaProvider)
                             throws SQLException

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

Parameters:

dbName - Table dbName

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 parentDbName,
 String parentTable,
 String foreignDbName,
 String foreignTable,
 SchemaProvider schemaProvider)
                                throws SQLException

Like PRAGMA dbName.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:

parentDbName - Parent table dbName

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

foreignDbName - Child table dbName

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 dbName,
 String tableName,
 SchemaProvider schemaProvider)
                              throws SQLException

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

Parameters:

dbName - Tables dbName

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