<?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:----iaDR1i/xXQkgwIJmjbUlQ4vyPF5r369N8O3jwez/30Qi+NgFAc2At99v/k5lLBProwxMBXqUyn/F7Y11u2w9udgASaBc/3g/vBOZEF/3x70ohhAqj7XU+UCov3iYnQSGgEt43ahM1ax2RPu8ejPMT9erx4B90z2IUsv7dQ/kGC0/8YiGgviQofLDr92tOcpVJN/Go6MZ11+KAFP3I24pBMjjh/edGlzxK8sHSpu5rfBZLpbASR/gX3tecstS1Oj3ZNnde5JIKD4MubzAlIjfpdPslkUu+V4PkSJu9Ldxh36JKAk7wJrIQp2PSNBcCjzBDEM7GWCUIGRvprSv1onR3hCJoT055mlfl7ENUdKLu3lcAzRxCdm97RvRkz16BxW17d9+DRKtAys/kYcfjlOhdV8YMWDsmfMQHN9rfbULMnX0c9GrgTEbWBICtkn79yRo1JDy5FypufrS8tA57FqSEoayeGw7B7OVU4B00YU2qmr4TBiBnX+/NoamYhAI9xgxTpKwtCOdyKRFlgoaa8K4/cnwSr9limlUBAMAQ8ygeIVLYmup3RwDAtAL0KMRrkwYMin1TlYzF3z1z16pkS1qt5KY2Gl2gI2RYfqYikhQWBuV0zaTCAvJEVcGw2WswikBO0KoW3IIeT3eGTTLeXhxQO4DX7lbKhKNhRoAaCTS/wc=----ATTACHMENT:----ODM0ODM5NTYyNTk4MjkxMCA3NDAyODE0MTI3Nzk5NTUzIDM2NDMxMzY2MjgxMjQwMTg=