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 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.(package private) classOuterTableA Table class for forming OUTER type results.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 private Table[]CompositeTable. composite_tablesThe tables being made a composite of.private TableFunctionTable. cross_ref_tableThe table that this function table cross references.private TableCompositeTable. master_tableThe 'master table' used to resolve information about this table such as fields and field types.protected TableFilterTable. parentThe Table we are filtering the columns from.protected Table[]JoinedTable. reference_listThe list of tables that make up the join.private TableDatabase. SINGLE_ROW_TABLEA table that has a single row but no columns.private TableTableAccessState. tableThe underlying Table object.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.(package private) static TableTableFunctions. 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.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.private TableProcedureManager. 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 TableConnectionTriggerManager. 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 TableViewManager. 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.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.(package private) Table[]RawTableInformation. getTables()Returns an AbstractDataTable[] array of all the tables that have been added.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.(package private) IntegerVectorTable. 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) IntegerVectorTable. 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.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.(package private) static TableTableFunctions. 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.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.private static IntegerVectorNaturallyJoinedTable. createLookupRowList(Table t)Creates a lookup list for rows in the given 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.(package private) static voidDumpHelper. dump(Table table, java.io.PrintStream out)Dumps the contents of a table to the given output stream.(package private) SelectableSchemeCompositeTable. getSelectableSchemeFor(int column, int original_column, Table table)(package private) SelectableSchemeDataTable. getSelectableSchemeFor(int column, int original_column, Table table)(package private) SelectableSchemeDataTableFilter. getSelectableSchemeFor(int column, int original_column, Table table)Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableSchemeDefaultDataTable. getSelectableSchemeFor(int column, int original_column, Table table)Returns a SelectableScheme object for the given column of the VirtualTable.(package private) SelectableSchemeFilterTable. getSelectableSchemeFor(int column, int original_column, Table table)Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableSchemeJoinedTable. getSelectableSchemeFor(int column, int original_column, Table table)Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableSchemeOuterTable. getSelectableSchemeFor(int column, int original_column, Table table)Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) SelectableSchemeSubsetColumnTable. getSelectableSchemeFor(int column, int original_column, Table table)Returns a SelectableScheme for the given column in the given VirtualTable row domain.(package private) abstract SelectableSchemeTable. getSelectableSchemeFor(int column, int original_column, Table table)Returns a SelectableScheme for the given column in the given VirtualTable row domain.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.(package private) static IntegerVectorINHelper. in(Table table1, Table table2, int[] t1_cols, int[] t2_cols)A multi-column version of IN.(package private) static IntegerVectorINHelper. in(Table table1, Table table2, int column1, int column2)This implements the 'in' command.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.voidOuterTable. mergeIn(Table outside_table)Merges the given table in with this table.(package private) static IntegerVectorINHelper. notIn(Table table1, Table table2, int[] t1_cols, int[] t2_cols)A multi-column version of NOT IN.(package private) static IntegerVectorINHelper. notIn(Table table1, Table table2, int col1, int col2)This implements the 'not_in' command.(package private) static IntegerVectorINHelper. origIn(Table table1, Table table2, int column1, int column2)This implements the 'in' command.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.(package private) static IntegerVectorPatternSearch. regexSearch(Table table, int column, java.lang.String pattern)Matches a column of a table against a constant regular expression pattern.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.(package private) static IntegerVectorPatternSearch. search(Table table, int column, java.lang.String pattern)This is the search method.(package private) static IntegerVectorPatternSearch. search(Table table, int column, java.lang.String pattern, char escape_char)This is the search method.(package private) voidVirtualTable. set(Table[] tables, BlockIntegerList[] rows)Sets the rows in this table as above, but uses a BlockIntegerList array as an argument instead.(package private) voidVirtualTable. set(Table[] tables, IntegerVector[] rows)This is used in a join to set a list or joined rows and tables.(package private) voidVirtualTable. set(Table table, BlockIntegerList rows)Sets the rows in this table as above, but uses a BlockIntegerList as an argument instead.(package private) voidVirtualTable. set(Table table, IntegerVector rows)Sets the rows in this 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.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 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.jdbcserver
Fields in com.mckoi.database.jdbcserver declared as Table Modifier and Type Field Description private TableAbstractJDBCDatabaseInterface.ResultSetInfo. resultThe 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 IntegerVectorJavaRegex. regexSearch(Table table, int column, java.lang.String regular_expression, java.lang.String expression_ops)
-