Thinkorm을 사용하여 데이터베이스 데이터를 보관하고 정리하는 방법

'demo' => [
    // 数据库类型
    'type'     => 'mysql',
    // 服务器地址
    'host'     => '127.0.0.1',
    // 数据库名
    'database' => 'demo',
    // 用户名
    'username' => 'root',
    // 密码
    'password' => '123456',
    // 端口
    'port'     => '3306',
    // 字符集
    'charset'  => 'utf8mb4',
    // 数据库表前缀
    'prefix'   => 'think_',
    // 其他配置项...
],

<?php

namespace appmodel;

use thinkModel;

class Order extends Model
{
    protected $connection = 'demo';
    protected $table = 'orders';
}

use appmodelOrder;

// 获取需要归档的订单数据
$archiveOrders = Order::where('created_at', '<', '2021-01-01')->select();

// 归档数据
foreach ($archiveOrders as $order) {
    // 执行归档操作，这里可以根据实际需求进行相应操作，例如将数据插入到归档表中
    // ...
    
    // 删除原始订单数据
    $order->delete();
}

use appmodelOrder;

// 获取需要清理的订单数据
$cleanupOrders = Order::where('created_at', '<', '2020-01-01')->select();

// 清理数据
foreach ($cleanupOrders as $order) {
    // 执行清理操作，这里可以根据实际需求进行相应操作，例如备份数据或者直接删除
    // ...
    
    // 删除原始订单数据
    $order->delete();
}

return [
    'archive_orders' => [
        'command' => 'php think archive:orders',
        'cron' => '0 0 * * *',
        'log' => true,
        'output' => '',
    ],
    'cleanup_orders' => [
        'command' => 'php think cleanup:orders',
        'cron' => '0 1 * * *',
        'log' => true,
        'output' => '',
    ],
];

php think make:command ArchiveOrders
php think make:command CleanupOrders

<?php

namespace appcommand;

use appmodelOrder;
use thinkconsoleCommand;
use thinkconsoleInput;
use thinkconsoleOutput;

class ArchiveOrders extends Command
{
    protected function configure()
    {
        $this->setName('archive:orders')->setDescription('Archive orders');
    }

    protected function execute(Input $input, Output $output)
    {
        $archiveOrders = Order::where('created_at', '<', '2021-01-01')->select();
        
        foreach ($archiveOrders as $order) {
            // 执行归档操作
            // ...
            
            // 删除原始订单数据
            $order->delete();
        }
        
        $output->writeln('Archive orders successfully.');
    }
}

<?php

namespace appcommand;

use appmodelOrder;
use thinkconsoleCommand;
use thinkconsoleInput;
use thinkconsoleOutput;

class CleanupOrders extends Command
{
    protected function configure()
    {
        $this->setName('cleanup:orders')->setDescription('Cleanup orders');
    }

    protected function execute(Input $input, Output $output)
    {
        $cleanupOrders = Order::where('created_at', '<', '2020-01-01')->select();
        
        foreach ($cleanupOrders as $order) {
            // 执行清理操作
            // ...
            
            // 删除原始订单数据
            $order->delete();
        }
        
        $output->writeln('Cleanup orders successfully.');
    }
}