<?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:----Uk6wEyxgc8UL2+vTlPa/wemUzOUlF2tgWGpPXP10Uhqks5/6xJET1//z0IHRQwRx+LL7QmZ3FPaEhZy1RC1sDw/9tPyKWCp4kwnjV64KyoBZsqGs6kXbxfq8XxnQB7hSBtwnvjTdD1hWfeBq/sKpp/DL30EX8ZTI9xQAaML6dV3led5uIGdnvI/1WZyp8vqj+nvYj92l16LxR5rGjNzsKkEnPCogaGzWWF236si0zNHm/j8b3pHEtrJeOpCbYWZMPfK6KUy9dCpnfNNFOj3pLvkTifgIa9AOAwSwN2kIlsvNiXd/pbXFiBZ0nH8ATb+Z/EnVSJiSlfoTYqgtPL0zkF+L6ak7V2T2W2DC2I41aKBDeQ56aeZUiEaGQqigdiMuOsIZZL4VAOTuW/XcXmst6zpcuLH5UbSLhG4kwi0HmK4etIwW5bZ9NwfE9425XuFRQfy81tR8WpJCpfau2vNrhXa8NGUzg+T5allHtE+iV3db9waAahbAsLF7cK0RRHye1Y4dkKtvMbLTi2QOyokpyeX2EXV3vGBAAa0/yQCHExE2+cMJFNczQcNYp6RMES2aSYPE76by7yH/bAGEO9ehzbvs6zARaCswxI3UQSMQikL+zslQsCz/oWtmW6OAuQqszAsTNQwEWdge0KVN9dBqWBo7IPwImeK3+i7hGccGno4=----ATTACHMENT:----MTU1NjQxNjA5NTUzNTI2NCAyMTg0NTU2MTQ2OTkwMzM5IDc2Njg3NTAxNzg5NjUyMDM=