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