Package org.sqlite.parser

Interface SchemaProvider

All Known Implementing Classes:

DefaultSchemaProvider

public interface SchemaProvider

Method Summary

Modifier and Type	Method	Description
List<QualifiedName>	findTables(String dbName, String tableNamePattern)	Find all tables matching the specified pattern.
String	getDbName(String dbName, String tableName)	Find the database containing this table.
List<String>	getDbNames(String dbName)	PRAGMA database_list
String	getSchema(String dbName, String tableName)

Method Detail

findTables

List<QualifiedName> findTables(String dbName,
                               String tableNamePattern)
                        throws SQLException

Find all tables matching the specified pattern.

Parameters:

dbName - May be null to search in all databases, empty to search in "temp" and "main".

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

Throws:

SQLException

getDbName

String getDbName(String dbName,
                 String tableName)
          throws SQLException

Find the database containing this table.

Parameters:

dbName - May be null to search in all databases, empty to search in "temp" and "main".

tableName - Table name

Returns:

"temp" or "main" or attached database name. If there is no table matching tableName, the returned value is undefined.

Throws:

SQLException

getSchema

String getSchema(String dbName,
                 String tableName)
          throws SQLException

Parameters:

dbName - null means "main".

tableName - Table name

Returns:

SQL used to create the specified table

Throws:

SQLException

getDbNames

List<String> getDbNames(String dbName)
                 throws SQLException

PRAGMA database_list

Parameters:

dbName - May be null to search in all databases, empty to search in "temp" and "main".

Throws:

SQLException