/**
* @covers SQLAdapter::__construct
* @covers SQLAdapter::select
*/
public function testSelect()
{
$config = new PDOConfig(array('database' => 'test', 'pass' => ''));
$pdo = new PDOExtended($config);
#
# Select
#
$adapter = new SQLAdapter($pdo);
$generator = new BindParamGenerator();
$generator->equal_('ID', '3');
$response = $adapter->select('TBL_TEST', array('ID', 'FIELD1', 'FIELD3'), $generator->generate());
$actual = $response->fetchAll();
$expected = array(0 => array('ID' => '3', 'FIELD1' => 'f3_1', 'FIELD3' => 'f3_3'));
$this->assertEquals($expected, $actual, __CLASS__ . "::" . __METHOD__ . ": line " . __LINE__);
#
# Select with WHERE IN - 1
#
$adapter = new SQLAdapter($pdo);
$generator = new BindParamGenerator();
$generator->in_('ID', array(2, 4));
$response = $adapter->select('TBL_TEST', array('ID', 'FIELD1', 'FIELD3'), $generator->generate());
$actual = $response->fetchAll();
$expected = array(0 => array('ID' => '2', 'FIELD1' => 'f2_1', 'FIELD3' => 'f2_3'), 1 => array('ID' => '4', 'FIELD1' => 'f4_1', 'FIELD3' => 'f4_3'));
$this->assertEquals($expected, $actual, __CLASS__ . "::" . __METHOD__ . ": line " . __LINE__);
#
# Select with WHERE IN and ORDER BY
#
$adapter = new SQLAdapter($pdo);
$generator = new BindParamGenerator();
$generator->in_('FIELD1', array('f2_1', 'f4_1'))->orderBy(array('ID' => 'DESC'));
$response = $adapter->select('TBL_TEST', array('ID', 'FIELD1', 'FIELD3'), $generator->generate());
$actual = $response->fetchAll();
$expected = array(0 => array('ID' => '4', 'FIELD1' => 'f4_1', 'FIELD3' => 'f4_3'), 1 => array('ID' => '2', 'FIELD1' => 'f2_1', 'FIELD3' => 'f2_3'));
$this->assertEquals($expected, $actual, __CLASS__ . "::" . __METHOD__ . ": line " . __LINE__);
}
/**
* @covers BindParamGenerator::in_
* @covers BindParamGenerator::_addWhereInParams
*/
public function test_in_()
{
$gen = new BindParamGenerator();
$gen->in_('field', array(1, 2, 3, 4, "5"));
$param = $gen->generate();
$actual = $param->getConditionStr();
$expected = "field IN (:field_0,:field_1,:field_2,:field_3,:field_4)";
$this->assertEquals($expected, $actual);
}
