chillerlan / php-database

/**

 * Class FirebirdQueryTest

 */

class FirebirdQueryTest extends QueryTestAbstract{

	protected $driver = PDOFirebirdDriver::class;

	protected $envVar = 'DB_FIREBIRD_';

#	public function setUp(){

#		$this->markTestIncomplete('use the vagrant box...');

#	}

	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()

		);

	}

	public function testCreateTable(){

		var_dump($this->createTable()->sql());

		var_dump($this->createTable()->execute());

		$this->markTestIncomplete();

	}

}

/**

 * 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()

		);

	}

	public function testCreateTable(){

		var_dump($this->createTable()->sql());

		$this->markTestIncomplete();

	}

}