File "2021_06_03_154902_materialize_link_clicks.php"
Full Path: /home/markqprx/iniasli.pro/database/migrations/2021_06_03_154902_materialize_link_clicks.php
File size: 639 bytes
MIME-type: text/x-php
Charset: utf-8
<?php
use App\Models\Link;
use Illuminate\Database\Migrations\Migration;
class MaterializeLinkClicks extends Migration
{
public function up()
{
$cursor = DB::table('link_clicks')
->where('crawler', false)
->select(['link_clicks.link_id', DB::raw('count(*) as clicks_count')])
->groupBy('link_clicks.link_id')
->cursor();
foreach ($cursor as $linkClicks) {
Link::where('id', $linkClicks->link_id)->update([
'clicks_count' => $linkClicks->clicks_count,
]);
}
}
public function down()
{
//
}
}