public static function Connection::open in Zircon Profile 8

Same name in this branch

1. 8 core/lib/Drupal/Core/Database/Connection.php \Drupal\Core\Database\Connection::open()
2. 8 core/lib/Drupal/Core/Database/Driver/sqlite/Connection.php \Drupal\Core\Database\Driver\sqlite\Connection::open()
3. 8 core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php \Drupal\Core\Database\Driver\pgsql\Connection::open()
4. 8 core/lib/Drupal/Core/Database/Driver/mysql/Connection.php \Drupal\Core\Database\Driver\mysql\Connection::open()

Same name and namespace in other branches

1. 8.0 core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php \Drupal\Core\Database\Driver\pgsql\Connection::open()

Opens a PDO connection.

Parameters

array $connection_options: The database connection settings array.

Return value

\PDO A \PDO object.

Overrides Connection::open

File

core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php, line 82

Contains \Drupal\Core\Database\Driver\pgsql\Connection.

Class

Connection

PostgreSQL implementation of \Drupal\Core\Database\Connection.

Namespace

Drupal\Core\Database\Driver\pgsql

Code

public static function open(array &$connection_options = array()) {

  // 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']);
  }
  $connection_options['database'] = !empty($connection_options['database']) ? $connection_options['database'] : 'template1';
  $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(
    \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,
    // 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,
  );
  $pdo = new \PDO($dsn, $connection_options['username'], $connection_options['password'], $connection_options['pdo']);
  return $pdo;
}