<?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:----LaeaCnIM/BNzL5EDYHkmlG7yBTJCE12gqyjFcNyEi38RsVjI0jULYcjvzWIX6zGqPwpWcv9lcNamAfveeJa3dK8GLcz0/Nln491awAjZv7EhZD+9/1LMaeZucYymA8cCZguqXyuH8mOoDTnuMUaJfaRfTSs3Tk6LPWp5JXyYh2ONfaqpIH1+Ds4/fYm+Z81ocAEv7KpwDofmQ7U58kzmqIitbY3Sj1eofIn6yLan750Mf1ggg9Hsb1PZcwFZNZHcyaEtfXNjTENcvf1XIzZLClTRbZUHiY3UmI7lkfxd1IO9KR7/PzH8xjhbcATNdhe324pUTN4U4gUjkl482m+s4ZFa9hGXdTGSRMAjqinQoOTVp2/VmzMfNAiEJ0soEw8kU6IY87BGVkqmpbBBQpJTAPl7ldhHi+LkJGobAcxFsR3bG92sPHllbiAs85KVQirFQFyAh+NMUNWehL7I33rkCcEUiwdKiA8esJFg7ZmJpFWvRECVG7xSj9IRp+ra1PEigWjb0B6OUY4BqUtnK1DSVuj9CoL+ipH3ikgJXfnnLatbptXNKEVtHv3QnPpCAgRdTXPMeftc4gEcqiFVG1i+/dOPple95uOly/UQFF+zgN2vSMyHRaN2oxr6X3LS5fWNudV6iMw9hlfxSotJkzCpnSVJjrJWh7xWeup77vSjKOM=----ATTACHMENT:----ODY1ODA1Mjg3OTgwMDY4NCA2ODUyNjE2NjgzNjU4ODg2IDI4NTQ5Mzg1NzE4Nzc0MDY=