function test_remove_where_clause()
{
$test = $this->tests[0];
$parser = new SQL_Parser();
$compiler = new SQL_Compiler();
$parsed = $parser->parse($test['sql']);
$wrapper = new SQL_Parser_wrapper($parsed);
$to_be_removed = array('arg_1' => array('value' => 'cat', 'type' => 'ident'), 'op' => '<>', 'arg_2' => array('value' => 4, 'type' => 'int_val'));
$wrapper->removeWhereClause($to_be_removed);
$this->assertTrue(!isset($parsed['where_clause']));
$sql = $compiler->compile($parsed);
$this->assertEquals("select * from dog", $sql);
//-------
$parsed = $parser->parse('select one, two from hairy where two <> 4 and one = 2');
$wrapper = new SQL_Parser_wrapper($parsed);
$to_be_removed = array('arg_1' => array('value' => 'two', 'type' => 'ident'), 'op' => '<>', 'arg_2' => array('value' => 4, 'type' => 'int_val'));
$wrapper->removeWhereClause($to_be_removed);
$expected = array('arg_1' => array('value' => 'one', 'type' => 'ident'), 'op' => '=', 'arg_2' => array('value' => 2, 'type' => 'int_val'));
$this->assertEquals($expected, $parsed['where_clause']);
}
