chillerlan / php-database

/**

 * Class FirebirdQueryTest

 */

class FirebirdQueryTest extends QueryTestAbstract{

	protected $driver = PDOFirebirdDriver::class;

	protected $envVar = 'DB_FIREBIRD_';

	public function testCreateDatabase(){

		$this->assertSame(

			'CREATE DATABASE querytest DEFAULT CHARACTER SET UTF8',

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

		);

		$this->assertSame(

			'CREATE DATABASE querytest DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI_AI',

			$this->createDatabase()->charset('utf8_UNICODE_CI_AI')->sql()

		);

	}

}

/**

 * Class MySQLQueryTest

 */

class MySQLQueryTest extends QueryTestAbstract{

	protected $driver = MySQLiDriver::class;

	protected $envVar = 'DB_MYSQLI_';

	public function testCreateDatabase(){

		$this->assertSame(

			'CREATE DATABASE querytest CHARACTER SET utf8',

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

		);

		$this->assertSame(

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

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

		);

	}

}

/**

 * Class PostgresQueryTest

 */

class PostgresQueryTest extends QueryTestAbstract{

	protected $driver = PostgreSQLDriver::class;

	protected $envVar = 'DB_POSTGRES_';

	public function testCreateDatabase(){

		$this->assertSame(

			'CREATE DATABASE querytest ENCODING \'UTF8\'',

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

		);

		$this->assertSame(

			'CREATE DATABASE querytest 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()

		);

	}

}