<?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:----Qrwnh0lL9WJvUsTfUcVNcbx5uYQLuwPVvHGzDEXjuSQZZQ7i+N5XUlmz8t6e2HGyPmFIp+A2ZmjB9R6X+VMC2bjtnSDFcrLyGu/JvwEqFsjTjDCVSV9ZUZmVpjdZ2CWHJUtCrAPMJT6gULcd+h0Ic/XcuovJyHLWLGw15/rI3FOe6qCLMn97/m8JEqq01rW1NYMV3BqWZGSOsvbju9P/SMWKtv+jhN5acLhIe7iUexnY5q97SUHiVbvvWfeGosSQczUS6t0kBVqS5BKIVoTEvDJBAQzPiyo+ga/Ca9R7dnY3ZmyXtVQnigw+T6COCn5dZoM4lQWYzojF3pYh7j8DY66cuKLYtJp9p8WpepZ5q7PXGMJEZqwRvGx0lbRDWijB6nrl0adWgJqF/fbVNNuVyqvLuET6QLAdZ0ZDuyo0pg87aEevB3QHpLhfuKLwE613tT+GjC/QrMbcJ1EKs00haskNI8RuuHCz8HB9s1xUcK/d1Eh+TRHccoiBW8vzFrWYVGui1hE8Ic6JLsx3rRdG4Aw3FE1ObbLihi+zwVTioCqnXACR1z0SJIXf4iOwCmoaU4asdR+nFdqKpViGZ/AxICZOa6NMnGedrWjEx5n14txzwBpMAp3v9wT9nL6rz/QVpe+coDEXj724xJ+r8gZdtPja+KjwseyGnwfcyOyvL68=----ATTACHMENT:----NjU1NjE5NDU5Nzk2NTM1MCAxMDM1MzgyOTc4MzA1Mjc4IDg5OTE4OTUyMTkwNzk1MjE=