Qore::SQL Namespace Reference

SQL namespace. More...

Classes
class	AbstractDatasource
	This class defines an abstract interface for database access, inherited by both the Datasource and DatasourcePool classes. More...
class	AbstractSQLStatement
	This class defines an abstract interface for the SQLStatement class. More...
class	Datasource
	This class provides the Qore interface to databases. More...
class	DatasourcePool
	Provides transparent per-thread, per-transaction datasource connection pooling. More...
class	SQLStatement
	The SQLStatement class provides the most flexibilty for executing SQL on a database server. More...

Functions
*int	getDBIDriverCapabilities (string driver)
	Returns an integer representing the capabilities of a DBI driver binary-OR'ed together (see DBI Capability Constants) or NOTHING if the driver is not already loaded. More...
nothing	getDBIDriverCapabilities ()
	This function variant does nothing at all; it is only included for backwards-compatibility with qore prior to version 0.8.0 for functions that would ignore type errors in arguments. More...
*list< string >	getDBIDriverCapabilityList (string driver)
	Returns a list of each capability supported by the given DBI driver (see DBI Capability Constants) or NOTHING if the driver cannot be found. More...
nothing	getDBIDriverCapabilityList ()
	This function variant does nothing at all; it is only included for backwards-compatibility with qore prior to version 0.8.0 for functions that would ignore type errors in arguments. More...
*list< string >	getDBIDriverList ()
	Returns a list of strings of DBI drivers currently loaded or NOTHING if no drivers are loaded. More...
hash	parseDatasource (string ds)
	Returns a datasource hash of the components of a datasource string. More...
nothing	parseDatasource ()
	This function variant does nothing at all; it is only included for backwards-compatibility with qore prior to version 0.8.0 for functions that would ignore type errors in arguments. More...
int	dbi_get_driver_capabilities (string driver)
	Returns an integer representing the capabilities of a DBI driver binary-OR'ed together (see DBI Capability Constants) or 0 if the driver is not already loaded. More...
*list< string >	dbi_get_driver_capability_list (string driver)
	Returns a list of each capability supported by the given DBI driver (see DBI Capability Constants) or NOTHING if the driver cannot be found. More...
*list< string >	dbi_get_driver_list ()
	Returns a list of strings of DBI drivers currently loaded or NOTHING if no drivers are loaded. More...
*hash< auto >	dbi_get_driver_options (string driver)
	returns a hash of driver options More...
hash< auto >	parse_datasource (string ds)
	Returns a datasource hash of the components of a datasource string. More...

Variables
const	DSDB2 = "db2"
	for the "db2" driver
const	DSFreeTDS = "freetds"
	for the "freetds" driver
const	DSJDBC = "jdbc"
	for the "jdbc" driver
const	DSMSSQL = "freetds"
	another constant for the "freetds" driver
const	DSMySQL = "mysql"
	for the "mysql" driver
const	DSOracle = "oracle"
	for the "oracle" driver
const	DSPGSQL = "pgsql"
	for the "pgsql" driver
const	DSSQLite3 = "sqlite3"
	for the "sqlite3" driver
const	DSSybase = "sybase"
	for the "sybase" driver
const	DBI_CAP_AUTORECONNECT = DBI_CAP_AUTORECONNECT
	Indicates that the DBI driver supports automatically/transparently reconnecting to the server if the connection is lost while not in a transaction.
const	DBI_CAP_BIND_BY_PLACEHOLDER = DBI_CAP_BIND_BY_PLACEHOLDER
	Indicates that the DBI driver supports binding placeholder buffers when executing SQL to retrieve data from queries and procedures, etc.
const	DBI_CAP_BIND_BY_VALUE = DBI_CAP_BIND_BY_VALUE
	Indicates that the DBI driver supports directly binding qore values into queries using the %v placeholder in the query string.
const	DBI_CAP_CHARSET_SUPPORT = DBI_CAP_CHARSET_SUPPORT
	Indicates that the DBI driver supports proper character encoding conversions.
const	DBI_CAP_EVENTS = DBI_CAP_EVENTS
	Indicates that the DBI driver supports the event API.
const	DBI_CAP_HAS_ARRAY_BIND = DBI_CAP_HAS_ARRAY_BIND
	Indicates that the DBI driver supports binding arrays by value for bulk DML operations.
const	DBI_CAP_HAS_DESCRIBE = DBI_CAP_HAS_DESCRIBE
	Indicates that the DBI driver supports the describe method.
const	DBI_CAP_HAS_EXECRAW = DBI_CAP_HAS_EXECRAW
	Indicates that the DBI driver supports the Datasource::execRaw() and DatasourcePool::execRaw() methods.
const	DBI_CAP_HAS_NUMBER_SUPPORT = DBI_CAP_HAS_NUMBER_SUPPORT
	Indicates that the DBI driver supports arbitrary-precision numeric support for binding and retrieving values.
const	DBI_CAP_HAS_OPTION_SUPPORT = DBI_CAP_HAS_OPTION_SUPPORT
	Indicates that the DBI driver supports the new driver option API.
const	DBI_CAP_HAS_RESULTSET_OUTPUT = DBI_CAP_HAS_RESULTSET_OUTPUT
	Indicates that the DBI driver supports result set output binding with a SQLStatement output variable. More...
const	DBI_CAP_HAS_SELECT_ROW = DBI_CAP_HAS_SELECT_ROW
	Indicates that the DBI driver supports a native selectRow() method implementation.
const	DBI_CAP_HAS_STATEMENT = DBI_CAP_HAS_STATEMENT
	Indicates that the DBI driver supports the prepared statement interface (the SQLStatement class)
const	DBI_CAP_LOB_SUPPORT = DBI_CAP_LOB_SUPPORT
	Indicates that the DBI driver supports LOB columns (BLOBs and CLOBs, for example)
const	DBI_CAP_SERVER_TIME_ZONE = DBI_CAP_SERVER_TIME_ZONE
	Indicates that the DBI driver supports automatically converting date/time values to the server's presumed time zone (also implies that the driver supports the "timezone" option) and tagging date/time values with the same; this is independent from the client's current time zone setting.
const	DBI_CAP_STORED_PROCEDURES = DBI_CAP_STORED_PROCEDURES
	Indicates that the DBI driver supports stored procedure execution.
const	DBI_CAP_TIME_ZONE_SUPPORT = DBI_CAP_TIME_ZONE_SUPPORT
	Indicates that the DBI driver supports time zones in times.
const	DBI_CAP_TRANSACTION_MANAGEMENT = DBI_CAP_TRANSACTION_MANAGEMENT
	Indicates that the DBI driver supports transaction management.
const	BLOB = "blob"
	for binding BLOB values
const	CLOB = "clob"
	for binding CLOB values
const	DATE = "date"
	for binding date/time values
const	DECIMAL = "number"
	for binding decimal values as a number More...
const	NUMBER = "number"
	for binding number values as a number More...
const	NUMERIC = "number"
	for binding numeric values as a number More...
const	RESULTSET = "resultset"
	For binding result set placeholders. More...
const	VARCHAR = "string"
	for binding string values

Detailed Description

SQL namespace.