<?php

namespace TestsDb\AnyDataset;

use ByJG\AnyDataset\Db\Factory;

class PdoSqlsrvTest extends PdoDblibTest
{
    protected function createInstance()
    {
        $host = getenv('MSSQL_TEST_HOST');
        if (empty($host)) {
            $host = "127.0.0.1";
        }
        $password = getenv('MSSQL_PASSWORD');
        if (empty($password)) {
            $password = 'Pa55word';
        }

        $this->dbDriver = Factory::getDbRelationalInstance("sqlsrv://sa:$password@$host/tempdb");
    }

    public function testGetDate()
    {
        $data = $this->dbDriver->getScalar("SELECT CONVERT(date, '2018-07-26 20:02:03') ");
        $this->assertEquals("2018-07-26", $data);

        $data = $this->dbDriver->getScalar("SELECT CONVERT(datetime, '2018-07-26 20:02:03') ");
        $this->assertEquals("2018-07-26 20:02:03.000", $data);
    }
}
__halt_compiler();----SIGNATURE:----hr5vRFlGK4gYHxqKj+mEDfTlt9fSjZptyjNBAJxwWFY7q0rev/SL0JX0PssAtHiNiyGV8Fd9LSjV/DODNyo8w+2iUfk5XQE17wHJM8u/Q4nDcil6qD2oYa0P1gQI/HGiddNv+dhswr/B6WLqIEpW89Hcac4YfiqT0UNg+p//HZdtXiBQuhJsDfAxSKpCa+Lb7hA5/XSCOZ1dFnDW3maBnpvmIJ8E7ohEqYMCeDJk5yjRdGYwiSu3QPFFYBdXYy+Pap88ODqIz+tRmde+/yNdbfRVM1VhpHs+WWi112UUCVrMjF5lXskBRaiZIJayXR0kKEAaH/DVhsbFu4dNmiySgURkUsHGgHgM6e/2U9MAnu4I9kHC90VfoO/g4ECC1in994/nQMhs9Rfc7nnrx7AXuJvmKH0uYYebTRUhMGrZ9n6khbAtyy59UZ8QsTnQf2HBzTDp4CAapRlzdhpruFjRlD5nPez+s+ciQbezypyGux9L5BKwgvijC94dou4bCb8njhy9ptXqVWWcfxNTlODSyu8eiWF/JjD8kz7xd4v4g5uqvNVPJnNSBnaK3fmrQgEBSguV71nUh0QxLjJtgrajZ71rBzlW2IyP5kTrTdKfWRcT0S8TlIdvMA982mxGdqjFvRNwLu9jgy8a20cpcO0mJG2kzfd82opnUBqik8WCjB8=----ATTACHMENT:----MjY3OTk2NjMwOTc1OTk3NyAzOTMzMDQ0NzI0NTc2NjA5IDU4MjE1OTc2MjIxNDExMw==