Class PostgreSQL

Defined settings:

array database
- string adapter
- string name, Database name
- string username
- string password
- string host
- integer port

Phramework\Database\PostgreSQL implements Phramework\Database\IAdapter

Direct known subclasses

Phramework\Database\MySQL, Phramework\Database\SQLite

Namespace: Phramework\Database
License: Apache-2.0
Author: Xenofon Spafaridis nohponex@gmail.com
Since: 0.0.0
Uses: \PDO
Located at PostgreSQL.php

Methods summary

`public string`	# `getAdapterName( )` Get adapter's name Get adapter's name Returns string Adapter's name (lowercase) Implementation of `Phramework\Database\IAdapter::getAdapterName()`
`public`	# `__construct( object $settingsDb )` Parameters `$settingsDb` Throws Phramework\Exceptions\DatabaseException
`public integer`	# `execute( string $query, array $parameters = [] )` Execute a query and return the row count Execute a query and return the row count Parameters `$query` `$parameters` Returns integer Returns the number of rows affected or selected Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::execute()`
`public mixed`	# `executeLastInsertId( string $query, array $parameters = [] )` Execute a query and return last inserted id Execute a query and return last inserted id Parameters `$query` `$parameters` Query parameters Returns mixed Returns the id of last inserted item Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::executeLastInsertId()`
`public array`	# `executeAndFetch( string $query, array $parameters = [], $castModel = null )` Execute a query and fetch first row as associative array Execute a query and fetch first row as associative array Parameters `$query` `$parameters` Query parameters `$castModel` Returns array Returns a single row from database Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::executeAndFetch()`
`public array[]`	# `executeAndFetchAll( string $query, array $parameters = [], $castModel = null )` Execute a query and fetch all rows as associative array Execute a query and fetch all rows as associative array Parameters `$query` `$parameters` Query parameters `$castModel` Returns array[] Returns multiple rows from database Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::executeAndFetchAll()`
`public array`	# `executeAndFetchArray( string $query, array $parameters = [] )` Execute a query and fetch first row as array Execute a query and fetch first row as array Parameters `$query` `$parameters` Query parameters Returns array Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::executeAndFetchArray()`
`public array[]`	# `executeAndFetchAllArray( string $query, array $parameters = [] )` Parameters `$query` Query string `$parameters` Query parameters Returns array[] Throws Phramework\Exceptions\DatabaseException Uses PDO::FETCH_COLUMN Implementation of `Phramework\Database\IAdapter::executeAndFetchAllArray()`
`public mixed`	# `bindExecuteLastInsertId( string $query, array $parameters = [] )` Bind Execute a query and return last inserted id Bind Execute a query and return last inserted id Parameters `$query` Query string `$parameters` Query parameters Returns mixed Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::bindExecuteLastInsertId()`
`public integer`	# `bindExecute( string $query, array $parameters = [] )` Bind Execute a query and return the row count Bind Execute a query and return the row count Parameters `$query` Query string `$parameters` Query parameters Returns integer Throws Phramework\Exceptions\DatabaseException Todo provide documentation Implementation of `Phramework\Database\IAdapter::bindExecute()`
`public array`	# `bindExecuteAndFetch( string $query, array $parameters = [], $castModel = null )` Bind Execute a query and fetch first row as associative array Bind Execute a query and fetch first row as associative array Parameters `$query` Query string `$parameters` Query parameters `$castModel` Returns array Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::bindExecuteAndFetch()`
`public array[]`	# `bindExecuteAndFetchAll( string $query, array $parameters = [], $castModel = null )` Bind Execute a query and fetch all rows as associative array Bind Execute a query and fetch all rows as associative array Parameters `$query` Query string `$parameters` Query parameters `$castModel` Returns array[] Throws Phramework\Exceptions\DatabaseException Implementation of `Phramework\Database\IAdapter::bindExecuteAndFetchAll()`
`public`	# `close( )` Close the connection to database Close the connection to database Implementation of `Phramework\Database\IAdapter::close()`

Properties summary

`protected PDO`	`$link`	#
`protected string`	`$adapterName`	# `'postgresql'`

Namespaces

Classes

Interfaces

Class PostgreSQL

Direct known subclasses

Methods summary

Returns

Implementation of

Parameters

Throws

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Uses

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Todo

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Implementation of

Properties summary