{"id":872,"date":"2025-06-12T01:40:06","date_gmt":"2025-06-11T17:40:06","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/php\/php-application-manual\/laravel\/872.html"},"modified":"2025-06-12T01:40:06","modified_gmt":"2025-06-11T17:40:06","slug":"eloquent%ef%bc%9a%e5%a6%82%e4%bd%95%e8%87%aa%e5%8a%a8%e5%88%a0%e9%99%a4n%e5%a4%a9%e5%90%8e%e7%9a%84%e6%97%a7%e8%ae%b0%e5%bd%95","status":"publish","type":"my1js","link":"https:\/\/www.zhaozhao123.cn\/php\/my1js\/872.html","title":{"rendered":"Eloquent\uff1a\u5982\u4f55\u81ea\u52a8\u5220\u9664N\u5929\u540e\u7684\u65e7\u8bb0\u5f55"},"content":{"rendered":"
\r\n
\r\n
\r\n
\r\n
\r\n
\"Bug编译狮\"<\/figure>\r\n\r\n\r\n\r\n

Bug编译狮<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n

Eloquent 是 Laravel 框架中的一个强大 ORM（对象关系映射），它简化了与数据库的交互。要实现自动删除 N 天后的旧记录，可以通过以下步骤来完成：<\/p>\n

    \n
  1. \n

    定义模型<\/strong>：\n首先，你需要创建一个 Eloquent 模型来代表你要操作的数据表。<\/p>\n

    \/\/ app\/Models\/Record.php\n\nnamespace AppModels;\n\nuse IlluminateDatabaseEloquentModel;\nuse CarbonCarbon;\n\nclass Record extends Model\n{\n   protected $fillable = ['name', 'created_at'];\n\n   public function deleteOldRecords($days)\n   {\n       $thresholdDate = Carbon::now()->subDays($days);\n       return $this->where('created_at', '<=', $thresholdDate)->delete();\n   }\n}<\/code><\/pre>\n<\/li>\n
  2. \n
    使用模型方法<\/strong>：\n在你的控制器或其他地方，你可以调用 deleteOldRecords<\/code> 方法来删除 N 天前的旧记录。<\/p>\n
    \/\/ app\/Http\/Controllers\/RecordController.php\n\nnamespace AppHttpControllers;\n\nuse AppModelsRecord;\nuse IlluminateHttpRequest;\n\nclass RecordController extends Controller\n{\n   public function deleteOldRecords(Request $request)\n   {\n       $days = $request->input('days');\n       if ($days) {\n           $result = Record::deleteOldRecords($days);\n           if ($result) {\n               return response()->json(['message' => 'Old records deleted successfully'], 200);\n           } else {\n               return response()->json(['error' => 'Failed to delete old records'], 500);\n           }\n       } else {\n           return response()->json(['error' => 'Missing days parameter'], 400);\n       }\n   }\n}<\/code><\/pre>\n<\/li>\n
  3. \n
    路由配置<\/strong>：\n确保你在路由文件中配置了相应的路由。<\/p>\n
    \/\/ routes\/web.php\n\nuse AppHttpControllersRecordController;\n\nRoute::post('\/delete-records', [RecordController::class, 'deleteOldRecords']);<\/code><\/pre>\n<\/li>\n
  4. \n
    示例请求<\/strong>：\n使用 Postman 或其他 HTTP 客户端发送 POST 请求到 \/delete-records<\/code> 路由，并传递 N 天数作为参数。<\/p>\n
    curl -X POST http:\/\/localhost:8000\/delete-records -H \"Content-Type: application\/json\" -d '{\"days\": 7}'<\/code><\/pre>\n<\/li>\n<\/ol>\n
    通过以上步骤，你就可以实现自动删除 N 天后的旧记录的功能。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \"黑板Bug讲师\"<\/figure>\r\n\r\n\r\n\r\n
    黑板Bug讲师<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    介绍<\/h2>
    在开发应用程序时，自动删除旧记录以保持数据库整洁是一项常见的需求。本教程将探讨如何使用Laravel的ORM（对象关系映射）和Eloquent设置一个自动删除机制，以便在一定天数后删除记录。<\/p>
    理解李奥普拉斯修剪<\/h2>
    Laravel的内置ORM称为eloquent，它提供了一个表示数据库表的eloquent模型。在Laravel 8.x及更高版本中引入了名为模型修剪的新特性，这有助于解决这种场景。<\/p>
    自动修剪：基础知识<\/h3>
    为了利用这一功能，您的模型需要使用它。IlluminateDatabaseEloquentPrunable<\/code>特性。这个特性提供了你需要覆盖的方法，以便定义记录何时被认为是过时并被清除。<\/p>
    namespace AppModels;\n\nuse IlluminateDatabaseEloquentModel;\nuse IlluminateDatabaseEloquentPrunable;\n\nclass YourModel extends Model\n{\n    use Prunable;\n\n    protected function pruning() {\n        return $this->where('created_at', '<=', now()->subDays(30));\n    }\n}\n<\/code><\/pre>
    例如，这里作为例子，pruning<\/code>方法定义为自动删除超过30天的记录。该方法使用了Carbon库。subDays<\/code>计算日期和时间的。where<\/code>过滤记录的条目声明。<\/p>
    设置定时修剪<\/h2>
    为了自动触发修剪过程，你需要在Laravel中设置一个调度器来运行这个过程。prune<\/code>命令。<\/p>
    \/\/ AppConsoleKernel.php\n\nprotected function schedule(Schedule $schedule)\n{\n    $schedule->command('model:prune', [\n        '--model' => [YourModel::class],\n    ])->daily();\n}\n<\/code><\/pre>
    这将安排修剪过程每天进行。但是，可以根据需要通过使用如调整频率等方法来修改此设置。hourly<\/code>好的，请发送你需要翻译的内容。weekly<\/code>等等。<\/p>
    自动化定时任务<\/h2>
    在定义了时间表后，请别忘了在服务器上设置任务调度器的cron条目以运行Laravel调度器。<\/p>
    * * * * * cd \/path-to-your-project && php artisan schedule:run >> \/dev\/null 2>&1\n<\/code><\/pre>
    它将运行。schedule:run<\/code>每分钟检查是否有任何预定命令到期。<\/p>
    高级修剪条件<\/h2>
    在基本用途之外，您可能需要扩展逻辑以处理更复杂的场景，例如软删除记录。根据您的应用程序逻辑，可以在查询内部进行细化调整。pruning<\/code>继续使用方法。<\/p>
    \/\/ If you're using SoftDeletes and want to prune soft deleted records...\nprotected function pruning() {\n    return $this->onlyTrashed()->where('deleted_at', '<=', now()->subDays(30));\n}\n<\/code><\/pre>
    手动触发修剪<\/h2>
    在开发或其他操作期间，手动启动过程也是必要的，因为虽然批量修剪可能高效，但您也可能需要手动执行此过程。<\/p>
    php artisan model:prune --model=AppModelsYourModel\n<\/code><\/pre>
    完成修剪后，您会看到确认信息。<\/p>
    处理修剪事件<\/h2>
    Laravel 在修剪之前和之后会触发事件：eloquent.prune: *your model class*<\/code>and 是中文中的“并且”的意思。eloquent.pruned: *your model class*<\/code>在您的应用程序中，您可以监听以下内容：<\/p>
    Event::listen('eloquent.prune: AppModelsYourModel', function ($model) {\n    \/\/ Do stuff before pruning\n});\nEvent::listen('eloquent.pruned: AppModelsYourModel', function ($model) {\n    \/\/ Do stuff after pruning\n});\n<\/code><\/pre>
    定制修剪逻辑<\/h2>
    也许你需要在修剪发生时采取其他行动或调整逻辑；你可以覆盖这些行为。pruneAll<\/code>方法来完全定制行为。<\/p>
    protected function pruneAll()\n{\n    \/\/ Your custom logic for pruning.\n}\n<\/code><\/pre>
    考虑修剪策略时应考虑以下因素：1. 环境条件，包括光照、湿度和温度等；2. 植物的生长习性；3. 预期的开花结果情况。<\/h2>
    在实施剪枝之前，考虑表的大小、剪枝频率以及业务逻辑，以确保应用的稳定性和性能不受影响。定期备份数据库，以防意外数据丢失。<\/p>
    结论。<\/h2>
    在本教程中，我们已经介绍了如何通过自动删除指定天数内不再需要的Eloquent记录来减少旧数据。定期修剪过时的信息可以节省数据库空间，降低存储成本，并通常提高性能。请确保在部署到生产环境之前，在非生产环境中彻底测试任何修剪策略，以确保其按预期工作。<\/p><\/body>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \"长工码奴1523\"<\/figure>\r\n\r\n\r\n\r\n
    长工码奴1523<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    为了实现自动删除指定日期后（假设为N天）的旧记录功能，我们可以使用Eloquent ORM结合MySQL数据库。以下是如何操作的一个例子：<\/p>\n
    首先，确保你已经安装了Eloquent和PHP，并且已将数据库连接到服务器上。<\/p>\n
      \n
    1. 首先创建一个模型类来存储数据：\n
      \n<?php<\/code><\/pre><\/li>\n<\/ol>\n
      use IlluminateDatabaseEloquentModel;<\/p>\n
      class Record extends Model\n{\nprotected $fillable = [‘content’, ‘timestamp’];<\/p>\n
      public function getTimestampAttribute($value)\n{\n    return new DateTime($value);\n}<\/code><\/pre>\n
      }<\/p>\n
      \n2. 然后创建一个迁移文件来定义表结构：\n```sql\n<?php\n\nuse IlluminateDatabaseMigrationsMigration;\nuse IlluminateDatabaseSchemaBlueprint;\nuse IlluminateSupportFacadesSchema;\n\nclass CreateRecordsTable extends Migration\n{\n    \/**\n     * Run the migrations.\n     *\n     * @return void\n     *\/\n    public function up()\n    {\n        Schema::create('records', function (Blueprint $table) {\n            $table->id();\n            $table->string('content');\n            $table->timestamps();\n        });\n    }\n\n    \/**\n     * Reverse the migrations.\n     *\n     * @return void\n     *\/\n    public function down()\n    {\n        Schema::dropIfExists('records');\n    }\n}<\/code><\/pre>\n
        \n
      1. 在控制器中创建一个新的方法来处理删除操作:\n
        \n<?php<\/code><\/pre><\/li>\n<\/ol>\n
        namespace AppHttpControllers;<\/p>\n
        use IlluminateHttpRequest;\nuse AppModelsRecord;<\/p>\n
        class RecordsController extends Controller\n{\npublic function deleteOld(Request $request, int $days)\n{\n$record = Record::whereDate(‘timestamp’, ‘<=’, date(“Y-m-d”, strtotime(“-$days days”)))->delete();<\/p>\n
            if ($record) {\n        return response()->json(['status' => 'success']);\n    } else {\n        return response()->json(['status' => 'error'], 500);\n    }\n}<\/code><\/pre>\n
        }<\/p>\n
        \n4. 最后，在应用中注册这个控制器:\n```php\n<?php\n\nnamespace AppHttpControllers;\n\nuse IlluminateHttpRequest;\nuse AppModelsRecord;\n\nclass RecordsController extends Controller\n{\n    public function __construct() {\n        $this->middleware('auth:api');\n    }\n\n    public function deleteOld(Request $request, int $days)\n    {\n        $record = Record::whereDate('timestamp', '<=', date(\"Y-m-d\", strtotime(\"-$days days\")))->delete();\n\n        if ($record) {\n            return response()->json(['status' => 'success']);\n        } else {\n            return response()->json(['status' => 'error'], 500);\n        }\n    }\n}<\/code><\/pre>\n
        以上代码演示了一个基本的自动删除功能，它会在特定日期之后删除所有与该日期相隔N天的数据。你可以根据需要调整逻辑和参数以满足你的需求。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
        Bug编译狮 Eloquent 是 Laravel 框架中的一个强大 ORM（对象关&#3199..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":false},"tags":[],"my1js2nav":[44],"tuisongtax":[],"class_list":["post-872","my1js","type-my1js","status-publish","hentry","my1js2nav-laravel"],"acf":{"qian_art_seotitle":"","qian_art_seotitle_source":{"label":"SEO\u6807\u9898","type":"text","formatted_value":""},"qian_art_seokws":"","qian_art_seokws_source":{"label":"SEO\u5173\u952e\u8bcd","type":"text","formatted_value":""},"qian_art_stzhong":"","qian_art_stzhong_source":{"label":"\u4e2d | \u77ed\u6807\u9898","type":"text","formatted_value":""}},"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js\/872","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/types\/my1js"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/media?parent=872"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tags?post=872"},{"taxonomy":"my1js2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js2nav?post=872"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tuisongtax?post=872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}