<?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:----cr70vrtNxD4LRV9MARMt0xlmkPHzUjsTrjcMHUhBNnjHCSCQ2lOB/Nemas027B9yJ8eCc2zTWrN8B54XHXDu1yNf/RKwNJGTL+rMfoKdCqOriZoWZ6gNequmuOGWr/vIliqUZ8UmTiBXp4evZ9kZPp4lPak0Ml3PL3tO+ZZh4usE4k5F9UU6V6CjKWNFT+JJNJlS3KBqimMoMHYQZhh8XRkaz7t88ZHX1wk+y8/4Bu2AXxgoA1xZCeBVGBVWJEUaxNZ+K301Vo8Wct5l6FDa/UgfLfYVFpbh3r7eJp55Ecy/0aUrqSIuwWFwS+Y8sn0bDLUhVqILkA001T+NtZCY+Oy8XwsO1qULdqN+XqrS3VC57nxmmoRw1CCiCl0qLNUxBZJa2coUBMU3sF378gCvwjVvhZMVt+XM7rdX0rUgYiLxQ+MfaEQjZLwGagIBGmZso1tWDwzhPPJSXN2H2JZ3475Drb/69qKkGaMSAIfHYpj+D7NX2D1LHGxGrIfMNgZ6rcpFHBlErGmPEchPPBfe3j9JbeK4REuwInifnWehYjmZM9lHPwQoqCdEblv0oHJthStW+ROexpMixvUeC6S8Y3jiBdyr3VGEmBp68hCCW3uCW6BekKTH6+/2366g3dS1ScOyeUZV/UdXi0gdFTD3WfYOOeLfRmvb0UeI0GGv8HE=----ATTACHMENT:----OTY0MjU5OTE5NjQ3OTk1OSAxMjM2MTY1OTk0NTc5MzE4IDk0NzA2NzAxNTE1MTI1MzY=