Class PgSQLDriver
Neevo PostgreSQL driver (PHP extension 'pgsql')
Driver configuration: - host, hostaddr, port, dbname, user, password,
connect_timeout, options, sslmode, service => see PHP pg_connect() - string
=> Use connection string instead - schema => Schema search path - charset
=> Character encoding to set (defaults to utf-8) - persistent (bool) =>
Try to find a persistent link
- resource (type resource) => Existing SQLite link - lazy, table_prefix...
=> see Neevo\Connection
-
Neevo\Drivers\PgSQLDriver
implements
Neevo\IDriver
Namespace: Neevo\
Drivers
Author:
Smasty
Located at Neevo/Drivers/pgsql.php
Methods summary
public
|
#
__construct( Neevo\BaseStatement $statement = null )
Check for required PHP extension.
Check for required PHP extension.
Throws
Implementation of
|
public
|
#
connect( array $config )
Create connection to database.
Create connection to database.
Parameters
- $config
array
Configuration options Throws
Implementation of
|
public
|
#
closeConnection( )
Close the connection.
Implementation of
|
public
boolean
|
#
freeResultSet( resource $resultSet )
Free memory used by given result set.
Free memory used by given result set.
Parameters
Returns
boolean
Implementation of
|
public
resource|boolean
|
#
runQuery( string $queryString )
Execute given SQL statement.
Execute given SQL statement.
Parameters
Returns
resource|boolean
Throws
Implementation of
|
public
|
#
beginTransaction( string $savepoint = null )
Begin a transaction if supported.
Begin a transaction if supported.
Parameters
Implementation of
|
public
|
#
commit( string $savepoint = null )
Commit statements in a transaction.
Commit statements in a transaction.
Parameters
Implementation of
|
public
|
#
rollback( string $savepoint = null )
Rollback changes in a transaction.
Rollback changes in a transaction.
Parameters
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
Returns
array
Implementation of
|
public
boolean
|
#
seek( resource $resultSet, integer $offset )
Move internal result pointer.
Move internal result pointer.
Parameters
- $resultSet
resource- $offset
integer Returns
boolean
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
|
#
randomizeOrder( Neevo\BaseStatement $statement )
Randomize result order.
Parameters
Implementation of
|
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
Returns
integer|false
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- $type
string Returns
mixed
Throws
Implementation of
|
public
mixed
|
#
unescape( mixed $value, string $type )
Decode given value.
Parameters
- $value
mixed- $type
string 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.
Experimental implementation!
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- $table
string Returns
array
Implementation of
|