<?php

namespace ByJG\AnyDataset\Db;

use ByJG\AnyDataset\Db\Exception\DbDriverNotConnected;
use ByJG\Util\Uri;
use PDO;

class PdoMysql extends DbPdoDriver
{
    protected array $mysqlAttr = [
        'ca' => PDO::MYSQL_ATTR_SSL_CA,
        'capath' => PDO::MYSQL_ATTR_SSL_CAPATH,
        'cert' => PDO::MYSQL_ATTR_SSL_CERT,
        'key' => PDO::MYSQL_ATTR_SSL_KEY,
        'cipher' => PDO::MYSQL_ATTR_SSL_CIPHER,
        'verifyssl' => 1014,
    ];

    public static function schema(): array
    {
        return ['mysql', 'mariadb'];
    }

    /**
     * PdoMysql constructor.
     *
     * @param Uri $connUri
     * @throws DbDriverNotConnected
     */
    public function __construct(Uri $connUri)
    {
        $preOptions = [];

        $postOptions = [
            PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true,
        ];

        $executeAfterConnect = [
            "SET NAMES utf8"
        ];

        if (!empty($connUri->getQuery())) {
            foreach ($this->mysqlAttr as $key => $property) {
                $value = $connUri->getQueryPart($key);
                if (!empty($value)) {
                    $prepValue = urldecode($value);
                    if ($prepValue === 'false') {
                        $prepValue = false;
                    } else if ($prepValue === 'true') {
                        $prepValue = true;
                    }
                    $preOptions[$property] = $prepValue;
                }
            }
        }

        $this->setSupportMultiRowset(true);

        parent::__construct($connUri, $preOptions, $postOptions, $executeAfterConnect);
    }
}__halt_compiler();----SIGNATURE:----YSIKjcWDaguBh6rELxgqIAQvPkzTj51pJP4jNfL/oFqvfdJxEWkgtyosqGHhcUGUvtivWbgnOhgEzp9dXOBvEGHdR1ROJ7cwSrMPBGRWGA09Tu8XS8EZQ3il/VpOsNC4lY8MwEGBOx5lKLJ8KekOUgGfgLpiwBkx5b1juOCwHAApPlYuqc3KuXZD8SHOMNLzNC764Zpfcw62YGZBTLjJkDW12zUZnhmDPj1FDbx4T2rC+EKJOoGNi8/JZ4t/j+wHd4ucN6uFYO9NKapuouguMfFDh7tzpJL5JMFJ343D9AFL8GnfRc/T5nIQB34MlO64Zi7pcDU7ZYslO7smTofvvk7n7lo4MZRoT8Yr4q3uvtnsIWu4ldTsJKgXFjU9O3T/Ik1ZoyKXSqpKNPrA/pFSE/FWM6f/1R0FaMSN3bmhhpjZMEwfiRx0xE/Aj63FU78OT0ZQA6+T3gEbJRUpAHO/iNAS3tRieXv/4rwO58EOgQgivbvFFneI1xI7xIpT7cCIxIIodKphhUPq5YQYUMb78DTGZwjrBlMu6DblYBauGHLq+ePoAwC1st4JMogZlCjjuYcYfAkhFqHAVXQqlZSf/0rEskbdtoO1bDVGB2PJQMwm2FGokFEmcVRVOraTJvzyWhEsTDrPoo0O5Qq2cFDs3koUsraq6oNxoYKKj2bFE48=----ATTACHMENT:----NDA1NzAyNjk1NTk0OTE3NCA1MDIxNTQ2MzYwOTc5NjkzIDgxODUzOTIwMTQ3ODI5NTg=