Uses of Class
com.mckoi.database.Table
-
Packages that use Table Package Description com.mckoi.database The core database classes for Mckoi.com.mckoi.database.interpret com.mckoi.database.regexbridge Implementations of the RegexLibrary interface, which allows the application to select which regular expression package to use. -
-
Uses of Table in com.mckoi.database
Subclasses of Table in com.mckoi.database Modifier and Type Class Description class
AbstractDataTable
This is the abstract class implemented by a DataTable like table.class
CompositeTable
A composite of two or more datasets used to implement UNION, INTERSECTION, and DIFFERENCE.class
DataTable
DataTable is a wrapper for a MutableTableDataSource that fits into the query hierarchy level.class
DataTableFilter
This object sits on top of a DataTable object filtering out certain types of calls.class
DefaultDataTable
This represents a default implementation of a DataTable.class
FilterTable
A table that is a filter for another table.class
FunctionTable
A table that has a number of columns and as many rows as the refering table.class
JoinedTable
A Table that represents the result of one or more other tables joined together.class
NaturallyJoinedTable
A table that is the cartesian product of two tables.class
ReferenceTable
This is an implementation of a Table that references a DataTable as its parent.class
SubsetColumnTable
This object is a filter that sits atop a Table object.class
TemporaryTable
This class represents a temporary table that is built from data that is not related to any underlying DataTable object from the database.class
VirtualTable
A VirtualTable is a representation of a table whose rows are actually physically stored in another table.Fields in com.mckoi.database declared as Table Modifier and Type Field Description protected Table
FilterTable. parent
The Table we are filtering the columns from.protected Table[]
JoinedTable. reference_list
The list of tables that make up the join.Methods in com.mckoi.database that return Table Modifier and Type Method Description Table
Table. all(QueryContext context, Expression lhs, Operator op, Table table)
Evaluates a non-correlated ALL type operator given the LHS expression, the RHS subquery and the ALL operator to use.Table
Table. any(QueryContext context, Expression lhs, Operator op, Table right_table)
Evaluates a non-correlated ANY type operator given the LHS expression, the RHS subquery and the ANY operator to use.Table
Table. columnMerge(Table table)
Returns a Table that is a merge of this table and the destination table.Table
Table. distinct(int[] col_map)
Returns a new table that has only distinct rows in it.Table
Table. emptySelect()
Returns a new Table based on this table with no rows in it.Table
QueryPlan.CachePointNode. evaluate(QueryContext context)
Table
QueryPlan.CompositeNode. evaluate(QueryContext context)
Table
QueryPlan.ConstantSelectNode. evaluate(QueryContext context)
Table
QueryPlan.CreateFunctionsNode. evaluate(QueryContext context)
Table
QueryPlan.DistinctNode. evaluate(QueryContext context)
Table
QueryPlan.EquiJoinNode. evaluate(QueryContext context)
Table
QueryPlan.ExhaustiveSelectNode. evaluate(QueryContext context)
Table
QueryPlan.FetchTableNode. evaluate(QueryContext context)
Table
QueryPlan.FetchViewNode. evaluate(QueryContext context)
Table
QueryPlan.FunctionalSelectNode. evaluate(QueryContext context)
Table
QueryPlan.GroupNode. evaluate(QueryContext context)
Table
QueryPlan.JoinNode. evaluate(QueryContext context)
Table
QueryPlan.LeftOuterJoinNode. evaluate(QueryContext context)
Table
QueryPlan.LogicalUnionNode. evaluate(QueryContext context)
Table
QueryPlan.MarkerNode. evaluate(QueryContext context)
Table
QueryPlan.MultiColumnEquiSelectNode. evaluate(QueryContext context)
Table
QueryPlan.NaturalJoinNode. evaluate(QueryContext context)
Table
QueryPlan.NonCorrelatedAnyAllNode. evaluate(QueryContext context)
Table
QueryPlan.RangeSelectNode. evaluate(QueryContext context)
Table
QueryPlan.SimplePatternSelectNode. evaluate(QueryContext context)
Table
QueryPlan.SimpleSelectNode. evaluate(QueryContext context)
Table
QueryPlan.SingleRowTableNode. evaluate(QueryContext context)
Table
QueryPlan.SortNode. evaluate(QueryContext context)
Table
QueryPlan.SubsetNode. evaluate(QueryContext context)
Table
QueryPlanNode. evaluate(QueryContext context)
Evaluates the node and returns the result as a Table.Table
DatabaseProcedure. execute(User user, java.lang.Object[] args)
Executes the procudure and returns the resultant table.Table
Table. exhaustiveSelect(QueryContext context, Expression exp)
Exhaustively searches through this table for rows that match the expression given.Table
AbstractQueryContext. getCachedNode(long id)
Returns a cached table or null if it isn't cached.Table
QueryContext. getCachedNode(long id)
Returns a cached table or null if it isn't cached.Table
AbstractQueryContext. getMarkedTable(java.lang.String mark_name)
Returns a table that was marked in a query plan or null if no mark was found.Table
QueryContext. getMarkedTable(java.lang.String mark_name)
Returns a table that was marked in a query plan or null if no mark was found.protected Table
FilterTable. getParent()
Returns the parent table.Table
FunctionTable. getReferenceTable()
Returns the Table this function is based on.protected Table[]
JoinedTable. getReferenceTables()
Returns the list of Table objects that represent this VirtualTable.Table
Database. getSingleRowTable()
Returns a static table that has a single row but no columns.Table
Table. join(Table table)
Performs a natural join of this table with the given table.Table
FunctionTable. mergeWithReference(Variable max_column)
Returns a Table that is this function table merged with the cross reference table.Table
Table. orderByColumns(int[] col_map)
Returns a table that is ordered by the given column numbers.Table
Table. rangeSelect(Variable col_var, SelectableRange[] ranges)
A single column range select on this table.static Table
FunctionTable. resultTable(DatabaseQueryContext context, int result_val)
Returns a FunctionTable that has an int value made into a BigDecimal.static Table
FunctionTable. resultTable(DatabaseQueryContext context, Expression expression)
Returns a FunctionTable that has a single Expression evaluated in it.static Table
FunctionTable. resultTable(DatabaseQueryContext context, TObject ob)
Returns a FunctionTable that has a single TObject in it.static Table
FunctionTable. resultTable(DatabaseQueryContext context, java.lang.Object ob)
Returns a FunctionTable that has a single Object in it.Table
Table. simpleJoin(QueryContext context, Table table, Variable lhs_var, Operator op, Expression rhs)
A simple join operation.Table
Table. simpleSelect(QueryContext context, Variable lhs_var, Operator op, Expression rhs)
A simple select on this table.Table
Table. singleRowSelect(int row_index)
Selects a single row at the given index from this table.Table
Table. union(Table table)
Returns a new Table that is the union of the this table and the given table.Methods in com.mckoi.database with parameters of type Table Modifier and Type Method Description void
AbstractQueryContext. addMarkedTable(java.lang.String mark_name, Table table)
Marks a table in a query plan.void
QueryContext. addMarkedTable(java.lang.String mark_name, Table table)
Marks a table in a query plan.Table
Table. all(QueryContext context, Expression lhs, Operator op, Table table)
Evaluates a non-correlated ALL type operator given the LHS expression, the RHS subquery and the ALL operator to use.Table
Table. any(QueryContext context, Expression lhs, Operator op, Table right_table)
Evaluates a non-correlated ANY type operator given the LHS expression, the RHS subquery and the ANY operator to use.Table
Table. columnMerge(Table table)
Returns a Table that is a merge of this table and the destination table.void
TemporaryTable. copyFrom(Table table, int row)
Copies the contents of the row of the given Table onto the end of this table.int
DataTable. delete(Table table)
int
DataTable. delete(Table table, int limit)
This is the public method for removing a given result set from this table.SelectableScheme
SelectableScheme. getSubsetScheme(Table subset_table, int subset_column)
Asks the Scheme for a SelectableScheme abject that describes a sub-set of the set handled by this Scheme.protected void
JoinedTable. init(Table[] tables)
Helper function for initializing the variables in the joined table.protected void
VirtualTable. init(Table[] tables)
Helper function for the constructor.Table
Table. join(Table table)
Performs a natural join of this table with the given table.VirtualTable
Table. outside(Table rtable)
Finds all rows in this table that are 'outside' the result in the given table.void
AbstractQueryContext. putCachedNode(long id, Table table)
Put a Table into the cache.void
QueryContext. putCachedNode(long id, Table table)
Put a Table into the cache.IntegerVector
RegexLibrary. regexSearch(Table table, int column, java.lang.String regular_expression, java.lang.String expression_ops)
Performs a regular expression search on the given column of the table.void
TemporaryTable. setCellFrom(Table table, int src_col, int src_row, java.lang.String to_col)
Copies the cell from the given table (src_col, src_row) to the last row of the column specified of this table.Table
Table. simpleJoin(QueryContext context, Table table, Variable lhs_var, Operator op, Expression rhs)
A simple join operation.Table
Table. union(Table table)
Returns a new Table that is the union of the this table and the given table.int
DataTable. update(QueryContext context, Table table, Assignment[] assign_list, int limit)
Updates the table by applying the assignment operations over each row that is found in the input 'table' set.Constructors in com.mckoi.database with parameters of type Table Constructor Description CompositeTable(Table[] composite_list)
Consturcts the composite table assuming the first item in the list is the master table.CompositeTable(Table master_table, Table[] composite_list)
Constructs the composite table given the 'master_table' (the field structure this composite dataset is based on), and a list of tables to be the composite of this table.FilterTable(Table parent)
The Constructor.FunctionTable(Table cross_ref_table, Expression[] in_exp_list, java.lang.String[] col_names, DatabaseQueryContext context)
Constructs the FunctionTable.NaturallyJoinedTable(Table left, Table right)
Constructs the table.SubsetColumnTable(Table parent)
The Constructor.TemporaryTable(java.lang.String name, Table based_on)
Constructs this TemporaryTable based on the fields from the given Table object. -
Uses of Table in com.mckoi.database.interpret
Methods in com.mckoi.database.interpret that return Table Modifier and Type Method Description Table
AlterTable. evaluate()
Table
Call. evaluate()
Table
Compact. evaluate()
Table
CompleteTransaction. evaluate()
Table
CreateTable. evaluate()
Table
CreateTrigger. evaluate()
Table
Delete. evaluate()
Table
DropTable. evaluate()
Table
DropTrigger. evaluate()
Table
Function. evaluate()
Table
Insert. evaluate()
Table
Misc. evaluate()
Table
NoOp. evaluate()
Table
PrivManager. evaluate()
Table
Schema. evaluate()
Table
Select. evaluate()
Evaluates the select statement with the given Database context.Table
Sequence. evaluate()
Table
Set. evaluate()
Table
Show. evaluate()
abstract Table
Statement. evaluate()
Evaluates the statement and returns a table that represents the result set.Table
UpdateTable. evaluate()
Table
UserManager. evaluate()
Table
ViewManager. evaluate()
Table
SQLQueryExecutor. execute(DatabaseConnection connection, SQLQuery query)
Executes the given SQLQuery object on the given DatabaseConnection object. -
Uses of Table in com.mckoi.database.regexbridge
Methods in com.mckoi.database.regexbridge with parameters of type Table Modifier and Type Method Description IntegerVector
JavaRegex. regexSearch(Table table, int column, java.lang.String regular_expression, java.lang.String expression_ops)
-