Download the PHP package eniams/safe-migrations without Composer

Safe Migrations Bundle

⚠️ Warn you when your auto generated doctrine migrations contains unsafe SQL statements.

An unsafe migration is:

• An operation that have to be done carefully if you are doing zero downtime deployments.
• An operation on a critical table defined by yourself.
• An operation that can lock table such like NOT NULL CONSTRAINT or loss data such like remove or truncate.
• An operation that can be dangerous such like DROP or RENAME.
• An operation defined by yourself.

When an unsafe migration is detected, a warning is displayed in the command doctrine:migrations:diff and a comment is added into the migration file.

Unsafe statements list

• CREATE INDEX
• DROP
• MODIFY
• NOT NULL
• RENAME
• TRUNCATE

Any of these statement present in your last migration will trigger a warning, feel free to submit a PR to add more statements.

Features

• You can exclude a statement
• You can add your own statements
• You can flag a table as critical to be warned when a migration contains changes on these tables
• You decorate a statement to personalize the warning message

Getting started

Installation

You can easily install Safe Migrations Bundle by composer

Then, bundle should be registered. Just verify that config\bundles.php is containing :

Configuration

Then, you should register it in the configuration (config/packages/dev/safe_migrations.yaml) :

Exclude a statement

If you want to exclude a statement, you can do it by adding it in the configuration file.

Create your own statement

If you want to create a custom statement, you can do it by adding a new class that implements Eniams\SafeMigrationsBundle\Statement\StatementInterface.

Here is an example

Configure critical tables

If you want to flag a table as critical and be warned when a migration contains changes on it, just flag the tables like this:

Decorate a statement

If you want to wrap a statement to personalize the warning message or the logic to catch the statement you can use the decorator design pattern.

See the example bellow, you can also check how to decorate a service with Symfony.

Event Listener

When an unsafe migration is created, an event Eniams\SafeMigrationsBundle\Event\UnsafeMigrationEvent is dispatched, you can listen it and retrieve a UnsafeMigration with the migration name and the content of the migration file.

Example:

Debug the configuration

You can debug the configuration you set with the following command: $ bin/console eniams:debug-configuration

Contributing

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.

After writing your fix/feature, you can run following commands to make sure that everything is still ok.

Authors

• Smaïne Milianni - ismail1432 - smaine(dot)milianni@gmail(dot)com
• Quentin Dequippe - qdequippe - quentin@dequippe(dot)tech