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