Download the PHP package othyn/laravel-migrate-to-sql without Composer

Laravel: Migrate to SQL

Quickly convert and export all Laravel migrations into an SQL file, or to TTY, with options to prettify the output via a new handy artisan command that extends the default migrate command list.

Index

• Installation
• Usage
• Testing
• Todo
• Changelog

Installation

Via Composer, you can run a composer require which will grab the latest version of this repo via packagist. Although, for the time being you will need to first add the custom repo to load the patched version of doctrine/sql-formatter until the PR is merged:

If you want to have composer use your SSH key instead of an oauth token (like I do) when fetching the package, you can use the no-api key:

Then you can run composer require as normal:

Installation - This Package Version vs. PHP & Laravel Versions

The following table describes which version of this packagae you will require for the given PHP & Laravel version.

Usage

Outlined below are all of the explicit command options, detailing their usage:

Usage - Default behaviour

By default, the command will:

• Generate SQL for the up migrations
• Generate the SQL queries to disk, in the root of your project directory, base_path() in the name format migrations.{type}.{Y_m_d__His}.sql.
• Prettify the SQL output into structured queries

Usage - Output a specific type of migration

By type, I'm referring to both the up and down methods within a migration - in which those are your only two options here.

By default, the command will generate up migrations, but if you wish to generate down migrations, then you can my doing the following:

which will generate the down migrations to a file on disk, in the default directory specified above, in the following structure:

Usage - Output to a specific custom export path

If you wish for the command to export to a custom defined location, then pass it with the --exportPath option, for example:

which will generate the up migrations to ~/migrations.up.sql on disk, in the following structure:

Usage - Output without formatting or prettifying the query

If you wish for the command to export the queries without doing any sort of formatting or pretty-ing of them, then pass the --ugly option, for example:

which will generate the up migrations to a file on disk, in the default directory specified above, in the following structure:

Usage - Output to TTY instead of to disk

If you wish for the command to export the queries without storing them to disk and stead sending them to TTY, then pass the --tty option, for example (which will generate the up migrations):

Usage - Custom database connection

If you wish for the command to use a custom database connection, so that it can read the migration state from the provided database connection and only generate queries for migrations that have not been run, then pass it with the --connection option, for example:

which will generate the up migrations to ~/migrations.up.sql on disk, for the sqlite connection, only containing migrations not run against that connection, in the following structure:

Usage - Combining multiple options

Options can be combined with each other to get a more customised output, for example you could do this:

To generate only down migrations, against the sqlite connection, to TTY only and without any SQL formatting taking place.

Testing

There is a Docker container that is pre-built that contains an Alpine CLI release of PHP + PHPUnit + xdebug. This is setup to test the project and can be setup via the following:

This should trigger Docker Compose to build the image.

There are tests for all code written, in which can be run via:

In those tests, there are Feature tests for a production ready implementation of the package. There are also Unit tests for each class written for full coverage.

You can also easily open a shell in the testing container by using the command:

Todo

• Maybe this should be more Laravel-ified in its default behaviour, in that instead of it generating all migrations by default, it should instead generate for the current default database connection defined by the .env, leaving in the option to override this for just the command via the existing --connection option. Then adding a new --all option to trigger a null connection resolve to generate all the commands, which is currently the default implementation.
• Implement matrix testing for all supported Laravel versions. Or, perhaps instead branching versions so the paired version of the orchestra test framework can be appropriately used for the Laravel version that is being tested, instead of having a universal plugin. At which point it may be worth aligning the semver version of the project with the Laravel version for easy user reference.
• Currently I'm using my own forked version of doctrine/sql-formatter with a PR'd change. If or once this is merged, then the repositories key in composer.json can be removed, and the package updated to version 1.1.x.
• Wait for GitHub actions to formally introduce official support for dynamic code coverage badges, or implement something like this that can parse out from a phpunit coverage report. For now, its manual.

Changelog

Any and all project changes for releases should be documented below. Versioning follows the SEMVER standard.

Version 2.0.0

Custom DB connection support for generating partial, only non-migrated patch files.

The original v1.1.0 patch that this was should've triggered this major semver version bump due to the new composer version dependencies. This causing a breaking change to build dependencies in environments accepting the original minor version upgrade, apologies for any inconvenience caused.

Added

• Packagist link now added in the installation part of the docs
• Binding the package version to a Laravel version for compatibility safety
• Binding the package version to a PHP version for compatibility safety
• Custom connection support for generating the migration patch files against, so you can generate only the required SQL statements into the patch file

Changed

• Nothing

Fixed

• When tests failed, they could leave fragments behind on disk that could pollute other tests
• Force composer to use "spatie/macroable": "^1.0" so that the dependency doesn't fall through for "php": "^7.4" as composer attempts to fullfill this by using "spatie/macroable": "^2.0" which is not required

Removed

• Nothing

Version 1.0.0

Initial release.

Added

• Everything

Changed

• Everything

Fixed

• Everything

Removed

• Everything