<?php

namespace ByJG\DbMigration\Database;

use ByJG\AnyDataset\Db\Factory;
use ByJG\Util\Uri;
use Psr\Http\Message\UriInterface;

class MySqlDatabase extends AbstractDatabase
{
    public static function prepareEnvironment(UriInterface $uri)
    {
        $database = preg_replace('~^/~', '', $uri->getPath());

        $customUri = new Uri($uri->__toString());

        $dbDriver = Factory::getDbRelationalInstance($customUri->withPath('/')->__toString());
        $dbDriver->execute("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
    }

    public function createDatabase()
    {
        $database = preg_replace('~^/~', '', $this->getDbDriver()->getUri()->getPath());

        $this->getDbDriver()->execute("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
        $this->getDbDriver()->execute("USE `$database`");
    }

    public function dropDatabase()
    {
        $database = preg_replace('~^/~', '', $this->getDbDriver()->getUri()->getPath());

        $this->getDbDriver()->execute("drop database `$database`");
    }

    /**
     * @throws \ByJG\DbMigration\Exception\DatabaseNotVersionedException
     * @throws \ByJG\DbMigration\Exception\OldVersionSchemaException
     */
    public function createVersion()
    {
        $this->getDbDriver()->execute('CREATE TABLE IF NOT EXISTS ' . $this->getMigrationTable() . ' (version int, status varchar(20), PRIMARY KEY (version))');
        $this->checkExistsVersion();
    }

    public function executeSql($sql)
    {
        $this->getDbDriver()->execute($sql);
    }
}
__halt_compiler();----SIGNATURE:----bcSF2Zt0edi0gsj5cGhOS95DoGDkRjlKlpF9sUSAwbsifBA8mMGsZbAGeAGE88XNov0ZKAmt9lQW6qAgrECPT9L9xBz9SurhpthArhcbHpbKmnj1r+BczJmdYlvxwE+Fds4Q/vJUn42DjE5V4SpcMv8qTlSGxDvannZxD6fC8PZSzQninhiZLNdbyz2nIpBxearhxD6lg3r19Me7b4Yd3syENzBrgZWF8JF+2ksWcMuGGuSEqCR+PoVgiRMHxAvQT4PPeM/hvUap6YOBINmvJ9RHLmwc8xFGup9u6HDhO7rxymyyLZHArKkNsFXemSvsYlps9zFxhUji823Pj25w+wkc9QGv5ZceK25tzCvT5x/osjB9wDLzF6Q7iWhmINTGf7w69g7cjsSXTyxE1fKESVTsZTNYhV3eZckX5b9rdY1nAVuUQFcAL+b7R778qcxiKoeIXDrGLl3enswpAlp98A3sAbueegYbSmGfPWEbd1GoF2XbsBMmPqw2zGIkmaa+4BhgX7u7/f0hngrbjizq88utWUNMHSnYV+hUF5v/ivTY+kHbTlu2c8MlyeNP3txYwlsoVEOKFdtKyqCRij9E7cGJTkCkoFHlecdbJpkh8gbCa4odjQgou62fhNROJDtNk0I//mgBIlqgfqOTZpFzC/ToReQEc1pE7+YnYCcHaM8=----ATTACHMENT:----NDYwNTIyMDI4OTQ3NTkzMCA5NTAwMDc4MTk0NTkzOTM1IDE4NTQ1MDI5NDg4MjI5