/**
*
*/
public function __construct()
{
self::$param_id = 0;
$this->conditionList = array();
$this->phraseList = array();
$this->paramList = array();
}
public function test_limit()
{
#
# invalid value
#
$gen = new BindParamGenerator();
$gen->limit(null);
$param = $gen->generate();
$actual = $param->getConditionStr();
$expected = "";
$this->assertEquals($expected, $actual);
$actual = $param->getParamArray();
$expected = array();
$this->assertEquals($expected, $actual);
#
# one parameter
#
$gen = new BindParamGenerator();
$gen->limit(1);
$param = $gen->generate();
$actual = $param->getConditionStr();
$expected = " LIMIT 1";
$this->assertEquals($expected, $actual);
$actual = $param->getParamArray();
$expected = array();
$this->assertEquals($expected, $actual);
#
# two parameters
#
$gen = new BindParamGenerator();
$gen->limit(0, 3);
$param = $gen->generate();
$actual = $param->getConditionStr();
$expected = " LIMIT 0,3";
$this->assertEquals($expected, $actual);
$actual = $param->getParamArray();
$expected = array();
$this->assertEquals($expected, $actual);
}
/**
* @covers SQLAdapter::__construct
* @covers SQLAdapter::select
* @covers SQLAdapter::delete
*/
public function test_delete()
{
$config = new PDOConfig(array('database' => 'test', 'pass' => ''));
$pdo = new PDOExtended($config);
$adapter = new SQLAdapter($pdo);
$generator = new BindParamGenerator();
$generator->equal_('ID', 4);
$actual = $adapter->delete('TBL_TEST', null);
$expected = false;
$this->assertEquals($expected, $actual, __CLASS__ . "::" . __METHOD__ . ": line " . __LINE__);
#
# delete
#
$adapter = new SQLAdapter($pdo);
$generator = new BindParamGenerator();
$generator->equal_('ID', 4);
$response = $adapter->delete('TBL_TEST', $generator->generate());
$actual = $response->getErrorCode();
$expected = '00000';
$this->assertEquals($expected, $actual, __CLASS__ . "::" . __METHOD__ . ": line " . __LINE__);
#
# try to select a deleted data
#
$adapter = new SQLAdapter($pdo);
$generator = new BindParamGenerator();
$generator->equal_('ID', 4);
$response = $adapter->select('TBL_TEST', array('ID', 'FIELD1', 'FIELD3'), $generator->generate());
$actual = $response->fetchAll();
$expected = array();
$this->assertEquals($expected, $actual, __CLASS__ . "::" . __METHOD__ . ": line " . __LINE__);
}
