readerstacks/querymigration

Migrate custom raw query

1.1.5 2022-02-03 13:23 UTC

MIT

• readerstacks

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