Class SQLite3Driver

Neevo SQLite 3 driver (PHP extension 'sqlite3')

Driver configuration:

database (or file)
memory (bool) => use an in-memory database (overrides 'database')
charset => Character encoding to set (defaults to utf-8)
dbcharset => Database character encoding (will be converted to 'charset')
updateLimit (bool) => Set TRUE if SQLite driver was compiled with SQLITE_ENABLE_UPDATE_DELETE_LIMIT
resource (instance of SQLite3) => Existing SQLite 3 link
lazy, table_prefix => see Neevo\Connection

Since SQLite 3 only allows unbuffered queries, number of result rows and seeking is not supported for this driver.

Neevo\Parser

Neevo\Drivers\SQLite3Driver implements Neevo\DriverInterface

Namespace: Neevo\Drivers
Author: Smasty
Located at Neevo/Drivers/sqlite3.php

Methods summary

`public`	# `__construct( Neevo\BaseStatement $statement = null )` Checks for required PHP extension. Checks for required PHP extension. Parameters `$statement` `Neevo\BaseStatement` $statement Throws `Neevo\DriverException` Overrides `Neevo\Parser::__construct` Implementation of `Neevo\DriverInterface::__construct()`
`public`	# `connect( array $config )` Creates connection to database. Creates connection to database. Parameters `$config` `array` $config Configuration options Throws `Neevo\DriverException` Implementation of `Neevo\DriverInterface::connect()`
`public`	# `closeConnection( )` Closes the connection. Closes the connection. Implementation of `Neevo\DriverInterface::closeConnection()`
`public boolean`	# `freeResultSet( SQLite3Result $resultSet )` Frees memory used by given result. Frees memory used by given result. Neevo\Result automatically NULLs the resource, so this is not necessary. Parameters `$resultSet` `SQLite3Result` $resultSet Returns `boolean` Implementation of `Neevo\DriverInterface::freeResultSet()`
`public SQLite3Result\|boolean`	# `runQuery( string $queryString )` Executes given SQL statement. Executes given SQL statement. Parameters `$queryString` `string` $queryString Returns `SQLite3Result\|boolean` Throws `Neevo\DriverException` Implementation of `Neevo\DriverInterface::runQuery()`
`public`	# `beginTransaction( string $savepoint = null )` Begins a transaction if supported. Begins a transaction if supported. Parameters `$savepoint` `string` $savepoint Implementation of `Neevo\DriverInterface::beginTransaction()`
`public`	# `commit( string $savepoint = null )` Commits statements in a transaction. Commits statements in a transaction. Parameters `$savepoint` `string` $savepoint Implementation of `Neevo\DriverInterface::commit()`
`public`	# `rollback( string $savepoint = null )` Rollbacks changes in a transaction. Rollbacks changes in a transaction. Parameters `$savepoint` `string` $savepoint Implementation of `Neevo\DriverInterface::rollback()`
`public array`	# `fetch( SQLite3Result $resultSet )` Fetches row from given result set as an associative array. Fetches row from given result set as an associative array. Parameters `$resultSet` `SQLite3Result` $resultSet Returns `array` Implementation of `Neevo\DriverInterface::fetch()`
`public boolean`	# `seek( SQLite3Result $resultSet, integer $offset )` Moves internal result pointer. Moves internal result pointer. Not supported because of unbuffered queries. Parameters `$resultSet` `SQLite3Result` $resultSet `$offset` `integer` $offset Returns `boolean` Throws `Neevo\DriverException` Implementation of `Neevo\DriverInterface::seek()`
`public integer`	# `getInsertId( )` Returns the ID generated in the INSERT statement. Returns the ID generated in the INSERT statement. Returns `integer` Implementation of `Neevo\DriverInterface::getInsertId()`
`public`	# `randomizeOrder( Neevo\BaseStatement $statement )` Randomizes result order. Randomizes result order. Parameters `$statement` `Neevo\BaseStatement` $tatement Implementation of `Neevo\DriverInterface::randomizeOrder()`
`public integer\|boolean`	# `getNumRows( SQLite3Result $resultSet )` Returns the number of rows in the given result set. Returns the number of rows in the given result set. Not supported because of unbuffered queries. Parameters `$resultSet` `SQLite3Result` $resultSet Returns `integer\|boolean` Throws `Neevo\DriverException` Implementation of `Neevo\DriverInterface::getNumRows()`
`public integer`	# `getAffectedRows( )` Returns the umber of affected rows in previous operation. Returns the umber of affected rows in previous operation. Returns `integer` Implementation of `Neevo\DriverInterface::getAffectedRows()`
`public mixed`	# `escape( mixed $value, string $type )` Escapes given value. Escapes given value. Parameters `$value` `mixed` $value `$type` `string` $type Returns `mixed` Throws `InvalidArgumentException` Implementation of `Neevo\DriverInterface::escape()`
`public mixed`	# `unescape( mixed $value, string $type )` Decodes given value. Decodes given value. Parameters `$value` `mixed` $value `$type` `string` $type Returns `mixed` Throws `InvalidArgumentException` Implementation of `Neevo\DriverInterface::unescape()`
`public string`	# `getPrimaryKey( string $table )` Returns the PRIMARY KEY column for given table. Returns the PRIMARY KEY column for given table. Parameters `$table` `string` $table Returns `string` Implementation of `Neevo\DriverInterface::getPrimaryKey()`
`public array`	# `getColumnTypes( SQLite3Result $resultSet, string $table )` Returns types of columns in given result set. Returns types of columns in given result set. Parameters `$resultSet` `SQLite3Result` $resultSet `$table` `string` $table Returns `array` Implementation of `Neevo\DriverInterface::getColumnTypes()`
`protected string`	# `parseUpdateStmt( )` Parses UPDATE statement. Parses UPDATE statement. Returns `string` Overrides `Neevo\Parser::parseUpdateStmt`
`protected string`	# `parseDeleteStmt( )` Parses DELETE statement. Parses DELETE statement. Returns `string` Overrides `Neevo\Parser::parseDeleteStmt`

Methods inherited from Neevo\Parser

applyLimit(), applyModifiers(), escapeValue(), parse(), parseFieldName(), parseGrouping(), parseInsertStmt(), parseSelectStmt(), parseSorting(), parseSource(), parseWhere(), tryDelimite()

Magic methods summary

Properties summary

Properties inherited from Neevo\Parser

$clauses, $stmt

Namespaces

Classes

Class SQLite3Driver

Methods summary

Parameters

Throws

Overrides

Implementation of

Parameters

Throws

Implementation of

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Implementation of

Parameters

Implementation of

Parameters

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Throws

Implementation of

Returns

Implementation of

Parameters

Implementation of

Parameters

Returns

Throws

Implementation of

Returns

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Returns

Overrides

Returns

Overrides

Methods inherited from Neevo\Parser

Magic methods summary

Properties summary

Properties inherited from Neevo\Parser