Class Sqlite3Driver

The driver for SQLite3 database.

Driver options: - database (or file) => the filename of the SQLite3 database - formatDate => how to format date in SQL (@see date) - formatDateTime => how to format datetime in SQL (@see date) - resource (SQLite3) => existing connection resource

Dibi\Drivers\Sqlite3Driver implements Dibi\Driver uses Dibi\Strict

Namespace: Dibi\Drivers
Located at Dibi/Drivers/Sqlite3Driver.php

Methods summary
`public`	# `__construct( array & $config )` Throws `Dibi\NotSupportedException` Dibi\NotSupportedException
`public`	# `disconnect( )` Disconnects from a database. Disconnects from a database. Throws `Exception` Exception Implementation of `Dibi\Driver::disconnect()`
`public Dibi\ResultDriver\|null`	# `query( string $sql )` Executes the SQL query. Executes the SQL query. Parameters `$sql` Returns `Dibi\ResultDriver\|null` Dibi\ResultDriver\|null Throws `Dibi\DriverException` Dibi\DriverException Implementation of `Dibi\Driver::query()`
`public static Dibi\DriverException`	# `createException( string $message, string $code, $sql )` Parameters `$message` `$code` $sql `$sql` Returns `Dibi\DriverException` Dibi\DriverException
`public integer\|null`	# `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. Returns `integer\|null` int\|null Implementation of `Dibi\Driver::getAffectedRows()`
`public integer\|null`	# `getInsertId( string\|null $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. Parameters `$sequence` Returns `integer\|null` int\|null Implementation of `Dibi\Driver::getInsertId()`
`public`	# `begin( string $savepoint = null )` Begins a transaction (if supported). Begins a transaction (if supported). Parameters `$savepoint` Throws `Dibi\DriverException` Dibi\DriverException Implementation of `Dibi\Driver::begin()`
`public`	# `commit( string $savepoint = null )` Commits statements in a transaction. Commits statements in a transaction. Parameters `$savepoint` Throws `Dibi\DriverException` Dibi\DriverException Implementation of `Dibi\Driver::commit()`
`public`	# `rollback( string $savepoint = null )` Rollback changes in a transaction. Rollback changes in a transaction. Parameters `$savepoint` Throws `Dibi\DriverException` Dibi\DriverException Implementation of `Dibi\Driver::rollback()`
`public SQLite3\|null`	# `getResource( )` Returns the connection resource. Returns the connection resource. Returns `SQLite3\|null` SQLite3\|null Implementation of `Dibi\Driver::getResource()`
`public Dibi\Reflector`	# `getReflector( )` Returns the connection reflector. Returns the connection reflector. Returns `Dibi\Reflector` Dibi\Reflector Implementation of `Dibi\Driver::getReflector()`
`public Dibi\Drivers\Sqlite3Result`	# `createResultDriver( SQLite3Result $result )` Result set driver factory. Result set driver factory. Returns `Dibi\Drivers\Sqlite3Result` Sqlite3Result
`public string`	# `escapeText( string $value )` Encodes data for use in a SQL statement. Encodes data for use in a SQL statement. Parameters `$value` Returns `string` string Implementation of `Dibi\Driver::escapeText()`
`public string`	# `escapeBinary( string $value )` Parameters `$value` Returns `string` string Implementation of `Dibi\Driver::escapeBinary()`
`public string`	# `escapeIdentifier( string $value )` Parameters `$value` Returns `string` string Implementation of `Dibi\Driver::escapeIdentifier()`
`public string`	# `escapeBool( boolean $value )` Parameters `$value` Returns `string` string Implementation of `Dibi\Driver::escapeBool()`
`public string`	# `escapeDate( DateTimeInterface\|string\|integer $value )` Parameters `$value` Returns `string` string Implementation of `Dibi\Driver::escapeDate()`
`public string`	# `escapeDateTime( DateTimeInterface\|string\|integer $value )` Parameters `$value` Returns `string` string Implementation of `Dibi\Driver::escapeDateTime()`
`public string`	# `escapeLike( string $value, integer $pos )` Encodes string for use in a LIKE statement. Encodes string for use in a LIKE statement. Parameters `$value` `$pos` Returns `string` string Implementation of `Dibi\Driver::escapeLike()`
`public`	# `applyLimit( string & $sql, integer\|null $limit, integer\|null $offset )` Injects LIMIT/OFFSET to the SQL query. Injects LIMIT/OFFSET to the SQL query. Parameters `$sql` `$limit` `$offset` Implementation of `Dibi\Driver::applyLimit()`
`public`	# `registerFunction( string $name, callable $callback, $numArgs = -1 )` Registers an user defined function for use in SQL statements. Registers an user defined function for use in SQL statements. Parameters `$name` `$callback` $numArgs `$numArgs`
`public`	# `registerAggregateFunction( string $name, callable $rowCallback, callable $agrCallback, $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` `$rowCallback` $numArgs `$agrCallback` `$numArgs`

Methods used from Dibi\Strict
`__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod()`

Namespaces

Classes

Class Sqlite3Driver

Throws

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Throws

Implementation of

Parameters

Throws

Implementation of

Parameters

Throws

Implementation of

Returns

Implementation of

Returns

Implementation of

Returns

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Implementation of

Parameters

Parameters