/**
* Hook into the task scheduler. This uses the queries defined in the cache_builder.php
* file to create and populate cache tables. The tables are not always up to date as they
* are only updated when the scheduler runs, but they have the advantage of simplifying
* the data model for reporting as well as reducing the need to join in queries, therefore
* significantly improving report performance.
* @param string $last_run_date Date last run, or null if never run
* @param object $db Database object.
*/
function cache_builder_scheduled_task($last_run_date, $db)
{
if (isset($_GET['force_cache_rebuild'])) {
$last_run_date = date('Y-m-d', time() - 60 * 60 * 24 * 365 * 200);
} elseif ($last_run_date === null) {
// first run, so get all records changed in last day. Query will automatically gradually pick up the rest.
$last_run_date = date('Y-m-d', time() - 60 * 60 * 24);
}
try {
foreach (kohana::config('cache_builder') as $table => $queries) {
cache_builder::populate_cache_table($db, $table, $last_run_date);
if (!variable::get("populated-{$table}")) {
// don't bother populating the next table, as there can be dependencies.
break;
}
}
} catch (Exception $e) {
echo $e->getMessage();
}
}
