FirebirdDriver
class FirebirdDriver implements Driver, ResultDriver, Reflector
The dibi driver for Firebird/InterBase database.
Driver options:
- database => the path to database file (server:/path/database.fdb)
- username (or user)
- password (or pass)
- charset => character encoding to set
- buffers (int) => buffers is the number of database buffers to allocate for the server-side cache. If 0 or omitted, server chooses its own default.
- resource (resource) => existing connection resource
- lazy, profiler, result, substitutes, ... => see Dibi\Connection options
Constants
| ERROR_EXCEPTION_THROWN |
|
Methods
No description
Connects to a database.
Disconnects from a database.
Executes the SQL query.
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
Begins a transaction (if supported).
Commits statements in a transaction.
Rollback changes in a transaction.
Is in transaction?
Returns the connection resource.
Returns the connection reflector.
Result set driver factory.
Encodes data for use in a SQL statement.
No description
No description
No description
No description
No description
Encodes string for use in a LIKE statement.
Decodes data from result set.
Injects LIMIT/OFFSET to the SQL query.
Automatically frees the resources allocated for this result set.
Returns the number of rows in a result set.
Fetches the row at current position and moves the internal cursor to the next position.
Moves cursor position without fetching row.
Frees the resources allocated for this result set.
Returns the result set resource.
Returns metadata for all columns in a result set.
Returns list of tables.
Returns metadata for all columns in a table.
Returns metadata for all indexes in a table (the constraints are included).
Returns metadata for all foreign keys in a table.
Returns list of indices in given table (the constraints are not listed).
Returns list of constraints in given table.
Returns metadata for all triggers in a table or database.
Returns list of triggers for given table.
Returns metadata from stored procedures and their input and output parameters.
Returns list of stored procedures.
Returns list of generators.
Returns list of user defined functions (UDF).
Details
at line 50
__construct()
No description
at line 63
void
connect(array $config)
Connects to a database.
at line 97
void
disconnect()
Disconnects from a database.
at line 109
ResultDriver|null
query($sql)
Executes the SQL query.
at line 134
int|false
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 145
int|false
getInsertId($sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 157
void
begin($savepoint = NULL)
Begins a transaction (if supported).
at line 173
void
commit($savepoint = NULL)
Commits statements in a transaction.
at line 193
void
rollback($savepoint = NULL)
Rollback changes in a transaction.
at line 211
bool
inTransaction()
Is in transaction?
at line 221
mixed
getResource()
Returns the connection resource.
at line 231
Reflector
getReflector()
Returns the connection reflector.
at line 242
ResultDriver
createResultDriver($resource)
Result set driver factory.
at line 258
string
escapeText($value)
Encodes data for use in a SQL statement.
at line 268
string
escapeBinary($value)
No description
at line 278
string
escapeIdentifier($value)
No description
at line 288
string
escapeBool($value)
No description
at line 298
string
escapeDate($value)
No description
at line 311
string
escapeDateTime($value)
No description
at line 326
string
escapeLike($value, $pos)
Encodes string for use in a LIKE statement.
at line 337
string
unescapeBinary($value)
Decodes data from result set.
at line 344
escape($value, $type)
deprecated
deprecated
No description
at line 358
void
applyLimit($sql, $limit, $offset)
Injects LIMIT/OFFSET to the SQL query.
at line 374
void
__destruct()
Automatically frees the resources allocated for this result set.
at line 384
int
getRowCount()
Returns the number of rows in a result set.
at line 395
array
fetch($assoc)
Fetches the row at current position and moves the internal cursor to the next position.
at line 419
bool
seek($row)
Moves cursor position without fetching row.
at line 429
void
free()
Frees the resources allocated for this result set.
at line 440
mixed
getResultResource()
Returns the result set resource.
at line 451
array
getResultColumns()
Returns metadata for all columns in a result set.
at line 475
array
getTables()
Returns list of tables.
at line 499
array
getColumns($table)
Returns metadata for all columns in a table.
at line 554
array
getIndexes($table)
Returns metadata for all indexes in a table (the constraints are included).
at line 588
array
getForeignKeys($table)
Returns metadata for all foreign keys in a table.
at line 618
array
getIndices($table)
Returns list of indices in given table (the constraints are not listed).
at line 640
array
getConstraints($table)
Returns list of constraints in given table.
at line 666
array
getTriggersMeta($table = NULL)
Returns metadata for all triggers in a table or database.
(Only if user has permissions on ALTER TABLE, INSERT/UPDATE/DELETE record in table)
at line 714
array
getTriggers($table = NULL)
Returns list of triggers for given table.
(Only if user has permissions on ALTER TABLE, INSERT/UPDATE/DELETE record in table)
at line 735
array
getProceduresMeta()
Returns metadata from stored procedures and their input and output parameters.
at line 787
array
getProcedures()
Returns list of stored procedures.
at line 805
array
getGenerators()
Returns list of generators.
at line 824
array
getFunctions()
Returns list of user defined functions (UDF).
Traits
Better OOP experience.