Package | Description |
---|---|
com.mckoi.database |
The core database classes for Mckoi.
|
com.mckoi.database.interpret |
Modifier and Type | Field and Description |
---|---|
static TableName |
TableDataConglomerate.CHECK_INFO_TABLE |
static TableName |
TableDataConglomerate.FOREIGN_COLS_TABLE |
static TableName |
TableDataConglomerate.FOREIGN_INFO_TABLE |
TableName |
Transaction.ColumnGroupReference.key_table_name
The key table name.
|
static TableName |
Database.NEW_TRIGGER_TABLE
The NEW table used inside a triggered procedure to represent a triggered
row after the operation occurs.
|
static TableName |
Database.OLD_TRIGGER_TABLE
The OLD table used inside a triggered procedure to represent a triggered
row before the operation occurs.
|
static TableName |
TableDataConglomerate.PERSISTENT_VAR_TABLE |
static TableName |
TableDataConglomerate.PRIMARY_COLS_TABLE |
static TableName |
TableDataConglomerate.PRIMARY_INFO_TABLE |
TableName |
Transaction.ColumnGroupReference.ref_table_name
The referenced table name.
|
static TableName |
TableDataConglomerate.SCHEMA_INFO_TABLE
The schema info table.
|
static TableName |
Database.SYS_DATA_TRIGGER
The system internally generated 'sUSRDataTrigger' table.
|
static TableName |
Database.SYS_DB_STATISTICS
The system internally generated 'sUSRDatabaseStatistics' table.
|
static TableName |
Database.SYS_FUNCTION
The function table.
|
static TableName |
Database.SYS_FUNCTIONFACTORY
The function factory table.
|
static TableName |
Database.SYS_GRANTS |
static TableName |
Database.SYS_LABEL
The label table.
|
static TableName |
Database.SYS_PASSWORD
The password privs and grants table.
|
static TableName |
TableDataConglomerate.SYS_SEQUENCE |
static TableName |
TableDataConglomerate.SYS_SEQUENCE_INFO |
static TableName |
Database.SYS_SERVICE
The services table.
|
static TableName |
Database.SYS_TABLE_COLUMNS
The system internally generated 'sUSRTableColumns' table.
|
static TableName |
Database.SYS_TABLE_INFO
The system internally generated 'sUSRTableInfo' table.
|
static TableName |
Database.SYS_USERCONNECT |
static TableName |
Database.SYS_USERPRIV |
static TableName |
Database.SYS_VIEW
The view table.
|
static TableName |
TableDataConglomerate.UNIQUE_COLS_TABLE |
static TableName |
TableDataConglomerate.UNIQUE_INFO_TABLE |
Modifier and Type | Method and Description |
---|---|
protected TableName[] |
Transaction.getDynamicTableList()
Returns a list of all dynamic table names.
|
protected TableName[] |
SimpleTransaction.getDynamicTableList()
Returns a list of all dynamic table names.
|
TableName |
JoiningSet.getFirstTable()
Returns the first table in the join set.
|
TableName |
JoiningSet.getTable(int n)
Returns table 'n' in the result set where table 0 is the first table in
the join set.
|
TableName[] |
DatabaseConnection.getTableList()
Returns a TableName[] array that contains the list of database
tables that are visible by this transaction.
|
TableName[] |
SimpleTransaction.getTableList()
Returns a list of table names that are visible within this transaction.
|
TableName |
AbstractDataTable.getTableName()
Returns the fully resolved table name.
|
TableName |
DataTableDef.getTableName() |
TableName |
TableCommitModificationEvent.getTableName()
Returns the name of the table.
|
TableName |
ReferenceTable.getTableName()
Filters the name of the table.
|
TableName |
TableModificationEvent.getTableName()
Returns the name of the table of this modification.
|
TableName |
Variable.getTableName()
Returns the TableName context.
|
static TableName[] |
Transaction.queryTablesRelationallyLinkedTo(SimpleTransaction transaction,
TableName table)
Returns the list of tables (as a TableName array) that are dependant
on the data in the given table to maintain referential consistancy.
|
TableName[] |
DatabaseConnection.queryTablesRelationallyLinkedTo(TableName table)
Same as the Transaction.queryTablesRelationallyLinkedTo method.
|
static TableName |
TableName.resolve(String namev)
Resolves a [schema name].[table name] type syntax to a TableName
object.
|
static TableName |
TableName.resolve(String schemav,
String namev)
Resolves a [schema name].[table name] type syntax to a TableName
object.
|
TableName |
TableName.resolveSchema(String scheman)
Resolves a schema reference in a table name.
|
TableName |
DatabaseConnection.resolveTableName(String name)
Resolves a TableName string (eg.
|
TableName |
DatabaseConnection.resolveToTableName(String name)
Resolves the given string to a table name, throwing an exception if
the reference is ambiguous.
|
TableName |
SimpleTransaction.resolveToTableName(String current_schema,
String name,
boolean case_insensitive)
Resolves the given string to a table name, throwing an exception if
the reference is ambiguous.
|
TableName |
DatabaseConnection.tryResolveCase(TableName table_name)
Attempts to resolve the given table name to its correct case assuming
the table name represents a case insensitive version of the name.
|
TableName |
SimpleTransaction.tryResolveCase(TableName table_name)
Attempts to resolve the given table name to its correct case assuming
the table name represents a case insensitive version of the name.
|
Modifier and Type | Method and Description |
---|---|
void |
DatabaseConnection.addCheckConstraint(TableName table_name,
Expression expression,
short deferred,
String constraint_name)
Same as the Transaction.addCheckConstraint method.
|
void |
Transaction.addCheckConstraint(TableName table_name,
Expression expression,
short deferred,
String constraint_name)
Adds a check expression that becomes perminent when the transaction
is committed.
|
void |
DatabaseConnection.addForeignKeyConstraint(TableName table,
String[] cols,
TableName ref_table,
String[] ref_cols,
String delete_rule,
String update_rule,
short deferred,
String constraint_name)
Same as the Transaction.addForeignKeyConstraint method.
|
void |
Transaction.addForeignKeyConstraint(TableName table,
String[] cols,
TableName ref_table,
String[] ref_cols,
String delete_rule,
String update_rule,
short deferred,
String constraint_name)
Adds a foreign key constraint to the database which becomes perminent
when the transaction is committed.
|
void |
DatabaseConnection.addPrimaryKeyConstraint(TableName table_name,
String[] cols,
short deferred,
String constraint_name)
Same as the Transaction.addPrimaryKeyConstraint method.
|
void |
Transaction.addPrimaryKeyConstraint(TableName table_name,
String[] cols,
short deferred,
String constraint_name)
Adds a primary key constraint that becomes perminent when the transaction
is committed.
|
void |
DatabaseConnection.addSelectedFromTable(TableName name)
Adds the given table name to the list of tables that are selected from
within the transaction in this connection.
|
void |
Transaction.addSelectedFromTable(TableName table_name)
Called by the query evaluation layer when information is selected
from this table as part of this transaction.
|
void |
JoiningSet.addTable(TableName table_name)
Adds a new table into the set being joined.
|
void |
TableDataConglomerate.addTransactionModificationListener(TableName table_name,
TransactionModificationListener listener)
Adds a listener for transactional modification events that occur on the
given table in this conglomerate.
|
void |
DatabaseConnection.addUniqueConstraint(TableName table_name,
String[] cols,
short deferred,
String constraint_name)
Same as the Transaction.addUniqueConstraint method.
|
void |
Transaction.addUniqueConstraint(TableName table_name,
String[] cols,
short deferred,
String constraint_name)
Adds a unique constraint to the database which becomes perminant when
the transaction is committed.
|
void |
Transaction.alterTable(TableName table_name,
DataTableDef table_def)
Alters the table with the given name within this transaction to the
specified table definition.
|
void |
Transaction.alterTable(TableName table_name,
DataTableDef table_def,
int data_sector_size,
int index_sector_size)
Alter the table with the given name to the new definition and give the
copied table a new data sector size.
|
boolean |
Database.canUserAlterTableObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can alter a table or view with the given name,
otherwise returns false.
|
boolean |
Database.canUserCompactTableObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can compact a table with the given name,
otherwise returns false.
|
boolean |
Database.canUserCreateProcedureObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can create a procedure with the given name,
otherwise returns false.
|
boolean |
Database.canUserCreateSequenceObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can create a sequence with the given name,
otherwise returns false.
|
boolean |
Database.canUserCreateTableObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can create a table or view with the given name,
otherwise returns false.
|
boolean |
Database.canUserDeleteFromTableObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can delete from a table or view with the given
name and given columns, otherwise returns false.
|
boolean |
Database.canUserDropProcedureObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can drop a procedure with the given name,
otherwise returns false.
|
boolean |
Database.canUserDropSequenceObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can drop a sequence with the given name,
otherwise returns false.
|
boolean |
Database.canUserDropTableObject(DatabaseQueryContext context,
User user,
TableName table)
Returns true if the user can drop a table or view with the given name,
otherwise returns false.
|
boolean |
Database.canUserInsertIntoTableObject(DatabaseQueryContext context,
User user,
TableName table,
Variable[] columns)
Returns true if the user can insert into a table or view with the given
name and given columns, otherwise returns false.
|
boolean |
Database.canUserSelectFromTableObject(DatabaseQueryContext context,
User user,
TableName table,
Variable[] columns)
Returns true if the user can select from a table or view with the given
name and given columns, otherwise returns false.
|
boolean |
Database.canUserUpdateTableObject(DatabaseQueryContext context,
User user,
TableName table,
Variable[] columns)
Returns true if the user can update a table or view with the given
name and given columns, otherwise returns false.
|
void |
DatabaseConnection.checkAllConstraints(TableName table_name)
Checks all the rows in the table for immediate constraint violations
and when the transaction is next committed check for all deferred
constraint violations.
|
void |
Transaction.checkAllConstraints(TableName table_name)
Checks all the rows in the table for immediate constraint violations
and when the transaction is next committed check for all deferred
constraint violations.
|
void |
DatabaseConnection.compactTable(TableName table_name)
Compacts the table with the given name.
|
void |
Transaction.compactTable(TableName table_name)
Compacts the table with the given name within this transaction.
|
QueryPlanNode |
DatabaseConnection.createObjectFetchQueryPlan(TableName table_name,
TableName aliased_name)
Creates a QueryPlanNode to fetch the given table object from this
connection.
|
void |
DatabaseConnection.createSequenceGenerator(TableName name,
long start_value,
long increment_by,
long min_value,
long max_value,
long cache,
boolean cycle)
Creates a new sequence generator with the given TableName and
initializes it with the given details.
|
void |
Transaction.createSequenceGenerator(TableName name,
long start_value,
long increment_by,
long min_value,
long max_value,
long cache,
boolean cycle)
Creates a new sequence generator with the given TableName and
initializes it with the given details.
|
void |
ConnectionTriggerManager.createTableTrigger(String schema,
String name,
int type,
TableName on_table,
String procedure_name,
TObject[] params)
Creates a new trigger action on a stored procedure and makes the change
to the transaction of this DatabaseConnection.
|
QueryPlanNode |
ViewManager.createViewQueryPlanNode(TableName view_name)
Returns a freshly deserialized QueryPlanNode object for the given view
object.
|
QueryPlanNode |
DatabaseQueryContext.createViewQueryPlanNode(TableName name)
Creates a QueryPlanNode for the view with the given name.
|
long |
SimpleTransaction.currentUniqueID(TableName table_name)
Returns the current unique id for the given table name.
|
ReferenceTable |
DataTable.declareAs(TableName new_name)
We can declare a DataTable as a new type.
|
boolean |
ViewManager.deleteView(TableName view_name)
Deletes the view with the given name, or returns false if no entries were
deleted from the view table.
|
void |
DatabaseConnection.dropAllConstraintsForTable(TableName table_name)
Same as the Transaction.dropAllConstraintsForTable method.
|
void |
Transaction.dropAllConstraintsForTable(TableName table_name)
Drops all the constraints defined for the given table.
|
boolean |
Transaction.dropCheckConstraintForTable(TableName table,
String constraint_name)
Drops a single named check constraint from the given table.
|
boolean |
Transaction.dropForeignKeyReferenceConstraintForTable(TableName table,
String constraint_name)
Drops a single named foreign key reference from the given table.
|
int |
DatabaseConnection.dropNamedConstraint(TableName table_name,
String constraint_name)
Same as the Transaction.dropNamedConstraint method.
|
int |
Transaction.dropNamedConstraint(TableName table_name,
String constraint_name)
Drops the named constraint from the transaction.
|
boolean |
DatabaseConnection.dropPrimaryKeyConstraintForTable(TableName table_name,
String constraint_name)
Same as the Transaction.dropPrimaryKeyConstraintForTable method.
|
boolean |
Transaction.dropPrimaryKeyConstraintForTable(TableName table_name,
String constraint_name)
Drops the primary key constraint for the given table.
|
void |
DatabaseConnection.dropSequenceGenerator(TableName name)
Drops an existing sequence generator with the given name.
|
void |
Transaction.dropSequenceGenerator(TableName name)
Drops an existing sequence generator with the given name.
|
void |
DatabaseConnection.dropTable(TableName table_name)
Drops a table from within the context of the current connection
transaction.
|
void |
Transaction.dropTable(TableName table_name)
Drops a table within this transaction.
|
boolean |
Transaction.dropUniqueConstraintForTable(TableName table,
String constraint_name)
Drops a single named unique constraint from the given table.
|
boolean |
DatabaseConnection.dropView(TableName view_name)
Drops the view with the given name and returns true if the drop succeeded.
|
boolean |
TableName.equalsIgnoreCase(TableName tn)
Equality but ignore the case.
|
protected com.mckoi.database.MasterTableDataSource |
SimpleTransaction.findVisibleTable(TableName table_name,
boolean ignore_case)
Searches through the list of tables visible within this transaction and
returns the MasterTableDataSource object with the given name.
|
protected void |
SimpleTransaction.flushTableCache(TableName table_name)
Flushes the table cache and purges the cache of the entry for the given
table name.
|
DataTableDef |
DatabaseConnection.getDataTableDef(TableName name)
Returns the DataTableDef for the table with the given name.
|
DataTableDef |
SimpleTransaction.getDataTableDef(TableName table_name)
Returns the DataTableDef for the table with the given name that is
visible within this transaction.
|
DataTableDef |
DatabaseQueryContext.getDataTableDef(TableName name)
Returns a DataTableDef for the given table name.
|
protected DataTableDef |
Transaction.getDynamicDataTableDef(TableName table_name)
Returns the DataTableDef for the given internal table.
|
protected DataTableDef |
SimpleTransaction.getDynamicDataTableDef(TableName table_name)
Returns the DataTableDef for a dynamic table defined in this transaction.
|
protected MutableTableDataSource |
Transaction.getDynamicTable(TableName table_name)
Returns an instance of MutableDataTableSource that represents the
contents of the internal table with the given name.
|
protected MutableTableDataSource |
SimpleTransaction.getDynamicTable(TableName table_name)
If this transaction implementation defines dynamic tables (tables whose
content is determined by some function), this should return the
table here as a MutableTableDataSource object.
|
String |
Transaction.getDynamicTableType(TableName table_name)
Returns a string type describing the type of the dynamic table.
|
protected String |
SimpleTransaction.getDynamicTableType(TableName table_name)
Returns a string type describing the type of the dynamic table.
|
DataTable |
DatabaseConnection.getTable(TableName name)
Returns a DataTable that represents the table from the given schema,
name in the database.
|
MutableTableDataSource |
SimpleTransaction.getTable(TableName table_name)
Returns a MutableTableDataSource object that represents the table with
the given name within this transaction.
|
DataTable |
DatabaseQueryContext.getTable(TableName name)
Returns a DataTable from the database with the given table name.
|
TableDataSource |
SimpleTransaction.getTableDataSource(TableName table_name)
Returns a TableDataSource object that represents the table with the
given name within this transaction.
|
TableQueryDef |
DatabaseConnection.getTableQueryDef(TableName table_name,
TableName aliased_as)
Returns a TableQueryDef object that describes the characteristics of a
table including the name (TableName), the columns (DataTableDef) and the
query plan to produce the table (QueryPlanNode).
|
String |
DatabaseConnection.getTableType(TableName table_name)
Returns the type of the table object.
|
String |
SimpleTransaction.getTableType(TableName table_name)
Returns the type of the table object with the given name.
|
protected boolean |
Transaction.isDynamicTable(TableName table_name)
Returns true if the given table name represents a dynamically generated
system table.
|
protected boolean |
SimpleTransaction.isDynamicTable(TableName table_name)
Returns true if the given table name is a dynamically generated table and
is not a table that is found in the table list defined in this transaction
object.
|
long |
SimpleTransaction.lastSequenceValue(TableName name)
Returns the sequence value for the given sequence generator that
was last returned by a call to 'nextSequenceValue'.
|
long |
SimpleTransaction.nextSequenceValue(TableName name)
Requests of the sequence generator the next value from the sequence.
|
long |
DatabaseConnection.nextUniqueID(TableName name)
Returns the next unique identifier for the given table from the schema.
|
long |
SimpleTransaction.nextUniqueID(TableName table_name)
Atomically returns a unique id that can be used as a seed for a set of
unique identifiers for a table.
|
boolean |
ProcedureManager.procedureExists(TableName procedure_name)
Returns true if the procedure with the given table name exists.
|
static Transaction.CheckExpression[] |
Transaction.queryTableCheckExpressions(SimpleTransaction transaction,
TableName table_name)
Returns a set of check expressions that are constrained over all new
columns added to the given table in this transaction.
|
Transaction.CheckExpression[] |
DatabaseConnection.queryTableCheckExpressions(TableName table_name)
Same as the Transaction.queryTableCheckExpression method.
|
static Transaction.ColumnGroupReference[] |
Transaction.queryTableForeignKeyReferences(SimpleTransaction transaction,
TableName table_name)
Returns an array of column references in the given table that represent
foreign key references.
|
Transaction.ColumnGroupReference[] |
DatabaseConnection.queryTableForeignKeyReferences(TableName table_name)
Same as the Transaction.queryTableForeignKeyReferences method.
|
static Transaction.ColumnGroupReference[] |
Transaction.queryTableImportedForeignKeyReferences(SimpleTransaction transaction,
TableName ref_table_name)
Returns an array of column references in the given table that represent
foreign key references that reference columns in the given table.
|
Transaction.ColumnGroupReference[] |
DatabaseConnection.queryTableImportedForeignKeyReferences(TableName table_name)
Same as the Transaction.queryTableImportedForeignKeyReferences method.
|
static Transaction.ColumnGroup |
Transaction.queryTablePrimaryKeyGroup(SimpleTransaction transaction,
TableName table_name)
Returns a set of primary key groups that are constrained to be unique
for the given table in this transaction (there can be only 1 primary
key defined for a table).
|
Transaction.ColumnGroup |
DatabaseConnection.queryTablePrimaryKeyGroup(TableName table_name)
Same as the Transaction.queryTablePrimaryKeyGroup method.
|
static TableName[] |
Transaction.queryTablesRelationallyLinkedTo(SimpleTransaction transaction,
TableName table)
Returns the list of tables (as a TableName array) that are dependant
on the data in the given table to maintain referential consistancy.
|
TableName[] |
DatabaseConnection.queryTablesRelationallyLinkedTo(TableName table)
Same as the Transaction.queryTablesRelationallyLinkedTo method.
|
static Transaction.ColumnGroup[] |
Transaction.queryTableUniqueGroups(SimpleTransaction transaction,
TableName table_name)
Returns a set of unique groups that are constrained to be unique for
the given table in this transaction.
|
Transaction.ColumnGroup[] |
DatabaseConnection.queryTableUniqueGroups(TableName table_name)
Same as the Transaction.queryTableUniqueGroups method.
|
void |
TableDataConglomerate.removeTransactionModificationListener(TableName table_name,
TransactionModificationListener listener)
Removes a listener for transaction modification events on the given table
in this conglomerate as previously set by the
'addTransactionModificationListener' method.
|
static Variable |
Variable.resolve(TableName tname,
String name)
Attempts to resolve a string '[table_name].[column]' to a Variable
instance.
|
Variable |
Variable.resolveTableName(TableName tablen)
Returns a ColumnName that is resolved against a table name context only
if the ColumnName is unknown in this object.
|
void |
QueryPlan.SubsetNode.setGivenName(TableName name)
Sets the given table name of the resultant table.
|
void |
SimpleTransaction.setSequenceValue(TableName name,
long value)
Sets the sequence value for the given sequence generator.
|
void |
DataTableDef.setTableName(TableName name) |
void |
Variable.setTableName(TableName tname)
Sets the TableName of this variable.
|
void |
SimpleTransaction.setUniqueID(TableName table_name,
long unique_id)
Sets the unique id for the given table name.
|
boolean |
DatabaseConnection.tableExists(TableName table_name)
Returns true if the table exists within this connection transaction.
|
boolean |
SimpleTransaction.tableExists(TableName table_name)
Returns true if the database table object with the given name exists
within this transaction.
|
TableName |
DatabaseConnection.tryResolveCase(TableName table_name)
Attempts to resolve the given table name to its correct case assuming
the table name represents a case insensitive version of the name.
|
TableName |
SimpleTransaction.tryResolveCase(TableName table_name)
Attempts to resolve the given table name to its correct case assuming
the table name represents a case insensitive version of the name.
|
boolean |
ViewManager.viewExists(TableName view_name)
Returns true if the view with the given name exists.
|
Constructor and Description |
---|
DataIndexSetDef(TableName table_name)
Constructor.
|
FetchTableNode(TableName table_name,
TableName aliased_as) |
FetchViewNode(TableName table_name,
TableName aliased_as) |
ProcedureName(TableName table_name)
Constructs the ProcedureName from a TableName.
|
TableCommitModificationEvent(SimpleTransaction transaction,
TableName table_name,
int[] added,
int[] removed)
Constructs the event.
|
Variable(TableName table_name,
String column_name)
Constructs the ColumnName.
|
Modifier and Type | Method and Description |
---|---|
TableName |
FromTableDirectSource.getGivenTableName()
Returns the given name of the table.
|
TableName |
FromTableDirectSource.getRootTableName()
Returns the root name of the table.
|
Constructor and Description |
---|
FromTableDirectSource(DatabaseConnection connection,
TableQueryDef table_query,
String unique_name,
TableName given_name,
TableName root_name)
Constructs the source.
|
FromTableSubQuerySource(DatabaseConnection connection,
String unique_key,
TableSelectExpression table_expression,
com.mckoi.database.interpret.TableExpressionFromSet from_set,
TableName aliased_table_name)
Constructs the source.
|
Copyright © 2015. All rights reserved.