Exemplo n.º 1
0
 public function __construct(array $connection_options = array())
 {
     $this->transactionSupport = TRUE;
     // Transactional DDL is always available in PostgreSQL,
     $this->transactionalDDLSupport = TRUE;
     $pdo = parent::openConnection(array(PDO::ATTR_EMULATE_PREPARES => FALSE, PDO::ATTR_STRINGIFY_FETCHES => TRUE, PDO::ATTR_CASE => PDO::CASE_LOWER));
     parent::__construct($pdo);
     // Force PostgreSQL to use the UTF-8 character set by default.
     $pdo->exec("SET NAMES 'UTF8'");
 }
Exemplo n.º 2
0
 public function __construct(array $connection_options = array())
 {
     $this->transactionSupport = FALSE;
     // MySQL never supports transactional DDL.
     $this->transactionalDDLSupport = FALSE;
     $pdo = parent::openConnection(array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => TRUE, PDO::ATTR_EMULATE_PREPARES => TRUE, PDO::ATTR_CASE => PDO::CASE_LOWER));
     parent::__construct($pdo);
     // Force MySQL to use the UTF-8 character set.
     $pdo->exec('SET NAMES utf8');
     // Force MySQL's behavior to conform more closely to SQL standards.
     // This allows Drupal to run almost seamlessly on many different
     // kinds of database systems. These settings force MySQL to behave
     // the same as postgresql, or sqlite in regards to syntax interpretation
     // and invalid data handling. See http://drupal.org/node/344575 for further discussion.
     $pdo->exec("SET sql_mode='ANSI,TRADITIONAL'");
 }
Exemplo n.º 3
0
 public function __construct(array $connection_options = array())
 {
     // We don't need a specific PDOStatement class here, we simulate it below.
     $this->statementClass = NULL;
     $this->connectionOptions = $connection_options;
     $pdo = parent::openConnection(array(PDO::ATTR_CASE => PDO::CASE_LOWER, PDO::ATTR_STRINGIFY_FETCHES => TRUE));
     parent::__construct($pdo);
     // Detect support for SAVEPOINT.
     $version = $this->query('SELECT sqlite_version()')->fetchField();
     $this->savepointSupport = version_compare($version, '3.6.8') >= 0;
     // This driver defaults to transaction support, except if explicitly passed FALSE.
     $this->transactionSupport = version_compare($version, '3.0.0') >= 0;
     // Create functions needed by SQLite.
     $this->getPDO()->sqliteCreateFunction('if', array($this, 'sqlFunctionIf'));
     $this->getPDO()->sqliteCreateFunction('greatest', array($this, 'sqlFunctionGreatest'));
     $this->getPDO()->sqliteCreateFunction('pow', 'pow', 2);
     $this->getPDO()->sqliteCreateFunction('length', 'strlen', 1);
     $this->getPDO()->sqliteCreateFunction('md5', 'md5', 1);
     $this->getPDO()->sqliteCreateFunction('concat', array($this, 'sqlFunctionConcat'));
     $this->getPDO()->sqliteCreateFunction('substring', array($this, 'sqlFunctionSubstring'), 3);
     $this->getPDO()->sqliteCreateFunction('substring_index', array($this, 'sqlFunctionSubstringIndex'), 3);
     $this->getPDO()->sqliteCreateFunction('rand', array($this, 'sqlFunctionRand'));
 }