/**
* 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();
}
/**
* 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);
}
}
/**
* 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
}