/**
* Method to test getQuery().
*
* @return void
*
* @covers Windwalker\Query\Mysql\MysqlQueryBuilder::getQuery
*/
public function testGetQuery()
{
$this->assertInstanceOf('Windwalker\\Query\\Mysql\\MysqlQuery', MysqlQueryBuilder::getQuery());
$this->assertSame(MysqlQueryBuilder::getQuery(), MysqlQueryBuilder::getQuery());
$this->assertNotSame(MysqlQueryBuilder::getQuery(), MysqlQueryBuilder::getQuery(true));
}
/**
* getColumnDetail
*
* @param string $column
* @param bool $full
*
* @return mixed
*/
public function getColumnDetail($column, $full = true)
{
$query = MysqlQueryBuilder::showTableColumns($this->table, $full, 'Field = ' . $this->db->quote($column));
return $this->db->setQuery($query)->loadOne();
}
/**
* 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();
}
/**
* getTableDetail
*
* @param bool $table
*
* @return mixed
*/
public function getTableDetail($table)
{
$table = $this->db->replacePrefix($table);
$query = MysqlQueryBuilder::showDbTables($this->database, 'Name = ' . $this->db->quote($table));
$table = $this->db->setQuery($query)->loadOne();
if (!$table) {
return false;
}
return $table;
}
/**
* tearDownAfterClass
*
* @return void
*/
public static function tearDownAfterClass()
{
if (static::$dbo) {
try {
static::$dbo->setQuery(MysqlQueryBuilder::dropTable('#__cloud', true))->execute();
} catch (\Exception $e) {
// Do nothing
}
try {
static::$dbo->setQuery(MysqlQueryBuilder::dropTable('#__wind', true))->execute();
} catch (\Exception $e) {
// Do nothing
}
}
parent::tearDownAfterClass();
}
/**
* drop
*
* @param bool $ifNotExists
* @param string $option
*
* @return static
*/
public function drop($ifNotExists = true, $option = '')
{
$query = MysqlQueryBuilder::dropTable($this->table, $ifNotExists, $option);
$this->db->setQuery($query)->execute();
return $this;
}
