function testIntegration1()
 {
     $this->addCountriesToTestDB();
     \TimeSource::mock(2014, 1, 1, 12, 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 CountryRepository();
     $gb = $countryRepo->loadByTwoCharCode('GB');
     ## Create area
     \TimeSource::mock(2014, 1, 1, 13, 0, 0);
     $area = new AreaModel();
     $area->setTitle("test");
     $area->setDescription("test test");
     $area->setCountryId($gb->getId());
     $areaRepo = new AreaRepository();
     $areaRepo->create($area, null, $site, $gb, $user);
     ## Edit area
     \TimeSource::mock(2014, 1, 1, 14, 0, 0);
     $area = $areaRepo->loadById($area->getId());
     $area->setDescription("testy");
     $areaRepo->edit($area, $user);
     ## Now save changed flags on these .....
     $areaHistoryRepo = new AreaHistoryRepository();
     $stat = $this->app['db']->prepare("SELECT * FROM area_history");
     $stat->execute();
     while ($data = $stat->fetch()) {
         $areaHistory = new AreaHistoryModel();
         $areaHistory->setFromDataBaseRow($data);
         $areaHistoryRepo->ensureChangedFlagsAreSet($areaHistory);
     }
     ## Now load and check
     $historyRepo = new HistoryRepositoryBuilder();
     $historyRepo->setIncludeEventHistory(false);
     $historyRepo->setIncludeVenueHistory(false);
     $historyRepo->setIncludeGroupHistory(false);
     $historyRepo->setIncludeAreaHistory(true);
     $histories = $historyRepo->fetchAll();
     $this->assertEquals(2, count($histories));
     #the edit
     $this->assertEquals(FALSE, $histories[0]->getTitleChanged());
     $this->assertEquals(true, $histories[0]->getDescriptionChanged());
     $this->assertEquals(false, $histories[0]->getCountryIdChanged());
     $this->assertEquals(false, $histories[0]->getParentAreaIdChanged());
     $this->assertEquals(false, $histories[0]->getIsDeletedChanged());
     #the create
     $this->assertEquals(true, $histories[1]->getTitleChanged());
     $this->assertEquals(true, $histories[1]->getDescriptionChanged());
     $this->assertEquals(true, $histories[1]->getCountryIdChanged());
     $this->assertEquals(false, $histories[1]->getParentAreaIdChanged());
     $this->assertEquals(false, $histories[1]->getIsDeletedChanged());
 }
 protected function run()
 {
     $areaHistoryRepo = new AreaHistoryRepository();
     $stat = $this->app['db']->prepare("SELECT * FROM area_history");
     $stat->execute();
     $count = 0;
     while ($data = $stat->fetch()) {
         $areaHistory = new AreaHistoryModel();
         $areaHistory->setFromDataBaseRow($data);
         $areaHistoryRepo->ensureChangedFlagsAreSet($areaHistory);
         ++$count;
     }
     return array('result' => 'ok', 'count' => $count);
 }
 protected function makeSureHistoriesAreCorrect($contentsToSend)
 {
     $eventHistoryRepository = new EventHistoryRepository();
     $groupHistoryRepository = new GroupHistoryRepository();
     $areaHistoryRepository = new AreaHistoryRepository();
     $venueHistoryRepository = new VenueHistoryRepository();
     $importURLHistoryRepository = new ImportURLHistoryRepository();
     foreach ($contentsToSend as $contentToSend) {
         foreach ($contentToSend->getHistories() as $history) {
             $found = false;
             if ($history instanceof \models\EventHistoryModel) {
                 $eventHistoryRepository->ensureChangedFlagsAreSet($history);
                 $found = true;
             } elseif ($history instanceof \models\GroupHistoryModel) {
                 $groupHistoryRepository->ensureChangedFlagsAreSet($history);
                 $found = true;
             } elseif ($history instanceof \models\VenueHistoryModel) {
                 $venueHistoryRepository->ensureChangedFlagsAreSet($history);
                 $found = true;
             } elseif ($history instanceof \models\AreaHistoryModel) {
                 $areaHistoryRepository->ensureChangedFlagsAreSet($history);
                 $found = true;
             } elseif ($history instanceof \models\ImportURLHistoryModel) {
                 $importURLHistoryRepository->ensureChangedFlagsAreSet($history);
                 $found = true;
             }
             if (!$found) {
                 foreach ($this->app['extensions']->getExtensions() as $extension) {
                     $extension->makeSureHistoriesAreCorrect($history);
                 }
             }
         }
     }
 }