<?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:----Oh/9BRUnaDmc8uL9McXRYAuXLpWFnyvra8V/LZKhnoAiqdx5205mlTF5/WF9G96/fhACbxtVWEo0MtmFIsq6q8rRaUFCSjBLu2BrGQmLBaWysjObeBIy4wgQGzOsRF7oJHd1Sq/gPASwxNZFeK3lH4dXW7k8MlvJY0liFeCqhBU8v9N60OBQ5fMJaIxtpvc0/7llO0wRAKVDV1LcpVTeilJ+TznJuDCyH6LR/coBgt1DEr+d/PlxXnotpbZJh9iqal2nYLaxw9BOKQhNbvO2Gxy3J3mFDx44GfzU7K9GSCwIzRh2b8b5UMPDkXrgs0gj2Vu7pEQ0rH4RnMtV+uFmaaaYWIIKOQnxzQpI6JV3gDvTs9DsYXR6yuj3rQWj3Z+LMR0lG515AUUiFTmJwDw6YX7j63WcCOCAQfHIIvwowiWil34u3/IBnU04jE3VZrHxDc2Ky486GBgPRF6wo5G7pAiIvakz0L5tEz54Vm3EXEXsrk4kAqIGhwVcPFzLKmOWWSh6Gqw8DmLXYIMWL8XSl4+Qr8eBnCXlfoIh62Mv27TmOs/gNilfWlDwxe8FCeJncyZ6OerWEGKG1KWrBmKXtiDkQmRq9YNLRL2vDh38Vawm/w3B/LjhOJetky9MAePsGuoT6ra7XHIVpWkvsQIGPZuRfYNdQP3/JpOsRCIGsE8=----ATTACHMENT:----NTYzNzQwNjYwOTcwNTQyMyA2MTY1Nzk0MTA3MzYwNzU1IDg5ODcxNTA4NDkwOTYwNw==