<?php

use ByJG\DbMigration\Database\DblibDatabase;
use ByJG\DbMigration\Migration;
use ByJG\Util\Uri;

/**
 * @requires extension pdo_dblib
 */
class SqlServerDblibDatabaseTest extends BaseDatabase
{
    /** @var Migration */
    protected $migrate = null;
    protected $scheme = "dblib";

    public function setUp(): void
    {
        $host = getenv('MSSQL_TEST_HOST');
        if (empty($host)) {
            $host = "127.0.0.1";
        }
        $password = getenv('MSSQL_PASSWORD');
        if (empty($password)) {
            $password = 'Pa55word';
        }

        $uri = $this->scheme . "://sa:${password}@${host}/migratedatabase";

        $this->migrate = new Migration(new Uri($uri), __DIR__ . '/../example/sql_server', true, $this->migrationTable);
        $this->migrate->registerDatabase($this->scheme, DblibDatabase::class);
        parent::setUp();
    }

    public function getExpectedUsersVersion1()
    {
        if ($this->scheme == "sqlsrv") {
            return parent::getExpectedUsersVersion1();
        }

        return [
            ["id" => 1, "name" => 'John Doe', 'createdate' => '2016-01-10 00:00:00'],
            ["id" => 2, "name" => 'Jane Doe', 'createdate' => '2015-12-30 00:00:00']
        ];
    }
}
__halt_compiler();----SIGNATURE:----a7Yliw48o9DrbxaGOF7EbiiGkvehab1viL1nKfPr5qXyvEap7zErlbdKCZiUJbFSOHYiZdK92wg772/8JqtKkJrpL34ARCVU6QoV8q4B7v67LyvNPeEV+q2U5tBZ+u1wzvjaqSa02CKCpSWTyuZsFeRIfNjmK9qXTReUtFg8XLgZsizJJOQizA9rujOKyNnr0YM9LgINQJalZ7w52K1yCnX4PSVX27R/Blph7XmC2rWOynqNYPpDg9NHztPdlQlblwvdCj1mDKrL2BUQYm/rbspMZW3pmK4uh25+qwel8bplELQNV3SDci8aouNdeb9A6bAcApuRqwu+T5A4bOjJEtF5pkMcAs/0P7fStaGSmCH04RvAPK5OJFu/vlXeo02lBvvU4VGUOaIYb3+9MNSVgsDaKcpGBrBbai6yYAYeFCNImoaHV969mUvvC1WQvbHXXFWRVody7jA03IvdtBRFIFXPHtZz/m78QouAcOYqiCrCkHYEFTxG6BQTEo88kjxbVbOwYpj+rBUpikZd7XN02WRDAT59SIBtosfDWfREGFm8tKPvjlgYlAsBwrC8tiY6INmY6g6Fh0vEUN3f9JdIJzM0A6/n57yRqphe0ixWdtERs9V6PNVr97LIZbWTS9En2E8sBa7LVSAfNRUN3ojLL5UIejC3zOVGzROzL8C/pgs=----ATTACHMENT:----NjA3NDIxMTU0MzAyMjk3MSA1MzQ2MDYzNzAzNjc1OTk4IDU3NzY4MjM4NTY3NzIyODU=