Qore Programming Language Reference Manual  1.8.0
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< stringgetDBIDriverCapabilityList (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< stringgetDBIDriverList ()
 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< stringdbi_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< stringdbi_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 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 (SQLStatement output values) More...
 
const VARCHAR = "string"
 for binding string values
 

Detailed Description

SQL namespace.