<?php

namespace ByJG\AnyDataset\Db;

use ByJG\AnyDataset\Core\Exception\NotAvailableException;
use ByJG\Util\Uri;

class PdoDblib extends PdoPdo
{
    public static function schema(): array
    {
        return ['dblib'];
    }

    /**
     * PdoDblib constructor.
     *
     * @param Uri $connUri
     * @throws NotAvailableException
     */
    public function __construct(Uri $connUri)
    {
        $this->setSupportMultiRowset(true);

        // Run after instance is created
        // Solve the error:
        // SQLSTATE[HY000]: General error: 1934 General SQL Server error: Check messages from the SQL Server [1934]
        // (severity 16) [(null)]
        //
        // http://gullele.wordpress.com/2010/12/15/accessing-xml-column-of-sql-server-from-php-pdo/
        // http://stackoverflow.com/questions/5499128/error-when-using-xml-in-stored-procedure-pdo-ms-sql-2008
        $executeAfterConnect = [
            'SET QUOTED_IDENTIFIER ON',
            'SET ANSI_WARNINGS ON',
            'SET ANSI_PADDING ON',
            'SET ANSI_NULLS ON',
            'SET CONCAT_NULL_YIELDS_NULL ON',
        ];

        parent::__construct($this->getMssqlUri($connUri), [], [], $executeAfterConnect);
    }

    protected function getMssqlUri(Uri $connUri): Uri
    {
        /** @var Uri $uri */
        $uri = Uri::getInstanceFromString("dblib://");

        return $uri
            ->withUserInfo($connUri->getUsername(), $connUri->getPassword())
            ->withHost($connUri->getScheme())
            ->withQueryKeyValue("host" , $connUri->getHost() . (!empty($connUri->getPort()) ? "," . $connUri->getPort() : ""))
            ->withQueryKeyValue("dbname", ltrim($connUri->getPath(), "/"))
        ;
    }
}__halt_compiler();----SIGNATURE:----pjhMoYEWN4AvTKGe3pJQdde5htgQSJrLX+R8w+fPlswpWrZpU80NuC0WfyDqWGak9b2caCyVwA6rX2fnUnqIoq5xXjOvY3hQy6NMvTV3KRGrkOOJA7k92WG+5PGG8EwqG/CsPun3tNIZtz0EUNvYYhB2uEwKCGr08RBebkmK4N6aEnEYmENba6YRCNyHtdlzHDD80VDUQL0T2SwIGLdWPBdYmmB+GLSen5r+xfi6BkRSEahOqaBNBlLj9kCu8DtAuW7o5w4GI6TUsVfTBcgN0mI87vwELzQmQmj2NJuLXcF/bRkvq2Jaic6Lm/0U5QbPOI0QO8MDRUKoQ10VjtWwEeHUsGd5z4qr9itaRGewx6pEb0vIDrQdEg2aCAvzp7bmn2Qm/hsHi68UQdI9ves6dVN3g7o1HhfSWLH29k61ppnZO9H5bG0CH70/dBp1kk+HTPOUvSQFMRbdQf70qabXNyU+rik+MS8D8edF6uFbkJ9Dva/FyD1YQTXN99U9HSGWHbmBnRK5HRhub8m7YAjxsY1RQBpZ953Ki7oHbOSY6aLSVXFkQM7FsW6lJ21u2atm3ilh1rB57DLCCgh+IfbjF7MwDiPwcmhD8HwtgVmFghPIPG+g0Drv2fRmYfVDqriYQeqn2jndTigegJAs+iNy8+vVSj9AdadEVN4YeZBLxp8=----ATTACHMENT:----Nzg3NDgzNjQ4Nzk5MzkxMiA4ODQ1NTc0MTcyOTE0NzYgMjM1NzczMDI0NTc5NDE0MQ==