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__); }