/** * @param PASL_DB_Driver_Common|MDB2_Driver_common $dbObject */ private function testBasicQueryMethods($dbObject) { $sql = "SELECT * FROM pasl_query_tests"; $expectedRecord = array(); $expectedRecord['id'] = "1"; $expectedRecord['name'] = 'db_test'; $expectedRecord['sequence'] = 'primary'; $expectedRecord['timestamp'] = '0000-00-00 00:00:00'; $result = $dbObject->queryCol($sql, 'name'); $this->assertEqual($result[0], $expectedRecord['name']); $result = $dbObject->queryCol($sql, 1); $this->assertEqual($result[0], $expectedRecord['name']); $result = $dbObject->queryOne($sql, 'name'); $this->assertEqual($result, $expectedRecord['name']); $result = $dbObject->queryOne($sql, 1); $this->assertEqual($result, $expectedRecord['name']); $result = $dbObject->queryRow($sql); $this->assertIsA($result, 'Array'); $this->assertIdentical($result, $expectedRecord); $result = $dbObject->queryAll($sql); $this->assertIsA($result, 'Array'); $this->assertIdentical($result[0], $expectedRecord); }