/**
* Method to test createDatabase().
*
* @return void
*
* @covers Windwalker\Query\Mysql\MysqlQueryBuilder::createDatabase
*/
public function testCreateDatabase()
{
$expected = "CREATE DATABASE {$this->qn('foo')}";
$actual = MysqlQueryBuilder::createDatabase('foo');
$this->assertEquals($this->format($expected), $this->format($actual));
$expected = "CREATE DATABASE IF NOT EXISTS {$this->qn('foo')}";
$actual = MysqlQueryBuilder::createDatabase('foo', true);
$this->assertEquals($this->format($expected), $this->format($actual));
$expected = "CREATE DATABASE IF NOT EXISTS {$this->qn('foo')} CHARACTER SET='utf8' COLLATE='bar'";
$actual = MysqlQueryBuilder::createDatabase('foo', true, 'utf8', 'bar');
$this->assertEquals($this->format($expected), $this->format($actual));
}
/**
* createDatabase
*
* @param bool $ifNotExists
* @param string $charset
* @param string $collate
*
* @return static
*/
public function create($ifNotExists = false, $charset = 'utf8', $collate = 'utf8_general_ci')
{
$query = MysqlQueryBuilder::createDatabase($this->database, $ifNotExists, $charset, $collate);
$this->db->setQuery($query)->execute();
return $this;
}
