coolify/app/Livewire/SettingsBackup.php

<?php

namespace App\Livewire;

use App\Models\InstanceSettings;
use App\Models\S3Storage;
use App\Models\ScheduledDatabaseBackup;
use App\Models\Server;
use App\Models\StandaloneDocker;
use App\Models\StandalonePostgresql;
use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Livewire\Attributes\Locked;
use Livewire\Attributes\Validate;
use Livewire\Component;

class SettingsBackup extends Component
{
    use AuthorizesRequests;

    public InstanceSettings $settings;

    public Server $server;

    public ?StandalonePostgresql $database = null;

    public ScheduledDatabaseBackup|null|array $backup = [];

    #[Locked]
    public $s3s;

    #[Locked]
    public $executions = [];

    #[Validate(['required'])]
    public string $uuid;

    #[Validate(['required'])]
    public string $name;

    #[Validate(['nullable'])]
    public ?string $description = null;

    #[Validate(['required'])]
    public string $postgres_user;

    #[Validate(['required'])]
    public string $postgres_password;

    public function mount()
    {
        if (! isInstanceAdmin()) {
            return redirect()->route('dashboard');
        }
        $settings = instanceSettings();
        $this->server = Server::findOrFail(0);
        // The instance database is always id 0; a team database can also be named coolify-db.
        $this->database = StandalonePostgresql::find(0);
        $s3s = S3Storage::whereTeamId(0)->get() ?? [];
        if ($this->database) {
            $this->uuid = $this->database->uuid;
            $this->name = $this->database->name;
            $this->description = $this->database->description;
            $this->postgres_user = $this->database->postgres_user;
            $this->postgres_password = $this->database->postgres_password;

            if ($this->database->status !== 'running') {
                $this->database->status = 'running';
                $this->database->save();
            }
            $this->backup = $this->database->scheduledBackups->first();
            if ($this->backup && ! $this->server->isFunctional()) {
                $this->backup->enabled = false;
                $this->backup->save();
            }
            $this->executions = $this->backup?->executions ?? [];
        }
        $this->settings = $settings;
        $this->s3s = $s3s;
    }

    public function addCoolifyDatabase()
    {
        try {
            $this->authorize('update', $this->settings);
            $this->database = StandalonePostgresql::find(0);
            if (! $this->database) {
                $server = Server::findOrFail(0);
                $out = instant_remote_process(['docker inspect coolify-db'], $server);
                $envs = format_docker_envs_to_json($out);
                $this->database = new StandalonePostgresql;
                $this->database->forceFill([
                    'id' => 0,
                    'name' => 'coolify-db',
                    'description' => 'Coolify database',
                    'postgres_user' => $envs['POSTGRES_USER'],
                    'postgres_password' => $envs['POSTGRES_PASSWORD'],
                    'postgres_db' => $envs['POSTGRES_DB'],
                    'status' => 'running',
                    'destination_type' => StandaloneDocker::class,
                    'destination_id' => 0,
                ]);
                $this->database->save();
            }
            $this->backup = $this->database->scheduledBackups()->first()
                ?? ScheduledDatabaseBackup::create([
                    'enabled' => true,
                    'save_s3' => false,
                    'frequency' => '0 0 * * *',
                    'database_id' => $this->database->id,
                    'database_type' => StandalonePostgresql::class,
                    'team_id' => 0,
                ]);
            $this->database->refresh();
            $this->backup->refresh();
            if ($this->backup->wasRecentlyCreated) {
                auditLog('ui.database.backup_schedule_created', [
                    'team_id' => $this->backup->team_id,
                    'database_uuid' => $this->database->uuid,
                    'database_name' => $this->database->name,
                    'backup_uuid' => $this->backup->uuid,
                    'frequency' => $this->backup->frequency,
                    'save_s3' => (bool) $this->backup->save_s3,
                ]);
            }
            $this->s3s = S3Storage::whereTeamId(0)->get();

            $this->uuid = $this->database->uuid;
            $this->name = $this->database->name;
            $this->description = $this->database->description;
            $this->postgres_user = $this->database->postgres_user;
            $this->postgres_password = $this->database->postgres_password;
            $this->executions = $this->backup->executions;

        } catch (\Exception $e) {
            return handleError($e, $this);
        }
    }

    public function submit()
    {
        try {
            $this->authorize('update', $this->settings);
            $this->validate();

            $this->database->update([
                'name' => $this->name,
                'description' => $this->description,
                'postgres_user' => $this->postgres_user,
                'postgres_password' => $this->postgres_password,
            ]);
            $this->dispatch('success', 'Backup updated.');
        } catch (\Throwable $e) {
            return handleError($e, $this);
        }
    }
}