Class SQLite2Driver
Neevo SQLite 2 driver (PHP extension 'sqlite')
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')
- persistent (bool) => Try to find a persistent link
- unbuffered (bool) => Sends query without fetching and buffering the
result
- updateLimit (bool) => Set TRUE if SQLite driver was compiled with
SQLITE_ENABLE_UPDATE_DELETE_LIMIT
- resource (type resource) => Existing SQLite 2 link
- lazy, table_prefix... => see
Neevo\Connection
-
Neevo\Parser
-
Neevo\Drivers\SQLite2Driver
implements
Neevo\DriverInterface
Methods summary
public
|
#
__construct( Neevo\BaseStatement $statement = null )
Checks for required PHP extension.
Checks for required PHP extension.
Parameters
Throws
Overrides
Implementation of
|
public
|
#
connect( array $config )
Creates connection to database.
Creates connection to database.
Parameters
- $config
array
$config Configuration options Throws
Implementation of
|
public
|
|
public
boolean
|
#
freeResultSet( resource $resultSet )
Free memory used by given result set.
Free memory used by given result set.
Parameters
- $resultSet
resource
$resultSet Returns
boolean
Implementation of
|
public
resource|boolean
|
#
runQuery( string $queryString )
Executes given SQL statement.
Executes given SQL statement.
Parameters
- $queryString
string
$queryString Returns
resource|boolean
Throws
Implementation of
|
public
|
#
beginTransaction( string $savepoint = null )
Begins a transaction if supported.
Begins a transaction if supported.
Parameters
- $savepoint
string
$savepoint Implementation of
|
public
|
#
commit( string $savepoint = null )
Commits statements in a transaction.
Commits statements in a transaction.
Parameters
- $savepoint
string
$savepoint Implementation of
|
public
|
#
rollback( string $savepoint = null )
Rollbacks changes in a transaction.
Rollbacks changes in a transaction.
Parameters
- $savepoint
string
$savepoint Implementation of
|
public
array
|
#
fetch( resource $resultSet )
Fetches row from given result set as an associative array.
Fetches row from given result set as an associative array.
Parameters
- $resultSet
resource
$resultSet Returns
array
Implementation of
|
public
boolean
|
#
seek( resource $resultSet, integer $offset )
Moves internal result pointer.
Moves internal result pointer.
Parameters
- $resultSet
resource
$resultSet- $offset
integer
$offset Returns
boolean
Throws
Implementation of
|
public
integer
|
#
getInsertId( )
Returns the ID generated in the INSERT statement.
Returns the ID generated in the INSERT statement.
Returns
integer
Implementation of
|
public
|
|
public
integer|boolean
|
#
getNumRows( resource $resultSet )
Returns the number of rows in the given result set.
Returns the number of rows in the given result set.
Parameters
- $resultSet
resource
$resultSet Returns
integer|boolean
Throws
Implementation of
|
public
integer
|
#
getAffectedRows( )
Returns the number of affected rows in previous operation.
Returns the number of affected rows in previous operation.
Returns
integer
Implementation of
|
public
mixed
|
#
escape( mixed $value, string $type )
Escapes given value.
Parameters
- $value
mixed
$value- $type
string
$type Returns
mixed
Throws
Implementation of
|
public
mixed
|
#
unescape( mixed $value, string $type )
Decodes given value.
Parameters
- $value
mixed
$value- $type
string
$type Returns
mixed
Throws
Implementation of
|
public
string
|
#
getPrimaryKey( string $table )
Returns the PRIMARY KEY column for given table.
Returns the PRIMARY KEY column for given table.
Parameters
Returns
string
Implementation of
|
public
array
|
#
getColumnTypes( resource $resultSet, string $table )
Returns types of columns in given result set.
Returns types of columns in given result set.
Parameters
- $resultSet
resource
$resultSet- $table
string
$table Returns
array
Implementation of
|
protected
string
|
|
protected
string
|
|
applyLimit(),
applyModifiers(),
escapeValue(),
parse(),
parseFieldName(),
parseGrouping(),
parseInsertStmt(),
parseSelectStmt(),
parseSorting(),
parseSource(),
parseWhere(),
tryDelimite()
Magic methods summary
Properties summary
Properties inherited from Neevo\Parser
$clauses,
$stmt