/** * dropColumn * * @param string $name * * @return mixed */ public function dropColumn($name) { $query = MysqlQueryBuilder::dropColumn($this->table, $name); $this->db->setQuery($query)->execute(); return $this; }
/** * Method to test dropColumn(). * * @return void * * @covers Windwalker\Query\Mysql\MysqlQueryBuilder::dropColumn */ public function testDropColumn() { $expected = "ALTER TABLE {$this->qn('foo')} DROP {$this->qn('bar')}"; $actual = MysqlQueryBuilder::dropColumn('foo', 'bar'); $this->assertEquals($this->format($expected), $this->format($actual)); }
/** * Method to test dropColumn(). * * @return void * * @covers Windwalker\Query\Mysql\MysqlQueryBuilder::dropColumn */ public function testDropColumn() { $expected = "ALTER TABLE {$this->qn}foo{$this->qn} DROP {$this->qn}bar{$this->qn}"; $actual = MysqlQueryBuilder::dropColumn('foo', 'bar'); $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual)); }