include edbi.e namespace edbi public type db_handle(object o)
Defines a valid database connection handle.
include edbi.e namespace edbi public type dbr_handle(object o)
Defines a valid database result set handle.
include edbi.e namespace edbi public procedure set_driver_path(sequence v)
Set an alternate DBI driver path.
include edbi.e namespace edbi public function open(sequence connection, object routines = 0)
Open a database connection.
include edbi.e namespace edbi public procedure close(db_handle h = 0)
Close a database connection
include edbi.e namespace edbi public function error_code(db_handle h = 0)
Get the current error code, if any
include edbi.e namespace edbi public function error_message(db_handle h = 0)
Get the current error message (text), if any
include edbi.e
namespace edbi
public function execute(sequence sql, sequence data = {},
db_handle h = 0)
Execute a SQL query that does not expect any record results.
include edbi.e namespace edbi public function last_insert_id(sequence seq_name = "", db_handle h = 0)
Get the unique id of the last inserted record.
include edbi.e namespace edbi public function total_changes(db_handle h = 0)
Get the total number of changes caused by the last execute SQL statement.
include edbi.e
namespace edbi
public function query(sequence sql, sequence data = {}, db_handle h = 0)
Issue a SQL query that expects record data as a result.
include edbi.e namespace edbi public function next(dbr_handle dbr)
Retrieve the next available row of data.
include edbi.e namespace edbi public procedure closeq(dbr_handle dbr)
Close an active query result.
include edbi.e
namespace edbi
public function query_rows(sequence sql, sequence data = {},
db_handle db = 0)
Query the database for all the rows in the result.
query, query_row, query_object
include edbi.e
namespace edbi
public function query_row(sequence sql, sequence data = {},
db_handle db = 0)
Query the database for just the first row. Querying the database, fetching the first row and closing the query is all handled internally with this routine.
include edbi.e
namespace edbi
public function query_object(sequence sql, sequence data = {},
db_handle db = 0)
Query the database for just the first object of the first row. Querying the database, fetching the first object and closing the query is all handled internally with this routine. This routine is helpful for queries such as "SELECT COUNT(*) FROM people".
EDBI is a common database interface for Euphoria that contains hot-loadable database drivers for a variety of database systems.