Uses of Class
com.mckoi.database.Variable
Packages that use Variable
Package
Description
The core database classes for Mckoi.
These classes parse SQL statements in Mckoi.
-
Uses of Variable in com.mckoi.database
Methods in com.mckoi.database that return VariableModifier and TypeMethodDescriptionVariable[]
QueryPlan.SubsetNode.getNewColumnNames()
Returns the list of new column names that represent the new columns in this subset.Variable[]
QueryPlan.SubsetNode.getOriginalColumns()
Returns the list of original columns that represent the mappings from the columns in this subset.CompositeTable.getResolvedVariable
(int column) DataTable.getResolvedVariable
(int column) DataTableFilter.getResolvedVariable
(int column) Returns a fully qualified Variable object that represents the name of the column at the given index.DefaultDataTable.getResolvedVariable
(int column) Returns a fully qualified Variable object that represents the name of the column at the given index.FilterTable.getResolvedVariable
(int column) Returns a fully qualified Variable object that represents the name of the column at the given index.final Variable
JoinedTable.getResolvedVariable
(int column) Returns a fully qualified Variable object that represents the name of the column at the given index.ReferenceTable.getResolvedVariable
(int column) Returns a fully qualified Variable object that represents the name of the column at the given index.SubsetColumnTable.getResolvedVariable
(int column) Returns a fully qualified Variable object that represents the name of the column at the given index.abstract Variable
Table.getResolvedVariable
(int column) Returns a fully qualified Variable object that represents the name of the column at the given index.TableAccessState.getResolvedVariable
(int column) Returns the TableName of the given column of this table.Assignment.getVariable()
Returns the variable for this assignment.CorrelatedVariable.getVariable()
Returns the wrapped Variable.Expression.getVariable()
Returns the Variable if this expression evaluates to a single variable, otherwise returns null.static Variable
Attempts to resolve a string '[table_name].[column]' to a Variable instance.static Variable
Attempts to resolve a string '[table_name].[column]' to a Variable instance.Variable.resolveTableName
(TableName tablen) Returns a ColumnName that is resolved against a table name context only if the ColumnName is unknown in this object.Sets this Variable object with information from the given Variable.Methods in com.mckoi.database with parameters of type VariableModifier and TypeMethodDescriptionboolean
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
FunctionTable.createGroupMatrix
(Variable[] col_list) Creates a grouping matrix for the given tables.final int
Table.fastFindFieldName
(Variable col) A faster way to find a column index given a string column name.int
CompositeTable.findFieldName
(Variable v) int
DataTable.findFieldName
(Variable v) int
DataTableFilter.findFieldName
(Variable v) Given a fully qualified variable field name, ie.int
DefaultDataTable.findFieldName
(Variable v) Given a fully qualified variable field name, ie.int
FilterTable.findFieldName
(Variable v) Given a fully qualified variable field name, ie.int
JoinedTable.findFieldName
(Variable v) Given a fully qualified variable field name, ie.int
ReferenceTable.findFieldName
(Variable v) Given a fully qualified variable field name, ie.int
SubsetColumnTable.findFieldName
(Variable v) Given a fully qualified variable field name, ie.abstract int
Table.findFieldName
(Variable v) Given a fully qualified variable field name, ie.Table.getTTypeForColumn
(Variable v) Returns a TType object that would represent values in the given column.FunctionTable.mergeWithReference
(Variable max_column) Returns a Table that is this function table merged with the cross reference table.final VirtualTable
Table.orderByColumn
(Variable column) final VirtualTable
Table.orderByColumn
(Variable column, boolean ascending) final Table
Table.rangeSelect
(Variable col_var, SelectableRange[] ranges) A single column range select on this table.Returns the value of a variable of a group.Returns the value of a given variable.VariableResolver.returnTType
(Variable variable) Returns the TType of object the given variable is.Sets this Variable object with information from the given Variable.void
SubsetColumnTable.setColumnMap
(int[] mapping, Variable[] aliases) Adds a column map into this table.final Table
Table.simpleJoin
(QueryContext context, Table table, Variable lhs_var, Operator op, Expression rhs) A simple join operation.final Table
Table.simpleSelect
(QueryContext context, Variable lhs_var, Operator op, Expression rhs) A simple select on this table.Constructors in com.mckoi.database with parameters of type VariableModifierConstructorDescriptionAssignment
(Variable variable, Expression expression) Constructs the assignment.CorrelatedVariable
(Variable variable, int level_offset) Constructs the CorrelatedVariable.DistinctNode
(QueryPlanNode child, Variable[] columns) EquiJoinNode
(QueryPlanNode left, QueryPlanNode right, Variable[] left_cols, Variable[] right_cols) GroupNode
(QueryPlanNode child, Variable[] columns, Variable group_max_column, Expression[] function_list, String[] name_list) Groups over the given columns from the child.GroupNode
(QueryPlanNode child, Variable group_max_column, Expression[] function_list, String[] name_list) Groups over the entire child (always ends in 1 result in set).JoinNode
(QueryPlanNode left, QueryPlanNode right, Variable left_var, Operator join_op, Expression right_expression) MultiColumnEquiSelectNode
(QueryPlanNode child, Variable[] columns, Expression[] values) NonCorrelatedAnyAllNode
(QueryPlanNode left, QueryPlanNode right, Variable[] left_vars, Operator subquery_op) SimpleSelectNode
(QueryPlanNode child, Variable left_var, Operator op, Expression right_expression) SortNode
(QueryPlanNode child, Variable[] columns, boolean[] ascending) SubsetNode
(QueryPlanNode child, Variable[] original_columns, Variable[] new_column_names) -
Uses of Variable in com.mckoi.database.interpret
Fields in com.mckoi.database.interpret declared as VariableModifier and TypeFieldDescriptionTableSelectExpression.group_max
The group max variable or null if no group max.SelectColumn.internal_name
The name of this column used internally to reference it.ByColumn.name
The name of the column in the 'by'.SelectColumn.resolved_name
The fully resolved name that this column is given in the resulting table.Methods in com.mckoi.database.interpret that return VariableModifier and TypeMethodDescriptionVariable[]
FromTableDirectSource.allColumns()
Variable[]
FromTableInterface.allColumns()
Returns an array of Variable objects that references each column available in this table set item in order from left column to right column.Variable[]
FromTableSubQuerySource.allColumns()
FromTableDirectSource.resolveColumn
(String catalog, String schema, String table, String column) FromTableInterface.resolveColumn
(String catalog, String schema, String table, String column) Returns a Variable that is a fully resolved form of the given column in this table set.FromTableSubQuerySource.resolveColumn
(String catalog, String schema, String table, String column) Statement.resolveVariableName
(Variable v) Given a Variable object, this will resolve the name into a column name the database understands (substitutes aliases, etc).Methods in com.mckoi.database.interpret with parameters of type VariableModifier and TypeMethodDescriptionStatement.resolveVariableName
(Variable v) Given a Variable object, this will resolve the name into a column name the database understands (substitutes aliases, etc). -
Uses of Variable in com.mckoi.database.sql
Methods in com.mckoi.database.sql that return VariableModifier and TypeMethodDescriptionfinal Variable
SQL.ColumnNameVariable()
final Variable
SQL.GroupMaxColumn()
NOTE: This is an extension, allows for us to specify a column to return the max value for each row representing a group.