<?php

namespace ByJG\AnyDataset\Db;

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

class PdoSqlsrv extends PdoDblib
{
    /**
     * PdoSqlsrv constructor.
     *
     * @param Uri $connUri
     * @throws \ByJG\AnyDataset\Core\Exception\NotAvailableException
     */
    public function __construct($connUri)
    {
        $this->setSupportMultRowset(true);

        $this->validateConnUri($connUri);

        $dsn = $connUri->getScheme() . ":"
            . "server=" . $connUri->getHost() . (!empty($connUri->getPort()) ? "," . $connUri->getPort() : "") . ";"
            . "Database=" . preg_replace('~^/~', '', $connUri->getPath());

        $this->instance = new PDO($dsn, $connUri->getUsername(), $connUri->getPassword());

        $this->setPdoDefaultParams();

        // 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
        $this->getDbConnection()->exec('SET QUOTED_IDENTIFIER ON');
        $this->getDbConnection()->exec('SET ANSI_WARNINGS ON');
        $this->getDbConnection()->exec('SET ANSI_PADDING ON');
        $this->getDbConnection()->exec('SET ANSI_NULLS ON');
        $this->getDbConnection()->exec('SET CONCAT_NULL_YIELDS_NULL ON');
    }
}
__halt_compiler();----SIGNATURE:----PYY7FzE7LdCDIXCqRX4RZwDn0acQndDy2B1PQMfOyE6lXSrEuh5251Kk2KKiLqCaGygEPi5+Pf2JJgEPTQAlt7K4ey0fDnMEDNwEtOlS17DA0pJ1QrLWIQTpX0lSS0YhY1m6e1+f4EOHr7hGuAfnx62BMsT30peHoNUt7aKLSMMlmJUbdU66EXQcw4pY9PaIrM86eUFoqv7ovV2Jm325vCt8/gHZv9wQwQZH+u5J3mhb86SAzyTPiA2JOjLpt2nCzj2AEclOga7rXqQbURsIU0Ex4kKIy2Pn3VH85GPJg5a3QIE3DPccbAkqYPROMKrcTKt44Roh+FUflaDk/kZY9lljEhQ9CCl/Q+9XzNHBX7UcY6mF2I7WGcDWpSvrjetp2r6sNzK6GIOo3yrYKt3vH77tFq3CPuRpMETM6OtB6jZkHga0BS/UF13ZxczR1zzqqcd9UgPqBvcNdimL4usfxsVYXjCXoQJiTx4xEcpcYGMwKbAAC1wdzgbsu8jwIBLPBtziQqKg51YeK/nDXMcO6mNZBXZ5N/kXaJwYtKwAu3UCy0+DqzAzUHBdeeELrtus4RB66hEfpGlJD1sDk1IIEdEpW20NZMt4BU11O8S/ljm7TYXaaYmLUktD1LZ5+mUOkM5Yra8z+Y7asCE7+RRKW6ubYNfzdBKqd9TnsN1hPo4=----ATTACHMENT:----MjQxMzYzODc0OTE1NDMzIDQzMDI1NDMzNTcyNzE3ODggNzIwMTk0NzQ0OTY0MzMwOQ==