/** * 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(); }
/** * Tests creating/dropping all of the MPE temporary tables. * * Note that testing for the existence of temporary tables is done via * SELECT statements, as some databases (e.g. MySQL) do not allow * temporary tables to be seen via any administrative commands. * * Requirements: * Test 1: Test that all MPE temporary tables can be created and dropped. */ function testAllMaintenancePriorityTables() { $tmpTables = array('tmp_ad_required_impression', 'tmp_ad_zone_impression'); // Test 1 $conf =& $GLOBALS['_MAX']['CONF']; $conf['table']['prefix'] = ''; $oDbh =& OA_DB::singleton(); foreach ($tmpTables as $tableName) { $query = "SELECT * FROM {$tableName}"; RV::disableErrorHandling(); $result = $oDbh->query($query); RV::enableErrorHandling(); $this->assertEqual(strtolower(get_class($result)), 'mdb2_error'); } $oTable =& OA_DB_Table_Priority::singleton(); foreach ($tmpTables as $tableName) { $oTable->createTable($tableName); } $aExistingTables = OA_DB_Table::listOATablesCaseSensitive(); foreach ($tmpTables as $tableName) { // Test that the table has been created $query = "SELECT * FROM {$tableName}"; $result = $oDbh->query($query); $this->assertTrue($result); // Test that the table can be dropped // Use a different query to overcome MDB2 query buffering $query = "SELECT foo FROM {$tableName}"; RV::disableErrorHandling(); $result = $oDbh->query($query); RV::enableErrorHandling(); $this->assertEqual(strtolower(get_class($result)), 'mdb2_error'); } // Restore the testing environment TestEnv::restoreEnv(); }
/** * Method to create/register/return the Maintenance Priority table class. * * @access private * @return OA_DB_Table_Priority */ function &_getMaxTablePriorityObj() { $dbType = strtolower($GLOBALS['_MAX']['CONF']['database']['type']); $oServiceLocator =& OA_ServiceLocator::instance(); $oTable = $oServiceLocator->get('OA_DB_Table_Priority'); if (!$oTable) { $oTable =& OA_DB_Table_Priority::singleton(); $oServiceLocator->register('OA_DB_Table_Priority', $oTable); } return $oTable; }
/** * execute the Priority engine tasks */ function runPriority() { // Run maintenance before recalculating priorities $this->runMaintenance(); $this->printHeading('Starting updatePriorities; date: ' . $this->_getDateTimeString(), 3); $oMaintenancePriority = new OA_Maintenance_Priority_AdServer(); $oMaintenancePriority->updatePriorities(); $this->printPriorities(); $this->printHeading('End updatePriorities; date: ' . $this->_getDateTimeString(), 3); // Hack! The TestEnv class doesn't always drop temp tables for some // reason, so drop them "by hand", just in case. $dbType = strtolower($GLOBALS['_MAX']['CONF']['database']['type']); $oTable =& OA_DB_Table_Priority::singleton(); $oTable->dropTable("tmp_ad_required_impression"); $oTable->dropTable("tmp_ad_zone_impression"); }
/** * Method to test the getAllZonesWithAllocInv method. * * Requirements: * Test 1: Test with no data, and ensure no data returned. * Test 2: Test with sample data, and ensure the correct data is returned. */ function DEPRECATED_testGetAllZonesWithAllocInv() { $conf = $GLOBALS['_MAX']['CONF']; $oDbh =& OA_DB::singleton(); $oMaxDalMaintenance = 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'); $tableTmp = $oDbh->quoteIdentifier('tmp_ad_zone_impression', true); // Test 1 $result =& $oMaxDalMaintenance->getAllZonesWithAllocInv(); $this->assertEqual(count($result), 0); // Test 2 $query = "\n INSERT INTO\n {$tableTmp}\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions\n )\n VALUES\n (\n 1,\n 1,\n 2,\n 3\n )"; $rows = $oDbh->exec($query); $query = "\n INSERT INTO\n {$tableTmp}\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions\n )\n VALUES\n (\n 1,\n 2,\n 4,\n 5\n )"; $rows = $oDbh->exec($query); $query = "\n INSERT INTO\n {$tableTmp}\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions\n )\n VALUES\n (\n 2,\n 2,\n 6,\n 7\n )"; $rows = $oDbh->exec($query); $result =& $oMaxDalMaintenance->getAllZonesWithAllocInv(); $this->assertEqual(count($result), 3); $this->assertEqual($result[0]['zone_id'], 1); $this->assertEqual($result[0]['ad_id'], 1); $this->assertEqual($result[0]['required_impressions'], 2); $this->assertEqual($result[0]['requested_impressions'], 3); $this->assertEqual($result[1]['zone_id'], 2); $this->assertEqual($result[1]['ad_id'], 1); $this->assertEqual($result[1]['required_impressions'], 4); $this->assertEqual($result[1]['requested_impressions'], 5); $this->assertEqual($result[2]['zone_id'], 2); $this->assertEqual($result[2]['ad_id'], 2); $this->assertEqual($result[2]['required_impressions'], 6); $this->assertEqual($result[2]['requested_impressions'], 7); TestEnv::dropTempTables(); }
/** * The test to ensure that a campaign with banners that have time-based * delivery limitations are correctly prioritised by the MPE. * * Test Basis: * * - One campaign, running from 2008-02-26 to 2008-02-27 (2 days). * - Booked impressions of 48,000 impressions (i.e. 1,000 per hour * required on average). * - Two banners in the zone, both with weight one. * - Banner ID 1 has a Time:Date delivery limitation, to only allow * the banner to deliver on 2008-02-26. * - Banner ID 2 has a Time:Date delivery limitation, to only allow * the banner to deliver on 2008-02-27. * - The campaign is linked to one constantly delivering zone (at * 1,000 impressions per hour). * * - Run the MPE with an OI of 60 minutes for the two days of the * campaign lifetime, and assume that all required impressions * allocated to the banner(s) are delivered. * * The expected result of this is that the MPE should allocate 1,000 * impressions per hour for Banner ID 1 all day on 2008-02-26, and * 1,000 impressions per hour for Banner ID 2 all day on 2008-02-37. */ function testCampaign() { $aConf =& $GLOBALS['_MAX']['CONF']; $aConf['maintenance']['operationInteval'] = 60; $aConf['priority']['useZonePatterning'] = false; OA_setTimeZone('GMT'); $oServiceLocator =& OA_ServiceLocator::instance(); $oServiceLocator->register('now', new Date('2008-02-27')); // Prepare the test campaign $doCampaigns = OA_Dal::factoryDO('campaigns'); $doCampaigns->views = 48000; $doCampaigns->clicks = -1; $doCampaigns->conversions = -1; $doCampaigns->activate_time = '2008-02-26 00:00:00'; $doCampaigns->expire_time = '2008-02-27 23:59:59'; $doCampaigns->priority = 10; $doCampaigns->target_impression = 0; $doCampaigns->target_click = 0; $doCampaigns->target_conversion = 0; $campaignId = DataGenerator::generateOne($doCampaigns); // Prepare the first banner $doBanners = OA_Dal::factoryDO('banners'); $doBanners->campaignid = $campaignId; $doBanners->active = 't'; $doBanners->weight = 1; $bannerId1 = DataGenerator::generateOne($doBanners); $doAcls = OA_Dal::factoryDO('acls'); $doAcls->bannerid = $bannerId1; $doAcls->logical = 'and'; $doAcls->type = 'deliveryLimitations:Time:Date'; $doAcls->comparison = '=='; $doAcls->data = '20080226'; $doAcls->executionorder = 0; DataGenerator::generateOne($doAcls); // Prepare the second banner $doBanners = OA_Dal::factoryDO('banners'); $doBanners->campaignid = $campaignId; $doBanners->active = 't'; $doBanners->weight = 1; $bannerId2 = DataGenerator::generateOne($doBanners); $doAcls = OA_Dal::factoryDO('acls'); $doAcls->bannerid = $bannerId2; $doAcls->logical = 'and'; $doAcls->type = 'deliveryLimitations:Time:Date'; $doAcls->comparison = '=='; $doAcls->data = '20080227'; $doAcls->executionorder = 0; DataGenerator::generateOne($doAcls); // Prepare the zone $doZones = OA_Dal::factoryDO('zones'); $zoneId = DataGenerator::generateOne($doZones); // Link the banners to the zone $doAd_zone_assoc = OA_Dal::factoryDO('ad_zone_assoc'); $doAd_zone_assoc->zone_id = $zoneId; $doAd_zone_assoc->ad_id = $bannerId1; DataGenerator::generateOne($doAd_zone_assoc); $doAd_zone_assoc = OA_Dal::factoryDO('ad_zone_assoc'); $doAd_zone_assoc->zone_id = $zoneId; $doAd_zone_assoc->ad_id = $bannerId2; DataGenerator::generateOne($doAd_zone_assoc); // Run the code to get the required ad impressions over // the 48 hour period of the test for ($counter = 1; $counter <= 48; $counter++) { // Set the "current" date/time that the MPE would be // running at for the appropriate hour of the test $oNowDate = new Date('2008-02-26 00:00:01'); $oNowDate->addSeconds(($counter - 1) * SECONDS_PER_HOUR); $oServiceLocator->register('now', $oNowDate); // Run the code to get the required ad impressions $oGetRequiredAdImpressionsLifetime = new OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime(); $oGetRequiredAdImpressionsLifetime->run(); // Test that 1,000 impressions have been "required" for // the appropriate banner $query = "SELECT * FROM tmp_ad_required_impression"; $rsRequiredImpression = DBC::NewRecordSet($query); $rsRequiredImpression->find(); $aRequiredImpressions = $rsRequiredImpression->getAll(); $this->assertTrue(is_array($aRequiredImpressions), "No array for required impressions SQL result in test hour {$counter}"); $this->assertEqual(count($aRequiredImpressions), 1, "More than one row found for required impressions SQL result in test hour {$counter}"); $this->assertTrue(is_array($aRequiredImpressions[0]), "Badly formatted result row for required impressions SQL result in test hour {$counter}"); $this->assertEqual(count($aRequiredImpressions[0]), 2, "Badly formatted result row for required impressions SQL result in test hour {$counter}"); $bannerId = $aRequiredImpressions[0]['ad_id']; if ($counter <= 24) { $this->assertEqual($bannerId, $bannerId1, "Expected required impressions for banner ID {$bannerId1} in test hour {$counter}"); } else { $this->assertEqual($bannerId, $bannerId2, "Expected required impressions for banner ID {$bannerId2} in test hour {$counter}"); } $impressions = $aRequiredImpressions[0]['required_impressions']; $this->assertEqual($impressions, 1000, "Incorrectly requested {$impressions} impressions instead of 1000 in test hour {$counter}"); // Insert the required impressions for the banner into the // data_intermediate_ad table, as if the delivery has occurred, // so that the next hour's test is based on delivery having happened $aDates = OX_OperationInterval::convertDateToOperationIntervalStartAndEndDates($oNowDate); $operationIntervalId = OX_OperationInterval::convertDateToOperationIntervalID($oNowDate); $doData_intermediate_ad = OA_Dal::factoryDO('data_intermediate_ad'); $doData_intermediate_ad->day = $aDates['start']->format('%Y-%m-%d'); $doData_intermediate_ad->hour = $aDates['start']->format('%H'); $doData_intermediate_ad->operation_interval = $aConf['maintenance']['operationInteval']; $doData_intermediate_ad->operation_interval_id = $operationIntervalId; $doData_intermediate_ad->interval_start = $aDates['start']->format('%Y-%m-%d %H:%M:%S'); $doData_intermediate_ad->interval_end = $aDates['end']->format('%Y-%m-%d %H:%M:%S'); $doData_intermediate_ad->ad_id = $bannerId; $doData_intermediate_ad->zone_id = $zoneId; $doData_intermediate_ad->requests = $impressions; $doData_intermediate_ad->impressions = $impressions; $doData_intermediate_ad->clicks = 0; $doData_intermediate_ad->conversions = 0; DataGenerator::generateOne($doData_intermediate_ad); // Drop the temporary table that is used to store the // required impressions, so that it does not interfer // with the next test run in the loop unset($GLOBALS['_OA']['DB_TABLES']['tmp_ad_required_impression']); $oTable =& OA_DB_Table_Priority::singleton(); foreach ($oTable->aDefinition['tables'] as $tableName => $aTable) { $oTable->truncateTable($tableName); $oTable->dropTable($tableName); } } }
public function _generateData($priority) { $oDbh =& OA_DB::singleton(); // Create the required temporary table for the tests $oTable =& OA_DB_Table_Priority::singleton(); $oTable->createTable('tmp_ad_zone_impression'); // set up agencies, affiliates and zones $idClient1 = DataGenerator::generateOne('clients', true); $agencyId1 = DataGenerator::getReferenceId('agency'); $idClient2 = DataGenerator::generateOne('clients', true); $agencyId2 = DataGenerator::getReferenceId('agency'); $idClient3 = DataGenerator::generateOne('clients', true); $agencyId3 = DataGenerator::getReferenceId('agency'); // Add affiliates (websites) $doAffiliates = OA_Dal::factoryDO('affiliates'); $doAffiliates->agencyid = $agencyId1; $affiliateId1 = DataGenerator::generateOne($doAffiliates); $doAffiliates = OA_Dal::factoryDO('affiliates'); $doAffiliates->agencyid = $agencyId3; $affiliateId2 = DataGenerator::generateOne($doAffiliates); $doZones = OA_Dal::factoryDO('zones'); $doZones->description = 'Test zone'; $doZones->affiliateid = $affiliateId1; $this->idZone1 = DataGenerator::generateOne($doZones); $doZones = OA_Dal::factoryDO('zones'); $doZones->description = 'Test zone'; $doZones->affiliateid = $affiliateId2; $idZone2 = DataGenerator::generateOne($doZones); $doCampaigns = OA_Dal::factoryDO('campaigns'); $doCampaigns->clientid = $idClient1; $doCampaigns->priority = --$priority; $doCampaigns->ecpm_enabled = 1; $idCampaign1 = DataGenerator::generateOne($doCampaigns); $doBanners = OA_Dal::factoryDO('banners'); $doBanners->campaignid = $idCampaign1; $idAd1 = DataGenerator::generateOne($doBanners); $doCampaigns = OA_Dal::factoryDO('campaigns'); $doCampaigns->clientid = $idClient1; $doCampaigns->priority = ++$priority; $doCampaigns->ecpm_enabled = 1; $idCampaign2 = DataGenerator::generateOne($doCampaigns); $doBanners = OA_Dal::factoryDO('banners'); $doBanners->campaignid = $idCampaign2; $idAd2 = DataGenerator::generateOne($doBanners); $doCampaigns = OA_Dal::factoryDO('campaigns'); $doCampaigns->clientid = $idClient1; $doCampaigns->priority = ++$priority; $doCampaigns->ecpm_enabled = 1; $idCampaign3 = DataGenerator::generateOne($doCampaigns); $doBanners = OA_Dal::factoryDO('banners'); $doBanners->campaignid = $idCampaign3; $idAd3 = DataGenerator::generateOne($doBanners); $query = "\n INSERT INTO\n tmp_ad_zone_impression\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions,\n to_be_delivered\n )\n VALUES\n (\n 1,\n {$idZone2},\n 2,\n 3,\n 1\n )"; $rows = $oDbh->exec($query); $query = "\n INSERT INTO\n tmp_ad_zone_impression\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions,\n to_be_delivered\n )\n VALUES\n (\n {$idAd1},\n {$this->idZone1},\n 1,\n 5,\n 1\n )"; $rows = $oDbh->exec($query); $query = "\n INSERT INTO\n tmp_ad_zone_impression\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions,\n to_be_delivered\n )\n VALUES\n (\n {$idAd2},\n {$this->idZone1},\n 2,\n 5,\n 1\n )"; $rows = $oDbh->exec($query); $query = "\n INSERT INTO\n tmp_ad_zone_impression\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions,\n to_be_delivered\n )\n VALUES\n (\n {$idAd3},\n {$this->idZone1},\n 5,\n 5,\n 1\n )"; $rows = $oDbh->exec($query); $query = "\n INSERT INTO\n tmp_ad_zone_impression\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions,\n to_be_delivered\n )\n VALUES\n (\n 2,\n {$this->idZone1},\n 6,\n 7,\n 0\n )"; $rows = $oDbh->exec($query); return array($agencyId1, $agencyId2); }
function _testBatchInsert($method) { $oTable =& OA_DB_Table_Priority::singleton(); $oTable->createTable('tmp_ad_required_impression'); $this->assertEqual(array(), $this->_getbatchInsertRecords()); $aData = array(array('ad_id' => '23', 'required_impressions' => '140'), array('ad_id' => '29', 'required_impressions' => '120')); $result = OA_Dal::$method('tmp_ad_required_impression', array('ad_id', 'required_impressions'), $aData); $this->assertEqual($result, 2); $result = $this->_getbatchInsertRecords(); $this->assertTrue(count($result) == 2); $this->assertEqual($result, $aData); $oneMoreRow = array(array(100, 2)); $result = OA_Dal::$method('tmp_ad_required_impression', array('ad_id', 'required_impressions'), $oneMoreRow); $this->assertEqual($result, 1); $result = $this->_getbatchInsertRecords(); $this->assertTrue(count($result) == 3); $this->assertEqual($result, array_merge($aData, array(array('ad_id' => 100, 'required_impressions' => 2)))); TestEnv::dropTempTables(); }
static function dropTempTables() { $oDbh =& OA_DB::singleton(); // Truncate & drop all existing temporary tables $oTable =& OA_DB_Table_Priority::singleton(); foreach ($oTable->aDefinition['tables'] as $tableName => $aTable) { if ($oTable->existsTemporaryTable($tableName)) { $oTable->truncateTable($tableName); $oTable->dropTable($tableName); } } $oTable =& OA_DB_Table_Statistics::singleton(); foreach ($oTable->aDefinition['tables'] as $tableName => $aTable) { if ($oTable->existsTemporaryTable($tableName)) { $oTable->truncateTable($tableName); $oTable->dropTable($tableName); } } }