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 classAbstractDataTableThis is the abstract class implemented by a DataTable like table.classCompositeTableA composite of two or more datasets used to implement UNION, INTERSECTION, and DIFFERENCE.classDataTableDataTable is a wrapper for a MutableTableDataSource that fits into the query hierarchy level.classDataTableFilterThis object sits on top of a DataTable object filtering out certain types of calls.classDefaultDataTableThis represents a default implementation of a DataTable.classFilterTableA table that is a filter for another table.classFunctionTableA table that has a number of columns and as many rows as the refering table.classJoinedTableA Table that represents the result of one or more other tables joined together.classNaturallyJoinedTableA table that is the cartesian product of two tables.classReferenceTableThis is an implementation of a Table that references a DataTable as its parent.classSubsetColumnTableThis object is a filter that sits atop a Table object.classTemporaryTableThis class represents a temporary table that is built from data that is not related to any underlying DataTable object from the database.classVirtualTableA 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 TableFilterTable. parentThe Table we are filtering the columns from.protected Table[]JoinedTable. reference_listThe list of tables that make up the join.Methods in com.mckoi.database that return Table Modifier and Type Method Description TableTable. 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.TableTable. 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.TableTable. columnMerge(Table table)Returns a Table that is a merge of this table and the destination table.TableTable. distinct(int[] col_map)Returns a new table that has only distinct rows in it.TableTable. emptySelect()Returns a new Table based on this table with no rows in it.TableQueryPlan.CachePointNode. evaluate(QueryContext context)TableQueryPlan.CompositeNode. evaluate(QueryContext context)TableQueryPlan.ConstantSelectNode. evaluate(QueryContext context)TableQueryPlan.CreateFunctionsNode. evaluate(QueryContext context)TableQueryPlan.DistinctNode. evaluate(QueryContext context)TableQueryPlan.EquiJoinNode. evaluate(QueryContext context)TableQueryPlan.ExhaustiveSelectNode. evaluate(QueryContext context)TableQueryPlan.FetchTableNode. evaluate(QueryContext context)TableQueryPlan.FetchViewNode. evaluate(QueryContext context)TableQueryPlan.FunctionalSelectNode. evaluate(QueryContext context)TableQueryPlan.GroupNode. evaluate(QueryContext context)TableQueryPlan.JoinNode. evaluate(QueryContext context)TableQueryPlan.LeftOuterJoinNode. evaluate(QueryContext context)TableQueryPlan.LogicalUnionNode. evaluate(QueryContext context)TableQueryPlan.MarkerNode. evaluate(QueryContext context)TableQueryPlan.MultiColumnEquiSelectNode. evaluate(QueryContext context)TableQueryPlan.NaturalJoinNode. evaluate(QueryContext context)TableQueryPlan.NonCorrelatedAnyAllNode. evaluate(QueryContext context)TableQueryPlan.RangeSelectNode. evaluate(QueryContext context)TableQueryPlan.SimplePatternSelectNode. evaluate(QueryContext context)TableQueryPlan.SimpleSelectNode. evaluate(QueryContext context)TableQueryPlan.SingleRowTableNode. evaluate(QueryContext context)TableQueryPlan.SortNode. evaluate(QueryContext context)TableQueryPlan.SubsetNode. evaluate(QueryContext context)TableQueryPlanNode. evaluate(QueryContext context)Evaluates the node and returns the result as a Table.TableDatabaseProcedure. execute(User user, java.lang.Object[] args)Executes the procudure and returns the resultant table.TableTable. exhaustiveSelect(QueryContext context, Expression exp)Exhaustively searches through this table for rows that match the expression given.TableAbstractQueryContext. getCachedNode(long id)Returns a cached table or null if it isn't cached.TableQueryContext. getCachedNode(long id)Returns a cached table or null if it isn't cached.TableAbstractQueryContext. getMarkedTable(java.lang.String mark_name)Returns a table that was marked in a query plan or null if no mark was found.TableQueryContext. getMarkedTable(java.lang.String mark_name)Returns a table that was marked in a query plan or null if no mark was found.protected TableFilterTable. getParent()Returns the parent table.TableFunctionTable. getReferenceTable()Returns the Table this function is based on.protected Table[]JoinedTable. getReferenceTables()Returns the list of Table objects that represent this VirtualTable.TableDatabase. getSingleRowTable()Returns a static table that has a single row but no columns.TableTable. join(Table table)Performs a natural join of this table with the given table.TableFunctionTable. mergeWithReference(Variable max_column)Returns a Table that is this function table merged with the cross reference table.TableTable. orderByColumns(int[] col_map)Returns a table that is ordered by the given column numbers.TableTable. rangeSelect(Variable col_var, SelectableRange[] ranges)A single column range select on this table.static TableFunctionTable. resultTable(DatabaseQueryContext context, int result_val)Returns a FunctionTable that has an int value made into a BigDecimal.static TableFunctionTable. resultTable(DatabaseQueryContext context, Expression expression)Returns a FunctionTable that has a single Expression evaluated in it.static TableFunctionTable. resultTable(DatabaseQueryContext context, TObject ob)Returns a FunctionTable that has a single TObject in it.static TableFunctionTable. resultTable(DatabaseQueryContext context, java.lang.Object ob)Returns a FunctionTable that has a single Object in it.TableTable. simpleJoin(QueryContext context, Table table, Variable lhs_var, Operator op, Expression rhs)A simple join operation.TableTable. simpleSelect(QueryContext context, Variable lhs_var, Operator op, Expression rhs)A simple select on this table.TableTable. singleRowSelect(int row_index)Selects a single row at the given index from this table.TableTable. 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 voidAbstractQueryContext. addMarkedTable(java.lang.String mark_name, Table table)Marks a table in a query plan.voidQueryContext. addMarkedTable(java.lang.String mark_name, Table table)Marks a table in a query plan.TableTable. 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.TableTable. 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.TableTable. columnMerge(Table table)Returns a Table that is a merge of this table and the destination table.voidTemporaryTable. copyFrom(Table table, int row)Copies the contents of the row of the given Table onto the end of this table.intDataTable. delete(Table table)intDataTable. delete(Table table, int limit)This is the public method for removing a given result set from this table.SelectableSchemeSelectableScheme. 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 voidJoinedTable. init(Table[] tables)Helper function for initializing the variables in the joined table.protected voidVirtualTable. init(Table[] tables)Helper function for the constructor.TableTable. join(Table table)Performs a natural join of this table with the given table.VirtualTableTable. outside(Table rtable)Finds all rows in this table that are 'outside' the result in the given table.voidAbstractQueryContext. putCachedNode(long id, Table table)Put a Table into the cache.voidQueryContext. putCachedNode(long id, Table table)Put a Table into the cache.IntegerVectorRegexLibrary. 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.voidTemporaryTable. 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.TableTable. simpleJoin(QueryContext context, Table table, Variable lhs_var, Operator op, Expression rhs)A simple join operation.TableTable. union(Table table)Returns a new Table that is the union of the this table and the given table.intDataTable. 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 TableAlterTable. evaluate()TableCall. evaluate()TableCompact. evaluate()TableCompleteTransaction. evaluate()TableCreateTable. evaluate()TableCreateTrigger. evaluate()TableDelete. evaluate()TableDropTable. evaluate()TableDropTrigger. evaluate()TableFunction. evaluate()TableInsert. evaluate()TableMisc. evaluate()TableNoOp. evaluate()TablePrivManager. evaluate()TableSchema. evaluate()TableSelect. evaluate()Evaluates the select statement with the given Database context.TableSequence. evaluate()TableSet. evaluate()TableShow. evaluate()abstract TableStatement. evaluate()Evaluates the statement and returns a table that represents the result set.TableUpdateTable. evaluate()TableUserManager. evaluate()TableViewManager. evaluate()TableSQLQueryExecutor. 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 IntegerVectorJavaRegex. regexSearch(Table table, int column, java.lang.String regular_expression, java.lang.String expression_ops)
-