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

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`
`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 instert id Execute a query and return last instert 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 instert id Bind Execute a query and return last instert 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

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