function Connection::__construct

Overrides Connection::__construct

File

core/modules/mysql/src/Driver/Database/mysql/Connection.php, line 94

Class

Connection

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

Namespace

Code

public function __construct(\PDO $connection, array $connection_options) {
    // If the SQL mode doesn't include 'ANSI_QUOTES' (explicitly or via a
    // combination mode), then MySQL doesn't interpret a double quote as an
    // identifier quote, in which case use the non-ANSI-standard backtick.
    //
    // Because we still support MySQL 5.7, check for the deprecated combination
    // modes as well.
    //
    // @see https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_ansi_quotes
    $ansi_quotes_modes = [
        'ANSI_QUOTES',
        'ANSI',
        'DB2',
        'MAXDB',
        'MSSQL',
        'ORACLE',
        'POSTGRESQL',
    ];
    $is_ansi_quotes_mode = FALSE;
    foreach ($ansi_quotes_modes as $mode) {
        // None of the modes in $ansi_quotes_modes are substrings of other modes
        // that are not in $ansi_quotes_modes, so a simple stripos() does not
        // return false positives.
        if (stripos($connection_options['init_commands']['sql_mode'], $mode) !== FALSE) {
            $is_ansi_quotes_mode = TRUE;
            break;
        }
    }
    if ($this->identifierQuotes === [
        '"',
        '"',
    ] && !$is_ansi_quotes_mode) {
        $this->identifierQuotes = [
            '`',
            '`',
        ];
    }
    parent::__construct($connection, $connection_options);
}