/**
* Performs the actual task of table population.
*/
public static function populate_cache_table($db, $table, $last_run_date)
{
$queries = kohana::config("cache_builder.{$table}");
try {
$count = cache_builder::get_changelist($db, $table, $queries, $last_run_date);
if ($count > 0) {
cache_builder::do_delete($db, $table, $queries);
// preprocess some of the tags in the queries
if (is_array($queries['update'])) {
foreach ($queries['update'] as $key => &$sql) {
$sql = str_replace('#join_needs_update#', $queries['join_needs_update'], $sql);
}
} else {
$queries['update'] = str_replace('#join_needs_update#', $queries['join_needs_update'], $queries['update']);
}
cache_builder::run_statement($db, $table, $queries['update'], 'update');
// preprocess some of the tags in the queries
if (is_array($queries['insert'])) {
foreach ($queries['insert'] as $key => &$sql) {
$sql = str_replace('#join_needs_update#', $queries['join_needs_update'] . ' and (nu.deleted=false or nu.deleted is null)', $sql);
}
} else {
$queries['insert'] = str_replace('#join_needs_update#', $queries['join_needs_update'] . ' and (nu.deleted=false or nu.deleted is null)', $queries['insert']);
}
cache_builder::run_statement($db, $table, $queries['insert'], 'insert');
if (isset($queries['extra_multi_record_updates'])) {
cache_builder::run_statement($db, $table, $queries['extra_multi_record_updates'], 'final update');
}
if (!variable::get("populated-{$table}")) {
$cacheQuery = $db->query("select count(*) from cache_{$table}")->result_array(false);
if (isset($queries['count'])) {
$totalQuery = $db->query($queries['count'])->result_array(false);
} else {
$totalQuery = $db->query("select count(*) from {$table} where deleted='f'")->result_array(false);
}
$percent = round($cacheQuery[0]['count'] * 100 / $totalQuery[0]['count']);
echo "{$table} population in progress - {$percent}% done";
}
echo '<br/>';
}
$db->query("drop table needs_update_{$table}");
} catch (Exception $e) {
error::log_error('Building cache', $e);
echo $e->getMessage();
$db->query("drop table needs_update_{$table}");
}
}
