chillerlan / php-database

use chillerlan\Database\Drivers\MySQLiDriver;

class MySQLQueryTest extends QueryTestAbstract{

	protected $driver = MySQLiDriver::class;

	protected $envVar = 'DB_MYSQLI_';

	public function testCreateDatabase(){

		$this->assertSame(

			'CREATE DATABASE `vagrant` CHARACTER SET utf8',

			$this->createDatabase()->sql()

		);

		$this->assertSame(

			'CREATE DATABASE IF NOT EXISTS `vagrant` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin',

			$this->createDatabase()->charset('utf8mb4_bin')->ifNotExists()->sql()

		);

	}

}

use chillerlan\Database\Drivers\PDO\PDOPostgresDriver;

use chillerlan\Database\Drivers\PostgreSQLDriver;

class PostgresQueryTest extends QueryTestAbstract{

	protected $driver = PDOPostgresDriver::class;

	protected $envVar = 'DB_POSTGRES_';

	public function testCreateDatabase(){

		$this->assertSame(

			'CREATE DATABASE "vagrant" ENCODING \'UTF8\'',

			$this->createDatabase()->sql()

		);

		$this->assertSame(

			'CREATE DATABASE "vagrant" ENCODING \'EUC_KR\' LC_COLLATE=\'ko_KR.euckr\' LC_CTYPE=\'ko_KR.euckr\'',

			$this->createDatabase()->charset('EUC_KR,ko_KR.euckr,ko_KR.euckr')->sql()

		);

	}

}