/**
* @covers Openbuildings\Kohana\Database_Query::parameters
* @covers Openbuildings\Kohana\Database_Query::bind
* @covers Openbuildings\Kohana\Database_Query::compile
* @covers Openbuildings\Kohana\Database_Query::param
*/
public function test_parameters()
{
$query = new Database_Query(Database::SELECT, 'SELECT * FROM table1 WHERE name = :param1 AND price > :param2 AND name IS NOT :param3');
$param2 = 20;
$query->parameters(array(':param1' => 'test'));
$query->param(':param3', NULL);
$query->bind(':param2', $param2);
$param2 = 10;
$expected = "SELECT * FROM table1 WHERE name = 'test' AND price > 10 AND name IS NOT NULL";
$result = $query->compile();
$this->assertEquals($expected, $result);
}
