Package org.sqlite.parser

Class DefaultSchemaProvider

java.lang.Object

org.sqlite.parser.DefaultSchemaProvider

All Implemented Interfaces:

SchemaProvider

public class DefaultSchemaProvider
extends Object
implements SchemaProvider

Constructor Summary

Constructors

Constructor	Description
DefaultSchemaProvider(Connection conn)

Method Summary

Modifier and Type	Method	Description
List<QualifiedName>	findTables(String dbName, String tableNamePattern)	Find all tables matching the specified pattern.
List<QualifiedName>	findTables(String dbName, String tableNamePattern, boolean all)
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)

Methods inherited from class java.lang.Object

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

Constructor Detail

DefaultSchemaProvider

public DefaultSchemaProvider(Connection conn)

Method Detail

findTables

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

Description copied from interface: SchemaProvider

Find all tables matching the specified pattern.

Specified by:

findTables in interface SchemaProvider

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

findTables

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

Throws:

SQLException

getDbName

public String getDbName(String dbName,
                        String tableName)
                 throws SQLException

Description copied from interface: SchemaProvider

Find the database containing this table.

Specified by:

getDbName in interface SchemaProvider

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

getDbNames

public List<String> getDbNames(String dbName)
                        throws SQLException

Description copied from interface: SchemaProvider

PRAGMA database_list

Specified by:

getDbNames in interface SchemaProvider

Parameters:

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

Throws:

SQLException

getSchema

public String getSchema(String dbName,
                        String tableName)
                 throws SQLException

Specified by:

getSchema in interface SchemaProvider

Parameters:

dbName - null means "main".

tableName - Table name

Returns:

SQL used to create the specified table

Throws:

SQLException