/**
* @covers Openbuildings\Kohana\DB::update
*/
public function test_update()
{
$result = DB::update('table1');
$this->assertInstanceOf('Openbuildings\\Kohana\\Database_Query_Builder_Update', $result);
$this->assertEquals(Database::UPDATE, $result->type());
$this->assertEquals('UPDATE `table1` SET ', $result->compile());
}
/**
* @covers Openbuildings\Kohana\Database_Query_Builder_Insert::select
* @expectedException Openbuildings\Kohana\Database_Exception
*/
public function test_select()
{
$query = new Database_Query_Builder_Insert('table1', array('name', 'price'));
$this->assertEquals("INSERT INTO `table1` (`name`, `price`) SELECT `name` AS `price` FROM `table2`", $query->select(DB::select(array('name', 'price'))->from('table2'))->compile());
$query = new Database_Query_Builder_Insert('table1', array('name', 'price'));
$query->select(DB::update('table2'));
}
