osu-web / app / Console / Commands / BuildsUpdatePropagationHistory.php

<?php

// Copyright (c) ppy Pty Ltd <[e-mail]>. Licensed under the GNU Affero General Public License v3.0.
// See the LICENCE file in the repository root for full licence text.

namespace App\Console\Commands;

use App\Models\Build;
use App\Models\BuildPropagationHistory;
use Carbon\Carbon;
use DB;
use Illuminate\Console\Command;

class BuildsUpdatePropagationHistory extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'builds:update-propagation-history';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Updates the build propagation history based on current data.';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        DB::transaction(function () {
            $date = Carbon::now();

            $builds = Build::propagationHistory()
                ->whereIn('stream_id', $GLOBALS['cfg']['osu']['changelog']['update_streams'])
                ->get();

            foreach ($builds as $build) {
                BuildPropagationHistory::create([
                    'build_id' => $build->build_id,
                    'user_count' => $build->users,
                    'created_at' => $date,
                ]);
            }
        }, 3);
    }
}