Download the PHP package lastdragon-ru/lara-asp-migrator without Composer
On this page you can find all versions of the php package lastdragon-ru/lara-asp-migrator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download lastdragon-ru/lara-asp-migrator
More information about lastdragon-ru/lara-asp-migrator
Files in lastdragon-ru/lara-asp-migrator
Package lara-asp-migrator
Short Description The Awesome Set of Packages for Laravel - The Migrator.
License MIT
Homepage https://github.com/LastDragon-ru/lara-asp
Informations about the package lara-asp-migrator
(Laravel) Raw SQL Migrator/Seeder
This package improves standard Laravel migrations to add support for raw SQL files during migration and seeding. So you can easily use your favorite visual tool for database development like MySQL Workbench with Laravel 🥳
[!IMPORTANT]
The Migrator uses the same mechanism as Squashing Migrations so not all databases are supported, please see Laravel Documentation for more details.
[include:artisan]: <lara-asp-documentator:requirements "{$directory}">
Requirements
Requirement | Constraint | Supported by |
---|---|---|
PHP | ^8.3 |
HEAD ⋯ 5.0.0 |
^8.2 |
HEAD ⋯ 2.0.0 |
|
^8.1 |
6.4.2 ⋯ 2.0.0 |
|
^8.0 |
4.6.0 ⋯ 2.0.0 |
|
^8.0.0 |
1.1.2 ⋯ 0.12.0 |
|
>=8.0.0 |
0.11.0 ⋯ 0.4.0 |
|
>=7.4.0 |
0.3.0 ⋯ 0.1.0 |
|
Laravel | ^11.0.0 |
HEAD ⋯ 6.2.0 |
^10.34.0 |
HEAD ⋯ 6.2.0 |
|
^10.0.0 |
6.1.0 ⋯ 2.1.0 |
|
^9.21.0 |
5.6.0 ⋯ 5.0.0-beta.1 |
|
^9.0.0 |
5.0.0-beta.0 ⋯ 0.12.0 |
|
^8.22.1 |
3.0.0 ⋯ 0.2.0 |
|
^8.0 |
0.1.0 |
Installation
Migrations
To create migration, just use the following command:
It will create the following files in database/migrations
:
Usually, you just need to put your SQL into *~up.sql
and *~down.sql
😇 Note that you still can use standard Laravel migrations. Also, migrations can be placed into subdirectories.
Seeders
The package uses a bit different approach compared with standard and provides a few different types of seeders:
Seeder
- unlike standardSeeder
it is safer and will not run seeder if it is already applied (so it is safe for production 🤩);SqlSeeder
- extendsSmartSeeder
and allow you to use SQL.
To create SQL Seeder you should use the command:
The command will create two files:
MySeeder.php
- The class can be used to customizeisSeeded()
method, e.g. you can check if a model exists in the database.MySeeder.sql
- the file where the SQL seed stored.
Upgrading
Please follow Upgrade Guide.
Contributing
This package is the part of Awesome Set of Packages for Laravel. Please use the main repository to report issues, send pull requests, or ask questions.
All versions of lara-asp-migrator with dependencies
ext-json Version *
ext-mbstring Version *
illuminate/conditionable Version ^10.34.0|^11.0.0
illuminate/console Version ^10.34.0|^11.0.0
illuminate/container Version ^10.34.0|^11.0.0
illuminate/contracts Version ^10.34.0|^11.0.0
illuminate/database Version ^10.34.0|^11.0.0
illuminate/filesystem Version ^10.34.0|^11.0.0
illuminate/support Version ^10.34.0|^11.0.0
lastdragon-ru/lara-asp-core Version self.version
symfony/console Version ^6.3.0|^7.0.0
symfony/finder Version ^6.3.0|^7.0.0
symfony/polyfill-php83 Version ^1.28