public function testSiJeFaisUnSelectWhereAndOr_AlorsLeResultatEstBon()
{
$db = new dbIhm('requete_test');
initTestTable();
$db->select('id,a1,a2,a3')->addWhere('a1')->addWhere('a2')->addWhere('a2', '=', 'or', 'a22')->addWhere('a4', '<');
$db->prepare();
$db->bindParam('a1', '1');
$db->bindParam('a2', '1');
$db->bindParam('a22', '1');
$db->bindParam('a4', '6');
$result = $db->executeAndFetchAll();
$expected = array(0 => array('id' => 1, 'a1' => 1, 'a2' => 1, 'a3' => 1), 1 => array('id' => 6, 'a1' => 1, 'a2' => 1, 'a3' => 1), 2 => array('id' => 7, 'a1' => 1, 'a2' => 1, 'a3' => 1), 3 => array('id' => 8, 'a1' => 1, 'a2' => 1, 'a3' => 1), 4 => array('id' => 9, 'a1' => 1, 'a2' => 1, 'a3' => 2), 5 => array('id' => 11, 'a1' => 1, 'a2' => 1, 'a3' => 1), 6 => array('id' => 13, 'a1' => 1, 'a2' => 1, 'a3' => 3), 7 => array('id' => 14, 'a1' => 1, 'a2' => 1, 'a3' => 1), 8 => array('id' => 15, 'a1' => 1, 'a2' => 1, 'a3' => 1));
$this->assertEquals($expected, $result);
}
