kitloong / laravel-migrations-generator by kitloong

Generates Laravel Migrations from an existing database
3,265,177
2,208
43
Package Data
Maintainer Username: kitloong
Maintainer Contact: kitloong1008@gmail.com (Kit Loong)
Package Create Date: 2020-03-18
Package Last Update: 2024-03-05
Home Page:
Language: PHP
License: MIT
Last Refreshed: 2024-03-28 03:12:02
Package Statistics
Total Downloads: 3,265,177
Monthly Downloads: 146,786
Daily Downloads: 6,314
Total Stars: 2,208
Total Watchers: 43
Total Forks: 255
Total Open Issues: 2

Laravel Migrations Generator

Build Status Scrutinizer Code Quality Latest Stable Version License

Generate Laravel Migrations from an existing database, including indexes and foreign keys!

V4 Changes

  1. Major rewrite on FieldGenerator and IndexGenerator.
  2. Added spatial data type support such as geometry, point, etc.
  3. Support more Laravel migration types such as json, uuid, longText, year, etc
  4. Added spatialIndex support.
  5. timestamp and datetime support precision.
  6. Fixed MySQL tinyInteger and boolean issue.
  7. Able generate softDeletes, rememberToken, timestamps types.
  8. Support set for MySQL.
  9. It is now possible to generate nullable timestamp
  10. Removed unused classes.
  11. Fixed miscellaneous bugs.
  12. Added UT!
  13. More UT will be added to increase coverage.

This package is cloned from https://github.com/Xethron/migrations-generator and updated to support Laravel 6 and above.

Version Compatibility

|Laravel|Version| |---|---| |7.x|4.x| |6.x|4.x| |5.8.x|4.x| |5.7.x|4.x| |5.6.x|4.x| |5.5 and below|https://github.com/Xethron/migrations-generator|

Install

The recommended way to install this is through composer:

composer require --dev "kitloong/laravel-migrations-generator"

Laravel will automatically register service provider for you.

Lumen Setup

Auto discovery is not available in Lumen, you need some modification on bootstrap/app.php

Enable facade

Uncomment the following line

$app->withFacades();

Register provider

Add following line

$app->register(\KitLoong\MigrationsGenerator\MigrationsGeneratorServiceProvider::class);

Usage

To generate migrations from a database, you need to have your database setup in Laravel's Config.

Run php artisan migrate:generate to create migrations for all the tables, or you can specify the tables you wish to generate using php artisan migrate:generate table1,table2,table3,table4,table5. You can also ignore tables with --ignore="table3,table4,table5"

Laravel Migrations Generator will first generate all the tables, columns and indexes, and afterwards setup all the foreign key constraints. So make sure you include all the tables listed in the foreign keys so that they are present when the foreign keys are created.

You can also specify the connection name if you are not using your default connection with --connection="connection_name"

Run php artisan help migrate:generate for a list of options.

Thank You

Thanks to Bernhard Breytenbach for his great work. This package is cloned from https://github.com/Xethron/migrations-generator

Thanks to Jeffrey Way for his amazing Laravel-4-Generators package. This package depends greatly on his work.

Contributors

Kit Loong

Bernhard Breytenbach (@BBreyten)

License

The Laravel Migrations Generator is open-sourced software licensed under the MIT license