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.jdbcserver Implementation of the DatabaseInterface interface, including classes to handle local (embedded) mode and remote (client/server) mode.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.(package private) class
OuterTable
A Table class for forming OUTER type results.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 private Table[]
CompositeTable. composite_tables
The tables being made a composite of.private Table
FunctionTable. cross_ref_table
The table that this function table cross references.private Table
CompositeTable. master_table
The 'master table' used to resolve information about this table such as fields and field types.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.private Table
Database. SINGLE_ROW_TABLE
A table that has a single row but no columns.private Table
TableAccessState. table
The underlying Table object.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.(package private) static Table
TableFunctions. anyAllNonCorrelated(Table left_table, Variable[] left_vars, Operator op, Table right_table)
The function for a non-correlated ANY or ALL sub-query operation between a left and right branch.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.private Table
ProcedureManager. findProcedureEntry(DataTable table, ProcedureName procedure_name)
Given the SYS_FUNCTION table, this returns a new table that contains the entry with the given procedure name, or an empty result if nothing found.private Table
ConnectionTriggerManager. findTrigger(QueryContext context, DataTable table, java.lang.String schema, java.lang.String name)
Returns a Table object that contains the trigger information with the given name.private Table
ViewManager. findViewEntry(DataTable table, TableName view_name)
Given the SYS_VIEW table, this returns a new table that contains the entry with the given view name, or an empty result if the view is not found.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.(package private) Table[]
RawTableInformation. getTables()
Returns an AbstractDataTable[] array of all the tables that have been added.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.(package private) IntegerVector
Table. allRowsIn(int column, Table table)
Given a table and column (from this table), this returns all the rows from this table that are also in the first column of the given table.(package private) IntegerVector
Table. allRowsNotIn(int column, Table table)
Given a table and column (from this table), this returns all the rows from this table that are not in the first column of the given table.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.(package private) static Table
TableFunctions. anyAllNonCorrelated(Table left_table, Variable[] left_vars, Operator op, Table right_table)
The function for a non-correlated ANY or ALL sub-query operation between a left and right branch.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.private static IntegerVector
NaturallyJoinedTable. createLookupRowList(Table t)
Creates a lookup list for rows in the given 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.(package private) static void
DumpHelper. dump(Table table, java.io.PrintStream out)
Dumps the contents of a table to the given output stream.(package private) SelectableScheme
CompositeTable. getSelectableSchemeFor(int column, int original_column, Table table)
(package private) SelectableScheme
DataTable. getSelectableSchemeFor(int column, int original_column, Table table)
(package private) SelectableScheme
DataTableFilter. getSelectableSchemeFor(int column, int original_column, Table table)
Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableScheme
DefaultDataTable. getSelectableSchemeFor(int column, int original_column, Table table)
Returns a SelectableScheme object for the given column of the VirtualTable.(package private) SelectableScheme
FilterTable. getSelectableSchemeFor(int column, int original_column, Table table)
Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableScheme
JoinedTable. getSelectableSchemeFor(int column, int original_column, Table table)
Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableScheme
OuterTable. getSelectableSchemeFor(int column, int original_column, Table table)
Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableScheme
SubsetColumnTable. getSelectableSchemeFor(int column, int original_column, Table table)
Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) abstract SelectableScheme
Table. getSelectableSchemeFor(int column, int original_column, Table table)
Returns a SelectableScheme for the given column in the given VirtualTable row domain.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.(package private) static IntegerVector
INHelper. in(Table table1, Table table2, int[] t1_cols, int[] t2_cols)
A multi-column version of IN.(package private) static IntegerVector
INHelper. in(Table table1, Table table2, int column1, int column2)
This implements the 'in' command.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.void
OuterTable. mergeIn(Table outside_table)
Merges the given table in with this table.(package private) static IntegerVector
INHelper. notIn(Table table1, Table table2, int[] t1_cols, int[] t2_cols)
A multi-column version of NOT IN.(package private) static IntegerVector
INHelper. notIn(Table table1, Table table2, int col1, int col2)
This implements the 'not_in' command.(package private) static IntegerVector
INHelper. origIn(Table table1, Table table2, int column1, int column2)
This implements the 'in' command.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.(package private) static IntegerVector
PatternSearch. regexSearch(Table table, int column, java.lang.String pattern)
Matches a column of a table against a constant regular expression pattern.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.(package private) static IntegerVector
PatternSearch. search(Table table, int column, java.lang.String pattern)
This is the search method.(package private) static IntegerVector
PatternSearch. search(Table table, int column, java.lang.String pattern, char escape_char)
This is the search method.(package private) void
VirtualTable. set(Table[] tables, BlockIntegerList[] rows)
Sets the rows in this table as above, but uses a BlockIntegerList array as an argument instead.(package private) void
VirtualTable. set(Table[] tables, IntegerVector[] rows)
This is used in a join to set a list or joined rows and tables.(package private) void
VirtualTable. set(Table table, BlockIntegerList rows)
Sets the rows in this table as above, but uses a BlockIntegerList as an argument instead.(package private) void
VirtualTable. set(Table table, IntegerVector rows)
Sets the rows in this 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.GroupHelper(Table table, java.lang.String[] col_names)
Deprecated.Constructs the helper.JoinedTable(Table table)
Constructs the JoinedTable with a single table.JoinedTable(Table[] tables)
Constructs the JoinedTable with the list of tables in the parent.NaturallyJoinedTable(Table left, Table right)
Constructs the table.OuterTable(Table input_table)
Constructs the OuterTable given the base table.ReferenceTable(Table table, DataTableDef def)
Constructs the ReferenceTable given the parent table, and a new DataTableDef that describes the columns in this table.ReferenceTable(Table table, TableName tname)
The Constructor.SubsetColumnTable(Table parent)
The Constructor.TableAccessState(Table table)
The Constructor.TemporaryTable(java.lang.String name, Table based_on)
Constructs this TemporaryTable based on the fields from the given Table object.VirtualTable(Table table)
VirtualTable(Table[] tables)
The Constructor. -
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.jdbcserver
Fields in com.mckoi.database.jdbcserver declared as Table Modifier and Type Field Description private Table
AbstractJDBCDatabaseInterface.ResultSetInfo. result
The table that is the result.Constructors in com.mckoi.database.jdbcserver with parameters of type Table Constructor Description ResultSetInfo(SQLQuery query, Table table)
Constructs the result set. -
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)
-