<?php

namespace TestsDb\AnyDataset;

use ByJG\AnyDataset\Db\Factory;

class PdoDblibTest extends BasePdo
{
    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("dblib://sa:$password@$host/tempdb");
    }

    protected function createDatabase()
    {
        //create the database
        $this->dbDriver->execute("CREATE TABLE Dogs (Id INT NOT NULL IDENTITY(1,1) PRIMARY KEY, Breed VARCHAR(50), Name VARCHAR(50), Age INTEGER)");
    }

    public function deleteDatabase()
    {
        $this->dbDriver->execute('drop table Dogs;');
    }

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

        $data = $this->dbDriver->getScalar("SELECT CONVERT(datetime, '2018-07-26 20:02:03') ");
        $this->assertEquals("2018-07-26 20:02:03", $data);
    }

    public function testDontParseParam_3()
    {
        $this->expectException(\PDOException::class);

        parent::testDontParseParam_3();
    }
}
__halt_compiler();----SIGNATURE:----aOAo8rHUbU6K0kYWm9+ltcjBONTRCVLGBrFr3SxP4Rh0xUw+LP9btLxw6ieEX4xE1uT9fpsmQW+cNp4TubWfQ7bNUfFtjYsSF2UHRsN1rhRdWK6lXg0rp3ycA0rqyHfZVKB9656kqZwOsT+klPSpXEnwGxb9mFBYuaGiccPOktiJ3/dej8fp0hT4seWqabbZMcFCLnIOn2VO1ODsc3NS0HIJhF5IK5CaNe73GddU3rF4pfsa4Ede/4gmE/CVQsU2Q7ySrG5mkKjjVHd+SAcP8QdZk7XL/xZ6JPNiRnv4JtXn2l0d0e3cnxU7l18nCKY6LK5nNaWhPbaYsFLdTBNVW07K25o3vU/HWQJZSmIrDYYVWMMkCjvJR3Qb4fPvOW9IkmL8UAFsSItwVMxlrtxE7EisZtaUjoKiUBsR6qkhqAgMGmjTv3w70IDXZFzwe5uCXDTiaKJr08LWiCryvnPF+0B77GgcOAUi7JSpioWtgy3Jg3IxBzFOrwy2nbv3u91u8g9hpeIaZO8bWQrf78r0rMfI86zCzQ6tZUu1Wz870kmCqFXpnY9LFNOd//kN/B2VFnMVMgYTMAMDVJEJAeuI1eTtUuNNUB6D/Pdh0SDcVr4GJVmQA0QVvYpHH7P6z8He4BOWUF/uwTPiAlo7LtqyAd+soqScyq5Vs9+JhSznl9k=----ATTACHMENT:----MzE5NDA5NjEwNDQzODkwNSAxMDQ4Nzk0Nzg1MjY1NTY4IDQ3OTg5NTYzMjk0MDk3MjY=