<?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:----VUAquqK6uoYE28mcM1bUhMlhxKlKvgfod2FPawARA6G0o7sZRBOSU5hlfsHK66VXWnedyHm9KZOIuhuPcvtoHn0PBl6Y2/meWqnwGKx04hRDs7nGLp1BO3ti8QyByR1UkFEzbCWk7nr3CvS344Oq4scGY2L+P7hELADti6JxQSk8hXLGlbDigO/NIwZL0P4JSpoOc6lGLPOLc4iCAXf2uRFCHfr3mTedY/i0mCPsIN3w7ocz8MfzCaZh2CifmS5fMS1GsBC1wpBNJVYNjZmEoX3hQI/XiWRVcbg+dnnqxLfqrKrmDAa4h8kKTOBVyYf2sAB4HdtkHAlNfhOoY0DvuDt/u6yznt6+SCzGZkekhxkaAdrXcJ1Pm/NjP0B78HlvrwWJqlD98diphi/4snquBtUNfDXfzZZuzoRCJ8wReJuWjWERDfldN2Cyhqzu9EPn15jeU4PuR5Ol4s6U7j3a3iyl0y6HEEx07vmrr5rawBwZr8Bex9ExweZ52w2I3jZsxVBS2Exp9yFGu+2cBgzLU2E+6TlFsAkgZ2lzha/9mQLJfESC6Z3nFfWMrjwWye9zTHtKKQA8L0RS5ebxvHeR660bhHrCHD7G4uyqjFBNfmr3ePaIk4NixRRH3pHY6o5dHn2Pxr0cfeuZIq27VsfdllpvTSgHVSJDHnW5S/ywKv8=----ATTACHMENT:----NTU0MTk1MDM2NDE5NjAyMyAxMzYzMDQ3NDg3Nzc0MTU5IDEzNTkwOTAzODY2NjA5NDk=