laravel 数据库迁移转 sql 语句

 php artisan migrate --pretend --no-ansi　　

<?php

namespace App\Console\Commands;

use Illuminate\Contracts\Bus\SelfHandling;

class MigrateToSql implements SelfHandling
{
    protected $signature = ‘migrate_to_sql‘;

    protected $description = ‘数据库迁移转 sql‘;

    /**
     * Execute the command.
     *
     * @return void
     */
    public function handle()
    {
        $command = PHP_BINARY . ‘ ‘ . base_path(‘artisan‘) . ‘ migrate --pretend --no-ansi‘;
        exec($command, $output);

        $sql = ‘‘;
        if (count($output) > 0) {
            foreach ($output as $line) {
                $sql .= preg_replace(‘/.*?:/‘, ‘‘, $line) . ";\n";
            }
        }

        $file = database_path(‘sqls/‘ . date(‘Y-m-d H:i:s‘) . ‘.sql‘);
        file_put_contents($file, $sql);
    }
}