library dbtruncate

kreshnik/dbtruncate

A laravel command that helps truncate mysql database tables

Laravel DBTruncate Command

Automatically truncates all mysql tables for you. Works also with tables that use relationships, by using the FOREIGN_KEY_CHECKS system variable., _(*1)

Installation

Begin by installing this package through Composer. Edit your project's composer.json file to require kreshnik/dbtruncate, _(*2)

Laravel 5.5

"require-dev": {
    "kreshnik/dbtruncate": "dev-master"
}

Laravel 5.4

"require-dev": {
    "kreshnik/dbtruncate": "5.4.x-dev"
}

Next, update Composer from the Terminal:, _(*3)

composer update

Once this operation completes, the final step is to add the service provider. Open config/app.php, and add a new item to the providers array., _(*4)

Kreshnik\Dbtruncate\DbtruncateServiceProvider::class

That's it! You're all set to go. Run the artisan command from the Terminal to see the new db:truncate command., _(*5)

php artisan

Commands

db:truncate will prompt you to confirm the truncation process, _(*6)

Options

db:truncate --tables=table1,table2 In case you want to truncate specific tables. You can specify a list of tables divided with a comma., _(*7)

db:truncate --exclude=table1,table2 A list of tables that will be excluded from the truncation process. The tables have to be divded with a comma., _(*8)