<?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:----59ukMt7tVwT7O/4r8KlAZBxkpnKT2unX8WIffeKioy3KZa+X/xMOLKs35OWaIJuF1A0QBXXY/2UHiFW+MwePkiqwUbNoCd04WHGFMBbH2cV5olyaMgx5zynR5Sei9CSlY+MxxJ9uGZuksNnl8XfeTqtwTmQ7lTTY/KOoX9CFaXaQRrdQB1IUbjOox/hdURZJFckxd5s/mfkX10er3Rc1uS2Au1RBpD2SbMrGvALkg1fUUdibjfohpkOGRZvsW/lFapn/KOnM6idTT8TRD0MBio5ALK4buXNCQY8af/gF8AXtyYHrnMVazVt+FXs1HBQl1ZkfWwzrrhDZ9mv7ah+hMwwVGJdfMvm2c5s9Wfg6SMPwn3SQZjKpLNSis1820Ekrdq8sTQBQ4Ss37rNASkDlMO7J/WN6TdbqrbjPchp7Zm2m8fZlPGz/VRmmtuPuFeRsnW8xt1PhdmONo+wm+/dk1QudvHXMckrFKJmWCGLWHTA3VIOcJAFtZJZPNV5u/BUe+7OugX7EcHMKnLlLZRJ4gcX4HQ9nr+LBALlyFWyqBU6/psB3oerjKnJNCkxGqbN1J/OWtQ1Nxv5crI3d93DwEmdf2ByeAmxjA1CXCF5UTvEzMcIcDDBMy9RWRGbIcWIfcOmYfSGn6MuV1TIeejoZ56/nVJpyhJ3zDUn7AZ37SVc=----ATTACHMENT:----NTU5NDg1MTA3Nzg3OTE1NyA5Mjk4Njg0Njg1Njc5ODU2IDk5NjkzMTc3MzAyNDQ2Mzg=