Ejemplo n.º 1
0
 function testQinto2()
 {
     $checks = array(array("SELECT * FROM testtable WHERE level_ix > ? AND int_x = ?", array(1, 2), QDB::PARAM_QM), array("SELECT * FROM testtable WHERE level_ix > :level_ix AND int_x = :int_x", array('level_ix' => 1, 'int_x' => 2), QDB::PARAM_CL_NAMED), array("SELECT * FROM testtable WHERE level_ix > \$1 AND int_x = \$2", array(1, 2), QDB::PARAM_DL_SEQUENCE), array("SELECT * FROM testtable WHERE level_ix > @level_ix AND int_x = @int_x", array('level_ix' => 1, 'int_x' => 2), QDB::PARAM_AT_NAMED));
     $expected = 'SELECT * FROM testtable WHERE level_ix > 1 AND int_x = 2';
     foreach ($checks as $check) {
         list($sql, $args, $param_style) = $check;
         $this->assertEquals($expected, $this->dbo->qinto($sql, $args, $param_style), $sql);
     }
 }