/**
* @covers Openbuildings\Kohana\Database_Query_Builder_Select::having_open
* @covers Openbuildings\Kohana\Database_Query_Builder_Select::having_close
* @covers Openbuildings\Kohana\Database_Query_Builder_Select::and_having_open
* @covers Openbuildings\Kohana\Database_Query_Builder_Select::and_having_close
* @covers Openbuildings\Kohana\Database_Query_Builder_Select::or_having_open
* @covers Openbuildings\Kohana\Database_Query_Builder_Select::or_having_close
*/
public function test_having_open()
{
$query = new Database_Query_Builder_Select();
$this->assertEquals("SELECT * HAVING `table1`.`name` = 'test' AND (`table1`.`price` => 20 AND `table1`.`price` < 10) AND (`table1`.`name` LIKE 'test' AND `table1`.`name` IS NOT NULL) OR (`table1`.`description` LIKE 'test' OR `table1`.`description` IS NOT NULL)", $query->having('table1.name', '=', 'test')->having_open()->having('table1.price', '=>', 20)->and_having('table1.price', '<', 10)->having_close()->and_having_open()->having('table1.name', 'LIKE', 'test')->and_having('table1.name', 'IS NOT', NULL)->and_having_close()->or_having_open()->having('table1.description', 'LIKE', 'test')->or_having('table1.description', 'IS NOT', NULL)->or_having_close()->compile());
}
