void |
DatabaseConnection.addCheckConstraint(TableName table_name,
Expression expression,
short deferred,
java.lang.String constraint_name) |
Same as the Transaction.addCheckConstraint method.
|
void |
Transaction.addCheckConstraint(TableName table_name,
Expression expression,
short deferred,
java.lang.String constraint_name) |
Adds a check expression that becomes perminent when the transaction
is committed.
|
void |
DatabaseConnection.addForeignKeyConstraint(TableName table,
java.lang.String[] cols,
TableName ref_table,
java.lang.String[] ref_cols,
java.lang.String delete_rule,
java.lang.String update_rule,
short deferred,
java.lang.String constraint_name) |
Same as the Transaction.addForeignKeyConstraint method.
|
void |
Transaction.addForeignKeyConstraint(TableName table,
java.lang.String[] cols,
TableName ref_table,
java.lang.String[] ref_cols,
java.lang.String delete_rule,
java.lang.String update_rule,
short deferred,
java.lang.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,
java.lang.String[] cols,
short deferred,
java.lang.String constraint_name) |
Same as the Transaction.addPrimaryKeyConstraint method.
|
void |
Transaction.addPrimaryKeyConstraint(TableName table_name,
java.lang.String[] cols,
short deferred,
java.lang.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,
java.lang.String[] cols,
short deferred,
java.lang.String constraint_name) |
Same as the Transaction.addUniqueConstraint method.
|
void |
Transaction.addUniqueConstraint(TableName table_name,
java.lang.String[] cols,
short deferred,
java.lang.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(java.lang.String schema,
java.lang.String name,
int type,
TableName on_table,
java.lang.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 |
DatabaseQueryContext.createViewQueryPlanNode(TableName name) |
Creates a QueryPlanNode for the view with the given name.
|
QueryPlanNode |
ViewManager.createViewQueryPlanNode(TableName view_name) |
Returns a freshly deserialized QueryPlanNode object for the given view
object.
|
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,
java.lang.String constraint_name) |
Drops a single named check constraint from the given table.
|
boolean |
Transaction.dropForeignKeyReferenceConstraintForTable(TableName table,
java.lang.String constraint_name) |
Drops a single named foreign key reference from the given table.
|
int |
DatabaseConnection.dropNamedConstraint(TableName table_name,
java.lang.String constraint_name) |
Same as the Transaction.dropNamedConstraint method.
|
int |
Transaction.dropNamedConstraint(TableName table_name,
java.lang.String constraint_name) |
Drops the named constraint from the transaction.
|
boolean |
DatabaseConnection.dropPrimaryKeyConstraintForTable(TableName table_name,
java.lang.String constraint_name) |
Same as the Transaction.dropPrimaryKeyConstraintForTable method.
|
boolean |
Transaction.dropPrimaryKeyConstraintForTable(TableName table_name,
java.lang.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,
java.lang.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 |
DatabaseQueryContext.getDataTableDef(TableName name) |
Returns a DataTableDef for the given table name.
|
DataTableDef |
SimpleTransaction.getDataTableDef(TableName table_name) |
Returns the DataTableDef for the table with the given name that is
visible within this transaction.
|
protected DataTableDef |
SimpleTransaction.getDynamicDataTableDef(TableName table_name) |
Returns the DataTableDef for a dynamic table defined in this transaction.
|
protected DataTableDef |
Transaction.getDynamicDataTableDef(TableName table_name) |
Returns the DataTableDef for the given internal table.
|
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.
|
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 java.lang.String |
SimpleTransaction.getDynamicTableType(TableName table_name) |
Returns a string type describing the type of the dynamic table.
|
java.lang.String |
Transaction.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.
|
DataTable |
DatabaseQueryContext.getTable(TableName name) |
Returns a DataTable from the database with the given table name.
|
MutableTableDataSource |
SimpleTransaction.getTable(TableName table_name) |
Returns a MutableTableDataSource object that represents the table with
the given name within this transaction.
|
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).
|
java.lang.String |
DatabaseConnection.getTableType(TableName table_name) |
Returns the type of the table object.
|
java.lang.String |
SimpleTransaction.getTableType(TableName table_name) |
Returns the type of the table object with the given name.
|
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.
|
protected boolean |
Transaction.isDynamicTable(TableName table_name) |
Returns true if the given table name represents a dynamically generated
system table.
|
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.
|
Transaction.CheckExpression[] |
DatabaseConnection.queryTableCheckExpressions(TableName table_name) |
Same as the Transaction.queryTableCheckExpression method.
|
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.ColumnGroupReference[] |
DatabaseConnection.queryTableForeignKeyReferences(TableName table_name) |
Same as the Transaction.queryTableForeignKeyReferences 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.queryTableImportedForeignKeyReferences(TableName table_name) |
Same as the Transaction.queryTableImportedForeignKeyReferences 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.ColumnGroup |
DatabaseConnection.queryTablePrimaryKeyGroup(TableName table_name) |
Same as the Transaction.queryTablePrimaryKeyGroup 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).
|
TableName[] |
DatabaseConnection.queryTablesRelationallyLinkedTo(TableName table) |
Same as the Transaction.queryTablesRelationallyLinkedTo 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.
|
Transaction.ColumnGroup[] |
DatabaseConnection.queryTableUniqueGroups(TableName table_name) |
Same as the Transaction.queryTableUniqueGroups 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.
|
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,
java.lang.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.
|