Class DibiSqliteDriver
The dibi driver for SQLite database.
Driver options:
- database (or file) ⇒ the filename of the SQLite database
- persistent (bool) ⇒ try to find a persistent link?
- unbuffered (bool) ⇒ sends query without fetching and buffering the result
rows automatically?
- formatDate ⇒ how to format date in SQL (@see date)
- formatDateTime ⇒ how to format datetime in SQL (@see date)
- dbcharset ⇒ database character encoding (will be converted to
‚charset‘)
- charset ⇒ character encoding to set (default is UTF-8)
- resource (resource) ⇒ existing connection resource
- lazy, profiler, result, substitutes, … ⇒ see DibiConnection options
- DibiObject
-
DibiSqliteDriver implements IDibiDriver, IDibiResultDriver
public
|
#
__construct(
)
Throws |
public
void
|
#
connect(
array
& $config
)
Connects to a database. |
public
void
|
#
disconnect(
)
Disconnects from a database. |
public
IDibiResultDriver|NULL
|
#
query(
string
$sql
)
Executes the SQL query. Executes the SQL query. Parameters$sql string SQL statement.ThrowsImplementation of |
public
int|FALSE
|
#
getAffectedRows(
)
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query. Gets the number of affected rows by the last INSERT, UPDATE or DELETE query. Returnsint|FALSE number of rows or FALSE on error
Implementation of |
public
int|FALSE
|
#
getInsertId(
$sequence
)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Returnsint|FALSE int on success or FALSE on failure
Implementation of |
public
void
|
#
begin(
string
$savepoint = NULL
)
Begins a transaction (if supported). Begins a transaction (if supported). Parameters$savepoint string optional savepoint nameThrowsImplementation of |
public
void
|
#
commit(
string
$savepoint = NULL
)
Commits statements in a transaction. Commits statements in a transaction. Parameters$savepoint string optional savepoint nameThrowsImplementation of |
public
void
|
#
rollback(
string
$savepoint = NULL
)
Rollback changes in a transaction. Rollback changes in a transaction. Parameters$savepoint string optional savepoint nameThrowsImplementation of |
public
mixed
|
#
getResource(
)
Returns the connection resource. |
public
IDibiReflector
|
#
getReflector(
)
Returns the connection reflector. |
public
string
|
#
escape(
mixed
$value,
string
$type
)
Encodes data for use in a SQL statement. Encodes data for use in a SQL statement. Parameters$value mixed value$type string type (dibi::TEXT, dibi::BOOL, ...)Returnsstring encoded value
Throws
InvalidArgumentException
Implementation of |
public
string
|
#
escapeLike(
string
$value,
int
$pos
)
Encodes string for use in a LIKE statement. Encodes string for use in a LIKE statement. Parameters$value string$pos intImplementation of |
public
string
|
#
unescape(
string
$value,
string
$type
)
Decodes data from result set. Decodes data from result set. Parameters$value string value$type string type (dibi::BINARY)Returnsstring decoded value
Throws
InvalidArgumentException
Implementation of |
public
void
|
#
applyLimit(
string
& $sql,
int
$limit,
int
$offset
)
Injects LIMIT/OFFSET to the SQL query. Injects LIMIT/OFFSET to the SQL query. Parameters$sql string &$sql The SQL query that will be modified.$limit int $limit$offset int $offsetImplementation of |
public
int
|
#
getRowCount(
)
Returns the number of rows in a result set. |
public
array
|
#
fetch(
bool
$assoc
)
Fetches the row at current position and moves the internal cursor to the next position. Fetches the row at current position and moves the internal cursor to the next position. Parameters$assoc bool TRUE for associative array, FALSE for numericReturnsarray array on success, nonarray if no next record
Implementation of |
public
boolean
|
#
seek(
int
$row
)
Moves cursor position without fetching row. Moves cursor position without fetching row. Parameters$row int the 0-based cursor pos to seek toReturnsboolean TRUE on success, FALSE if unable to seek to specified record
ThrowsImplementation of |
public
void
|
#
free(
)
Frees the resources allocated for this result set. |
public
array
|
#
getResultColumns(
)
Returns metadata for all columns in a result set. Returns metadata for all columns in a result set. Implementation of |
public
mixed
|
#
getResultResource(
)
Returns the result set resource. |
public
void
|
#
registerFunction(
string
$name,
mixed
$callback,
int
$numArgs = -1
)
Registers an user defined function for use in SQL statements. Registers an user defined function for use in SQL statements. Parameters$name string function name$callback mixed callback$numArgs int num of arguments |
public
void
|
#
registerAggregateFunction(
string
$name,
mixed
$rowCallback,
mixed
$agrCallback,
int
$numArgs = -1
)
Registers an aggregating user defined function for use in SQL statements. Registers an aggregating user defined function for use in SQL statements. Parameters$name string function name$rowCallback mixed callback called for each row of the result set$agrCallback mixed callback called to aggregate the "stepped" data from each row$numArgs int num of arguments |