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