function testUserWatchesArea() { $this->addCountriesToTestDB(); $countryRepo = new CountryRepository(); $user = new UserAccountModel(); $user->setEmail("*****@*****.**"); $user->setUsername("test"); $user->setPassword("password"); $userTest = new UserAccountModel(); $userTest->setEmail("*****@*****.**"); $userTest->setUsername("testtest"); $userTest->setPassword("password"); $userRepo = new UserAccountRepository(); $userRepo->create($user); $userRepo->create($userTest); $site = new SiteModel(); $site->setTitle("Test"); $site->setSlug("test"); $siteRepo = new SiteRepository(); $siteRepo->create($site, $user, array(), $this->getSiteQuotaUsedForTesting()); $area = new \models\AreaModel(); $area->setTitle("Test"); $areaRepo = new \repositories\AreaRepository(); $areaRepo->create($area, null, $site, $countryRepo->loadByTwoCharCode('GB'), $user); // Test user doesn't have it $srb = new \repositories\builders\SiteRepositoryBuilder(); $srb->setUserInterestedIn($userTest); $sites = $srb->fetchAll(); $this->assertEquals(0, count($sites)); // watch area $userWatchesAreaRepo = new \repositories\UserWatchesAreaRepository(); $userWatchesAreaRepo->startUserWatchingArea($userTest, $area); // has it! $srb = new \repositories\builders\SiteRepositoryBuilder(); $srb->setUserInterestedIn($userTest); $sites = $srb->fetchAll(); $this->assertEquals(1, count($sites)); }
$areaMapItInfo = $areaMapItInfoRepo->getByCodeGSS($json_blob->codes->gss); if ($areaMapItInfo) { print " ... found area ID " . $areaMapItInfo->getAreaId() . "\n"; $areaMapItInfo->setName($json_blob->name); $areaMapItInfo->setCodeGss($json_blob->codes->gss); if (isset($json_blob->codes->unit_id)) { $areaMapItInfo->setCodeUnitId($json_blob->codes->unit_id); } $areaMapItInfo->setMapitId($json_blob->id); $areaMapItInfoRepo->edit($areaMapItInfo); } else { print " ... creating!\n"; if (!array_key_exists($json_blob->country_name, $parentAreas)) { die("No Parent Area: " . $json_blob->country_name . "\n"); } $area = new \models\AreaModel(); $area->setTitle($json_blob->name); $area->setCountryId($gb->getId()); $area->setSiteId($CONFIG->singleSiteID); $areaRepo->create($area, $parentAreas[$json_blob->country_name], $site, $gb, null); $areaMapItInfo = new \com\meetyournextmp\models\AreaMapItInfoModel(); $areaMapItInfo->setName($json_blob->name); $areaMapItInfo->setCodeGss($json_blob->codes->gss); if (isset($json_blob->codes->unit_id)) { $areaMapItInfo->setCodeUnitId($json_blob->codes->unit_id); } $areaMapItInfo->setMapitId($json_blob->id); $areaMapItInfo->setAreaId($area->getId()); $areaMapItInfoRepo->create($areaMapItInfo); } }
$site = $siteRepo->loadById($CONFIG->singleSiteID); configureAppForSite($site); for ($i = 1; $i <= 10; $i++) { // Get Human $stat = $DB->prepare("SELECT human_information.* FROM human_information " . " LEFT JOIN human_email ON human_email.human_id = human_information.id AND human_email.created_at > '2015-04-10 00:00:00'" . " JOIN human_in_area ON human_in_area.human_id = human_information.id " . " JOIN area_information ON area_information.id = human_in_area.area_id " . " WHERE human_information.is_deleted = '0' AND " . " human_information.email IS NOT NULL AND human_information.email != '' AND human_email.id IS NULL" . " LIMIT 1"); $stat->execute(); if ($stat->rowCount() == 0) { die("No Human Data"); } $human = new \com\meetyournextmp\models\HumanModel(); $human->setFromDataBaseRow($stat->fetch()); // Get Area $stat = $DB->prepare("SELECT area_information.* FROM area_information " . " JOIN human_in_area ON human_in_area.area_id = area_information.id AND human_in_area.human_id = :human_id"); $stat->execute(array('human_id' => $human->getId())); $stat->execute(); if ($stat->rowCount() == 0) { die("No Area Data"); } $area = new \models\AreaModel(); $area->setFromDataBaseRow($stat->fetch()); // make email $email = new \com\meetyournextmp\models\HumanEmailModel(); $email->setFromAppAndHumanAndArea($app, $human, $area); // save email $repo = new \com\meetyournextmp\repositories\HumanEmailRepository(); $repo->create($email); // send email $email->send($app); // record sent $repo->markSent($email); }
print "\n"; } } } } sleep(10); die; $countryRepo = new \repositories\CountryRepository(); $areaRepo = new \repositories\AreaRepository(); $gb = $countryRepo->loadByTwoCharCode("GB"); $siteRepo = new \repositories\SiteRepository(); $site = $siteRepo->loadById($CONFIG->singleSiteID); foreach ($parentAreas as $parentArea) { print "In: " . $parentArea->getTitle() . "\n\n"; if (isset($workToDo[$parentArea->getTitle()])) { foreach ($workToDo[$parentArea->getTitle()] as $newParentAreaTitle => $newParentAreaAreas) { if (count($newParentAreaAreas) > 1) { print "Make: " . $newParentAreaTitle . "\n"; $newParentAreaModel = new \models\AreaModel(); $newParentAreaModel->setTitle($newParentAreaTitle); $areaRepo->create($newParentAreaModel, $parentArea, $site, $gb); foreach ($newParentAreaAreas as $area) { print " - Area: " . $area->getTitle() . "\n"; $area->setParentAreaId($newParentAreaModel->getId()); $areaRepo->editParentArea($area); } print "\n"; } } } }
<?php define('APP_ROOT_DIR', __DIR__ . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR); require_once (defined('COMPOSER_ROOT_DIR') ? COMPOSER_ROOT_DIR : APP_ROOT_DIR) . '/vendor/autoload.php'; require_once APP_ROOT_DIR . '/core/php/autoload.php'; require_once APP_ROOT_DIR . '/core/php/autoloadCLI.php'; /** * * @package com.meetyournextmp * @license Closed Source * @copyright (c) 2013-2015, JMB Technology Limited, http://jmbtechnology.co.uk/ * @author James Baster <*****@*****.**> */ $stat = $DB->prepare("SELECT area_information.*, " . "area_mapit_information.mapit_id, area_mapit_information.code_unit_id, area_mapit_information.code_gss, area_mapit_information.name " . " FROM area_information JOIN area_mapit_information ON area_mapit_information.area_id = area_information.id"); $stat->execute(array()); $fp = fopen(__DIR__ . "/../../../webSingleSite/datadump/seats.csv", 'w'); if ($fp) { fputcsv($fp, array('name', 'mapit_id', 'code_unit_id', 'code_gss', "URL")); while ($data = $stat->fetch()) { $area = new \models\AreaModel(); $area->setFromDataBaseRow($data); fputcsv($fp, array($data['name'], $data['mapit_id'], $data['code_unit_id'], $data['code_gss'], "http://" . $CONFIG->webSiteDomain . "/area/" . $area->getSlugForUrl())); } fclose($fp); } else { die("OH NO"); }
print "Actually SEND: " . ($actuallySEND ? "YES" : "nah") . "\n"; if (!$actuallySEND) { die("DIE\n"); } // setup $siteRepo = new \repositories\SiteRepository(); $site = $siteRepo->loadById($CONFIG->singleSiteID); configureAppForSite($site); $innerSQL = "SELECT human_in_area.area_id, COUNT(human_tweet.id) As tweets FROM human_in_area " . " LEFT JOIN human_tweet ON human_tweet.human_id = human_in_area.human_id AND human_in_area.removed_at IS NULL " . "GROUP BY human_in_area.area_id"; // Get area $stat = $DB->prepare("SELECT area_information.* FROM area_information " . " JOIN area_mapit_information ON area_mapit_information.area_id = area_information.id " . " JOIN (" . $innerSQL . ") AS area_tweets ON area_tweets.area_id = area_information.id " . " WHERE area_tweets.tweets = 0 AND area_information.is_deleted = '0' AND area_information.cached_future_events > " . EVENTS_NEEDED_IN_AREA . " ORDER BY area_information.cached_future_events DESC LIMIT 1 "); $stat->execute(); if ($stat->rowCount() == 0) { die("No AREA Data"); } $area = new \models\AreaModel(); $area->setFromDataBaseRow($stat->fetch()); $areaURL = "http://" . $CONFIG->webSiteDomain . "/area/" . $area->getSlugForUrl(); print "Found Area " . $area->getTitle() . "\n"; $erb = new \com\meetyournextmp\repositories\builders\EventRepositoryBuilder(); $erb->setAfterNow(); $erb->setArea($area); $erb->setIncludeCancelled(false); $erb->setIncludeDeleted(false); $events = $erb->fetchCount(); if ($events < EVENTS_NEEDED_IN_AREA) { die("We checked and found less than " . EVENTS_NEEDED_IN_AREA . " events; is cache broken!"); } $hrb = new \com\meetyournextmp\repositories\builders\HumanRepositoryBuilder(); $hrb->setIncludeDeleted(false); $hrb->setArea($area);
function testParentChildSearches() { $this->addCountriesToTestDB(); TimeSource::mock(2014, 5, 1, 7, 0, 0); $user = new UserAccountModel(); $user->setEmail("*****@*****.**"); $user->setUsername("test"); $user->setPassword("password"); $userRepo = new UserAccountRepository(); $userRepo->create($user); $site = new SiteModel(); $site->setTitle("Test"); $site->setSlug("test"); $siteRepo = new SiteRepository(); $siteRepo->create($site, $user, array(), $this->getSiteQuotaUsedForTesting()); $countryRepo = new \repositories\CountryRepository(); $gb = $countryRepo->loadByTwoCharCode("GB"); $areaParent = new \models\AreaModel(); $areaParent->setTitle("Parent"); $areaCentre = new \models\AreaModel(); $areaCentre->setTitle("Centre"); $areaChild = new \models\AreaModel(); $areaChild->setTitle("Child"); $areaRepo = new \repositories\AreaRepository(); $areaRepo->create($areaParent, null, $site, $gb); $areaRepo->create($areaCentre, $areaParent, $site, $gb); $areaRepo->create($areaChild, $areaCentre, $site, $gb); $areaRepo->buildCacheAreaHasParent($areaParent); $areaRepo->buildCacheAreaHasParent($areaCentre); $areaRepo->buildCacheAreaHasParent($areaChild); $commentParent = new \org\openacalendar\comments\models\AreaCommentModel(); $commentParent->setTitle("Parent"); $commentCentre = new \org\openacalendar\comments\models\AreaCommentModel(); $commentCentre->setTitle("Centre"); $commentChild = new \org\openacalendar\comments\models\AreaCommentModel(); $commentChild->setTitle("Child"); $areaCommentRepo = new \org\openacalendar\comments\repositories\AreaCommentRepository(); TimeSource::mock(2014, 5, 1, 7, 0, 0); $areaCommentRepo->create($commentParent, $areaParent, $user); TimeSource::mock(2014, 5, 1, 7, 0, 1); $areaCommentRepo->create($commentCentre, $areaCentre, $user); TimeSource::mock(2014, 5, 1, 7, 0, 2); $areaCommentRepo->create($commentChild, $areaChild, $user); ##################################### Test Centre $areaCommentRepoBuilder = new \org\openacalendar\comments\repositories\builders\AreaCommentRepositoryBuilder(); $areaCommentRepoBuilder->setArea($areaCentre, false, false); $areaComments = $areaCommentRepoBuilder->fetchAll(); $this->assertEquals(1, count($areaComments)); $this->assertEquals($commentCentre->getId(), $areaComments[0]->getId()); ##################################### Test Centre + Parents $areaCommentRepoBuilder = new \org\openacalendar\comments\repositories\builders\AreaCommentRepositoryBuilder(); $areaCommentRepoBuilder->setArea($areaCentre, true, false); $areaComments = $areaCommentRepoBuilder->fetchAll(); $this->assertEquals(2, count($areaComments)); $this->assertEquals($commentParent->getId(), $areaComments[0]->getId()); $this->assertEquals($commentCentre->getId(), $areaComments[1]->getId()); ##################################### Test Centre + Children $areaCommentRepoBuilder = new \org\openacalendar\comments\repositories\builders\AreaCommentRepositoryBuilder(); $areaCommentRepoBuilder->setArea($areaCentre, false, true); $areaComments = $areaCommentRepoBuilder->fetchAll(); $this->assertEquals(2, count($areaComments)); $this->assertEquals($commentCentre->getId(), $areaComments[0]->getId()); $this->assertEquals($commentChild->getId(), $areaComments[1]->getId()); ##################################### Test Centre + Parents + Children $areaCommentRepoBuilder = new \org\openacalendar\comments\repositories\builders\AreaCommentRepositoryBuilder(); $areaCommentRepoBuilder->setArea($areaCentre, true, true); $areaComments = $areaCommentRepoBuilder->fetchAll(); $this->assertEquals(3, count($areaComments)); $this->assertEquals($commentParent->getId(), $areaComments[0]->getId()); $this->assertEquals($commentCentre->getId(), $areaComments[1]->getId()); $this->assertEquals($commentChild->getId(), $areaComments[2]->getId()); ##################################### Test Child + Children $areaCommentRepoBuilder = new \org\openacalendar\comments\repositories\builders\AreaCommentRepositoryBuilder(); $areaCommentRepoBuilder->setArea($areaChild, false, true); $areaComments = $areaCommentRepoBuilder->fetchAll(); $this->assertEquals(1, count($areaComments)); $this->assertEquals($commentChild->getId(), $areaComments[0]->getId()); }
function testEventInNoAreaHumanInCentre() { $this->addCountriesToTestDB(); TimeSource::mock(2014, 5, 1, 7, 0, 0); $user = new UserAccountModel(); $user->setEmail("*****@*****.**"); $user->setUsername("test"); $user->setPassword("password"); $userWatching = new UserAccountModel(); $userWatching->setEmail("*****@*****.**"); $userWatching->setUsername("test1"); $userWatching->setPassword("password"); $userRepo = new UserAccountRepository(); $userRepo->create($user); $userRepo->create($userWatching); $site = new SiteModel(); $site->setTitle("Test"); $site->setSlug("test"); $siteRepo = new SiteRepository(); $siteRepo->create($site, $user, array(), $this->getSiteQuotaUsedForTesting()); $countryRepo = new \repositories\CountryRepository(); $gb = $countryRepo->loadByTwoCharCode("GB"); $areaParent = new \models\AreaModel(); $areaParent->setTitle("Parent"); $areaChild = new \models\AreaModel(); $areaChild->setTitle("Child"); $areaOtherChild = new \models\AreaModel(); $areaOtherChild->setTitle("Other Child"); $areaRepo = new \repositories\AreaRepository(); $areaRepo->create($areaParent, null, $site, $gb); $areaRepo->create($areaChild, $areaParent, $site, $gb); $areaRepo->create($areaOtherChild, $areaParent, $site, $gb); $areaRepo->buildCacheAreaHasParent($areaParent); $areaRepo->buildCacheAreaHasParent($areaChild); $areaRepo->buildCacheAreaHasParent($areaOtherChild); $event = new EventModel(); $event->setSummary("test"); $event->setDescription("test test"); $event->setStartAt($this->mktime(2014, 5, 10, 19, 0, 0, 'Europe/London')); $event->setEndAt($this->mktime(2014, 5, 10, 21, 0, 0, 'Europe/London')); $event->setUrl("http://www.info.com"); $event->setTicketUrl("http://www.tickets.com"); $eventRepository = new EventRepository(); $eventRepository->create($event, $site, $user); $human = new \com\meetyournextmp\models\HumanModel(); $human->setTitle("Bob"); $humanRepo = new \com\meetyournextmp\repositories\HumanRepository(); $humanRepo->create($human, $site, null); $humanRepo->addHumanToArea($human, $areaChild, null); $humanRepo->addHumanToEvent($human, $event, null); $userWatchesAreaRepo = new \repositories\UserWatchesAreaRepository(); //////////////////////////////// TEST ALL EVENTS $erb = new \repositories\builders\EventRepositoryBuilder(); $events = $erb->fetchAll(); $this->assertEquals(1, count($events)); $hrb = new \repositories\builders\HistoryRepositoryBuilder(); $hrb->setIncludeAreaHistory(false); $hrb->setIncludeEventHistory(true); $histories = $hrb->fetchAll(); $this->assertEquals(1, count($histories)); //////////////////////////////// TEST OTHER CHILD $erb = new \repositories\builders\EventRepositoryBuilder(); $erb->setArea($areaOtherChild); $events = $erb->fetchAll(); $this->assertEquals(0, count($events)); $hrb = new \repositories\builders\HistoryRepositoryBuilder(); $hrb->getHistoryRepositoryBuilderConfig()->setArea($areaOtherChild); $hrb->setIncludeAreaHistory(false); $hrb->setIncludeEventHistory(true); $histories = $hrb->fetchAll(); $this->assertEquals(0, count($histories)); //////////////////////////////// TEST CHILD $erb = new \repositories\builders\EventRepositoryBuilder(); $erb->setArea($areaChild); $events = $erb->fetchAll(); $this->assertEquals(1, count($events)); $hrb = new \repositories\builders\HistoryRepositoryBuilder(); $hrb->getHistoryRepositoryBuilderConfig()->setArea($areaChild); $hrb->setIncludeAreaHistory(false); $hrb->setIncludeEventHistory(true); $histories = $hrb->fetchAll(); $this->assertEquals(1, count($histories)); //////////////////////////////// TEST PARENT $erb = new \repositories\builders\EventRepositoryBuilder(); $erb->setArea($areaChild); $events = $erb->fetchAll(); $this->assertEquals(1, count($events)); $hrb = new \repositories\builders\HistoryRepositoryBuilder(); $hrb->getHistoryRepositoryBuilderConfig()->setArea($areaChild); $hrb->setIncludeAreaHistory(false); $hrb->setIncludeEventHistory(true); $histories = $hrb->fetchAll(); $this->assertEquals(1, count($histories)); //////////////////////////////// USER WATCHES NOTHING $erb = new \repositories\builders\EventRepositoryBuilder(); $erb->setUserAccount($userWatching, false, true, true, true); $events = $erb->fetchAll(); $this->assertEquals(0, count($events)); //////////////////////////////// USER WATCHES PARENT $userWatchesAreaRepo->startUserWatchingArea($userWatching, $areaParent); $erb = new \repositories\builders\EventRepositoryBuilder(); $erb->setUserAccount($userWatching, false, true, true, true); $events = $erb->fetchAll(); $this->assertEquals(1, count($events)); //////////////////////////////// USER WATCHES CHILD $userWatchesAreaRepo->stopUserWatchingArea($userWatching, $areaParent); $userWatchesAreaRepo->startUserWatchingArea($userWatching, $areaChild); $erb = new \repositories\builders\EventRepositoryBuilder(); $erb->setUserAccount($userWatching, false, true, true, true); $events = $erb->fetchAll(); $this->assertEquals(1, count($events)); }