/** * When you use addSql multiple times, each string is concatenated and * use setSql to assign back the result * * @depends testAddSqlWhenNoSqlExists * @return null */ public function testAddSqlMultipleTimes() { $sql = "SELECT * FROM TABLE WHERE id=blah"; $this->request->setSql($sql); $this->assertTrue($this->request->isSql()); $this->assertEquals($sql, $this->request->getSql()); $sql2 = "SELECT * FROM TABLE WHERE id=foo"; $this->request->addSql($sql2); $this->assertTrue($this->request->isSql(), 'should not change'); $expected = "{$sql};{$sql2}"; $this->assertEquals($expected, $this->request->getSql()); $sql3 = "SELECT * FROM TABLE WHERE id=bar"; $this->request->addSql($sql3); $this->assertTrue($this->request->isSql(), 'should not change'); $expected = "{$sql};{$sql2};{$sql3}"; $this->assertEquals($expected, $this->request->getSql()); /* reset to one sql like this */ $this->request->setSql($sql); $this->assertTrue($this->request->isSql(), 'should not change'); $this->assertEquals($sql, $this->request->getSql()); }