/** * @covers BindParamGenerator::orderBy */ public function test_orderBy() { $gen = new BindParamGenerator(); $gen->equal_('field1', 'value1')->or_()->equal_('field2', 'value2')->orderBy(array('field1' => 'ASC', 'field2' => 'DESC')); $param = $gen->generate(); $actual = $param->getConditionStr(); $expected = "field1=:field1_0 OR field2=:field2_1 ORDER BY field1 ASC,field2 DESC"; $this->assertEquals($expected, $actual); $actual = $param->getParamArray(); $expected = array('field1_0' => 'value1', 'field2_1' => 'value2'); $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__); }