Class NeevoDriverSQLite2
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 NeevoConnection
-
NeevoParser
-
NeevoDriverSQLite2
implements
INeevoDriver
Methods summary
public
|
#
__construct( NeevoBaseStmt $statement = null )
Check for required PHP extension.
Check for required PHP extension.
Parameters
Throws
Overrides
Implementation of
|
public
|
#
connect( array $config )
Create connection to database.
Create 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 )
Execute given SQL statement.
Execute given SQL statement.
Parameters
- $queryString
string $queryString
Returns
resource|boolean
Throws
Implementation of
|
public
|
#
beginTransaction( string $savepoint = null )
Begin a transaction if supported.
Begin a transaction if supported.
Parameters
- $savepoint
string $savepoint
Implementation of
|
public
|
#
commit( string $savepoint = null )
Commit statements in a transaction.
Commit statements in a transaction.
Parameters
- $savepoint
string $savepoint
Implementation of
|
public
|
#
rollback( string $savepoint = null )
Rollback changes in a transaction.
Rollback changes in a transaction.
Parameters
- $savepoint
string $savepoint
Implementation of
|
public
array
|
#
fetch( resource $resultSet )
Fetch row from given result set as an associative array.
Fetch row from given result set as an associative array.
Parameters
- $resultSet
resource $resultSet
Returns
array
Implementation of
|
public
boolean
|
#
seek( resource $resultSet, integer $offset )
Move internal result pointer.
Move internal result pointer.
Parameters
- $resultSet
resource $resultSet
- $offset
integer $offset
Returns
boolean
Throws
Implementation of
|
public
integer
|
#
getInsertId( )
Get the ID generated in the INSERT statement.
Get the ID generated in the INSERT statement.
Returns
integer
Implementation of
|
public
|
|
public
integer|false
|
#
getNumRows( resource $resultSet )
Get the number of rows in the given result set.
Get the number of rows in the given result set.
Parameters
- $resultSet
resource $resultSet
Returns
integer|false
Throws
Implementation of
|
public
integer
|
#
getAffectedRows( )
Get the number of affected rows in previous operation.
Get the number of affected rows in previous operation.
Returns
integer
Implementation of
|
public
mixed
|
#
escape( mixed $value, string $type )
Escape given value.
Parameters
- $value
mixed $value
- $type
string $type
Returns
mixed
Throws
Implementation of
|
public
mixed
|
#
unescape( mixed $value, string $type )
Decode given value.
Parameters
- $value
mixed $value
- $type
string $type
Returns
mixed
Throws
Implementation of
|
public
string
|
#
getPrimaryKey( string $table )
Get the PRIMARY KEY column for given table.
Get the PRIMARY KEY column for given table.
Parameters
Returns
string
Implementation of
|
public
array
|
#
getColumnTypes( resource $resultSet, string $table )
Get types of columns in given result set.
Get types of columns in given result set.
Parameters
- $resultSet
resource $resultSet
- $table
string $table
Returns
array
Implementation of
|
protected
string
|
|
protected
string
|
|
Methods inherited from NeevoParser
applyLimit()
,
applyModifiers()
,
escapeValue()
,
parse()
,
parseFieldName()
,
parseGrouping()
,
parseInsertStmt()
,
parseSelectStmt()
,
parseSorting()
,
parseSource()
,
parseWhere()
,
tryDelimite()
Magic methods summary
Properties summary
Properties inherited from NeevoParser
$clauses
,
$stmt