<?php

namespace TestsDb\AnyDataset;

use ByJG\AnyDataset\Db\Factory;

class PdoPostgresTest extends BasePdo
{
    protected function createInstance()
    {
        $host = getenv('PSQL_TEST_HOST');
        if (empty($host)) {
            $host = "127.0.0.1";
        }
        $password = getenv('PSQL_PASSWORD');
        if (empty($password)) {
            $password = 'password';
        }
        if ($password == '.') {
            $password = "";
        }

        $this->dbDriver = Factory::getDbRelationalInstance("pgsql://postgres:$password@$host");
        $exists = $this->dbDriver->getScalar('select count(1) from pg_catalog.pg_database where datname = \'test\'');
        if ($exists == 0) {
            $this->dbDriver->execute('CREATE DATABASE test');
        }
        $this->dbDriver = Factory::getDbRelationalInstance("pgsql://postgres:$password@$host/test");
    }

    protected function createDatabase()
    {
        //create the database
        $this->dbDriver->execute("CREATE TABLE Dogs (Id SERIAL 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 CAST('2018-07-26' AS DATE) ");
        $this->assertEquals("2018-07-26", $data);

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

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

        parent::testDontParseParam_3();
    }
}
__halt_compiler();----SIGNATURE:----SEFMLwzeCNnmPnyxcJQPDfttEpEenSG+uspKFGHaplDHadQE/QGkKoGwYu2EZb/8qirGRgfyCtahTewtPRni7p0J2g2CQmrIpmaEpxLt+rsJTl5+bhXgbZ3tUrKR6O6NBaJ0Ev9wRYXmB/XhvFVDcxTq5U1vI+DofQtbhNbbdnIIQZyqXB5xHH7E6wuyDblf277wAeGSn9FzBB0FacRmoRLq4ZhFGzRkiI2gStknluzClfn/C4u1rh353pN1Tkms+0YE9EM+1BBvs7uw4anOiKb501eGI1JFo9ycEhi0jcpHgJtYWlQlg1Xr3Yc6KfaxQaJqP7FmkqYeliotq13+HwUQVEkrRXdf0RSadEZVfhWzxFMizwqTVTmOmPZ4sY74XrEZ6yJAPYJ72PApJyEImo3pIKs05k4pRIH7mQL7kvGRR61IM/hTWBtVvnC13up2ndfkEwecJZVuF/bW+OlW6QmxOQ4gtXJELS7HIulJBLkbK0Nbzn6LqqY5pmOO0UzKc6ueF+kqHHS3RfBChcMpMj1nVyoeKtYfJPunoMMV6Vzj5kplgBFyGyFsDwBIDVDMUMDobSh2tVkVSkv6cKzrTbn/2pzg+9c7YUhPGw1DTCZsetlDFVdL0oJ9nEU83Sjm3tiiRwMXBULRYpGIEgwP8cpQdslGUsEbq3fdUXgpla0=----ATTACHMENT:----NzMwMzI1MzE2NzExMzk0IDUzNTIxMjExMzMxOTc0NDUgMTU5ODY1MDMyODM0MzcxMw==