function DatabaseConnection_pgsql::__construct

Overrides DatabaseConnection::__construct

File

includes/database/pgsql/database.inc, line 20

Class

DatabaseConnection_pgsql

Code

public function __construct(array $connection_options = array()) {
    // This driver defaults to transaction support, except if explicitly passed FALSE.
    $this->transactionSupport = !isset($connection_options['transactions']) || $connection_options['transactions'] !== FALSE;
    // Transactional DDL is always available in PostgreSQL,
    // but we'll only enable it if standard transactions are.
    $this->transactionalDDLSupport = $this->transactionSupport;
    // Default to TCP connection on port 5432.
    if (empty($connection_options['port'])) {
        $connection_options['port'] = 5432;
    }
    // PostgreSQL in trust mode doesn't require a password to be supplied.
    if (empty($connection_options['password'])) {
        $connection_options['password'] = NULL;
    }
    else {
        $connection_options['password'] = str_replace('\\', '\\\\', $connection_options['password']);
    }
    $this->connectionOptions = $connection_options;
    $dsn = 'pgsql:host=' . $connection_options['host'] . ' dbname=' . $connection_options['database'] . ' port=' . $connection_options['port'];
    // Allow PDO options to be overridden.
    $connection_options += array(
        'pdo' => array(),
    );
    $connection_options['pdo'] += array(
        // Prepared statements are most effective for performance when queries
        // are recycled (used several times). However, if they are not re-used,
        // prepared statements become inefficient. Since most of Drupal's
        // prepared queries are not re-used, it should be faster to emulate
        // the preparation than to actually ready statements for re-use. If in
        // doubt, reset to FALSE and measure performance.
PDO::ATTR_EMULATE_PREPARES => TRUE,
        // Convert numeric values to strings when fetching.
PDO::ATTR_STRINGIFY_FETCHES => TRUE,
    );
    parent::__construct($dsn, $connection_options['username'], $connection_options['password'], $connection_options['pdo']);
    // Force PostgreSQL to use the UTF-8 character set by default.
    $this->connection
        ->exec("SET NAMES 'UTF8'");
    // Execute PostgreSQL init_commands.
    if (isset($connection_options['init_commands'])) {
        $this->connection
            ->exec(implode('; ', $connection_options['init_commands']));
    }
}