summaryrefslogtreecommitdiffstats
path: root/vendor/ipl/sql/src/Adapter/Mysql.php
blob: 2421caeb8181025133f951d5608dc1f655ccb652 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php

namespace ipl\Sql\Adapter;

use ipl\Sql\Config;
use ipl\Sql\Connection;
use PDO;

class Mysql extends BaseAdapter
{
    protected $quoteCharacter = ['`', '`'];

    protected $escapeCharacter = '``';

    public function setClientTimezone(Connection $db)
    {
        $db->exec('SET time_zone = ' . $db->quote($this->getTimezoneOffset()));

        return $this;
    }

    public function getOptions(Config $config)
    {
        $options = parent::getOptions($config);

        if (! empty($config->useSsl)) {
            if (! empty($config->sslKey)) {
                $options[PDO::MYSQL_ATTR_SSL_KEY] = $config->sslKey;
            }

            if (! empty($config->sslCert)) {
                $options[PDO::MYSQL_ATTR_SSL_CERT] = $config->sslCert;
            }

            if (! empty($config->sslCa)) {
                $options[PDO::MYSQL_ATTR_SSL_CA] = $config->sslCa;
            }

            if (! empty($config->sslCapath)) {
                $options[PDO::MYSQL_ATTR_SSL_CAPATH] = $config->sslCapath;
            }

            if (! empty($config->sslCipher)) {
                $options[PDO::MYSQL_ATTR_SSL_CIPHER] = $config->sslCipher;
            }

            if (
                defined('PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT')
                && ! empty($config->sslDoNotVerifyServerCert)
            ) {
                $options[PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] = false;
            }
        }

        return $options;
    }
}