# Truncate the current collections tables, and reset all collection id's
if (SpotCommandline::get('clean')) {
$dbConnection = $daoFactory->getConnection();
echo "Cleaning up all existing collections, ";
$dbConnection->rawExec('UPDATE spots SET collectionid = NULL WHERE collectionid IS NOT NULL');
$dbConnection->rawExec('TRUNCATE collections');
$dbConnection->rawExec('TRUNCATE mastercollections');
echo "done." . PHP_EOL;
}
// if
/* Load the complete collection cache in memory */
echo "Loading all existing collections in memory, ";
$daoFactory->getCollectionsDao()->loadCollectionCache(array());
echo "done" . PHP_EOL;
/* And start creating ocllections */
$svcCreateColl = new Services_Collections_Create($daoFactory);
$svcCreateColl->createCollections(0, 'displayProgress');
/*
* And actually start updating or creating the schema and settings
*/
echo "Done creating collections" . PHP_EOL;
} catch (Exception $x) {
echo PHP_EOL . PHP_EOL;
echo 'SpotWeb crashed' . PHP_EOL . PHP_EOL;
echo "Creation of collections failed:" . PHP_EOL;
echo " " . $x->getMessage() . PHP_EOL;
echo PHP_EOL . PHP_EOL;
echo $x->getTraceAsString();
die(1);
}
# catch
* Actually retrieve spots from the server
*/
$currentMaxSpotId = $spotDao->getMaxSpotId();
$retriever = new Services_Retriever_Spots($daoFactory, $settings, $forceMode, $retroMode);
$newSpotCount = $retriever->perform();
# Show the cumulative timings of the spotsretrieval
if ($showTiming) {
SpotTiming::displayCumul();
SpotTiming::clear();
}
# if
## Create collections, if enabled
if ($settings->get('create_collections')) {
echo "Creating collections starting from " . $currentMaxSpotId . ", ";
$svcPrvCreateColl = new Services_Collections_Create($daoFactory);
$svcPrvCreateColl->createCollections($currentMaxSpotId, null);
echo ", done" . PHP_EOL;
}
// if
## Creating filter counts
if ($newSpotCount > 0) {
$svcPrv_cacheSpotCount = new Services_Actions_CacheNewSpotCount($daoFactory->getUserFilterCountDao(), $daoFactory->getUserFilterDao(), $daoFactory->getSpotDao(), new Services_Search_QueryParser($daoFactory->getConnection()));
echo 'Calculating how many spots are new';
$notifyNewArray = $svcPrv_cacheSpotCount->cacheNewSpotCount();
echo ', done.' . PHP_EOL;
# Show the cumulative timings of the caching of these spots
if ($showTiming) {
SpotTiming::displayCumul();
SpotTiming::clear();
}
# if
