Refresh Your Laravel Database Without Dropping Every Table

Laravel 内置的 migrate:fresh drops every table before re-running your migrations, which is exactly what you want until it isn't. If a table holds seed data you don't want to regenerate, or test accounts you'd rather not recreate after every change, the all-or-nothing behaviour gets in the way. 定制新鲜 , by 马哈茂德·拉马丹 , adds a fresh:custom command that rebuilds the database while preserving the tables you name.

# Choosing Which Tables Survive

Say you're building a subscription billing app and iterating on the schema all day, but you don't want to lose your test accounts or the seeded plans data on every refresh. You can name the tables to keep as a comma-separated argument or use the --keep flag. Both forms do the same thing:

php

工匠

fresh:custom

users,plans
php

工匠

fresh:custom

--keep=users,plans

Everything else is dropped, and the migrations run again, so the tables you list keep their rows while the rest of the schema is rebuilt from scratch.

# Glob Patterns for Grouped Tables

Cashier alone creates subscriptions 和 subscription_items , and listing each one by name gets tedious. Custom Fresh accepts glob patterns, so a trailing wildcard matches any table sharing a prefix:

php

工匠

fresh:custom

"users,plans,subscription_*"

# Previewing Before You Commit

Because this command is destructive, you can ask it to report what it would do without touching the database. The --explain flag prints the tables it would keep and drop:

php

工匠

fresh:custom

users,plans,subscription_
*

--explain

You can also point the command at a specific connection with --database , which is handy when some data lives in a separate database:

php

工匠

fresh:custom

monthly_revenue

--database=analytics

# Configuration and Events

Publishing the config file lets you set defaults instead of passing the same flags on every run. Tables in always_keep survive automatically, patterns applies your glob rules without spelling them out each time, and confirm_in lists the environments where the command pauses for a confirmation prompt before it drops anything:

返回
[

'always_keep'

=>
[
“用户”
,
'plans'
]，

“模式”

=>
[
'subscription_*'
]，

'confirm_in'

=>
[
“舞台”
,
'生产'
]，
]；

The command also dispatches three events during a run, which you can listen for to log activity or trigger follow-up work: RefreshingDatabase before any tables are dropped, TablesDropped after the removal step, and DatabaseRefreshed once the migrations finish.

# 安装

Install the package with Composer:

作曲家

要求

ramadan/custom-fresh

Custom Fresh requires PHP 8.2 or higher and supports Laravel 10 through 13. You can read the documentation and view the source on GitHub 。