Qore SqlUtil Module Reference  1.4
SqlUtil Namespace Reference

the SqlUtil namespace contains all the objects in the SqlUtil module More...

Classes

class  AbstractCheckConstraint
 abstract class for check constraints More...
 
class  AbstractColumn
 the base class for column information 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  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  AbstractPrimaryKey
 represents a primary key 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...
 
struct  ColumnOperatorInfo
 column operator info hash as returned by all 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...
 
struct  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...
 
struct  InsertOperatorInfo
 insert operator info hash as returned by all insert operator functions More...
 
struct  JoinOperatorInfo
 join operator info hash as returned by all join operator functions More...
 
class  NumericColumnInfo
 the base class to use to extend AbstractColumn to implement numeric columns More...
 
struct  OperatorInfo
 SQL operator info hash as returned by all operator functions. 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...
 
struct  UpdateOperatorInfo
 update operator info hash as returned by all update operator functions More...
 

Functions

hash< ColumnOperatorInfocop_append (auto column, string arg)
 returns a ColumnOperatorInfo hash for the "append" operator with the given argument More...
 
hash< ColumnOperatorInfocop_as (auto column, string arg)
 returns a ColumnOperatorInfo hash for the "as" operator with the given argument More...
 
hash< ColumnOperatorInfocop_avg (auto column)
 returns a ColumnOperatorInfo hash for the "avg" operator; returns average column values More...
 
hash< ColumnOperatorInfocop_cast (auto column, string arg, auto arg1, auto arg2)
 returns a ColumnOperatorInfo hash for the "cast" operator with the given argument(s) More...
 
hash< ColumnOperatorInfocop_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 More...
 
hash< ColumnOperatorInfocop_count (auto column="")
 returns a ColumnOperatorInfo hash for the "count" operator; returns row counts More...
 
hash< ColumnOperatorInfocop_cume_dist ()
 Analytic/window function: relative rank of the current row. More...
 
hash< ColumnOperatorInfocop_dense_rank ()
 Analytic/window function: rank of the current row without gaps. More...
 
hash< ColumnOperatorInfocop_distinct (auto column)
 returns a ColumnOperatorInfo hash for the "distinct" operator with the given argument; returns distinct column values More...
 
hash< ColumnOperatorInfocop_divide (auto column1, auto column2)
 returns a ColumnOperatorInfo hash for the "/" operator with the given arguments More...
 
hash< ColumnOperatorInfocop_first_value (any column)
 Analytic/window function: value evaluated at the row that is the first row of the window frame. More...
 
hash< ColumnOperatorInfocop_last_value (any column)
 Analytic/window function: value evaluated at the row that is the last row of the window frame. More...
 
hash< ColumnOperatorInfocop_length (auto column)
 returns a ColumnOperatorInfo hash for the "len" operator with the given argument; returns the length of the given text field More...
 
hash< ColumnOperatorInfocop_lower (auto column)
 returns a ColumnOperatorInfo hash for the "lower" operator with the given argument; returns a column value in lower case More...
 
hash< ColumnOperatorInfocop_max (auto column)
 returns a ColumnOperatorInfo hash for the "max" operator; returns maximum column values More...
 
hash< ColumnOperatorInfocop_min (auto column)
 returns a ColumnOperatorInfo hash for the "min" operator; returns minimum column values More...
 
hash< ColumnOperatorInfocop_minus (auto column1, auto column2)
 returns a ColumnOperatorInfo hash for the "-" operator with the given arguments More...
 
hash< ColumnOperatorInfocop_multiply (auto column1, auto column2)
 returns a ColumnOperatorInfo hash for the "*" operator with the given arguments More...
 
hash< ColumnOperatorInfocop_ntile (int value)
 Analytic/window function: integer ranging from 1 to the argument value, dividing the partition as equally as possible. More...
 
hash< ColumnOperatorInfocop_over (auto column, *string partitionby, *string orderby)
 returns a ColumnOperatorInfo hash for the "over" clause More...
 
hash< ColumnOperatorInfocop_percent_rank ()
 Analytic/window function: relative rank of the current row. More...
 
hash< ColumnOperatorInfocop_plus (auto column1, auto column2)
 returns a ColumnOperatorInfo hash for the "+" operator with the given arguments More...
 
hash< ColumnOperatorInfocop_prepend (auto column, string arg)
 returns a ColumnOperatorInfo hash for the "prepend" operator with the given argument More...
 
hash< ColumnOperatorInfocop_rank ()
 Analytic/window function: rank of the current row with gaps. More...
 
hash< ColumnOperatorInfocop_row_number ()
 Analytic/window function: number of the current row within its partition, counting from 1. More...
 
hash< ColumnOperatorInfocop_seq (string seq, *string as)
 returns a ColumnOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose value should be returned More...
 
hash< ColumnOperatorInfocop_seq_currval (string seq, *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 More...
 
hash< ColumnOperatorInfocop_substr (auto column, int start, *int count)
 returns a ColumnOperatorInfo hash for the "substr" operator with the given arguments; returns a substring of a column value More...
 
hash< ColumnOperatorInfocop_sum (auto column)
 returns a ColumnOperatorInfo hash for the "sum" operator; returns the total sum of a numeric column. More...
 
hash< ColumnOperatorInfocop_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) More...
 
hash< ColumnOperatorInfocop_upper (auto column)
 returns a ColumnOperatorInfo hash for the "upper" operator with the given argument; returns a column value in upper case More...
 
hash< ColumnOperatorInfocop_value (auto arg)
 returns a ColumnOperatorInfo hash for the "value" (literal) operator with the given argument More...
 
hash< ColumnOperatorInfocop_year (auto column)
 returns a ColumnOperatorInfo hash for the "year" operator with the given argument More...
 
hash< ColumnOperatorInfocop_year_day (auto column)
 returns a ColumnOperatorInfo hash for the "year_day" operator with the given argument More...
 
hash< ColumnOperatorInfocop_year_hour (auto column)
 returns a ColumnOperatorInfo hash for the "year_hour" operator with the given argument More...
 
hash< ColumnOperatorInfocop_year_month (auto column)
 returns a ColumnOperatorInfo hash for the "year_month" operator with the given argument More...
 
hash< InsertOperatorInfoiop_seq (string arg)
 returns an InsertOperatorInfo hash for retrieving the value of the given sequence in insert queries More...
 
hash< InsertOperatorInfoiop_seq_currval (string arg)
 returns an InsertOperatorInfo hash for retrieving the current value of the given sequence in insert queries More...
 
hash< string, hash< JoinOperatorInfo > > join_inner (AbstractTable table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for standard inner joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_inner (Table table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for standard inner joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_inner (string table_name, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for standard inner joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_inner (string ta, AbstractTable table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_inner (string ta, Table table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_inner_alias (string ta, string table_name, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_left (AbstractTable table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for left outer joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_left (Table table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for left outer joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_left (string table_name, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for left outer joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_left (string ta, AbstractTable table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_left (string ta, Table table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_left_alias (string ta, string table_name, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_right (AbstractTable table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for right outer joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_right (Table table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for right outer joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_right (string table_name, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for right outer joins with the given arguments More...
 
hash< string, hash< JoinOperatorInfo > > join_right (string ta, AbstractTable table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_right (string ta, Table table, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< string, hash< JoinOperatorInfo > > join_right_alias (string ta, string table_name, *string alias, *hash jcols, *hash cond, *hash opt)
 returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table More...
 
hash< ColumnOperatorInfomake_cop (string cop, auto column, auto arg)
 returns a ColumnOperatorInfo hash More...
 
hash< InsertOperatorInfomake_iop (string iop, auto arg)
 returns an InsertOperatorInfo hash More...
 
hash< string, hash< JoinOperatorInfo > > make_jop (string jop, AbstractTable table, *string alias, *hash jcols, *hash cond, *string ta, *hash opt)
 returns hash keyed with the table name assigned to a JoinOperatorInfo hash More...
 
hash< string, hash< JoinOperatorInfo > > make_jop (string jop, string table_name, *string alias, *hash jcols, *hash cond, *string ta, *hash opt)
 returns a hash keyed with the table name assigned to a JoinOperatorInfo hash More...
 
hash< OperatorInfomake_op (string op, auto arg)
 returns an OperatorInfo hash
 
hash< UpdateOperatorInfomake_uop (string uop, auto arg, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_in ()
 returns an OperatorInfo hash for the "in" operator with all arguments passed to the function; for use in where clauses More...
 
hash< OperatorInfoop_in (list args)
 returns an OperatorInfo hash for the "in" operator with the given argument list as the first argument; for use in where clauses More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_like (string str)
 returns an OperatorInfo hash for the "like" operator with the given argument for use in where clauses More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_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 More...
 
hash< OperatorInfoop_not (hash arg)
 returns an OperatorInfo hash for the "not" operator; for use in where clauses More...
 
hash< OperatorInfoop_substr (int start, *int count, string text)
 returns an OperatorInfo hash for the "substr" operator with the given arguments; for use in where clauses More...
 
hash< OperatorInfoop_substr (int start, string text)
 returns an OperatorInfo hash for the "substr" operator with the given arguments; for use in where clauses More...
 
hash< UpdateOperatorInfouop_append (string arg, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "append" or concatenate operator with the given argument More...
 
hash< UpdateOperatorInfouop_divide (auto arg, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "/" operator with the given arguments More...
 
hash< UpdateOperatorInfouop_lower (*hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "lower" operator with the given argument; returns a column value in lower case More...
 
hash< UpdateOperatorInfouop_minus (auto arg, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "-" operator with the given arguments More...
 
hash< UpdateOperatorInfouop_multiply (auto arg, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "*" operator with the given arguments More...
 
hash< UpdateOperatorInfouop_plus (auto arg, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "+" operator with the given arguments More...
 
hash< UpdateOperatorInfouop_prepend (string arg, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "prepend" operator with the given argument More...
 
hash< UpdateOperatorInfouop_seq (string seq)
 returns an UpdateOperatorInfo hash for the "seq" operator with the given argument giving the sequence name whose value should be returned More...
 
hash< UpdateOperatorInfouop_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 More...
 
hash< UpdateOperatorInfouop_substr (int start, *int count, *hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "substr" operator with the given arguments; returns a substring of a column value More...
 
hash< UpdateOperatorInfouop_upper (*hash< UpdateOperatorInfo > nest)
 returns an UpdateOperatorInfo hash for the "upper" operator with the given argument; returns a column value in upper case More...
 
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 More...
 

Variables

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

Detailed Description

the SqlUtil namespace contains all the objects in the SqlUtil module

Variable Documentation

◆ DB_FUNCTIONS

const SqlUtil::DB_FUNCTIONS = "functions"

Features constants.

Feature: functions