/**
* A method to test the saveAllocatedImpressions method.
*/
function testSaveAllocatedImpressions()
{
$oDbh =& OA_DB::singleton();
$oDal = new OA_Dal_Maintenance_Priority();
// Create the required temporary table for the tests
$oTable =& OA_DB_Table_Priority::singleton();
$oTable->createTable('tmp_ad_zone_impression');
// Prepare the test data
$aData = array(array('ad_id' => 56, 'zone_id' => 11, 'required_impressions' => 9997, 'requested_impressions' => 9000), array('ad_id' => 56, 'zone_id' => 12, 'required_impressions' => 24, 'requested_impressions' => 24));
$result = $oDal->saveAllocatedImpressions($aData);
$query = "SELECT * FROM " . $oDbh->quoteIdentifier('tmp_ad_zone_impression', true) . " ORDER BY ad_id, zone_id";
$rc = $oDbh->query($query);
$result = $rc->fetchAll();
$this->assertTrue(is_array($result));
$this->assertTrue(count($result) == 2);
$tmp = $result[0];
$this->assertTrue(array_key_exists('ad_id', $tmp));
$this->assertEqual($tmp['ad_id'], 56);
$this->assertTrue(array_key_exists('zone_id', $tmp));
$this->assertEqual($tmp['zone_id'], 11);
$this->assertTrue(array_key_exists('required_impressions', $tmp));
$this->assertEqual($tmp['required_impressions'], 9997);
$this->assertTrue(array_key_exists('requested_impressions', $tmp));
$this->assertEqual($tmp['requested_impressions'], 9000);
$tmp = $result[1];
$this->assertTrue(array_key_exists('ad_id', $tmp));
$this->assertEqual($tmp['ad_id'], 56);
$this->assertTrue(array_key_exists('zone_id', $tmp));
$this->assertEqual($tmp['zone_id'], 12);
$this->assertTrue(array_key_exists('required_impressions', $tmp));
$this->assertEqual($tmp['required_impressions'], 24);
$this->assertTrue(array_key_exists('requested_impressions', $tmp));
$this->assertEqual($tmp['requested_impressions'], 24);
TestEnv::dropTempTables();
}
