<?php

namespace TestsDb\AnyDataset;

use ByJG\AnyDataset\Db\DbPdoDriver;
use ByJG\AnyDataset\Db\Factory;
use ByJG\Util\Uri;

class PdoSqliteTest extends BasePdo
{
    protected $host;

    protected function createInstance()
    {
        $this->host = getenv('SQLITE_TEST_HOST');
        if (empty($host)) {
            $this->host = "/tmp/test.db";
        }

        $uri = Uri::getInstanceFromString("sqlite://" . $this->host)
            ->withQueryKeyValue(DbPdoDriver::STATEMENT_CACHE, "true");

        $this->dbDriver = Factory::getDbInstance($uri);
    }

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

    public function deleteDatabase()
    {
        unlink($this->host);
    }

    public function testGetAllFields()
    {
        $this->markTestSkipped('Skipped: SqlLite does not support get all fields');
    }

    public function testStatementCache()
    {
        $this->assertEquals("true", $this->dbDriver->getUri()->getQueryPart(DbPdoDriver::STATEMENT_CACHE));
        $this->assertEquals(2, $this->dbDriver->getCountStmtCache()); // because of createDatabase() and populateData()

        $i = 3;
        while ($i<=10) {
            $it = $this->dbDriver->getIterator("select $i as name");
            $this->assertEquals($i, $this->dbDriver->getCountStmtCache()); // because of createDatabase() and populateData()
            $this->assertEquals([["name" => $i]], $it->toArray());
            $i++;
        }

        $it = $this->dbDriver->getIterator("select 20 as name");
        $this->assertEquals(10, $this->dbDriver->getCountStmtCache()); // because of createDatabase() and populateData()
        $this->assertEquals([["name" => 20]], $it->toArray());

        $it = $this->dbDriver->getIterator("select 30 as name");
        $this->assertEquals(10, $this->dbDriver->getCountStmtCache()); // because of createDatabase() and populateData()
        $this->assertEquals([["name" => 30]], $it->toArray());
    }

    public function testGetDate()
    {
        $data = $this->dbDriver->getScalar("SELECT DATE('2018-07-26') ");
        $this->assertEquals("2018-07-26", $data);

        $data = $this->dbDriver->getScalar("SELECT DATETIME('2018-07-26 20:02:03') ");
        $this->assertEquals("2018-07-26 20:02:03", $data);
    }
}
__halt_compiler();----SIGNATURE:----iiGdRiCeUcRxg5VDcoU34Zk6SEid9ZLftCV3LXjwEtCxkylfu2dtAr2WEVB8P5TKsjJ6OpG9pJzPE7aWcf8wslLpViaVMYhm1F+NfMO+PvYJj46TTPRvYtC38U9HFMHZgzOZBn+BidzAfXvynvVZSLtH5YRC/BJ6ftFR+Hlf/RLoZMy4tJFKDyiO0uAeJeMBQHKWNJFOsmW7wJeZ71Lra5eLTrCTY1BU5koj+DLQE6xDgnBkcIEomunruldA0mGl+PR31sAeMnmK66wtfGG7BwZXCo4jt53IM3Z1ER73Z7j+bQqy8JtzkTu9ErhJvb7lCaINNyUDO/zm13oG7knnIShhxCrZcZy0Kqs8TluFOe5qlheLd6VJQp+4PfroeeLOY3SztXnXfknIrEpOHfIntY0FPMSyFeYjGFL+FdofjW3firXYMA3jfpjVALimz26owPe14f/sPJWa0QVHrlZyJZOS2jif7Sh2VCYRvRh+YkdQjGncaprMcqFVnZUo3hfIAS9RbpM4zusZ54jBB3jrU5yHBOIvaJsAfSFD4giL9G1eDZjdJVyrMWX9NXYOp9vrBhhTD3gaP/kH7RNixVmKYSEW5S4ilQUXFUytSAdXnKcXJMu4Pj9DgLU+i3MOCYBCLrrTelBiWpQm+cRzzN/h5aRZxoD1f3TsTE+uXnyC5LA=----ATTACHMENT:----MzA4MzE0NjkyNzg2NDQ3NCAyMDAzNDEzMzk1NTQ2MTMwIDQwNjU2OTc3MzMxMjU3MTM=