Neevo Public API
  • Namespace
  • Class
  • Tree

Namespaces

  • Neevo
    • Cache
    • Drivers
    • Nette
  • PHP

Classes

  • MySQLDriver
  • MySQLiDriver
  • PDODriver
  • PgSQLDriver
  • SQLite2Driver
  • SQLite3Driver

Class PgSQLDriver

Neevo PostgreSQL driver (PHP extension 'pgsql')

Driver configuration:

  • host, hostaddr, port, dbname, user, password, connect_timeout, options, sslmode, service => see 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\DriverInterface
Namespace: Neevo\Drivers
Author: Smasty
Located at Neevo/Drivers/pgsql.php

Methods summary

public
# __construct( Neevo\BaseStatement $statement = null )

Checks for required PHP extension.

Checks for required PHP extension.

Throws

Neevo\DriverException

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( resource $resultSet )

Frees memory used by given result set.

Frees memory used by given result set.

Parameters

$resultSet
resource
$resultSet

Returns

boolean

Implementation of

Neevo\DriverInterface::freeResultSet()
public resource|boolean
# runQuery( string $queryString )

Executes given SQL statement.

Executes given SQL statement.

Parameters

$queryString
string
$queryString

Returns

resource|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( 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

Neevo\DriverInterface::fetch()
public boolean
# seek( resource $resultSet, integer $offset )

Moves internal result pointer.

Moves internal result pointer.

Parameters

$resultSet
resource
$resultSet
$offset
integer
$offset

Returns

boolean

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
$statement

Implementation of

Neevo\DriverInterface::randomizeOrder()
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

Implementation of

Neevo\DriverInterface::getNumRows()
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

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.

Experimental implementation!

Parameters

$table
string
$table

Returns

string

Implementation of

Neevo\DriverInterface::getPrimaryKey()
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

Neevo\DriverInterface::getColumnTypes()

Magic methods summary

Neevo Public API API documentation generated by ApiGen 2.8.0