Laravel 8中Firebase Storage文件条件删除策略与实践

use Kreait\Firebase\Storage;

/** @var Storage $storage */
$storage = app('firebase.storage');
$storage->getBucket()->object('temp/123.jpg')->delete();

// database/migrations/xxxx_xx_xx_create_firebase_files_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateFirebaseFilesTable extends Migration
{
    public function up()
    {
        Schema::create('firebase_files', function (Blueprint $table) {
            $table->id();
            $table->string('path')->unique()->comment('Firebase Storage中的完整文件路径');
            $table->timestamp('uploaded_at')->comment('文件上传时间');
            $table->string('directory')->index()->comment('文件所在的目录，方便查询');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('firebase_files');
    }
}

use Illuminate\Support\Facades\Storage as LaravelStorage;
use App\Models\FirebaseFile; // 假设你创建了FirebaseFile模型

// 示例：文件上传逻辑
public function uploadFile(UploadedFile $file, string $directory = 'temp')
{
    $fileName = time() . '_' . $file->getClientOriginalName();
    $filePath = $directory . '/' . $fileName;

    // 将文件上传到Firebase Storage
    $storage = app('firebase.storage');
    $bucket = $storage->getBucket();
    $object = $bucket->upload(fopen($file->getRealPath(), 'r'), [
        'name' => $filePath,
    ]);

    // 记录文件元数据到数据库
    FirebaseFile::create([
        'path' => $filePath,
        'uploaded_at' => now(),
        'directory' => $directory,
    ]);

    return $object->info();
}

php artisan make:command DeleteOldFirebaseFiles --command=firebase:delete-old-files

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use App\Models\FirebaseFile;
use Kreait\Firebase\Storage;
use Carbon\Carbon;

class DeleteOldFirebaseFiles extends Command
{
    protected $signature = 'firebase:delete-old-files {--days=30 : Files older than this many days will be deleted} {--directory=temp : The directory to clean up}';
    protected $description = 'Deletes old files from Firebase Storage based on metadata.';

    public function handle()
    {
        $days = (int) $this->option('days');
        $directory = $this->option('directory');
        $cutoffDate = Carbon::now()->subDays($days);

        $this->info("Starting Firebase Storage cleanup for directory '{$directory}' (files older than {$days} days)...");

        $filesToDelete = FirebaseFile::where('directory', $directory)
                                     ->where('uploaded_at', '<', $cutoffDate)
                                     ->get();

        if ($filesToDelete->isEmpty()) {
            $this->info("No files found to delete in '{$directory}' older than {$days} days.");
            return Command::SUCCESS;
        }

        /** @var Storage $storage */
        $storage = app('firebase.storage');
        $bucket = $storage->getBucket();
        $deletedCount = 0;

        foreach ($filesToDelete as $file) {
            try {
                $bucket->object($file->path)->delete();
                $file->delete(); // 从数据库中删除记录
                $deletedCount++;
                $this->line("Deleted: {$file->path}");
            } catch (\Exception $e) {
                $this->error("Failed to delete {$file->path}: " . $e->getMessage());
                // 考虑记录日志或重试机制
            }
        }

        $this->info("Cleanup complete. Total {$deletedCount} files deleted from Firebase Storage and database.");

        return Command::SUCCESS;
    }
}

// app/Console/Kernel.php
protected function schedule(Schedule $schedule)
{
    // 每天凌晨1点执行清理任务，删除temp目录下30天前的文件
    $schedule->command('firebase:delete-old-files --directory=temp --days=30')->dailyAt('01:00');
    // 你可以根据需要添加更多任务，例如清理images目录下60天前的文件
    // $schedule->command('firebase:delete-old-files --directory=images --days=60')->dailyAt('02:00');
}

* * * * * cd /path-to-your-project && php artisan schedule:run >> /dev/null 2>&1