Esempio n. 1
0
 function testQinto()
 {
     switch ($this->dbo->paramStyle()) {
         case QDB::PARAM_QM:
             $sql = "SELECT * FROM testtable WHERE level_ix > ? AND int_x = ?";
             $args = array(1, 2);
             break;
         case QDB::PARAM_CL_NAMED:
             $sql = "SELECT * FROM testtable WHERE level_ix > :level_ix AND int_x = :int_x";
             $args = array('level_ix' => 1, 'int_x' => 2);
             break;
         case QDB::PARAM_DL_NAMED:
             $sql = "SELECT * FROM testtable WHERE level_ix > \$1 AND int_x = \$2";
             $args = array(1, 2);
             break;
         case QDB::PARAM_AT_NAMED:
             $sql = "SELECT * FROM testtable WHERE level_ix > @level_ix AND int_x = @int_x";
             $args = array('level_ix' => 1, 'int_x' => 2);
             break;
     }
     $expected = 'SELECT * FROM testtable WHERE level_ix > 1 AND int_x = 2';
     $this->assertEquals($expected, $this->dbo->qinto($sql, $args));
 }