Class SqlJetSchema
- java.lang.Object
-
- org.tmatesoft.sqljet.core.internal.schema.SqlJetSchema
-
- All Implemented Interfaces:
ISqlJetSchema
public class SqlJetSchema extends java.lang.Object implements ISqlJetSchema
-
-
Field Summary
Fields Modifier and Type Field Description static java.util.Set<SqlJetBtreeTableCreateFlags>BTREE_CREATE_INDEX_FLAGSstatic java.util.Set<SqlJetBtreeTableCreateFlags>BTREE_CREATE_TABLE_FLAGS
-
Constructor Summary
Constructors Constructor Description SqlJetSchema(ISqlJetDbHandle db, ISqlJetBtree btree)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description ISqlJetTableDefalterTable(java.lang.String sql)ISqlJetIndexDefcreateIndex(java.lang.String sql)ISqlJetIndexDefcreateIndexForVirtualTable(java.lang.String virtualTableName, java.lang.String indexName)ISqlJetTableDefcreateTable(java.lang.String sql)ISqlJetTriggerDefcreateTrigger(java.lang.String sql)ISqlJetViewDefcreateView(java.lang.String sql)ISqlJetVirtualTableDefcreateVirtualTable(java.lang.String sql, int page)voiddropIndex(java.lang.String indexName)voiddropTable(java.lang.String tableName)voiddropTrigger(java.lang.String triggerName)voiddropView(java.lang.String viewName)ISqlJetBtreegetBtree()ISqlJetDbHandlegetDb()ISqlJetIndexDefgetIndex(java.lang.String name)Get index definition by name.java.util.Set<ISqlJetIndexDef>getIndexes(java.lang.String tableName)Get indices related with table.java.util.Set<java.lang.String>getIndexNames()Get indices names.ISqlJetTableDefgetTable(java.lang.String name)Get table definition by name.java.util.Set<java.lang.String>getTableNames()Get tables names.ISqlJetTriggerDefgetTrigger(java.lang.String name)Get trigger definition by name.java.util.Set<java.lang.String>getTriggerNames()ISqlJetViewDefgetView(java.lang.String name)Get view definition by name.java.util.Set<java.lang.String>getViewNames()ISqlJetVirtualTableDefgetVirtualTable(java.lang.String name)java.util.Set<java.lang.String>getVirtualTableNames()booleanisNameReserved(java.lang.String name)Returns true if name is reserved for internal use.ISqlJetBtreeDataTableopenSequenceTable()java.lang.StringtoString()
-
-
-
Field Detail
-
BTREE_CREATE_TABLE_FLAGS
public static final java.util.Set<SqlJetBtreeTableCreateFlags> BTREE_CREATE_TABLE_FLAGS
-
BTREE_CREATE_INDEX_FLAGS
public static final java.util.Set<SqlJetBtreeTableCreateFlags> BTREE_CREATE_INDEX_FLAGS
-
-
Constructor Detail
-
SqlJetSchema
public SqlJetSchema(ISqlJetDbHandle db, ISqlJetBtree btree) throws SqlJetException
- Throws:
SqlJetException
-
-
Method Detail
-
getDb
public ISqlJetDbHandle getDb()
-
getBtree
public ISqlJetBtree getBtree()
-
getTableNames
public java.util.Set<java.lang.String> getTableNames() throws SqlJetExceptionDescription copied from interface:ISqlJetSchemaGet tables names.- Specified by:
getTableNamesin interfaceISqlJetSchema- Returns:
- tables names.
- Throws:
SqlJetException
-
getTable
public ISqlJetTableDef getTable(java.lang.String name) throws SqlJetException
Description copied from interface:ISqlJetSchemaGet table definition by name.- Specified by:
getTablein interfaceISqlJetSchema- Parameters:
name- table name- Returns:
- table definition
- Throws:
SqlJetException
-
getIndexNames
public java.util.Set<java.lang.String> getIndexNames() throws SqlJetExceptionDescription copied from interface:ISqlJetSchemaGet indices names.- Specified by:
getIndexNamesin interfaceISqlJetSchema- Returns:
- indices names.
- Throws:
SqlJetException
-
getIndex
public ISqlJetIndexDef getIndex(java.lang.String name) throws SqlJetException
Description copied from interface:ISqlJetSchemaGet index definition by name.- Specified by:
getIndexin interfaceISqlJetSchema- Parameters:
name- index name- Returns:
- index definition
- Throws:
SqlJetException
-
getIndexes
public java.util.Set<ISqlJetIndexDef> getIndexes(java.lang.String tableName) throws SqlJetException
Description copied from interface:ISqlJetSchemaGet indices related with table.- Specified by:
getIndexesin interfaceISqlJetSchema- Parameters:
tableName- table name- Returns:
- indices of table
- Throws:
SqlJetException
-
getVirtualTableNames
public java.util.Set<java.lang.String> getVirtualTableNames() throws SqlJetException- Specified by:
getVirtualTableNamesin interfaceISqlJetSchema- Returns:
- Set of virtual table names defined in this schema.
- Throws:
SqlJetException
-
getVirtualTable
public ISqlJetVirtualTableDef getVirtualTable(java.lang.String name) throws SqlJetException
- Specified by:
getVirtualTablein interfaceISqlJetSchema- Returns:
- definition of the virtual table
name. - Throws:
SqlJetException
-
getView
public ISqlJetViewDef getView(java.lang.String name) throws SqlJetException
Description copied from interface:ISqlJetSchemaGet view definition by name.- Specified by:
getViewin interfaceISqlJetSchema- Parameters:
name- view name- Returns:
- view definition
- Throws:
SqlJetException
-
getViewNames
public java.util.Set<java.lang.String> getViewNames() throws SqlJetException- Specified by:
getViewNamesin interfaceISqlJetSchema- Returns:
- Set of view names defined in this schema.
- Throws:
SqlJetException
-
getTrigger
public ISqlJetTriggerDef getTrigger(java.lang.String name) throws SqlJetException
Description copied from interface:ISqlJetSchemaGet trigger definition by name.- Specified by:
getTriggerin interfaceISqlJetSchema- Parameters:
name- trigger name- Returns:
- trigger definition
- Throws:
SqlJetException
-
getTriggerNames
public java.util.Set<java.lang.String> getTriggerNames() throws SqlJetException- Specified by:
getTriggerNamesin interfaceISqlJetSchema- Returns:
- Set of trigger names defined in this schema.
- Throws:
SqlJetException
-
toString
public java.lang.String toString()
- Overrides:
toStringin classjava.lang.Object
-
createTable
public ISqlJetTableDef createTable(java.lang.String sql) throws SqlJetException
- Throws:
SqlJetException
-
openSequenceTable
public ISqlJetBtreeDataTable openSequenceTable() throws SqlJetException
- Throws:
SqlJetException
-
createIndex
public ISqlJetIndexDef createIndex(java.lang.String sql) throws SqlJetException
- Throws:
SqlJetException
-
dropTable
public void dropTable(java.lang.String tableName) throws SqlJetException- Throws:
SqlJetException
-
dropIndex
public void dropIndex(java.lang.String indexName) throws SqlJetException- Throws:
SqlJetException
-
alterTable
public ISqlJetTableDef alterTable(java.lang.String sql) throws SqlJetException
- Throws:
SqlJetException
-
createVirtualTable
public ISqlJetVirtualTableDef createVirtualTable(java.lang.String sql, int page) throws SqlJetException
- Throws:
SqlJetException
-
createView
public ISqlJetViewDef createView(java.lang.String sql) throws SqlJetException
- Throws:
SqlJetException
-
isNameReserved
public boolean isNameReserved(java.lang.String name)
Returns true if name is reserved for internal use.- Parameters:
name-- Returns:
- true if name is reserved
-
createIndexForVirtualTable
public ISqlJetIndexDef createIndexForVirtualTable(java.lang.String virtualTableName, java.lang.String indexName) throws SqlJetException
- Throws:
SqlJetException
-
dropView
public void dropView(java.lang.String viewName) throws SqlJetException- Throws:
SqlJetException
-
dropTrigger
public void dropTrigger(java.lang.String triggerName) throws SqlJetException- Throws:
SqlJetException
-
createTrigger
public ISqlJetTriggerDef createTrigger(java.lang.String sql) throws SqlJetException
- Throws:
SqlJetException
-
-