<?php

namespace TestsDb\AnyDataset;

use ByJG\AnyDataset\Db\Factory;

class PdoMySqlTest extends BasePdo
{
    protected function createInstance()
    {
        $this->escapeQuote = "\'";

        $host = getenv('MYSQL_TEST_HOST');
        if (empty($host)) {
            $host = "127.0.0.1";
        }
        $password = getenv('MYSQL_PASSWORD');
        if (empty($password)) {
            $password = 'password';
        }
        if ($password == '.') {
            $password = "";
        }

        $this->dbDriver = Factory::getDbRelationalInstance("mysql://root:$password@$host");
        $this->dbDriver->execute('CREATE DATABASE IF NOT EXISTS test');
        $this->dbDriver = Factory::getDbRelationalInstance("mysql://root:$password@$host/test");
    }

    protected function createDatabase()
    {
        //create the database
        $this->dbDriver->execute("CREATE TABLE Dogs (Id INTEGER PRIMARY KEY auto_increment, 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('2018-07-26 20:02:03', date) ");
        $this->assertEquals("2018-07-26", $data);

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

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

        parent::testDontParseParam_3();
    }
}
__halt_compiler();----SIGNATURE:----l5EoKQPdlBkLXsL72aFQaZBt6GHpnHX6hclrqp40079sOmNemt/wbqucaAP3+wftuQyhY4Q2ahBR/olz5krQ5fDDtkKEKhajWexWyhBmDL//IVYeN7AyVFgue5+dzuue7BC11TF8qJkAemfNn9VHcxQq/xvZFKSx9245ffhw0uOvyUrL1XDdTCCy2mPyr4KvtKlBmJG7RuJwQoM1+47oyAr2gxZ8cMez3pf5Ia5nP/owqqnHEvD9uRz+qPJ0SYYrkRhGhBe7l6JDlYdDUQvYzTRmvbUOA9DXmjShtFMBIezmCh/RIEJj9za/o34GBZvTVbQPTqZ3TmyXQUXkk+3wEitqodnDws/6DS2O5zh5HtuI8LOpdntWAH30E+BBuSGh+jBxxZZ5B18qSN0A8sD2Gl2ppWfPiuOQ6lBxXkDcdyOHR11icOdvZUYLp07v3beLYN/Lfcx4GFceG2mvvnlJqBCx4JZCIp7fzgP2wvAzHUatRevc/c/g9isOVm6yMWVgdxRuOlSpNWnQILUCHZ1mGrScOrc33nJx+b7RHcqHHVGxJr2OHpAqQfTn2XqD1c0vnmUkJU1K5EoKRh0ufuCnYR1FqyoLyLVwWkWEaqzNODtGn22TM+eoEdGRMtfiJCmLbAVfONxYDY6x9RZhBgeu0xGxJ5xmq8ybkpaQJiL4kTU=----ATTACHMENT:----NTUzMzczMzQ3MTE1MTg1OSAzMDM3MDk2NjU4ODU4Nzk3IDUxMzMwNDIzNDYzNjQwMA==