Download the PHP package mtoolkit/mtoolkit-evolutions without Composer
On this page you can find all versions of the php package mtoolkit/mtoolkit-evolutions. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download mtoolkit/mtoolkit-evolutions
More information about mtoolkit/mtoolkit-evolutions
Files in mtoolkit/mtoolkit-evolutions
Package mtoolkit-evolutions
Short Description Agile way to manage the releases of your database.
License LGPL-3.0+
Informations about the package mtoolkit-evolutions
MToolkit - Evolution
Agile way to manage your database releases.
Why
In the agile world you have to deploy quickly the new implementations of the software. Tracking and managing the changes of the database is difficult and boring. MToolkit - Evolution tries to make this task easy. We have been inspired by Play Framework: https://www.playframework.com/documentation/2.0/Evolutions You can track the database evolutions in your project (in a dedicated folder) and you can apply them for the release.
How to use
In your project, create one or more (one per each environment) .ini file like this:
This file will be used to connect to the database where you apply or revert the evolutions.
In a folder put the evolutions files. The names of the files must be 1.sql, 2.sql, etc. The content of the files must be like this:
UP and DOWN placeholders are mandatory. The UP queries will execute when you apply the evolutions. The DOWN queries will execute when you revert the evolutions.
Init
To initializate the database and before applying new evolutions, run the command:
Apply evolutions
To apply the evolutions run:
Revert evolutions
To revert the evolutions run:
To revert to a specific evolution use "-to=" argument:
The "down" query "1" will be executed.
Create PHAR executable
MToolkit Evolution uses box-project to create the PHAR file.
To create the PHAR executable, run the following command in the root of the project:
Not supported
- Using DELIMITER in the evolutions file.