SqlUtil Namespace Reference

Qore AbstractDatabase class definition. More...

Classes
class	AbstractCheckConstraint
	abstract class for check constraints More...
class	AbstractColumn
	the base class for column information More...
class	AbstractColumnConstraint
	the API for a constraint with columns More...
class	AbstractColumnSupportingConstraint
	the API for a constraint with columns More...
class	AbstractConstraint
	abstract base class for constraints More...
class	AbstractDatabase
	the base abstract class for the database implementation More...
class	AbstractDdlObject
	the base class for named objects More...
class	AbstractForeignConstraint
	the base class for foreign key constraint information More...
class	AbstractFunction
	base class for functions More...
class	AbstractFunctionBase
	base class for function or objects with code More...
class	AbstractHashContainer
	abstract container class that throws an exception if an unknown key is accessed More...
class	AbstractIndex
	the abstract base class for index information More...
class	AbstractListContainer
	abstract container class that throws an exception if an unknown key is accessed More...
class	AbstractNumericDataType
	the data type for Oracle NUMBER columns More...
class	AbstractPrimaryKey
	represents a primary key More...
class	AbstractSavepointHelper
	Abstract base class for savepoint helpers for epheremal transaction support. More...
class	AbstractSequence
	base class for sequences More...
class	AbstractSqlUtilBase
	base class for abstract SqlUtil classes More...
class	AbstractTable
	the base abstract class for the table implementation More...
class	AbstractTrigger
	the base class for triggers More...
class	AbstractUniqueConstraint
	represents a unique column constraint More...
class	AbstractView
	base class for views More...
hashdecl	ColumnOperatorInfo
	column operator info hash as returned by all sql_cop_funcs "column operator functions" More...
class	Columns
	column container class that throws an exception if an unknown column is accessed More...
class	Constraints
	constraint container class that throws an exception if an unknown constraint is accessed More...
class	Database
	represents a database; this class embeds an AbstractDatabase object that is created automatically in the constructor based on the database driver for the AbstractDatasource object providing the database connection More...
class	ForeignConstraints
	foreign constraint container class that throws an exception if an unknown constraint is accessed More...
class	ForeignConstraintTarget
	a class describing a foreign constraint target More...
class	Functions
	function container class that throws an exception if an unknown function is accessed More...
hashdecl	GenericColumnInfo
	generic column description hash in schema descriptions More...
class	Indexes
	index container class that throws an exception if an unknown index is accessed More...
hashdecl	InsertOperatorInfo
	insert operator info hash as returned by all sql_iop_funcs() "insert operator functions" More...
hashdecl	JoinOperatorInfo
	join operator info hash as returned by all sql_jop_funcs "join operator functions" More...
hashdecl	OperatorInfo
	SQL operator info hash as returned by all sql_op_funcs "operator functions". More...
hashdecl	QueryInfo
	Query information. More...
hashdecl	SqlCommandInfo
	A hash describing SQL and arguments for an SQL DML command. More...
hashdecl	SqlResultInfo
	Return type for methods that return a result and also SQL info. More...
class	SqlUtilColumnDataType
	generic type for SQL datatypes where no translations are provided for NULL for "or nothing" types More...
class	SqlUtilColumnField
	SqlUtil column field class. More...
hashdecl	SqlUtilDataTypeOptionInfo
	column data type options More...
class	SqlUtilDateType
	type for date / timestamp columns More...
class	SqlUtilDbSpecificDataType
	data type for DB-specific types that are not convertible to other types More...
class	SqlUtilFloatType
	type for date / timestamp columns More...
class	SqlUtilIntType
	type for date / timestamp columns More...
class	SqlUtilStringType
	type for string / varchar / char columns More...
class	Table
	represents a database table; this class embeds an AbstractTable object that is created automatically in the constructor based on the database driver for the AbstractDatasource object providing the database connection More...
class	Tables
	the table container class stores a collection of tables in a schema More...
class	Triggers
	trigger container class that throws an exception if an unknown trigger is accessed More...
hashdecl	UpdateOperatorInfo
	update operator info hash as returned by all sql_uop_funcs() "update operator functions" More...

Functions
hash< ColumnOperatorInfo >	cop_append (auto column, string arg)
	returns a ColumnOperatorInfo hash for the "append" operator with the given argument
hash< ColumnOperatorInfo >	cop_as (auto column, string arg)
	returns a ColumnOperatorInfo hash for the "as" operator with the given argument
hash< ColumnOperatorInfo >	cop_avg (auto column)
	returns a ColumnOperatorInfo hash for the "avg" operator; returns average column values
hash< ColumnOperatorInfo >	cop_cast (auto arg2, auto arg1, auto column, string arg)
	returns a ColumnOperatorInfo hash for the "cast" operator with the given argument(s)
hash< ColumnOperatorInfo >	cop_coalesce (auto col1, auto col2)
	returns a ColumnOperatorInfo hash for the "coalesce" operator with the given column arguments; the first non-NULL column value will be returned
hash< ColumnOperatorInfo >	cop_count (auto column)
	returns a ColumnOperatorInfo hash for the "count" operator; returns row counts
hash< ColumnOperatorInfo >	cop_cume_dist ()
	Analytic/window function: relative rank of the current row.
hash< ColumnOperatorInfo >	cop_dense_rank ()
	Analytic/window function: rank of the current row without gaps.
hash< ColumnOperatorInfo >	cop_distinct (auto column)
	returns a ColumnOperatorInfo hash for the "distinct" operator with the given argument; returns distinct column values
hash< ColumnOperatorInfo >	cop_divide (auto column1, auto column2)
	returns a ColumnOperatorInfo hash for the "/" operator with the given arguments
hash< ColumnOperatorInfo >	cop_first_value (any column)
	Analytic/window function: value evaluated at the row that is the first row of the window frame.
hash< ColumnOperatorInfo >	cop_last_value (any column)
	Analytic/window function: value evaluated at the row that is the last row of the window frame.
hash< ColumnOperatorInfo >	cop_length (auto column)
	returns a ColumnOperatorInfo hash for the "len" operator with the given argument; returns the length of the given text field
hash< ColumnOperatorInfo >	cop_lower (auto column)
	returns a ColumnOperatorInfo hash for the "lower" operator with the given argument; returns a column value in lower case
hash< ColumnOperatorInfo >	cop_max (auto column)
	returns a ColumnOperatorInfo hash for the "max" operator; returns maximum column values
hash< ColumnOperatorInfo >	cop_min (auto column)
	returns a ColumnOperatorInfo hash for the "min" operator; returns minimum column values
hash< ColumnOperatorInfo >	cop_minus (auto column1, auto column2)
	returns a ColumnOperatorInfo hash for the "-" operator with the given arguments
hash< ColumnOperatorInfo >	cop_multiply (auto column1, auto column2)
	returns a ColumnOperatorInfo hash for the "*" operator with the given arguments
hash< ColumnOperatorInfo >	cop_ntile (int value)
	Analytic/window function: integer ranging from 1 to the argument value, dividing the partition as equally as possible.
hash< ColumnOperatorInfo >	cop_over (soft< string > orderby, auto column, soft< string > partitionby)
	returns a ColumnOperatorInfo hash for the "over" clause
hash< ColumnOperatorInfo >	cop_percent_rank ()
	Analytic/window function: relative rank of the current row.
hash< ColumnOperatorInfo >	cop_plus (auto column1, auto column2)
	returns a ColumnOperatorInfo hash for the "+" operator with the given arguments
hash< ColumnOperatorInfo >	cop_prepend (auto column, string arg)
	returns a ColumnOperatorInfo hash for the "prepend" operator with the given argument
hash< ColumnOperatorInfo >	cop_rank ()
	Analytic/window function: rank of the current row with gaps.
hash< ColumnOperatorInfo >	cop_row_number ()
	Analytic/window function: number of the current row within its partition, counting from 1.
hash< ColumnOperatorInfo >	cop_seq (string seq, soft< string > as)
	returns a ColumnOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose value should be returned
hash< ColumnOperatorInfo >	cop_seq_currval (string seq, soft< string > as)
	returns a ColumnOperatorInfo hash for the "seq_currval" operator with the given argument giving the sequence name whose current value should be returned
hash< ColumnOperatorInfo >	cop_substr (soft< int > count, auto column, int start)
	returns a ColumnOperatorInfo hash for the "substr" operator with the given arguments; returns a substring of a column value
hash< ColumnOperatorInfo >	cop_sum (auto column)
	returns a ColumnOperatorInfo hash for the "sum" operator; returns the total sum of a numeric column.
hash< ColumnOperatorInfo >	cop_trunc_date (auto column, string mask)
	Truncates a date column or value regarding the given mask. The resulting value remains Qore::date (no conversion to eg. string)
hash< ColumnOperatorInfo >	cop_upper (auto column)
	returns a ColumnOperatorInfo hash for the "upper" operator with the given argument; returns a column value in upper case
hash< ColumnOperatorInfo >	cop_value (auto arg)
	returns a ColumnOperatorInfo hash for the "value" (literal) operator with the given argument
hash< ColumnOperatorInfo >	cop_year (auto column)
	returns a ColumnOperatorInfo hash for the "year" operator with the given argument
hash< ColumnOperatorInfo >	cop_year_day (auto column)
	returns a ColumnOperatorInfo hash for the "year_day" operator with the given argument
hash< ColumnOperatorInfo >	cop_year_hour (auto column)
	returns a ColumnOperatorInfo hash for the "year_hour" operator with the given argument
hash< ColumnOperatorInfo >	cop_year_month (auto column)
	returns a ColumnOperatorInfo hash for the "year_month" operator with the given argument
hash< InsertOperatorInfo >	iop_seq (string arg)
	returns an InsertOperatorInfo hash for retrieving the value of the given sequence in insert queries
hash< InsertOperatorInfo >	iop_seq_currval (string arg)
	returns an InsertOperatorInfo hash for retrieving the current value of the given sequence in insert queries
hash< string, hash< JoinOperatorInfo > >	join_inner (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, AbstractTable table, soft< string > alias)
	returns a hash for standard inner joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_inner (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, AbstractTable table)
	returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_inner (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, Table table)
	returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_inner (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, string table_name, soft< string > alias)
	returns a hash for standard inner joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_inner (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, Table table, soft< string > alias)
	returns a hash for standard inner joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_inner_alias (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, string table_name)
	returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_left (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, AbstractTable table, soft< string > alias)
	returns a hash for left outer joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_left (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, AbstractTable table)
	returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_left (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, Table table)
	returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_left (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, string table_name, soft< string > alias)
	returns a hash for left outer joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_left (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, Table table, soft< string > alias)
	returns a hash for left outer joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_left_alias (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, string table_name)
	returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_right (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, AbstractTable table, soft< string > alias)
	returns a hash for right outer joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_right (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, AbstractTable table)
	returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_right (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, Table table)
	returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table
hash< string, hash< JoinOperatorInfo > >	join_right (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, string table_name, soft< string > alias)
	returns a hash for right outer joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_right (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, Table table, soft< string > alias)
	returns a hash for right outer joins with the given arguments
hash< string, hash< JoinOperatorInfo > >	join_right_alias (soft< hash< auto > > opt, soft< hash > cond, soft< hash > jcols, soft< string > alias, string ta, string table_name)
	returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table
hash< ColumnOperatorInfo >	make_cop (auto arg, string cop, auto column)
	returns a ColumnOperatorInfo hash
hash< InsertOperatorInfo >	make_iop (string iop, auto arg)
	returns an InsertOperatorInfo hash
hash< string, hash< JoinOperatorInfo > >	make_jop (soft< hash< auto > > opt, soft< string > ta, soft< hash > cond, soft< hash > jcols, soft< string > alias, string jop, AbstractTable table)
	returns hash keyed with the table name assigned to a JoinOperatorInfo hash
hash< string, hash< JoinOperatorInfo > >	make_jop (soft< hash< auto > > opt, soft< string > ta, soft< hash > cond, soft< hash > jcols, soft< string > alias, string jop, string table_name)
	returns a hash keyed with the table name assigned to a JoinOperatorInfo hash
hash< OperatorInfo >	make_op (string op, auto arg)
	returns an OperatorInfo hash
hash< UpdateOperatorInfo >	make_uop (soft< hash< UpdateOperatorInfo > > nest, string uop, auto arg)
	returns an UpdateOperatorInfo hash
hash< OperatorInfo >	op_between (auto l, auto r)
	returns an OperatorInfo hash for the "between" operator with the given arguments, neither of which can be NULL or NOTHING; for use in where clauses
hash< OperatorInfo >	op_ceq (string arg)
	returns an OperatorInfo hash for the "==" operator with the given argument for use in where clauses when comparing the values of two columns
hash< OperatorInfo >	op_cge (string arg)
	returns an OperatorInfo hash for the ">=" operator with the given argument for use in where clauses when comparing the values of two columns
hash< OperatorInfo >	op_cgt (string arg)
	returns an OperatorInfo hash for the ">" operator with the given argument for use in where clauses when comparing the values of two columns
hash< OperatorInfo >	op_cle (string arg)
	returns an OperatorInfo hash for the "<=" operator with the given argument for use in where clauses when comparing the values of two columns
hash< OperatorInfo >	op_clt (string arg)
	returns an OperatorInfo hash for the "<" operator with the given argument for use in where clauses when comparing the values of two columns
hash< OperatorInfo >	op_cne (string arg)
	returns an OperatorInfo hash for the "!=" or "<>" operator with the given argument for use in where clauses when comparing the values of two columns
hash< OperatorInfo >	op_eq (auto arg)
	returns an OperatorInfo hash for the "==" operator with the given argument for use in where clauses when comparing column values to immediate values
hash< OperatorInfo >	op_ge (auto arg)
	returns an OperatorInfo hash for the ">=" operator with the given argument for use in where clauses when comparing column values to immediate values
hash< OperatorInfo >	op_gt (auto arg)
	returns an OperatorInfo hash for the ">" operator with the given argument for use in where clauses when comparing column values to immediate values
hash< OperatorInfo >	op_in ()
	returns an OperatorInfo hash for the "in" operator with all arguments passed to the function; for use in where clauses
hash< OperatorInfo >	op_in (list< auto > args)
	returns an OperatorInfo hash for the "in" operator with the given argument list as the first argument; for use in where clauses
hash< OperatorInfo >	op_in_select (AbstractTable table, hash< auto > select_hash)
	returns an OperatorInfo hash for the "in" operator with a subquery as the argument; for use in where clauses
hash< OperatorInfo >	op_in_select (string table, hash< auto > select_hash)
	returns an OperatorInfo hash for the "in" operator with a subquery as the argument; for use in where clauses
hash< OperatorInfo >	op_in_select (Table table, hash< auto > select_hash)
	returns an OperatorInfo hash for the "in" operator with a subquery as the argument; for use in where clauses
hash< OperatorInfo >	op_le (auto arg)
	returns an OperatorInfo hash for the "<=" operator with the given argument for use in where clauses when comparing column values to immediate values
hash< OperatorInfo >	op_like (string str)
	returns an OperatorInfo hash for the "like" operator with the given argument for use in where clauses
hash< OperatorInfo >	op_lt (auto arg)
	returns an OperatorInfo hash for the "<" operator with the given argument for use in where clauses when comparing column values to immediate values
hash< OperatorInfo >	op_ne (auto arg)
	returns an OperatorInfo hash for the "!=" or "<>" operator with the given argument for use in where clauses when comparing column values to immediate values
hash< OperatorInfo >	op_not (hash arg)
	returns an OperatorInfo hash for the "not" operator; for use in where clauses
hash< OperatorInfo >	op_substr (int start, string text)
	returns an OperatorInfo hash for the "substr" operator with the given arguments; for use in where clauses
hash< OperatorInfo >	op_substr (string text, int start, soft< int > count)
	returns an OperatorInfo hash for the "substr" operator with the given arguments; for use in where clauses
void	sqlutil_register_ds_deserializer (soft< code > new_ds_get)
	registers a closure or call reference taking a string type and string datasource configuration that will return an AbstractDatasource
void	sqlutil_register_ds_serializer (soft< code > new_ds_do)
	registers a closure or call reference taking a string type and string datasource configuration that will return an AbstractDatasource
hash< UpdateOperatorInfo >	uop_append (string arg, soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "append" or concatenate operator with the given argument
hash< UpdateOperatorInfo >	uop_divide (auto arg, soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "/" operator with the given arguments
hash< UpdateOperatorInfo >	uop_lower (soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "lower" operator with the given argument; returns a column value in lower case
hash< UpdateOperatorInfo >	uop_minus (auto arg, soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "-" operator with the given arguments
hash< UpdateOperatorInfo >	uop_multiply (auto arg, soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "*" operator with the given arguments
hash< UpdateOperatorInfo >	uop_plus (auto arg, soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "+" operator with the given arguments
hash< UpdateOperatorInfo >	uop_prepend (string arg, soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "prepend" operator with the given argument
hash< UpdateOperatorInfo >	uop_seq (string seq)
	returns an UpdateOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose value should be returned
hash< UpdateOperatorInfo >	uop_seq_currval (string seq)
	returns an UpdateOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose current value should be returned
hash< UpdateOperatorInfo >	uop_substr (soft< hash< UpdateOperatorInfo > > nest, int start, soft< int > count)
	returns an UpdateOperatorInfo hash for the "substr" operator with the given arguments; returns a substring of a column value
hash< UpdateOperatorInfo >	uop_upper (soft< hash< UpdateOperatorInfo > > nest)
	returns an UpdateOperatorInfo hash for the "upper" operator with the given argument; returns a column value in upper case
hash< string, hash< OperatorInfo > >	wop_or (hash h1, hash h2)
	returns an OperatorInfo hash with a fake "_OR_" column name; the list of arguments to the function is combined such that each hash in the list generates SQL expressions combined with "and" logic, and each of those clauses is combined with "or" logic; this is for use in where clauses

Variables
const auto	BLOB = ...
	specifies a large variable-length binary column (ie BLOB or BYTEA, etc)
const auto	CHAR = ...
	specifies a CHAR column
const auto	CLOB = ...
	specifies a large variable-length character column (ie CLOB or TEXT, etc)
const auto	COP_APPEND = ...
	to append a string to a column on output
const auto	COP_AS = ...
	to rename a column on output
const auto	COP_AVG = ...
	to return the average value
const auto	COP_CAST = ...
	to convert column value into another datatype
const auto	COP_COALESCE = ...
	to return the first non-null argument in the list
const auto	COP_COUNT = ...
	to return the row count
const auto	COP_CUME_DIST = ...
	Analytic (window) function: CUME_DIST.
const auto	COP_DENSE_RANK = ...
	Analytic (window) function: DENSE_RANK.
const auto	COP_DISTINCT = ...
	to return distinct values
const auto	COP_DIVIDE = ...
	the SQL "divide" operator
const auto	COP_FIRST_VALUE = ...
	Analytic (window) function: FIRST_VALUE.
const auto	COP_LAST_VALUE = ...
	Analytic (window) function: LAST_VALUE.
const auto	COP_LENGTH = ...
	to get the length of a text field
const auto	COP_LOWER = ...
	to return column value in lower case
const auto	COP_MAX = ...
	to return the maximum value
const auto	COP_MIN = ...
	to return the minimum value
const auto	COP_MINUS = ...
	the SQL "minus" operator
const auto	COP_MULTIPLY = ...
	the SQL "multiply" operator
const auto	COP_NTILE = ...
	Analytic (window) function: NTILE.
const auto	COP_OVER = ...
	the SQL "over" clause
const auto	COP_PERCENT_RANK = ...
	Analytic (window) function: PERCENT_RANK.
const auto	COP_PLUS = ...
	the SQL "plus" operator
const auto	COP_PREPEND = ...
	to prepend a string to a column on output
const auto	COP_RANK = ...
	Analytic (window) function: RANK.
const auto	COP_ROW_NUMBER = ...
	Analytic (window) function: ROW_NUMBER.
const auto	COP_SEQ = ...
	to return the next value of a sequence
const auto	COP_SEQ_CURRVAL = ...
	to return the last value of a sequence issued in the same session
const auto	COP_SUBSTR = ...
	to extract a substring from a column
const auto	COP_SUM = ...
	to return the sum value
const auto	COP_TRUNC_DATE = ...
	to return the date with truncated value
const auto	COP_UPPER = ...
	to return column value in upper case
const auto	COP_VALUE = ...
	to append a constant value (SQL Literal) to use as an output column value
const auto	COP_YEAR = ...
	to return a date value with year information only
const auto	COP_YEAR_DAY = ...
	to return a date value with year to day information
const auto	COP_YEAR_HOUR = ...
	to return a date value with year to hour information
const auto	COP_YEAR_MONTH = ...
	to return a date value with year to month information
const auto	DB_FUNCTIONS = ...
	Features constants.
const auto	DB_MVIEWS = ...
	Feature: materialized views / snapshots.
const auto	DB_PACKAGES = ...
	Feature: packages.
const auto	DB_PROCEDURES = ...
	Feature: procedures.
const auto	DB_SEQUENCES = ...
	Feature: sequences.
const auto	DB_SYNONYMS = ...
	Feature: synonyms.
const auto	DB_TABLES = ...
	Feature: tables.
const auto	DB_TYPES = ...
	Feature: named types.
const auto	DB_VIEWS = ...
	Feature: views.
const auto	DefaultCopMap = ...
	a hash of default column operator descriptions
const auto	DefaultExpressionMap = ...
	Default expressions to be supported by all SqlUtil modules.
const auto	DefaultIopMap = ...
	a hash of default insert operator descriptions (currently empty, all operators are driver-dependent)
const auto	DefaultOpMap = ...
	a hash of valid operators for use in Where Clauses
const auto	DefaultUopMap = ...
	a hash of valid update operators
const auto	DT_DAY = ...
	Format unit: day.
const auto	DT_HOUR = ...
	Format unit: hour.
const auto	DT_MINUTE = ...
	Format unit: minute.
const auto	DT_MONTH = ...
	Format unit: month.
const auto	DT_SECOND = ...
	Format unit: hour.
const auto	DT_YEAR = ...
	Format unit: year.
const auto	IOP_SEQ = ...
	for using the value of a sequence
const auto	IOP_SEQ_CURRVAL = ...
	for using the last value of a sequence issued in the current session
const auto	JOP_INNER = ...
	for standard inner joins
const auto	JOP_LEFT = ...
	for left outer joins
const auto	JOP_RIGHT = ...
	for right outer joins
const auto	JopMap = ...
	a hash of valid join operators
const auto	NUMERIC = ...
	specifies a numeric column (equivalent to Qore::Type::Number)
const auto	OP_BETWEEN = ...
	the SQL "between" operator for use in Where Clauses
const auto	OP_CEQ = ...
	the SQL equals operator (=) for use in Where Clauses
const auto	OP_CGE = ...
	the SQL greater than or equals operator (>=) for use in Where Clauses
const auto	OP_CGT = ...
	the SQL greater than operator (>) for use in Where Clauses
const auto	OP_CLE = ...
	the SQL less than or equals (<=) operator for use in Where Clauses
const auto	OP_CLT = ...
	the SQL less than (<) operator for use in Where Clauses when comparing two columns
const auto	OP_CNE = ...
	the SQL not equals operator (!= or <>) for use in Where Clauses
const auto	OP_EQ = ...
	the SQL equals operator (=) for use in Where Clauses
const auto	OP_GE = ...
	the SQL greater than or equals operator (>=) for use in Where Clauses
const auto	OP_GT = ...
	the SQL greater than operator (>) for use in Where Clauses
const auto	OP_IN = ...
	the SQL "in" operator for use in Where Clauses
const auto	OP_IN_SELECT = ...
	the SQL "in" operator with a select query for use in Where Clauses
const auto	OP_LE = ...
	the SQL less than or equals (<=) operator for use in Where Clauses
const auto	OP_LIKE = ...
	the SQL "like" operator for use in Where Clauses
const auto	OP_LT = ...
	the SQL less than (<) operator for use in Where Clauses
const auto	OP_NE = ...
	the SQL not equals operator (!= or <>) for use in Where Clauses
const auto	OP_NOT = ...
	the SQL "not" operator for use in Where Clauses
const auto	OP_OR = ...
	to combine SQL expressions with "or" for use in Where Clauses
const auto	OP_SUBSTR = ...
	the SQL "substr" operator for use in Where Clauses
const auto	SqlUtilDrivers = ...
	known drivers
const auto	SZ_MAND = ...
	the data type takes a mandatory size parameter
const auto	SZ_NONE = ...
	the data type does not take a size parameter
const auto	SZ_NUM = ...
	the data type is numeric so takes an optional precision and scale
const auto	SZ_OPT = ...
	the data type takes an optional size parameter
const auto	VARCHAR = ...
	specifies a VARCHAR column (equivalent to Qore::Type::String)

Detailed Description

Qore AbstractDatabase class definition.

Qore Table class definition.

Qore SqlUtilStringType class definition.

Qore SqlUtilIntType class definition.

Qore SqlUtilFloatType class definition.

Qore SqlUtilDbSpecificDataType class definition.

Qore SqlUtilDateType class definition.

Qore SqlUtilColumnField class definition.

Qore SqlUtilColumnDataType class definition.

the SqlUtil namespace contains all the objects in the SqlUtil module

Qore SqlResultInfo hash definition.

Qore Database class definition.

Qore AbstractTable class definition.

Qore AbstractSqlUtilBase class definition.

Qore AbstractSavepointHelper class definition.

Qore AbstractNumericDataType class definition.

AbstractDatabase.qc Copyright 2019 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

AbstractNumericDataType.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

AbstractSavepointHelper.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. strict argument handling contains all public definitions in the SqlUtil module

AbstractSqlUtilBase.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

AbstractTable.qc Copyright 2019 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

Database.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. strict argument handling contains all public definitions in the SqlUtil module

SqlResultInfo.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

SqlUtilColumnDataType.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. strict argument handling contains all public definitions in the SqlUtil module

SqlUtilColumnField.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. strict argument handling contains all public definitions in the SqlUtil module

SqlUtilDateType.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

SqlUtilDbSpecificDataType.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

SqlUtilFloatType.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

SqlUtilIntType.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

SqlUtilStringType.qc Copyright 2023 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. strict argument handling contains all public definitions in the SqlUtil module

Table.qc Copyright 2019 - 2024 Qore Technologies, s.r.o.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. contains all public definitions in the SqlUtil module

Function Documentation

cop_append()

hash< ColumnOperatorInfo > SqlUtil::cop_append	(	auto	column,
		string	arg
	)

returns a ColumnOperatorInfo hash for the "append" operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_append("name", "-migrated")), "where": ("type": "user")));

Parameters

column	the column specification for the column (string name or dot notation for use in joins)
arg	the text to append (ie concatenate) to the row values in the output column

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_as()

hash< ColumnOperatorInfo > SqlUtil::cop_as	(	auto	column,
		string	arg
	)

returns a ColumnOperatorInfo hash for the "as" operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_as("errors", "error_count")), "where": ("type": "user")));

Parameters

column	the column specification for the column (string name or dot notation for use in joins) or any other column "cop_..." function
arg	the new name of the output column

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

See also

SqlUtil::cop_value for SQL literals handling

cop_avg()

hash< ColumnOperatorInfo > SqlUtil::cop_avg

(

auto

column

)

returns a ColumnOperatorInfo hash for the "avg" operator; returns average column values

Example:

*list<auto> rows = table.selectRows(("columns": (cop_avg("quantity")), "where": ("order_type": "wholesale")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_cast()

hash< ColumnOperatorInfo > SqlUtil::cop_cast	(	auto	arg2,
		auto	arg1,
		auto	column,
		string	arg
	)

returns a ColumnOperatorInfo hash for the "cast" operator with the given argument(s)

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_cast("id", "string")), "where": ("type": "user")));

Parameters

column	the column specification for the column (string name or dot notation for use in joins) or any other column "cop_..." function
arg	the new datatype to cast the column value(s) to
arg1	optional, type dependent, specification (e.g. size or precision)
arg2	optional, type dependent, specification (e.g. scale)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

See also

SqlUtil::cop_value for SQL literals handling

cop_coalesce()

hash< ColumnOperatorInfo > SqlUtil::cop_coalesce	(	auto	col1,
		auto	col2
	)

returns a ColumnOperatorInfo hash for the "coalesce" operator with the given column arguments; the first non-NULL column value will be returned

Example:

*list<auto> rows = table.selectRows(("columns": ("first_name", "last_name", cop_colesce("first_name", "last_name")), "where": ("type": "user")));

Parameters

col1	the name or column operator hash for the first value
col2	the name or column operator hash for the second value, additional values should follow this argument

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

Exceptions

COALESCE-ERROR

the arguments must be either string column designators or column operator hashes

cop_count()

hash< ColumnOperatorInfo > SqlUtil::cop_count

(

auto

column

)

returns a ColumnOperatorInfo hash for the "count" operator; returns row counts

Example:

*list<auto> rows = table.selectRows(("columns": ("account_type", cop_count()), "where": ("type": "user"), "groupby": "account_type"));

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_cume_dist()

hash< ColumnOperatorInfo > SqlUtil::cop_cume_dist

(

)

Analytic/window function: relative rank of the current row.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_cume_dist(), "row_type", "id"), "cume_dist"),
    );
 
# rendered SQL statement
# select cume_dist() over (partition by row_type order by id) as "cume_dist" test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Returns

relative rank of the current row: (number of rows preceding or peer with current row) / (total rows)

Since

SqlUtil 1.4.0

cop_dense_rank()

hash< ColumnOperatorInfo > SqlUtil::cop_dense_rank

(

)

Analytic/window function: rank of the current row without gaps.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_dense_rank(), "row_type", "id"), "dense_rank"),
    );
 
# rendered SQL statement
select dense_rank() over (partition by row_type order by id) as "dense_rank" from test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Returns

rank of the current row without gaps; this function counts peer groups

Since

SqlUtil 1.4.0

cop_distinct()

hash< ColumnOperatorInfo > SqlUtil::cop_distinct

(

auto

column

)

returns a ColumnOperatorInfo hash for the "distinct" operator with the given argument; returns distinct column values

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_distinct("name")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_divide()

hash< ColumnOperatorInfo > SqlUtil::cop_divide	(	auto	column1,
		auto	column2
	)

returns a ColumnOperatorInfo hash for the "/" operator with the given arguments

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_divide("complete_count", "error_count")), "where": ("type": "user")));

Parameters

column1	the column specification for the first argument (string name or dot notation for use in joins)
column2	the column specification for the second argument (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_first_value()

hash< ColumnOperatorInfo > SqlUtil::cop_first_value

(

any

column

)

Analytic/window function: value evaluated at the row that is the first row of the window frame.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_first_value("row_value"), "row_type", "id"), "first_value"),
    );
 
# rendered SQL statement
select first_value(row_value) over (partition by row_type order by id) as "first_value" from test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Returns

returns value evaluated at the row that is the first row of the window frame

Since

SqlUtil 1.4.0

cop_last_value()

hash< ColumnOperatorInfo > SqlUtil::cop_last_value

(

any

column

)

Analytic/window function: value evaluated at the row that is the last row of the window frame.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_last_value("row_value"), "row_type", "id"), "last_value"),
    );
 
# rendered SQL statement
select last_value(row_value) over (partition by row_type order by id) as "last_value" from test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Returns

returns value evaluated at the row that is the last row of the window frame

Since

SqlUtil 1.4.0

cop_length()

hash< ColumnOperatorInfo > SqlUtil::cop_length

(

auto

column

)

returns a ColumnOperatorInfo hash for the "len" operator with the given argument; returns the length of the given text field

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_length("product_code")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

Since

SqlUtil 1.3.1

cop_lower()

hash< ColumnOperatorInfo > SqlUtil::cop_lower

(

auto

column

)

returns a ColumnOperatorInfo hash for the "lower" operator with the given argument; returns a column value in lower case

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_lower("name")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_max()

hash< ColumnOperatorInfo > SqlUtil::cop_max

(

auto

column

)

returns a ColumnOperatorInfo hash for the "max" operator; returns maximum column values

Example:

*list<auto> rows = table.selectRows(("columns": (cop_max("id")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_min()

hash< ColumnOperatorInfo > SqlUtil::cop_min

(

auto

column

)

returns a ColumnOperatorInfo hash for the "min" operator; returns minimum column values

Example:

*list<auto> rows = table.selectRows(("columns": (cop_min("id")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_minus()

hash< ColumnOperatorInfo > SqlUtil::cop_minus	(	auto	column1,
		auto	column2
	)

returns a ColumnOperatorInfo hash for the "-" operator with the given arguments

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_minus("complete_count", "error_count")), "where": ("type": "user")));

Parameters

column1	the column specification for the first argument (string name or dot notation for use in joins)
column2	the column specification for the second argument (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_multiply()

hash< ColumnOperatorInfo > SqlUtil::cop_multiply	(	auto	column1,
		auto	column2
	)

returns a ColumnOperatorInfo hash for the "*" operator with the given arguments

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_multiply("complete_count", "error_count")), "where": ("type": "user")));

Parameters

column1	the column specification for the first argument (string name or dot notation for use in joins)
column2	the column specification for the second argument (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_ntile()

hash< ColumnOperatorInfo > SqlUtil::cop_ntile

(

int

value

)

Analytic/window function: integer ranging from 1 to the argument value, dividing the partition as equally as possible.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_ntile(10), "row_type", "id"), "ntile"),
    );
 
# rendered SQL statement
select ntile(10) over (partition by row_type order by id) as "ntile" from test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Parameters

value

an integer value used as count of buckets

Returns

integer ranging from 1 to the argument value, dividing the partition as equally as possible

Since

SqlUtil 1.4.0

cop_over()

hash< ColumnOperatorInfo > SqlUtil::cop_over	(	soft< string >	orderby,
		auto	column,
		soft< string >	partitionby
	)

returns a ColumnOperatorInfo hash for the "over" clause

Example:

*list<auto> rows = table.selectRows(("columns": ("account_type", cop_count(), cop_as(cop_over(cop_max("qty"), "account_id"), "max_qty_per_account")), "where": ("type": "user"), "groupby": "account_type"));

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_percent_rank()

hash< ColumnOperatorInfo > SqlUtil::cop_percent_rank

(

)

Analytic/window function: relative rank of the current row.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_percent_rank(), "row_type", "id"), "percent_rank"),
    );
 
# rendered SQL statement
select percent_rank() over (partition by row_type order by id) as "percent_rank" from test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Returns

relative rank of the current row: (rank - 1) / (total rows - 1)

Since

SqlUtil 1.4.0

cop_plus()

hash< ColumnOperatorInfo > SqlUtil::cop_plus	(	auto	column1,
		auto	column2
	)

returns a ColumnOperatorInfo hash for the "+" operator with the given arguments

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_plus("complete_count", "error_count")), "where": ("type": "user")));

Parameters

column1	the column specification for the first argument (string name or dot notation for use in joins)
column2	the column specification for the second argument (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_prepend()

hash< ColumnOperatorInfo > SqlUtil::cop_prepend	(	auto	column,
		string	arg
	)

returns a ColumnOperatorInfo hash for the "prepend" operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_prepend("name", "migrated-")), "where": ("type": "user")));

Parameters

column	the column specification for the column (string name or dot notation for use in joins)
arg	the text to prepend to the row values in the output column

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_rank()

hash< ColumnOperatorInfo > SqlUtil::cop_rank

(

)

Analytic/window function: rank of the current row with gaps.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_rank(), "row_type", "id"), "rank"),
    );
 
# rendered SQL statement
select rank() over (partition by row_type order by id) as "rank" from test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Returns

rank of the current row with gaps; same as row_number of its first peer

Since

SqlUtil 1.4.0

cop_row_number()

hash< ColumnOperatorInfo > SqlUtil::cop_row_number

(

)

Analytic/window function: number of the current row within its partition, counting from 1.

Example:

# with table structure (Schema module syntax)
const T_TestAnalyticFunctions = (
    "columns" : (
        "id" : c_number(),
        "row_type" : c_varchar(10),
        "row_value" : c_number(),
    ),
);
 
# select hash
hash<auto> sh = (
        "columns" : cop_as(cop_over(cop_row_number(), "row_type", "id"), "row_number"),
    );
 
# rendered SQL statement
select row_number() over (partition by row_type order by id) as "row_number" from test_analytic_functions;

Analytic/window function. Must be used with cop_over with partitionby and orderby arguments

Note

MySQL DB family: This analytic function is available only in MariaDB 10.2 and later only.

Returns

number of the current row within its partition, counting from 1

Since

SqlUtil 1.4.0

cop_seq()

hash< ColumnOperatorInfo > SqlUtil::cop_seq	(	string	seq,
		soft< string >	as
	)

returns a ColumnOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose value should be returned

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_seq("xid", "xis")), "where": ("type": "user")));

Parameters

seq	the name of the sequence whose value should be returned
as	an optional column name that should be returned for the sequence value (so that SqlUtil::cop_as need not be used)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_seq_currval()

hash< ColumnOperatorInfo > SqlUtil::cop_seq_currval	(	string	seq,
		soft< string >	as
	)

returns a ColumnOperatorInfo hash for the "seq_currval" operator with the given argument giving the sequence name whose current value should be returned

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_seq("xid", "xid_val"), cop_seq_currval("xid", "xid_current")), "where": ("type": "user")));

Parameters

seq	the name of the sequence whose current value should be returned
as	an optional column name that should be returned for the sequence value (so that SqlUtil::cop_as need not be used)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_substr()

hash< ColumnOperatorInfo > SqlUtil::cop_substr	(	soft< int >	count,
		auto	column,
		int	start
	)

returns a ColumnOperatorInfo hash for the "substr" operator with the given arguments; returns a substring of a column value

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_substr("name", 1, 1)), "where": ("type": "user")));

Parameters

column	the column specification for the column (string name or dot notation for use in joins)
start	position where the substring starts
count	length of the substring in characters

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_sum()

hash< ColumnOperatorInfo > SqlUtil::cop_sum

(

auto

column

)

returns a ColumnOperatorInfo hash for the "sum" operator; returns the total sum of a numeric column.

Example:

*list<auto> rows = table.selectRows(("columns": (cop_sum("quantity")), "where": ("order_type": "wholesale")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_trunc_date()

hash< ColumnOperatorInfo > SqlUtil::cop_trunc_date	(	auto	column,
		string	mask
	)

Truncates a date column or value regarding the given mask. The resulting value remains Qore::date (no conversion to eg. string)

Example:

*list<auto> rows = table.selectRows(("columns": cop_trunc_date("mydate", DF_MINUTE));
# input: 2017-02-01 14:22:37
# output 2017-02-01 14:22:00

Parameters

column	the column specification for the column (string name or dot notation for use in joins)
mask	the string with one of specified values rederenced in sql_cop_trunc_date_enum

Returns

a column operator description hash corresponding to the arguments for use in the columns argument of a select option hash

Since

SqlUtil 1.4.0

cop_upper()

hash< ColumnOperatorInfo > SqlUtil::cop_upper

(

auto

column

)

returns a ColumnOperatorInfo hash for the "upper" operator with the given argument; returns a column value in upper case

Example:

*list<auto> rows = table.selectRows(("columns": ("id", cop_upper("name")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_value()

hash< ColumnOperatorInfo > SqlUtil::cop_value

(

auto

arg

)

returns a ColumnOperatorInfo hash for the "value" (literal) operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_value(100)), "where": ("type": "user")));

Parameters

arg	the value to be returned in the column

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

SQL literals can be useful in some cases - as dummy values for select statements where there is exact columns required, unions, expected values for arc.insertFromIterator(src.getStatement(sh)) "insert as select", etc.

The term literal refers to a fixed data value. For example, 123, 'foobar' etc.

Mapping of Qore values to literals:

Qore Type	SQL Type	Qore Example	SQL interpretation
Integer	NUMBER as it is	123	123
Float	NUMBER as it is	12.3	12.3
Numeric	NUMBER as it is	1.2n	1.2
Date	String representation of the date using DB native implementation like TO_TIMESTAMP for Oracle.	now()	to_timestamp('20150421104825000000', 'YYYYMMDDHH24MISSFF6')
Bool	Internal representation of the bool value using DB native implementation	True	1
String	Standard and escaped string literal. No additional literal methods like Oracle's nq{foobar} are supported now	"foo bar"	'foo bar'
NULL	Direct null literal	NULL	null
NOTHING	Direct null literal	NOTHING	null

Note

Passing an existing SQL function name as a value to the cop_value() function does not result in function call. The string value is escaped as it is. Example: sysdate becomes 'sysdate'. See example below.

The most useful SqlUtil::cop_value() usage is with cooperation of SqlUtil::cop_as() which allows human readable column name aliases.

Warning

Using SqlUtil::cop_value() without SqlUtil::cop_as() can result in errors depending on the DB backend. For example Oracle's use of cop_value(1), cop_value(True) ends with ORA-00918: column ambiguously defined because both values are interpreted as 1 in the resulting SQL.

Example

%new-style
%requires SqlUtil
 
DatasourcePool ds("oracle:pvanek_omq/omq@xbox(al32utf8)");
Database db(ds);
Table t(ds, "dual");
 
hash<auto> sh = (
    "columns" : (
        cop_as(cop_value(1), "as_int"),
        cop_as(cop_value(1.2), "as_float"),
        cop_as(cop_value(3.2n), "as_numeric"),
        cop_as(cop_value(now()), "as_date"),
        cop_as(cop_value("foo bar"), "as_string"),
        cop_as(cop_value("sysdate"), "as_function_call"),
        cop_as(cop_value(True), "as_bool"),
        cop_as(cop_value(NULL), "as_null"),
        cop_as(cop_value(NOTHING), "as_nothing"),
    ),
);
string sql;
on_exit { printf("sql: %s\n", sql); }
printf("%N\n", t.selectRow(sh, \sql));
 
# results in:
hash: (9 members)
  as_int : 1
  as_float : 1.2
  as_numeric : 3.2
  as_date : 2015-04-21 10:56:57.000000 Tue +02:00 (CEST)
  as_string : "foo bar"
  as_function_call : "sysdate"
  as_bool : 1
  as_null : <NULL>
  as_nothing : <NULL>
sql: select 1 as as_int,1.2 as as_float,3.2 as as_numeric,to_timestamp('20150421105657000000', 'YYYYMMDDHH24MISSFF6') as as_date,'foo bar' as as_string,'sysdate' as as_function_call,1 as as_bool,null as as_null,null as as_nothing from pvanek_omq.workflows fetch next %v rows only

cop_year()

hash< ColumnOperatorInfo > SqlUtil::cop_year

(

auto

column

)

returns a ColumnOperatorInfo hash for the "year" operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_year("error_time")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_year_day()

hash< ColumnOperatorInfo > SqlUtil::cop_year_day

(

auto

column

)

returns a ColumnOperatorInfo hash for the "year_day" operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_year_day("error_time")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_year_hour()

hash< ColumnOperatorInfo > SqlUtil::cop_year_hour

(

auto

column

)

returns a ColumnOperatorInfo hash for the "year_hour" operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_year_hour("error_time")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

cop_year_month()

hash< ColumnOperatorInfo > SqlUtil::cop_year_month

(

auto

column

)

returns a ColumnOperatorInfo hash for the "year_month" operator with the given argument

Example:

*list<auto> rows = table.selectRows(("columns": ("id", "name", cop_year_month("error_time")), "where": ("type": "user")));

Parameters

column

the column specification for the column (string name or dot notation for use in joins)

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

iop_seq()

hash< InsertOperatorInfo > SqlUtil::iop_seq

(

string

arg

)

returns an InsertOperatorInfo hash for retrieving the value of the given sequence in insert queries

Example:

table.insert(("id": id, "ref": iop_seq("xid")));

Parameters

arg	the name of the sequence whose value should be inserted into the column

Returns

an InsertOperatorInfo hash corresponding to the arguments for use in insert queries

iop_seq_currval()

hash< InsertOperatorInfo > SqlUtil::iop_seq_currval

(

string

arg

)

returns an InsertOperatorInfo hash for retrieving the current value of the given sequence in insert queries

Example:

table.insert(("id": id, "ref": iop_seq("xid"), "ref2": iop_seq_currval("xid")));

Parameters

arg	the name of the sequence whose current value should be inserted into the column

Returns

an InsertOperatorInfo hash corresponding to the arguments for use in insert queries

join_inner() [1/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_inner	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		AbstractTable	table,
		soft< string >	alias
	)

returns a hash for standard inner joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_inner(table2, "t2", ("id": "altid"))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_inner(table2)));

Parameters

table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_inner() [2/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_inner	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		AbstractTable	table
	)

returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_inner(table2, "t2", ("id": "altid")) + join_inner("t2", table3)));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_inner(table2)));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

Since

SqlUtil 1.3

join_inner() [3/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_inner	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		Table	table
	)

returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_inner(table2, "t2", ("id": "altid")) + join_inner("t2", table3)));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_inner(table2)));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_inner() [4/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_inner	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		string	table_name,
		soft< string >	alias
	)

returns a hash for standard inner joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_inner(table2, "t2", ("id": "altid"))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_inner(table2)));

Parameters

table_name	the table to join with; table will be subject to deferred resolution
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_inner() [5/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_inner	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		Table	table,
		soft< string >	alias
	)

returns a hash for standard inner joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_inner(table2, "t2", ("id": "altid"))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_inner(table2)));

Parameters

table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_inner_alias()

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_inner_alias	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		string	table_name
	)

returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_inner(table2, "t2", ("id": "altid")) + join_inner("t2", table3)));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_inner(table2)));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table_name	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

Since

SqlUtil 1.3

join_left() [1/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_left	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		AbstractTable	table,
		soft< string >	alias
	)

returns a hash for left outer joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", ("id": "altid"), ("tag", op_like("offset%")))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", NOTHING, ("tag", op_like("offset%")))));

Parameters

table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_left() [2/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_left	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		AbstractTable	table
	)

returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", ("id": "altid"), ("tag", op_like("offset%"))) + join_left("t2", table3, "t3")));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", NOTHING, ("tag", op_like("offset%"))) + join_left("t2", table3, "t3")));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_left() [3/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_left	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		Table	table
	)

returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", ("id": "altid"), ("tag", op_like("offset%"))) + join_left("t2", table3, "t3")));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", NOTHING, ("tag", op_like("offset%"))) + join_left("t2", table3, "t3")));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_left() [4/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_left	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		string	table_name,
		soft< string >	alias
	)

returns a hash for left outer joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", ("id": "altid"), ("tag", op_like("offset%")))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", NOTHING, ("tag", op_like("offset%")))));

Parameters

table_name	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

Since

SqlUtil 1.3

join_left() [5/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_left	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		Table	table,
		soft< string >	alias
	)

returns a hash for left outer joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", ("id": "altid"), ("tag", op_like("offset%")))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", NOTHING, ("tag", op_like("offset%")))));

Parameters

table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_left_alias()

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_left_alias	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		string	table_name
	)

returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", ("id": "altid"), ("tag", op_like("offset%"))) + join_left("t2", table3, "t3")));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_left(table2, "t2", NOTHING, ("tag", op_like("offset%"))) + join_left("t2", table3, "t3")));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table_name	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

Since

SqlUtil 1.3

join_right() [1/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_right	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		AbstractTable	table,
		soft< string >	alias
	)

returns a hash for right outer joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", ("id": "altid"), ("tag", op_like("offset%")))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", NOTHING, ("tag", op_like("offset%")))));

Parameters

table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_right() [2/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_right	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		AbstractTable	table
	)

returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", ("id": "altid"), ("tag", op_like("offset%"))) + join_right("t2", table3, "t3")));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", NOTHING, ("tag", op_like("offset%"))) + join_right("t2", table3, "t3")));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_right() [3/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_right	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		Table	table
	)

returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", ("id": "altid"), ("tag", op_like("offset%"))) + join_right("t2", table3, "t3")));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", NOTHING, ("tag", op_like("offset%"))) + join_right("t2", table3, "t3")));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_right() [4/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_right	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		string	table_name,
		soft< string >	alias
	)

returns a hash for right outer joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", ("id": "altid"), ("tag", op_like("offset%")))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", NOTHING, ("tag", op_like("offset%")))));

Parameters

table_name	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

Since

SqlUtil 1.3

join_right() [5/5]

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_right	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		Table	table,
		soft< string >	alias
	)

returns a hash for right outer joins with the given arguments

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", ("id": "altid"), ("tag", op_like("offset%")))));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", NOTHING, ("tag", op_like("offset%")))));

Parameters

table	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

join_right_alias()

hash< string, hash< JoinOperatorInfo > > SqlUtil::join_right_alias	(	soft< hash< auto > >	opt,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	ta,
		string	table_name
	)

returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table

Example With Explicit Join Columns:

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", ("id": "altid"), ("tag", op_like("offset%"))) + join_right("t2", table3, "t3")));

Example With Implicit Join Columns:

(using an automatically detected foreign key to primary key constraint)

*list<auto> rows = table.selectRows(("join": join_right(table2, "t2", NOTHING, ("tag", op_like("offset%"))) + join_right("t2", table3, "t3")));

Parameters

ta	the table name or alias of the other table to join with when not joining with the primary table
table_name	the table to join with
alias	the alias for table in the query
jcols	the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists
cond	additional conditions for the join clause for the table argument; see Where Clauses for more information
opt	optional join options (for example, to specify a partition for the join if supported)

Returns

a join description hash corresponding to the arguments for use in the join argument of a select option hash

Since

SqlUtil 1.3

make_cop()

hash< ColumnOperatorInfo > SqlUtil::make_cop	(	auto	arg,
		string	cop,
		auto	column
	)

returns a ColumnOperatorInfo hash

Parameters

cop	the column operator (one of sql_cops)
column	the column name
arg	the argument to the operator

Returns

a ColumnOperatorInfo hash corresponding to the arguments for use in the columns argument of a select option hash

Note

Normally this function is not called directly, but rather by the other column operator functions

make_iop()

hash< InsertOperatorInfo > SqlUtil::make_iop	(	string	iop,
		auto	arg
	)

returns an InsertOperatorInfo hash

Parameters

iop	the value operator (one of sql_iops)
arg	the argument to the operator

Returns

an InsertOperatorInfo hash corresponding to the arguments for use as values in insert queries

Note

Normally this function is not called directly, but rather by the other insert operator functions

make_jop() [1/2]

hash< string, hash< JoinOperatorInfo > > SqlUtil::make_jop	(	soft< hash< auto > >	opt,
		soft< string >	ta,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	jop,
		AbstractTable	table
	)

returns hash keyed with the table name assigned to a JoinOperatorInfo hash

Note

this function is normally not used directly, but rather is called by the other sql_jop_funcs

make_jop() [2/2]

hash< string, hash< JoinOperatorInfo > > SqlUtil::make_jop	(	soft< hash< auto > >	opt,
		soft< string >	ta,
		soft< hash >	cond,
		soft< hash >	jcols,
		soft< string >	alias,
		string	jop,
		string	table_name
	)

returns a hash keyed with the table name assigned to a JoinOperatorInfo hash

This version is used for deferred table resolution at join time

Note

this function is normally not used directly, but rather is called by the other sql_jop_funcs

make_uop()

hash< UpdateOperatorInfo > SqlUtil::make_uop	(	soft< hash< UpdateOperatorInfo > >	nest,
		string	uop,
		auto	arg
	)

returns an UpdateOperatorInfo hash

Parameters

uop	the update operator (one of sql_uops)
arg	the argument to the operator
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

Note

Normally this function is not called directly, but rather by the other update operator functions

op_between()

hash< OperatorInfo > SqlUtil::op_between	(	auto	l,
		auto	r
	)

returns an OperatorInfo hash for the "between" operator with the given arguments, neither of which can be NULL or NOTHING; for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_between("US", "UX"))));

Parameters

l	the lower bound for the "between" operator
r	the upper bound for the "between" operator

Returns

an OperatorInfo hash for use in where clauses

Exceptions

BETWEEN-ERROR

one or both of the required arguments are NULL or NOTHING

op_ceq()

hash< OperatorInfo > SqlUtil::op_ceq

(

string

arg

)

returns an OperatorInfo hash for the "==" operator with the given argument for use in where clauses when comparing the values of two columns

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_ceq("other_name"))));

Parameters

arg	the name of the column to compare against

Returns

an OperatorInfo hash for use in where clauses

See also

op_eq() for a function to be used when comparing a column against an immediate value

op_cge()

hash< OperatorInfo > SqlUtil::op_cge

(

string

arg

)

returns an OperatorInfo hash for the ">=" operator with the given argument for use in where clauses when comparing the values of two columns

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_cge("other_name"))));

Parameters

arg	the name of the column to compare against

Returns

an OperatorInfo hash for use in where clauses

See also

op_ge() for a function to be used when comparing a column against an immediate value

op_cgt()

hash< OperatorInfo > SqlUtil::op_cgt

(

string

arg

)

returns an OperatorInfo hash for the ">" operator with the given argument for use in where clauses when comparing the values of two columns

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_cgt("other_name"))));

Parameters

arg	the name of the column to compare against

Returns

an OperatorInfo hash for use in where clauses

See also

op_gt() for a function to be used when comparing a column against an immediate value

op_cle()

hash< OperatorInfo > SqlUtil::op_cle

(

string

arg

)

returns an OperatorInfo hash for the "<=" operator with the given argument for use in where clauses when comparing the values of two columns

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_cle("other_name"))));

Parameters

arg	the name of the column to compare against

Returns

an OperatorInfo hash for use in where clauses

See also

op_le() for a function to be used when comparing a column against an immediate value

op_clt()

hash< OperatorInfo > SqlUtil::op_clt

(

string

arg

)

returns an OperatorInfo hash for the "<" operator with the given argument for use in where clauses when comparing the values of two columns

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_clt("other_name"))));

Parameters

arg	the name of the column to compare against

Returns

an OperatorInfo hash for use in where clauses

See also

op_lt() for a function to be used when comparing a column against an immediate value

op_cne()

hash< OperatorInfo > SqlUtil::op_cne

(

string

arg

)

returns an OperatorInfo hash for the "!=" or "<>" operator with the given argument for use in where clauses when comparing the values of two columns

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_cne("other_name"))));

Parameters

arg	the name of the column to compare against

Returns

an OperatorInfo hash for use in where clauses

See also

op_ne() for a function to be used when comparing a column against an immediate value

op_eq()

hash< OperatorInfo > SqlUtil::op_eq

(

auto

arg

)

returns an OperatorInfo hash for the "==" operator with the given argument for use in where clauses when comparing column values to immediate values

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_eq("Smith"))));

Parameters

arg	the argument for the operator

Returns

an OperatorInfo hash for use in where clauses

See also

op_ceq() for a function to be used when comparing two column values

This operator also handles Qore::NULL as SQL NULL values expanding them into IS NULL clause.

op_ge()

hash< OperatorInfo > SqlUtil::op_ge

(

auto

arg

)

returns an OperatorInfo hash for the ">=" operator with the given argument for use in where clauses when comparing column values to immediate values

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_ge("Apple"))));

Parameters

arg	the argument for the operator

Returns

an OperatorInfo hash for use in where clauses

See also

op_cge() for a function to be used when comparing two column values

op_gt()

hash< OperatorInfo > SqlUtil::op_gt

(

auto

arg

)

returns an OperatorInfo hash for the ">" operator with the given argument for use in where clauses when comparing column values to immediate values

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_gt("Apple"))));

Parameters

arg	the argument for the operator

Returns

an OperatorInfo hash for use in where clauses

See also

op_cgt() for a function to be used when comparing two column values

op_in() [1/2]

hash< OperatorInfo > SqlUtil::op_in

(

)

returns an OperatorInfo hash for the "in" operator with all arguments passed to the function; for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_in(200, 300, 500, 9))));

Returns

an OperatorInfo hash for use in where clauses

Note

The argument list size may be constrained depending on the database server / driver used; passing a large number of arguments to this function may be a sign of an improper application or query design; consider using a join with a temporary table instead of passing a large number of arguments to this function

op_in() [2/2]

hash< OperatorInfo > SqlUtil::op_in

(

list< auto >

args

)

returns an OperatorInfo hash for the "in" operator with the given argument list as the first argument; for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_in(idlist))));

Parameters

args	a list of values for the "in" operator

Returns

an OperatorInfo hash for use in where clauses

Note

The argument list size may be constrained depending on the database server / driver used; passing a large number of arguments to this function may be a sign of an improper application or query design; consider using a join with a temporary table instead of passing a large number of arguments to this function

op_in_select() [1/3]

hash< OperatorInfo > SqlUtil::op_in_select	(	AbstractTable	table,
		hash< auto >	select_hash
	)

returns an OperatorInfo hash for the "in" operator with a subquery as the argument; for use in where clauses

Example:

*list<auto> rows = table.selectRows({"where": {"name": op_in_select(other_table, {"columns": "name", "where": where_hash})}});

Returns

an OperatorInfo hash for use in where clauses

op_in_select() [2/3]

hash< OperatorInfo > SqlUtil::op_in_select	(	string	table,
		hash< auto >	select_hash
	)

returns an OperatorInfo hash for the "in" operator with a subquery as the argument; for use in where clauses

Example:

*list<auto> rows = table.selectRows({"where": {"name": op_in_select("other_table", {"columns": "name", "where": where_hash})}});

Returns

an OperatorInfo hash for use in where clauses

op_in_select() [3/3]

hash< OperatorInfo > SqlUtil::op_in_select	(	Table	table,
		hash< auto >	select_hash
	)

returns an OperatorInfo hash for the "in" operator with a subquery as the argument; for use in where clauses

Example:

*list<auto> rows = table.selectRows({"where": {"name": op_in_select(other_table, {"columns": "name", "where": where_hash})}});

Returns

an OperatorInfo hash for use in where clauses

op_le()

hash< OperatorInfo > SqlUtil::op_le

(

auto

arg

)

returns an OperatorInfo hash for the "<=" operator with the given argument for use in where clauses when comparing column values to immediate values

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_le("Zebra"))));

Parameters

arg	the argument for the operator

Returns

an OperatorInfo hash for use in where clauses

See also

op_cle() for a function to be used when comparing two column values

op_like()

hash< OperatorInfo > SqlUtil::op_like

(

string

str

)

returns an OperatorInfo hash for the "like" operator with the given argument for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_like("%smith%"))));

Parameters

str	the argument for the operator

Returns

an OperatorInfo hash for use in where clauses

op_lt()

hash< OperatorInfo > SqlUtil::op_lt

(

auto

arg

)

returns an OperatorInfo hash for the "<" operator with the given argument for use in where clauses when comparing column values to immediate values

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_lt("Zebra"))));

Parameters

arg	the argument for the operator

Returns

an OperatorInfo hash for use in where clauses

See also

op_clt() for a function to be used when comparing two column values

op_ne()

hash< OperatorInfo > SqlUtil::op_ne

(

auto

arg

)

returns an OperatorInfo hash for the "!=" or "<>" operator with the given argument for use in where clauses when comparing column values to immediate values

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_ne("Smith"))));

Parameters

arg	the argument for the operator

Returns

an OperatorInfo hash for use in where clauses

See also

op_cne() for a function to be used when comparing two column values

This operator also handles Qore::NULL as SQL NULL values expanding them into IS NOT NULL clause.

op_not()

hash< OperatorInfo > SqlUtil::op_not

(

hash

arg

)

returns an OperatorInfo hash for the "not" operator; for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_not(op_in(200, 300, 500, 9))))_;

Returns

an OperatorInfo hash for use in where clauses

op_substr() [1/2]

hash< OperatorInfo > SqlUtil::op_substr	(	int	start,
		string	text
	)

returns an OperatorInfo hash for the "substr" operator with the given arguments; for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("hex": op_substr(5, "BEEF"))));

Parameters

start	position where the substring starts
text	what substring should match

Returns

an OperatorInfo hash for use in where clauses

op_substr() [2/2]

hash< OperatorInfo > SqlUtil::op_substr	(	string	text,
		int	start,
		soft< int >	count
	)

returns an OperatorInfo hash for the "substr" operator with the given arguments; for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_substr(1, 6, "Martin"))));

Parameters

start	position where the substring starts
count	length of the substring in characters
text	what substring should match

Returns

an OperatorInfo hash for use in where clauses

uop_append()

hash< UpdateOperatorInfo > SqlUtil::uop_append	(	string	arg,
		soft< hash< UpdateOperatorInfo > >	nest
	)

returns an UpdateOperatorInfo hash for the "append" or concatenate operator with the given argument

Example:

int rows_updated = t.update(("permission_type": uop_append("-migrated", uop_lower())));

Parameters

arg	the text to prepend to the row values in the output column
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_divide()

hash< UpdateOperatorInfo > SqlUtil::uop_divide	(	auto	arg,
		soft< hash< UpdateOperatorInfo > >	nest
	)

returns an UpdateOperatorInfo hash for the "/" operator with the given arguments

Example:

int rows_updated = t.update(("counter": uop_divide(2)));

Parameters

arg	numeric value to divide the column by
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_lower()

hash< UpdateOperatorInfo > SqlUtil::uop_lower

(

soft< hash< UpdateOperatorInfo > >

nest

)

returns an UpdateOperatorInfo hash for the "lower" operator with the given argument; returns a column value in lower case

Example:

int rows_updated = t.update(("permission_type": uop_lower()));

Parameters

nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_minus()

hash< UpdateOperatorInfo > SqlUtil::uop_minus	(	auto	arg,
		soft< hash< UpdateOperatorInfo > >	nest
	)

returns an UpdateOperatorInfo hash for the "-" operator with the given arguments

Example:

int rows_updated = t.update(("counter": uop_minus(1)));

Parameters

arg	numeric value to subtract from the column
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_multiply()

hash< UpdateOperatorInfo > SqlUtil::uop_multiply	(	auto	arg,
		soft< hash< UpdateOperatorInfo > >	nest
	)

returns an UpdateOperatorInfo hash for the "*" operator with the given arguments

Example:

int rows_updated = t.update(("counter": uop_multiply(2)));

Parameters

arg	numeric value to multiply the column by
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_plus()

hash< UpdateOperatorInfo > SqlUtil::uop_plus	(	auto	arg,
		soft< hash< UpdateOperatorInfo > >	nest
	)

returns an UpdateOperatorInfo hash for the "+" operator with the given arguments

Example:

int rows_updated = t.update(("counter": uop_plus(1)));

Parameters

arg	numeric value to add to the column
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_prepend()

hash< UpdateOperatorInfo > SqlUtil::uop_prepend	(	string	arg,
		soft< hash< UpdateOperatorInfo > >	nest
	)

returns an UpdateOperatorInfo hash for the "prepend" operator with the given argument

Example:

int rows_updated = t.update(("permission_type": uop_prepend("migrated-", uop_lower())));

Parameters

arg	the text to prepend to the row values in the output column
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_seq()

hash< UpdateOperatorInfo > SqlUtil::uop_seq

(

string

seq

)

returns an UpdateOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose value should be returned

Example:

*list<auto> rows = t.update(("id": uop_seq("xid")), ("type": "user"));

Parameters

seq	the name of the sequence whose value should be returned

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_seq_currval()

hash< UpdateOperatorInfo > SqlUtil::uop_seq_currval

(

string

seq

)

returns an UpdateOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose current value should be returned

Example:

*list<auto> rows = t.update(("id": uop_seq("xid")), ("type": "user"));

Parameters

seq	the name of the sequence whose current value should be returned

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_substr()

hash< UpdateOperatorInfo > SqlUtil::uop_substr	(	soft< hash< UpdateOperatorInfo > >	nest,
		int	start,
		soft< int >	count
	)

returns an UpdateOperatorInfo hash for the "substr" operator with the given arguments; returns a substring of a column value

Example:

int rows_updated = t.update(("first_name": uop_substr(1, 1)));

Parameters

start	position where the substring starts
count	length of the substring in characters
nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

uop_upper()

hash< UpdateOperatorInfo > SqlUtil::uop_upper

(

soft< hash< UpdateOperatorInfo > >

nest

)

returns an UpdateOperatorInfo hash for the "upper" operator with the given argument; returns a column value in upper case

Example:

int rows_updated = t.update(("permission_type": uop_upper()));

Parameters

nest	any nested operation to the operator

Returns

an UpdateOperatorInfo hash corresponding to the arguments for use in update statements

wop_or()

hash< string, hash< OperatorInfo > > SqlUtil::wop_or	(	hash	h1,
		hash	h2
	)

returns an OperatorInfo hash with a fake "_OR_" column name; the list of arguments to the function is combined such that each hash in the list generates SQL expressions combined with "and" logic, and each of those clauses is combined with "or" logic; this is for use in where clauses

Example:

*list<auto> rows = table.selectRows(("where": ("name": op_ceq("other_name")) + wop_or(("type": "C", "validation_flag": op_ne(NULL)), ("expiration_date": op_ge(date)))));

Generates:

select * from schema.table where name = other_name and ((type = %v and validation flag is not null) or (expiration_date >= %v))

Parameters

h1	the first hash of expressions to combine with "or" logic
h2	the second hash of expressions to combine with "or" logic
...	remaining expressions to combine with "or" logic

Returns

a hash with an OperatorInfo hash value keyed by a fake column name ("_OR_" with a numeric prefix for uniqueness) for use in a where operation description hash for use in where clauses

Note

a random prefix is used so that multiple uses of the function can be used to generate a single where clause hash

Variable Documentation

COP_APPEND

const auto SqlUtil::COP_APPEND = ...

to append a string to a column on output

See also

cop_append()

COP_AS

const auto SqlUtil::COP_AS = ...

to rename a column on output

See also

cop_as()

COP_AVG

const auto SqlUtil::COP_AVG = ...

to return the average value

See also

cop_avg

COP_CAST

const auto SqlUtil::COP_CAST = ...

to convert column value into another datatype

See also

cop_cast()

COP_COALESCE

const auto SqlUtil::COP_COALESCE = ...

to return the first non-null argument in the list

See also

cop_coalesce()

COP_COUNT

const auto SqlUtil::COP_COUNT = ...

to return the row count

See also

cop_count

COP_CUME_DIST

const auto SqlUtil::COP_CUME_DIST = ...

Analytic (window) function: CUME_DIST.

See also

cop_cume_dist()

Since

SqlUtil 1.4.0

COP_DENSE_RANK

const auto SqlUtil::COP_DENSE_RANK = ...

Analytic (window) function: DENSE_RANK.

See also

cop_dense_rank()

Since

SqlUtil 1.4.0

COP_DISTINCT

const auto SqlUtil::COP_DISTINCT = ...

to return distinct values

See also

cop_distinct

COP_DIVIDE

const auto SqlUtil::COP_DIVIDE = ...

the SQL "divide" operator

See also

cop_divide()

COP_FIRST_VALUE

const auto SqlUtil::COP_FIRST_VALUE = ...

Analytic (window) function: FIRST_VALUE.

See also

cop_first_value()

Since

SqlUtil 1.4.0

COP_LAST_VALUE

const auto SqlUtil::COP_LAST_VALUE = ...

Analytic (window) function: LAST_VALUE.

See also

cop_last_value()

Since

SqlUtil 1.4.0

COP_LENGTH

const auto SqlUtil::COP_LENGTH = ...

to get the length of a text field

See also

cop_length()

Since

SqlUtil 1.3.1

COP_LOWER

const auto SqlUtil::COP_LOWER = ...

to return column value in lower case

See also

cop_lower()

COP_MAX

const auto SqlUtil::COP_MAX = ...

to return the maximum value

See also

cop_max

COP_MIN

const auto SqlUtil::COP_MIN = ...

to return the minimum value

See also

cop_min

COP_MINUS

const auto SqlUtil::COP_MINUS = ...

the SQL "minus" operator

See also

cop_minus()

COP_MULTIPLY

const auto SqlUtil::COP_MULTIPLY = ...

the SQL "multiply" operator

See also

cop_multiply()

COP_NTILE

const auto SqlUtil::COP_NTILE = ...

Analytic (window) function: NTILE.

See also

cop_ntile()

Since

SqlUtil 1.4.0

COP_OVER

const auto SqlUtil::COP_OVER = ...

the SQL "over" clause

See also

cop_over()

COP_PERCENT_RANK

const auto SqlUtil::COP_PERCENT_RANK = ...

Analytic (window) function: PERCENT_RANK.

See also

cop_percent_rank()

Since

SqlUtil 1.4.0

COP_PLUS

const auto SqlUtil::COP_PLUS = ...

the SQL "plus" operator

See also

cop_plus()

COP_PREPEND

const auto SqlUtil::COP_PREPEND = ...

to prepend a string to a column on output

See also

cop_prepend()

COP_RANK

const auto SqlUtil::COP_RANK = ...

Analytic (window) function: RANK.

See also

cop_rank()

Since

SqlUtil 1.4.0

COP_ROW_NUMBER

const auto SqlUtil::COP_ROW_NUMBER = ...

Analytic (window) function: ROW_NUMBER.

See also

cop_row_number()

Since

SqlUtil 1.4.0

COP_SEQ

const auto SqlUtil::COP_SEQ = ...

to return the next value of a sequence

See also

cop_seq()

COP_SEQ_CURRVAL

const auto SqlUtil::COP_SEQ_CURRVAL = ...

to return the last value of a sequence issued in the same session

See also

cop_seq_currval()

COP_SUBSTR

const auto SqlUtil::COP_SUBSTR = ...

to extract a substring from a column

See also

cop_substr()

COP_SUM

const auto SqlUtil::COP_SUM = ...

to return the sum value

See also

cop_sum

COP_TRUNC_DATE

const auto SqlUtil::COP_TRUNC_DATE = ...

to return the date with truncated value

See also

cop_trunc_date()

See also sql_cop_trunc_date_enum

Since

SqlUtil 1.4.0

COP_UPPER

const auto SqlUtil::COP_UPPER = ...

to return column value in upper case

See also

cop_upper()

COP_VALUE

const auto SqlUtil::COP_VALUE = ...

to append a constant value (SQL Literal) to use as an output column value

See also

cop_value()

COP_YEAR

const auto SqlUtil::COP_YEAR = ...

to return a date value with year information only

See also

cop_year()

COP_YEAR_DAY

const auto SqlUtil::COP_YEAR_DAY = ...

to return a date value with year to day information

See also

cop_year_day()

COP_YEAR_HOUR

const auto SqlUtil::COP_YEAR_HOUR = ...

to return a date value with year to hour information

See also

cop_year_hour()

COP_YEAR_MONTH

const auto SqlUtil::COP_YEAR_MONTH = ...

to return a date value with year to month information

See also

cop_year_month()

DB_FUNCTIONS

const SqlUtil::DB_FUNCTIONS = ...

Features constants.

Features constants Feature: functions

Feature: functions

IOP_SEQ

const auto SqlUtil::IOP_SEQ = ...

for using the value of a sequence

See also

iop_seq()

IOP_SEQ_CURRVAL

const auto SqlUtil::IOP_SEQ_CURRVAL = ...

for using the last value of a sequence issued in the current session

See also

iop_seq_currval()

JOP_INNER

const auto SqlUtil::JOP_INNER = ...

for standard inner joins

See also

join_inner()

JOP_LEFT

const auto SqlUtil::JOP_LEFT = ...

for left outer joins

See also

join_left()

JOP_RIGHT

const auto SqlUtil::JOP_RIGHT = ...

for right outer joins

See also

join_right()

OP_BETWEEN

const auto SqlUtil::OP_BETWEEN = ...

the SQL "between" operator for use in Where Clauses

See also

op_between()

OP_CEQ

const auto SqlUtil::OP_CEQ = ...

the SQL equals operator (=) for use in Where Clauses

See also

op_ceq()

OP_CGE

const auto SqlUtil::OP_CGE = ...

the SQL greater than or equals operator (>=) for use in Where Clauses

See also

op_cge()

OP_CGT

const auto SqlUtil::OP_CGT = ...

the SQL greater than operator (>) for use in Where Clauses

See also

op_cgt()

OP_CLE

const auto SqlUtil::OP_CLE = ...

the SQL less than or equals (<=) operator for use in Where Clauses

See also

op_cle()

OP_CLT

const auto SqlUtil::OP_CLT = ...

the SQL less than (<) operator for use in Where Clauses when comparing two columns

See also

op_clt()

OP_CNE

const auto SqlUtil::OP_CNE = ...

the SQL not equals operator (!= or <>) for use in Where Clauses

See also

op_cne()

OP_EQ

const auto SqlUtil::OP_EQ = ...

the SQL equals operator (=) for use in Where Clauses

See also

op_eq()

OP_GE

const auto SqlUtil::OP_GE = ...

the SQL greater than or equals operator (>=) for use in Where Clauses

See also

op_ge()

OP_GT

const auto SqlUtil::OP_GT = ...

the SQL greater than operator (>) for use in Where Clauses

See also

op_gt()

OP_IN

const auto SqlUtil::OP_IN = ...

the SQL "in" operator for use in Where Clauses

See also

op_in()

OP_IN_SELECT

const auto SqlUtil::OP_IN_SELECT = ...

the SQL "in" operator with a select query for use in Where Clauses

See also

op_in_select()

OP_LE

const auto SqlUtil::OP_LE = ...

the SQL less than or equals (<=) operator for use in Where Clauses

See also

op_le()

OP_LIKE

const auto SqlUtil::OP_LIKE = ...

the SQL "like" operator for use in Where Clauses

See also

op_like()

OP_LT

const auto SqlUtil::OP_LT = ...

the SQL less than (<) operator for use in Where Clauses

See also

op_lt()

OP_NE

const auto SqlUtil::OP_NE = ...

the SQL not equals operator (!= or <>) for use in Where Clauses

See also

op_ne()

OP_NOT

const auto SqlUtil::OP_NOT = ...

the SQL "not" operator for use in Where Clauses

See also

op_not()

OP_OR

const auto SqlUtil::OP_OR = ...

to combine SQL expressions with "or" for use in Where Clauses

See also

wop_or()

OP_SUBSTR

const auto SqlUtil::OP_SUBSTR = ...

the SQL "substr" operator for use in Where Clauses

See also

op_substr()