• Главная
• lithium
• data
• source
• database
• adapter
• PostgreSql

PHP Класс lithium\data\source\database\adapter\PostgreSql

- Implements timezone support. - Implements schema/searchPath support. For more information on configuring the database connection, see the __construct() method. Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство	Тип	Описание
$_columns	array	PostgreSQL column type definitions.
$_constraints	array	Column contraints
$_metas	array	Column/table metas By default 'escape' is false and 'join' is ' '
$_quotes	array	Pair of opening and closing quote characters used for quoting identifiers in queries.

Открытые методы

Метод	Описание
__construct ( array $config = [] ) : void	Constructor. Constructs the PostgreSQL adapter and sets the default port to 5432.
alias ( $alias, $context )
conditions ( string $conditions, string $context, array $options = [] ) : string
connect ( ) : boolean	Connects to the database by constructing DSN string and creating a PDO intance using the parent class. Will set specific options on the connection as provided (timezone, schema).
describe ( mixed $entity, array $fields = [], array $meta = [] ) : array	Gets the column schema for a given PostgreSQL table.
enabled ( string $feature = null ) : boolean	Check for required PHP extension, or supported database feature.
encoding ( $encoding = null ) : mixed	Gets or sets the encoding for the connection.
error ( ) : array	Retrieves database error message and error code.
searchPath ( $searchPath ) : mixed	Gets or sets the search path for the connection.
sources ( string $model = null ) : array	Returns the list of tables in the currently-connected database.
timezone ( $timezone = null ) : mixed	Gets or sets the time zone for the connection
value ( mixed $value, array $schema = [] ) : mixed	Converts a given value into the proper type based on a given schema definition.

Защищенные методы

Метод	Описание
_buildColumn ( array $field ) : string	Helper for Database::column().
_column ( string $real ) : array	Converts database-layer column types to basic types.
_distinctExport ( object $query ) : array	Helper method for PostgreSql::_queryExport() to export data for use in distinct query.
_execute ( string $sql, array $options = [] ) : Result	Execute a given query.
_formatters ( )	Provide an associative array of Closures to be used as the "formatter" key inside of the Database::$_columns specification.
_insertId ( object $query ) : mixed	Gets the last auto-generated ID from the query that inserted a new record.
_queryExport ( object $query ) : array	Helper method for Database::read() to export query while handling additional joins when using relationships and limited result sets. Filters conditions on subsequent queries to just the ones applying to the relation.

Описание методов

Описание свойств