/**
* 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());
}
