readerstacks / querymigration
Migrate custom raw query
Installs: 1 998
Dependents: 0
Suggesters: 0
Security: 0
Stars: 1
Watchers: 1
Forks: 0
Open Issues: 0
README
Laravel Raw Sql Query Migration By readerstacks.com
Laravel Query Migration is a tool to migrate raw query in migration and keep track of them accross the servers.
For license information check the LICENSE-file.
Features
- Friendly raw query migrations
Installation
1 - Dependency
The first step is using composer to install the package and automatically update your composer.json
file, you can do this by running:
composer require readerstacks/querymigration
Note: If you are using Laravel 5.5, the steps 2 for providers and aliases, are unnecessaries. QieryMigrations supports Laravel new Package Discovery.
2 - Provider
You need to update your application configuration in order to register the package so it can be loaded by Laravel, just update your config/app.php
file adding the following code at the end of your 'providers'
section:
config/app.php
<?php return [ // ... 'providers' => [ Readerstacks\QueryMigration\QueryMigrationServiceProvider::class, // ... ], // ... ];
Lumen
Go to /bootstrap/app.php
file and add this line:
<?php // ... $app = new Laravel\Lumen\Application( dirname(__DIR__) ); // ... $app->register(Readerstacks\QueryMigration\QueryMigrationServiceProvider::class); // ... return $app;
3 Configuration
Publish config
In your terminal type
php artisan vendor:publish --provider="Readerstacks\QueryMigration\QueryMigrationServiceProvider"
Run Migration
In your terminal type
php artisan migrate
Usage
Laravel Usage
Add Query
php artisan QueryMigrate add --run
This will ask to enter the query to update the migration file and also run the query in database
If you want to update the migration and not wanted to run in database then remove --run option as below
php artisan QueryMigrate add
Check pending migrations
In your terminal type
php artisan QueryMigrate pending
Run migrations
In your terminal type
php artisan QueryMigrate migrate
List all migration
In your terminal type
php artisan QueryMigrate list
Remove all migration queries
In your terminal type
php artisan QueryMigrate removeAll
Remove single migration queries
In your terminal type
php artisan QueryMigrate remove --uid=id
Check pending migration queries
In your terminal type
php artisan QueryMigrate pedding
Run single migration only
In your terminal type
php artisan QueryMigrate migrate --uid=uid_of_migration
Run single migration again
In your terminal type
php artisan QueryMigrate migrate --uid=uid_of_migration --f