officelifehq/officelife

use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Http;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Artisan;
use Illuminate\Console\ConfirmableTrait;

class ResetDemo extends Command
{
    use ConfirmableTrait;

    protected $signature = 'demo:reset
                            {--force : Force the operation to run when in production.}';

    protected $description = 'Reset the demo env';

    public function handle(): void
    {
        if (! config('officelife.demo_mode')) {
            $this->line('This command is only available in demo mode.');
            return;
        }

        if ($this->confirmToProceed()) {
            try {
                Artisan::call('down');

                if (Cache::has('databasereset')) {
                    $sql = Cache::get('databasereset');
                } else {
                    $this->line('Downloading file...');
                    $file = Http::get('https://github.com/officelifehq/demosql/raw/main/officelife.sql');
                    $file->throw();

                    $sql = $file->body();
                    Cache::put('databasereset', $sql, 7200);
                }

                $this->line('Running transaction...');
                DB::unprepared($sql);

                $this->line('Running migration...');
                Artisan::call('migrate', ['--force' => true, '--verbose' => true]);
            } finally {
                Artisan::call('up');
            }

            $this->line('Database cleaned.');
        }
    }
}