大家在工作中是否都用数据迁移？

<?php

use Illuminate\Contracts\Config\Repository;
use Illuminate\Foundation\Testing\Concerns\InteractsWithViews;
use Illuminate\Foundation\Testing\RefreshDatabase;
use Sollado\Filesystem\FilesystemModel;
use Illuminate\View\Component;

class FilesystemAdapterTest extends \Orchestra\Testbench\TestCase
{

    use RefreshDatabase;
    protected $enablesPackageDiscoveries = true;


    public function testCanStoreStorehouse()
    {
        $filesystem = $this->storeStorehouse();
        $this->assertIsObject($filesystem);
        $this->assertEquals(\Sollado\Filesystem\FilesystemModel::class, get_class($filesystem));
    }

    public function testCanStoreFolder()
    {
        $storehouse = $this->getStorehouse();
        $filesystem = $this->storeFolder($storehouse);
        $this->assertIsObject($filesystem);
        $this->assertEquals(\Sollado\Filesystem\FilesystemModel::class, get_class($filesystem));
    }

    public function testCanStoreFile()
    {
        $storehouse = $this->getStorehouse();
        $folder = $this->getFolder($storehouse);
        $filesystem = $this->storeFile($folder);
        $this->assertIsObject($filesystem);
        $this->assertEquals(\Sollado\Filesystem\FilesystemModel::class, get_class($filesystem));
    }

    public function testCanResetFile()
    {
        $storehouse = $this->getStorehouse();
        $folder = $this->getFolder($storehouse);
        $file = $this->getFile($folder);
        $adapter = (new \Sollado\Filesystem\FilesystemManage())->disk(null);
        $filesystem = $adapter->resetFile($file, [
            'mime_type' => 'text/html',
            'size' => 3000,
            'path' => '/home/d.html',
            'disk' => 'minio'
        ]);
        $this->assertIsObject($filesystem);
        $this->assertEquals(\Sollado\Filesystem\FilesystemModel::class, get_class($filesystem));
        $this->assertEquals('text/html', $filesystem->mime_type);
        $this->assertEquals(3000, $filesystem->size);
        $this->assertEquals('/home/d.html', $filesystem->path);
        $this->assertEquals('minio', $filesystem->disk);
    }

    public function testCanCut()
    {
        $storehouse = $this->getStorehouse();
        $form = $this->getFolder($storehouse);
        $to = $this->getFolder($storehouse, [$form->id]);
        $filesystem = $this->getFile($form);
        $this->assertEquals(FilesystemModel::descendantsAndSelf($form->id)->toTree()->first()->children[0]->id, $filesystem->id);
        $this->assertEmpty(FilesystemModel::descendantsAndSelf($to->id)->toTree()->first()->children);
        $adapter = (new \Sollado\Filesystem\FilesystemManage())->disk(null);
        $adapter->cut($to, $filesystem);
        $this->assertEquals(FilesystemModel::descendantsAndSelf($to->id)->toTree()->first()->children[0]->id, $filesystem->id);
        $this->assertEmpty(FilesystemModel::descendantsAndSelf($form->id)->toTree()->first()->children);
        $adapter->cut($form, $filesystem);
    }

    public function testCanUploadFile()
    {
        $storehouse = $this->getStorehouse();
        $folder = $this->getFolder($storehouse);
        $file = $this->getFile($folder);
        $adapter = (new \Sollado\Filesystem\FilesystemManage())->disk(null);
        $testFile = __DIR__.'/bgm.mp3';
        if(is_file($testFile)) {
            $file = $adapter->uploadFile($file, $testFile)->refresh();
            $media = $file->getMedia('filesystem')->first();
            $this->assertIsObject($media);
            $this->assertEquals(Spatie\MediaLibrary\MediaCollections\Models\Media::class, get_class($media));
        }
    }
    public function testCanUploadDir()
    {
        $storehouse = $this->getStorehouse();
        $folder = $this->getFolder($storehouse);
        $file = $this->getFile($folder);
        $adapter = (new \Sollado\Filesystem\FilesystemManage())->disk(null);
        $testDir = __DIR__.'/bgm';
        if(is_dir($testDir)) {
            $file = $adapter->uploadDir($file, $testDir)->refresh();
            $media = $file->getMedia('filesystem')->first();
            $this->assertIsObject($media);
            $this->assertEquals(Spatie\MediaLibrary\MediaCollections\Models\Media::class, get_class($media));
        }
    }

    private function getFile($folder)
    {
        $file = FilesystemModel::where([
            ['type', '=',\Sollado\Filesystem\Enums\Type::File],
            ['parent_id', '=', $folder->id]
        ])->first();
        if(!$file){
            $file = $this->storeFile($folder);
        }
        return $file;
    }
    private function getFolder($storehouse, $exclude=[]){
        $query = FilesystemModel::where([
            ['type', '=', \Sollado\Filesystem\Enums\Type::Folder],
            ['parent_id', '=', $storehouse->id]
        ]);
        if($exclude){
            $query->whereNotIn('id', $exclude);
        }
        $folder = $query->first();
        if(!$folder){
            $folder = $this->storeFolder($storehouse);
        }
        return $folder;
    }
    private function getStorehouse(){
        $storehouse = FilesystemModel::where('type', \Sollado\Filesystem\Enums\Type::Storehouse)->first();
        if(!$storehouse){
            $storehouse = $this->storeStorehouse();
        }
        return $storehouse;
    }
    private function storeFile($folder)
    {
        $adapter = (new \Sollado\Filesystem\FilesystemManage())->disk(null);
        return $adapter->storeFile('测试文件', $folder, 'image/jpeg', 2000);
    }

    private function storeFolder($storehouse)
    {
        $adapter = (new \Sollado\Filesystem\FilesystemManage())->disk(null);
        return $adapter->storeFolder('测试文件夹', $storehouse);
    }

    /**
     * @return mixed
     */
    private function storeStorehouse(): mixed
    {
        $adapter = (new \Sollado\Filesystem\FilesystemManage())->disk(null);
        return $adapter->storeStorehouse('测试仓库');

    }


    protected function getPackageProviders($app)
    {
        return [
            \Sollado\Filesystem\FilesystemServiceProvider::class,
        ];
    }

    protected function defineEnvironment($app)
    {
        // Setup default database to use sqlite :memory:
        tap($app->make('config'), function (Repository $config) {
            $config->set('database.default', 'mysql');
            $config->set('database.connections.mysql', [
                'driver' => 'mysql',
                'host' => '',
                'port' => '3306',
                'database' => 'tests',
                'username' => '',
                'password' => '',
                'charset' => 'utf8mb4',
                'collation' => 'utf8mb4_unicode_ci',
                'prefix' => '',
                'prefix_indexes' => true,
                'strict' => true,
                'engine' => null,
                'options' => extension_loaded('pdo_mysql') ? array_filter([
                    PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
                ]) : [],
            ]);
        });
    }
}Copy