<?php

namespace ByJG\AnyDataset\Db;

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

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

    /**
     * PdoSqlsrv constructor.
     *
     * @param Uri $connUri
     * @throws NotAvailableException
     */
    public function __construct(Uri $connUri)
    {
        parent::__construct($connUri);
    }

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

        return $uri
            ->withUserInfo($connUri->getUsername(), $connUri->getPassword())
            ->withHost($connUri->getScheme())
            ->withQueryKeyValue("Server" , $connUri->getHost() . (!empty($connUri->getPort()) ? "," . $connUri->getPort() : ""))
            ->withQueryKeyValue("Database", ltrim($connUri->getPath(), "/"))
            ->withQueryKeyValue('TrustServerCertificate', 'true')
        ;
    }
}__halt_compiler();----SIGNATURE:----H0lw3DDg9FgjVwKhVKiqYRo2zZl9B1siloTbFNcVBrGAJcaREJB7RwKQCgwnECX9LNK9UhMauzHcbWlmbsfTgWlaTyNfcEVv0cjee5Y75KRoDODcQZEaM5YEgA3UIut6OjW7vDDfEEuyOJH4yv9LLIYLK4bNk5GacLkHHNetG8ffO6AZk6IzU5kPApM8ee4J/IZiD1Q1UhM0JVUONSGUlhqw1oLrsgjccGMkBEMr1l3PJPfCoisOq+F5VXIrNH1rkGbyeQGX28ZUtjncaV2CDMumb6plUNG1tpQdJrPtAX+nYOPptjSpsN7RNT+Do0iXv/k2JsaFnCMCEj/S1+Px8lQ1flWdjUpt290XeVYnRAcIkzuMVimv5La24b+O2j25jpnri6+wTrLnD2D7s7ERu8M1lB6p8Vh0vejtI6/3bw2643lyw51PvxyuVa6gCA5q7K2rfeTpU1mUe7+h59NyVKZR/9rEjwtoPoS1Hbp5K2zSG3wj/mlPME0nJ902CdP2g5U9x2IWN9gU3kf0CrkG9tKHhOXIWmMQIoS9AWf6YDhQGp3IURNrKGcCinQkJPFCVHemQ0Rqb1drgdilRGYLwlZ5R7uJtxpn3FRj6w+IKQCxv6pf8URFO3Z/rOIs5eHMcFWodB61zE9ST8794DX2KnKdjduwBaEYdCqvM+7Jv8g=----ATTACHMENT:----MzYzMzY4NTY2NjExMTAyNSAxNDY3NTQzMzQ1NzM0OTI5IDI3NTQyMzY4MjUyMTkyNjk=