コード例 #1
0
 /**
  * Test an ASSOC fetch with a connection that has the Creole::NO_ASSOC_LOWER flag set.
  */
 public function testFetchmodeAssocNoChange()
 {
     $exch = DriverTestManager::getExchange('ResultSetTest.ALL_RECORDS');
     $conn2 = Creole::getConnection(DriverTestManager::getDSN(), Creole::NO_ASSOC_LOWER);
     DriverTestManager::initDb($conn2);
     $rs = $conn2->executeQuery($exch->getSql(), ResultSet::FETCHMODE_ASSOC);
     $rs->next();
     $keys = array_keys($rs->getRow());
     $this->assertEquals("PRODUCTID", $keys[0], 0, "Expected to find uppercase column name for Oracle.");
     $rs->close();
 }
コード例 #2
0
 /**
  * Test an ASSOC fetch with a connection that has the Creole::NO_ASSOC_LOWER flag set.
  *
  * NOTE: This parent method for this test opens a second connection in
  *       order to test the Creole::NO_ASSOC_LOWER flag. I had to override
  *       this because the ODBC driver I was testing with is very sensitive
  *       to having multiple connections open. In particular, I couldn't drop
  *       a database table (via DriverTestManager::initDb()) from the second
  *       connection while the first was still open.
  */
 public function testFetchmodeAssocNoChange()
 {
     if ($this->conn->getAdapter()->preservesColumnCase()) {
         $exch = DriverTestManager::getExchange('ResultSetTest.ALL_RECORDS');
         $dsn = DriverTestManager::getDSN();
         $this->conn->close();
         $this->conn->connect($dsn, Creole::NO_ASSOC_LOWER);
         DriverTestManager::initDb($this->conn);
         $rs = $this->conn->executeQuery($exch->getSql(), ResultSet::FETCHMODE_ASSOC);
         $rs->next();
         $keys = array_keys($rs->getRow());
         $this->assertEquals("ProductID", $keys[0], 0, "Expected to find mixed-case column name.");
         $rs->close();
         $this->conn->close();
         $this->conn->connect($dsn);
     }
 }
コード例 #3
0
 /**
  * Test an ASSOC fetch with a connection that has the Creole::NO_ASSOC_LOWER flag set.
  */
 public function testFetchmodeAssocNoChange()
 {
     $exch = DriverTestManager::getExchange('ResultSetTest.ALL_RECORDS');
     $conn2 = Creole::getConnection(DriverTestManager::getDSN(), Creole::NO_ASSOC_LOWER);
     DriverTestManager::initDb($conn2);
     $rs = $conn2->executeQuery($exch->getSql(), ResultSet::FETCHMODE_ASSOC);
     $rs->next();
     $keys = array_keys($rs->getRow());
     $this->assertEquals("ProductID", $keys[0], 0, "Expected to find mixed-case column name.");
     $rs->close();
     // do NOT close the connection; in many cases both COnnection objects will share
     // the same db connection
 }