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 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 insert operator functions More...

hashdecl	JoinOperatorInfo
	join operator info hash as returned by all join operator functions More...

hashdecl	OperatorInfo
	SQL operator info hash as returned by all 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 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 column, string arg, auto arg1, auto arg2)
	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 (auto column, string partitionby, string orderby)
	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, *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, *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 (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

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 (AbstractTable table, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for standard inner joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_inner (string ta, AbstractTable table, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (string ta, Table table, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (string table_name, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for standard inner joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_inner (Table table, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for standard inner joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_inner_alias (string ta, string table_name, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (AbstractTable table, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for left outer joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_left (string ta, AbstractTable table, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (string ta, Table table, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (string table_name, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for left outer joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_left (Table table, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for left outer joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_left_alias (string ta, string table_name, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (AbstractTable table, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for right outer joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_right (string ta, AbstractTable table, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (string ta, Table table, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (string table_name, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for right outer joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_right (Table table, string alias, hash jcols, hash cond, hash< auto > opt)
	returns a hash for right outer joins with the given arguments

hash< string, hash< JoinOperatorInfo > >	join_right_alias (string ta, string table_name, string alias, hash jcols, hash cond, hash< auto > opt)
	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 (string cop, auto column, auto arg)

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

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

hash< string, hash< JoinOperatorInfo > >	make_jop (string jop, string table_name, string alias, hash jcols, hash cond, string ta, *hash< auto > opt)
	returns a hash keyed with the table name assigned to a JoinOperatorInfo hash

hash< OperatorInfo >	make_op (string op, auto arg)

hash< UpdateOperatorInfo >	make_uop (string uop, auto arg, *hash< UpdateOperatorInfo > nest)

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, *int count, string text)
	returns an OperatorInfo hash for the `"substr"` operator with the given arguments; 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

	sqlutil_register_ds_deserializer (*code new_ds_get)
	registers a closure or call reference taking a string type and string datasource configuration that will return an AbstractDatasource

	sqlutil_register_ds_serializer (*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, *hash< UpdateOperatorInfo > nest)
	returns an UpdateOperatorInfo hash for the `"append"` or concatenate operator with the given argument

hash< UpdateOperatorInfo >	uop_divide (auto arg, *hash< UpdateOperatorInfo > nest)
	returns an UpdateOperatorInfo hash for the `"/"` operator with the given arguments

hash< UpdateOperatorInfo >	uop_lower (*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, *hash< UpdateOperatorInfo > nest)
	returns an UpdateOperatorInfo hash for the `"-"` operator with the given arguments

hash< UpdateOperatorInfo >	uop_multiply (auto arg, *hash< UpdateOperatorInfo > nest)
	returns an UpdateOperatorInfo hash for the `"*"` operator with the given arguments

hash< UpdateOperatorInfo >	uop_plus (auto arg, *hash< UpdateOperatorInfo > nest)
	returns an UpdateOperatorInfo hash for the `"+"` operator with the given arguments

hash< UpdateOperatorInfo >	uop_prepend (string arg, *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 (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

hash< UpdateOperatorInfo >	uop_upper (*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	BLOB = "blob"
	specifies a large variable-length binary column (ie `BLOB` or `BYTEA`, etc)

const	CHAR = "char"
	specifies a `CHAR` column

const	CLOB = "clob"
	specifies a large variable-length character column (ie `CLOB` or `TEXT`, etc)

const	COP_APPEND = "append"
	to append a string to a column on output

const	COP_AS = "as"

const	COP_AVG = "avg"
	to return the average value

const	COP_CAST = "cast"
	to convert column value into another datatype

const	COP_COALESCE = "coalesce"
	to return the first non-null argument in the list

const	COP_COUNT = "count"
	to return the row count

const	COP_CUME_DIST = "cume_dist"
	Analytic (window) function: CUME_DIST.

const	COP_DENSE_RANK = "dense_rank"
	Analytic (window) function: DENSE_RANK.

const	COP_DISTINCT = "distinct"
	to return distinct values

const	COP_DIVIDE = "divide"
	the SQL `"divide"` operator

const	COP_FIRST_VALUE = "first_value"
	Analytic (window) function: FIRST_VALUE.

const	COP_LAST_VALUE = "last_value"
	Analytic (window) function: LAST_VALUE.

const	COP_LENGTH = "length"
	to get the length of a text field

const	COP_LOWER = "lower"
	to return column value in lower case

const	COP_MAX = "max"
	to return the maximum value

const	COP_MIN = "min"
	to return the minimum value

const	COP_MINUS = "minus"
	the SQL `"minus"` operator

const	COP_MULTIPLY = "multiply"
	the SQL `"multiply"` operator

const	COP_NTILE = "ntile"
	Analytic (window) function: NTILE.

const	COP_OVER = "over"
	the SQL `"over"` clause

const	COP_PERCENT_RANK = "percent_rank"
	Analytic (window) function: PERCENT_RANK.

const	COP_PLUS = "plus"
	the SQL `"plus"` operator

const	COP_PREPEND = "prepend"
	to prepend a string to a column on output

const	COP_RANK = "rank"
	Analytic (window) function: RANK.

const	COP_ROW_NUMBER = "row_number"
	Analytic (window) function: ROW_NUMBER.

const	COP_SEQ = "seq"
	to return the next value of a sequence

const	COP_SEQ_CURRVAL = "seq_currval"
	to return the last value of a sequence issued in the same session

const	COP_SUBSTR = "substr"
	to extract a substring from a column

const	COP_SUM = "sum"
	to return the sum value

const	COP_TRUNC_DATE = "truncate_date"
	to return the date with truncated value

const	COP_UPPER = "upper"
	to return column value in upper case

const	COP_VALUE = "value"
	to append a constant value (SQL Literal) to use as an output column value

const	COP_YEAR = "year"
	to return a date value with year information only

const	COP_YEAR_DAY = "year_day"
	to return a date value with year to day information

const	COP_YEAR_HOUR = "year_hour"
	to return a date value with year to hextern information

const	COP_YEAR_MONTH = "year_month"
	to return a date value with year to month information

const	DB_FUNCTIONS = "functions"
	Feature: functions.

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_SYNONYMS = "synonyms"
	Feature: synonyms.

const	DB_TABLES = "tables"
	Feature: tables.

const	DB_TYPES = "named types"
	Feature: named types.

const	DB_VIEWS = "views"
	Feature: views.

const	DefaultCopMap = ...
	a hash of default column operator descriptions

const	DefaultExpressionMap = ...
	Default expressions to be supported by all SqlUtil modules.

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 = ...

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"

const	IOP_SEQ = "seq"

const	IOP_SEQ_CURRVAL = "seq_currval"
	for using the last value of a sequence issued in the current session

const	JOP_INNER = "inner"

const	JOP_LEFT = "left"
	for left outer joins

const	JOP_RIGHT = "right"
	for right outer joins

const	JopMap = ...
	a hash of valid join operators

const	NUMERIC = "number"
	specifies a numeric column (equivalent to Qore::Type::Number)

const	OP_BETWEEN = "between"
	the SQL `"between"` operator for use in Where Clauses

const	OP_CEQ = "C="
	the SQL equals operator (=) for use in Where Clauses

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

const	OP_CGT = "C>"
	the SQL greater than operator (>) for use in Where Clauses

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

const	OP_CLT = "C<"
	the SQL less than (<) operator for use in Where Clauses when comparing two columns

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

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

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

const	OP_GT = ">"
	the SQL greater than operator (>) for use in Where Clauses

const	OP_IN = "in"
	the SQL `"in"` operator for use in Where Clauses

const	OP_IN_SELECT = "in_select"
	the SQL `"in"` operator with a select query for use in Where Clauses

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

const	OP_LIKE = "like"

const	OP_LT = "<"
	the SQL less than (<) operator for use in Where Clauses

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

const	OP_NOT = "not"
	the SQL `"not"` operator for use in Where Clauses

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

const	SqlUtilDrivers = ...
	known drivers

const	SZ_MAND = 1
	the data type takes a mandatory size parameter

const	SZ_NONE = 0

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	VARCHAR = "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.

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: