Class SQLite

Database management driver wrapping SQL Lite 3 extension.

SQLite3

Core\Modules\DB\Adapters\SQLite implements Core\Modules\DB\Interfaces\Adapter

Namespace: Core\Modules\DB\Adapters
Located at modules/db/adapters/sqlite.php

Methods summary

`public mixed`	# `run( Core\Modules\DB\Query $query )` Run method. Run method. Parameters `$query` Current query object. Returns mixed Implementation of `Core\Modules\DB\Interfaces\Adapter::run()`
`public array\|SQLite3Result`	# `query( string $sql, array $bind_params = array() )` Query construction method. Query construction method. Parameters `$sql` SQL query. `$bind_params` Query parameters. Returns array\|SQLite3Result Overrides `SQLite3::query`
`public boolean\|SQLite3Result`	# `execute( string $sql, array $bind_params = array() )` Execution method. Execution method. Parameters `$sql` SQL query string. `$bind_params` Query parameters. Returns boolean\|SQLite3Result Implementation of `Core\Modules\DB\Interfaces\Adapter::execute()`
`public boolean\|SQLite3Result`	# `setCharset( string $charset = 'utf8' )` Set charset method. Set charset method. Parameters `$charset` Character type string. Returns boolean\|SQLite3Result Implementation of `Core\Modules\DB\Interfaces\Adapter::setCharset()`
`public array`	# `getTables( string $schema )` Retrieves tables list method. Retrieves tables list method. Parameters `$schema` Schema contents. Returns array Implementation of `Core\Modules\DB\Interfaces\Adapter::getTables()`
`public array`	# `getTableSchema( string $table, mixed $schema )` Retrieves table schema. Retrieves table schema. Parameters `$table` Table name. `$schema` Schema contents. Returns array Implementation of `Core\Modules\DB\Interfaces\Adapter::getTableSchema()`
`public`	# `storeQueries( string $query, array $params = array() )` Store queries method. Store queries method. Parameters `$query` Query string. `$params` Query parameters. Implementation of `Core\Modules\DB\Interfaces\Adapter::storeQueries()`
`public integer`	# `getLastInsertId( )` Retrieval of the last inserted id. Retrieval of the last inserted id. Returns integer Implementation of `Core\Modules\DB\Interfaces\Adapter::getLastInsertId()`
`public boolean`	# `clearTable( string $table )` Clears a table. Clears a table. Parameters `$table` Table name. Returns boolean Implementation of `Core\Modules\DB\Interfaces\Adapter::clearTable()`
`private string`	# `buildSql( Core\Modules\DB\Query $query )` SQL builder method. SQL builder method. Parameters `$query` Query string. Returns string Throws DomainException DB Adapter does not support the required JOIN type.
`private array`	# `fetchAll( mixed $resource )` Retrieve all results. Retrieve all results. Parameters `$resource` Resource source. Returns array
`public static array`	# `getSupportedJoinTypes( )` Retrieves all supported types of JOIN. Retrieves all supported types of JOIN. Returns array Implementation of `Core\Modules\DB\Interfaces\Adapter::getSupportedJoinTypes()`

Methods inherited from SQLite3

__construct(), busyTimeout(), changes(), close(), createAggregate(), createCollation(), createFunction(), enableExceptions(), escapeString(), exec(), lastErrorCode(), lastErrorMsg(), lastInsertRowID(), loadExtension(), open(), openBlob(), prepare(), querySingle(), version()

Properties summary

`public Core\Modules\DB\DbCache`	`$cache` DB Cache instance. DB Cache instance.	#

Namespaces

Classes

Class SQLite

Methods summary

Parameters

Returns

Implementation of

Parameters

Returns

Overrides

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Implementation of

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Throws

Parameters

Returns

Returns

Implementation of

Methods inherited from SQLite3

Properties summary