public static function updateViewCount(array $viewCount)
{
if (!$viewCount) {
return 0;
}
$query = 'update `clips` set `view_count` = case ';
foreach ($viewCount as $clip_id => $view_count) {
$query .= ' when `id` = ' . intval($clip_id) . ' then ' . intval($view_count);
}
unset($clip_id, $view_count);
$query .= ' end';
DB::query($query);
return DB::affectedRows();
}