/** * 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; }