Package
Kitloong Laravel Migrations Generator
Generates Laravel Migrations from an existing database
Laravel Migrations Generator Summary
The Laravel Migrations Generator is a robust package designed to automatically generate migration files from an existing database, including the creation of indexes and foreign keys. This tool is crucial for developers looking to migrate databases seamlessly within the Laravel framework.
Key Features
- Database Support: Compatible with all major databases supported by Laravel, including MariaDB, MySQL, PostgreSQL, SQL Server, and SQLite.
- Version Compatibility: Fully supports Laravel versions from 5.6 and above.
- Customizable Migrations: Provides options to specify which tables to include or ignore during the migration generation process.
- Single File Option: Ability to squash all migrations into a single file for streamlined management.
- Extended Functionality: Supports generating views, stored procedures, and handling custom column types for certain databases.
Installation and Setup
Install via Composer:
composer require --dev kitloong/laravel-migrations-generatorFor Laravel
The package auto-registers the service provider.
For Lumen
Manual modifications are needed:
- Enable facades in
bootstrap/app.php. - Register the
MigrationsGeneratorServiceProvider.
Usage
Ensure your database configuration is set in config/database.php. Generate migrations with:
php artisan migrate:generateOptions include specifying tables to generate or ignore, setting the path for migration files, and more.
To generate a single migration file from multiple migrations, use:
php artisan migrate:generate --squashAdvanced Features
- SQLite Limitations: Handles SQLite's restrictions on altering foreign keys after table creation.
- User-Defined Custom Column Types: For PostgreSQL and SQL Server, allows custom data types and alters table schemas accordingly.
This package, building on the work by Bernhard Breytenbach, facilitates the easy generation of migration files, aiding developers in maintaining and versioning database structures efficiently.
