public function testNumbers()
{
$sql = 'SELECT * FROM test WHERE float_val > :float AND int_val > :int';
$params = array('float' => 3.14159, 'int' => 42);
$res = PdoDebugger::show($sql, $params);
$this->assertEquals($res, 'SELECT * FROM test WHERE float_val > 3.14159 AND int_val > 42');
}
public function testIssue4()
{
$sql = <<<eof
SELECT
u.id AS uid,
t.id AS tid,
t.lastmodifieddate AS tlmd,
ut.lastmodifieddate AS utlmd
FROM `territory` AS t
JOIN `userterritory` AS ut ON (ut.territoryid = t.id)
JOIN `user` AS u ON (ut.userid = u.id)
WHERE u.lastmodifieddate > (SELECT lastrun FROM `config` WHERE username = :username)
OR ut.lastmodifieddate > (SELECT lastrun FROM `config` WHERE username = :username)
OR t.lastmodifieddate > (SELECT lastrun FROM `config` WHERE username = :username)
eof;
$expected = <<<eof
SELECT
u.id AS uid,
t.id AS tid,
t.lastmodifieddate AS tlmd,
ut.lastmodifieddate AS utlmd
FROM `territory` AS t
JOIN `userterritory` AS ut ON (ut.territoryid = t.id)
JOIN `user` AS u ON (ut.userid = u.id)
WHERE u.lastmodifieddate > (SELECT lastrun FROM `config` WHERE username = '******')
OR ut.lastmodifieddate > (SELECT lastrun FROM `config` WHERE username = '******')
OR t.lastmodifieddate > (SELECT lastrun FROM `config` WHERE username = '******')
eof;
$params = array('username' => 'johndoe');
$res = PdoDebugger::show($sql, $params);
$this->assertEquals($res, $expected);
}
