/** * Method to test dropDatabase(). * * @return void * * @covers Windwalker\Query\Mysql\MysqlQueryBuilder::dropDatabase */ public function testDropDatabase() { $expected = "DROP DATABASE {$this->qn('foo')}"; $actual = MysqlQueryBuilder::dropDatabase('foo'); $this->assertEquals($this->format($expected), $this->format($actual)); $expected = "DROP DATABASE IF EXISTS {$this->qn('foo')}"; $actual = MysqlQueryBuilder::dropDatabase('foo', true); $this->assertEquals($this->format($expected), $this->format($actual)); }
/** * Method to test dropDatabase(). * * @return void * * @covers Windwalker\Query\Mysql\MysqlQueryBuilder::dropDatabase */ public function testDropDatabase() { $expected = "DROP DATABASE {$this->qn}foo{$this->qn}"; $actual = MysqlQueryBuilder::dropDatabase('foo'); $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual)); $expected = "DROP DATABASE IF EXISTS {$this->qn}foo{$this->qn}"; $actual = MysqlQueryBuilder::dropDatabase('foo', true); $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual)); }
/** * tearDownAfterClass * * @return void */ public static function tearDownAfterClass() { static::$dbo->setQuery(MysqlQueryBuilder::dropDatabase('windwalker_foo_test', true))->execute(); static::$dbo->setQuery(MysqlQueryBuilder::dropDatabase('windwalker_bar_test', true))->execute(); parent::tearDownAfterClass(); }
/** * dropDatabase * * @param bool $ifExists * * @return static */ public function drop($ifExists = false) { $query = MysqlQueryBuilder::dropDatabase($this->database, $ifExists); $this->db->setQuery($query)->execute(); return $this; }