kaliop/ezmigrationbundle

Kaliop eZ-Migration Bundle

Monday, July 23, 2018
by gggeek
Repository
6 Watchers
35 Stars
73,538 Installations

PHP
11 Dependents
0 Suggesters
39 Forks
38 Open issues
91 Versions
13 % Grown

The README.md

Kaliop eZ-Migration Bundle

This bundle makes it easy to programmatically deploy changes to eZPlatform / eZPublish 5 database structure and contents., _(*1)

It is inspired by the DoctrineMigrationsBundle, _(*2)

You can think of it as the grandson of the legacy ezxmlinstaller extension., _(*3)

Requirements

PHP 5.6 or later., _(*4)
eZPlatform 1, eZPlatform 2 or eZPublish Enterprise 5.4 or eZPublish Community 2014.11 or later., _(*5)

NB: for eZPlatform 3 and later, head on to https://github.com/tanoconsulting/ezmigrationbundle2, _(*6)

Installation

In either require or require-dev at the end of the bundle list in the composer.json file add:, _(*7)

"kaliop/ezmigrationbundle": "^6.0"

Save it and run, _(*8)

composer update --dev kaliop/ezmigrationbundle

This will install the bundle and all its dependencies., _(*9)

Please make sure that you have the bundle registered in the kernel as well. Check app/appKernel.php (for eZPublish ezpublish/EzPublishKernel.php), _(*10)

The registerBundles method should look similar to:, _(*11)

public function registerBundles()
{
    $bundles = array(
        ... more stuff here ...
        new \Kaliop\eZMigrationBundle\EzMigrationBundle()
    );
}

Checking that the bundle is installed correctly

If you run php bin/console (for eZPublish php ezpublish/console) you should see the following new commands in the list:, _(*12)

kaliop
  kaliop:migration:generate
  kaliop:migration:mass_migrate
  kaliop:migration:migrate
  kaliop:migration:migration
  kaliop:migration:resume
  kaliop:migration:status

This indicates that the bundle has been installed and registered correctly., _(*13)

Note: the command kaliop:migration:update is kept around for compatibility, and will be removed in future versions., _(*14)

Updating the bundle

To get the latest version, you can update the bundle to the latest available version by using composer, _(*15)

composer update kaliop/ezmigrationbundle

For upgrades from one major version to the following ones, see the instructions at the bottom of this readme., _(*16)

Getting started

All commands accept the standard Symfony/eZPublish 5 options, although some of them might not have any effect on the command's execution., _(*17)

Generating a new, empty migration definition file

The bundle provides a command to easily generate a new blank migration definition file, stored in a specific bundle., _(*18)

For example:, _(*19)

php bin/console kaliop:migration:generate --format=yml MyProjectBundle

The above command will place a new yml skeleton file in the MigrationVersions directory of the MyProjectBundle bundle., _(*20)

If the directory does not exist then the command will create it for you, as long as the bundle does exist and is registered. If the command is successful it will create a new yml file named with the following pattern: YYYYMMDDHHMMSS_placeholder.yml. You are encouraged to rename the file and change the placeholder part to something more meaningful, but please keep the timestamp part and underscore, as well as the extension., _(*21)

(the contents of the skeleton Yaml file are stored as twig template), _(*22)

Listing all migrations and their status

To see all the migrations definitions available in the system and whether they have been applied or not simply run the status command in your eZPublish 5 root directory:, _(*23)

php bin/console kaliop:migration:status

The list of migrations which have been already applied is stored in the database, in a table named kaliop_migrations. The bundle will automatically create the table if needed. In case you need to use a different name for that table, you can change the Symfony parameter ez_migration_bundle.table_name., _(*24)

Applying migrations

To apply all available migrations run the migrate command in your eZPublish 5 root directory:, _(*25)

 php bin/console kaliop:migration:migrate

NB: if you just executed the above command and got an error message because the migration definition file that you had just generated is invalid, do not worry - that is by design. Head on to the next paragraph..., _(*26)

NB: migrations execute by the default as the admin user with ID 14. Without this user account in the database, you must specify the use of another admin account by passing the -a flag., _(*27)

Applying a single migration file

To apply a single migration run the migrate command passing it the path to its definition, as follows:, _(*28)

php bin/console kaliop:migration:migrate --path=src/MyNamespace/MyBundle/MigrationVersions/20160803193400_a_migration.yml

NB: you can specify as well a folder with the --path flag, in which case all the migration definitions contained in that folder will be executed., _(*29)

Editing migration files

So far so good, but what kind of actions can be actually done using a migration?, _(*30)

Each migration definition consists of a series of steps, where each step defines an action., _(*31)

A simple example of a migration to create a 'folder' content is:, _(*32)

-
    mode: create
    type: content
    content_type: folder
    parent_location: 2
    attributes:
        name: hello world

In a Yaml migration, you can execute the following types of actions: - creation, update and deletion of Contents - creation, update and deletion of ContentTypes - creation, update and deletion of ContentTypeGroups - deletion of Content Versions - creation and deletion of Languages - creation, update and deletion of Locations - creation, update and deletion of ObjectStates - creation, update and deletion of ObjectStateGroups - creation, update and deletion of Roles - creation, update and deletion of Sections - creation and deletion of Tags (from the Netgen Tags Bundle) - creation and deletion of URL aliases and wildcards - creation, update and deletion of Users - creation, update and deletion of UserGroups - purging and recovering Contents from the Trash - creation, appending, copy, renaming and deletion of files - execution of SQL queries - execution of command-line scripts - execution of methods of Symfony services](Resources/doc/DSL/Services.yml) - execution of php functions and static methods - execution of http calls - sending of email - looping over arrays and executing one of the above actions on each element - canceling, snoozing or suspending the migration itself - generating and saving new migration definitions, _(*33)

More details on all supported migration-language features are in the DSL Language description, _(*34)

Custom migrations

For more specific needs, you can also use 2 other types of migrations: - SQL migrations - PHP migrations, _(*35)

SQL migrations

Example command to generate an SQL migration definition:, _(*36)

 php bin/console kaliop:migration:generate MyBundle create-new-table --format=sql

This will create the following file, which you are free to edit:, _(*37)

.../MyBundle/Migrations/2016XXYYHHMMSS_mysql_create-new-table.sql

NB if you rename the sql file, keep in mind that the type of database to which it is supposed to apply is the part of the filename between the first and second underscore characters. If you later try to execute that migration on an eZPublish installation running on, say, PostgreSQL, the migration will fail. You are of course free to create a specific SQL migration for a different database type., _(*38)

The Migration bundle itself imposes no limitations on the type of databases supported, but as it is based on the Doctrine DBAL, it will only work on the databases that Doctrine supports., _(*39)

NB you can also save the SQL statement to execute in a yml-formatted migration file. This gives you access to more options, such as setting and resolving references. Yml-formatted migration files do not need to have the db type in their name., _(*40)

NB if the SQL statement (or statements) in your migration is too long, the migration might fail or be only partially applied, in some cases (such as when using MySQL) without even reporting an error. If you need to execute multiple, long queries, you are better off splitting them, either in many .sql migrations, or in a single .yml migration with sql steps., _(*41)

PHP migrations

If the type of manipulation that you need to do is too complex for either YML or SQL, you can use a php class as migration definition. To generate a PHP migration definition, execute:, _(*42)

 php bin/console kaliop:migration:generate MyBundle AMigrationClass --format=php

This will create the following file, which you are free to edit:, _(*43)

.../MyBundle/Migrations/2016XXYYHHMMSS_AMigrationClass.php

As you can see in the generated definition, the php class to be used for a migration needs to implement a specific interface. The Symfony DIC container is passed to the migration class so that it can access from it all the services, parameters and other thing that it needs., _(*44)

For a more detailed example of a migration definition done in PHP, look in the MigrationVersions folder of this very bundle., _(*45)

NB if you rename the php file, keep in mind that the filename and the name of the class it contains are tied - the standard autoloading mechanism of the application does not apply when loading the migration definition. This is also the reason why the php classes used as migrations should not use namespaces., _(*46)

NB it is also possible to run any method of any existing Symfony service just by declaring it as migration step in a yaml migration. See the relevant DSL for details., _(*47)

NB it is also possible to run any existing php function or static class method just by declaring it as migration step in a yaml migration. See the relevant DSL for details., _(*48)

Re-executing failed migrations

The easiest way to re-execute a migration in 'failed' status, is to remove it from the migrations table:, _(*49)

php bin/console kaliop:migration:migration migration_name --delete

After removing the information about the migration from the migrations table, running the migrate command will execute it again., _(*50)

Usage of transactions / rolling back changes

By default the bundle runs each migration in a database transaction. This means that if a step fails, all the previous steps get rolled back, and the database is left in its original state. This is a safety feature built in by design; * if you prefer the migration steps to be executed in separate transactions the easiest way is to create a separate migration file for each step * you can use the command-line flag -u to disable usage of transactions by the migrate command, _(*51)

Note also that by default the migrate command stops on the 1st failed migration, but it can be executed with a flag to allow it to continue and execute all available migrations even in case of failures., _(*52)

As for rolling back changes: given the nature of the eZPublish API, rolling back changes to Content is not an easy feat. As such, the bundle does not provide built-in support for rolling back the database to the version it had before applying a given migration. We recommend always taking a database snapshot before applying migrations, and use it in case you need to roll back your changes. Another approach consists in writing a separate migration to undo the changes., _(*53)

Customizing the migration logic via Event Listeners

An easy way to hook up custom logic to the execution of migrations - without having to implement your own customized action executors - is to use Event Listeners., _(*54)

Two events are fired for each step during execution of migrations:, _(*55)

* ez_migration.before_execution => listeners receive a BeforeStepExecutionEvent event instance
* ez_migration.step_executed => listeners receive a StepExecutedEvent event instance

An event is fired only in case a migration fails because a step throws a specific migration abort exception:, _(*56)

* ez_migration.migration_aborted => listeners receive a MigrationAbortedEvent event instance

An event is fired when a migration is being generated using the kaliop:migration:generate command, allowing to alter the data that will be serialized as migration steps:, _(*57)

* ez_migration.migration_generated => listeners receive a MigrationGeneratedEvent event instance

In order to act on those events, you will need to declare tagged services, such as for ex:, _(*58)

my.step_executed_listener:
    class: my\helper\StepExecutedListener
    tags:
        - { name: kernel.event_listener, event: ez_migration.step_executed, method: onStepExecuted }

and the corresponding php class:, _(*59)

use Kaliop\eZMigrationBundle\API\Event\StepExecutedEvent;

class StepExecutedListener
{
    public function onStepExecuted(StepExecutedEvent $event)
    {
        // do something...
    }
}

Event Subscribers are supported as an alternative to Event Listeners, as is standard with Symfony projects., _(*60)

Known Issues and limitations

unlike the Doctrine Migrations Bundle, this bundle does not support rollback of changes. Read above for the reason why., _(*61)
if you are using the Doctrine Migrations Bundle to manage your schema, you will get spurious sql created to handle the database tables belonging to Kaliop Migrations Bundle. For the moment, the best work around is to use the filter-expression parameter on the command-line when running doctrine:migrations:diff and friends, with a value of kaliop_migrations_*, _(*62)
if you get fatal errors when running a migration stating that a node or object has not been found, it is most likely related to how the dual-kernel works in eZPublish, and the fact that the legacy and Symfony kernels use a separate connection to the database. Since the migration bundle by default wraps all database changes for a migration in a database transaction, when the Slots are fired which allow the legacy kernel to clear its caches, the legacy kernel cannot see the database changes applied by the Symfony kernel, and, depending on the specific Slot in use, might fail with a fatal error. The simplest workaround is to disable usage of transactions by passing the -u flag to the migrate command., _(*63)
similar symptoms can manifest themselves when you are using the Solr Search Engine Bundle. In this case the problem is compounded the fact that, even if a node or object is sent to Solr from within a database transaction, the Solr search index might be configured to only commit received data within a short time delay. A known workaround involve:, _(*64)
- separate your migration steps into separate migrations
- running the migrations each in its own transaction (and process) by using the -p flag to the migrate command
- adding sleep migration steps to migrations 2 .. N
- and/or configuring Solr to always commit changes to the index immediately (eg. disable commitwithin)
when using SOLR in multi-core configurations and getting a java.lang.NegativeArraySizeException error, you will have to set a lower value than the default 2147483647 for parameter ez_migration_bundle.query_limit, _(*65)
if you get fatal errors without any error message when running a migration which involves a lot of content changes, such as f.e. altering a contentType with many contents, it might be that you are running out of memory for your php process. Known workarounds involve:, _(*66)
- increase the maximum amount of memory allowed for the php script by running it with option '-d memory_limit=-1'
- execute the migration command using a Symfony environment which has reduced logging and kernel debug disabled: the default configuration for the dev environment is known to leak memory
- transform the migration, where possible, into one which loads and modifies contents one by one in a loop, instead of modifying them all in a single action. See an example of using loops here.
if you get fatal errors with the message 'You cannot create a service ("request") of an inactive scope ("request")', take a look at the following issue for a possible explanation and ideas for workarounds: https://jira.ez.no/browse/EZP-24691, _(*67)
if you are using eZPublish versions prior to 2015.9, you will not be able to create/update Role definitions that contain policies with limitations for custom modules/functions. The known workaround is to take over the RoleService and alter its constructor to inject into it the desired limitations, _(*68)
when updating a Role, you have to specify in the migration all the policies for it. Any existing policies that are not in the yml file will be removed. To make it easy to create a migration for updating a role, please use the migration:generate command using the --type=role flag, _(*69)
take care when creating content types: the eZPublish API, used internally by the migration bundle, will let you use dash characters in the content type identifiers, even if the resulting content types will then be unusable, eg., _(*70)

Example of an invalid definition:, _(*71)
```
    type: ezstring
    name: Topbar-hover-color
    identifier: topbar-hover-color
```
when eZ is set up in cluster mode, if you are setting references to the path of a content field of type ezimage, ezbinaryfile or ezmedia, or generating a migration for creating/updating it, the value you will get for the path will not be the absolute path on disk, but the path relative to the 'nfsvar' directory, which makes it unsuitable for being used directly in eg. a content/create migration. Check out the example in the Cookbook for how to deal with this., _(*72)

Frequently asked questions

How can I update a specific content which has a different Id on dev, test and prod environments?

A: use the 'reference/set' migration step to define a reference for the desired content Id, and use a Symfony parameter to store a different value for each Symfony environment. For example:, _(*73)

-
    type: reference
    mode: set
    identifier: content_id_ref
    value: '%a.parameter.name%'

-
    type: content
    mode: update
    match:
        content_id: "reference:content_id_ref"
    etc: ...

Note that there are many more solutions for this issue, sych as making sure your target Contents and Locations have the same Remote_id in all environments, or passing values for references as options to the migrate command-line., _(*74)

How to update an existing Role to change its policies?

When using a migration to update a Role, you must define ALL its policies. Any not defined will be removed. The safest and simplest way to make sure that you do not forget any of the existing policies is to first generate an update migration that has the complete specification of the role as it currently is defined, and then edit manually., _(*75)

Example command to create such a migration:, _(*76)

php bin/console kaliop:migration:generate --type=role --mode=update --match-type=identifier --match-value=Anonymous bundleName

When dumping a Content into a yml migration via the `generate` command, the list of attributes is empty

A: this is most likely due to using a bad language configuration, _(*77)

Are there examples of implementing common tasks which require complex migrations?

A: yes, please take a look in folder Resources/doc/Cookbook/, _(*78)

Can I run an external tool (command-line script) as part of a migration?

A: sure. Take a look at the relevant dsl and cookbook example for details., _(*79)

Extending the bundle

Supporting custom migrations

The bundle has been designed to be easily extended in many ways, such as: * adding support for custom/complex field-types * adding support for completely new actions in the Yml definitions * adding support for a new file format for storing migration definitions * adding support for new resolvers for the custom references in the migration definitions * taking over the way that the migrations definitions are loaded from the filesystem or stored in the database * etc..., _(*80)

Following Symfony best practices, for the first 4 options in the list above all you need to do is to create a service and give it an appropriate tag (the class implementing service should of course implement an appropriate interface)., _(*81)

To find out the names of the tags that you need to implement, as well as for all the other services which you can override, take a look at the services.yml file., _(*82)

It is also possible to define custom event listeners/subscribers to expand migration execution logic. See the dedicated paragraphs above for more details., _(*83)

Running tests

The bundle uses PHPUnit to run functional tests., _(*84)

Running tests in a working eZPublish / eZPlatform installation

To run the tests:, _(*85)

export KERNEL_DIR=app (or 'ezpublish' for ezpublish 5.4/cp setups)
export SYMFONY_ENV=behat (or whatever your environment is)

bin/phpunit --stderr -c vendor/kaliop/ezmigrationbundle/phpunit.xml.dist

NB the tests do not mock interaction with the database, but create/modify/delete many types of data in it. As such, there are good chances that running tests will leave stale/broken data. It is recommended to run the tests suite using a dedicated eZPublish installation or at least a dedicated database., _(*86)

Setting up a dedicated test environment for the bundle

A safer choice to run the tests of the bundle is to set up a dedicated environment, similar to the one used when the test suite is run on GitHub Actions. The advantages are multiple: on one hand you can start with any version of eZPublish you want; on the other you will be more confident that any tests you add or modify will also pass on GitHub. The disadvantages are that you will need Docker and Docker-compose, and that the environment you will use will look quite unlike a standard eZPublish setup! Also, it will take a considerable amount of disk space and time to build., _(*87)

Steps to set up a dedicated test environment and run the tests in it:, _(*88)

# if you have a github auth token, it is a good idea to copy it now to Tests/docker/data/.composer/auth.json
git clone --depth 1 --branch 0.4.0 https://github.com/tanoconsulting/euts.git teststack

# this config sets up a test environment with eZPlatform 2.5 running on php 7.4 / debian bullseye
export TESTSTACK_CONFIG_FILE=Tests/environment/.euts.2.5.env

./teststack/teststack build
./teststack/teststack runtests
./teststack/teststack.sh stop

You can also run a single test case:, _(*89)

./teststack/teststack runtests ./Tests/phpunit/01_CollectionsTest.php

Note: this will take some time the 1st time your run it, but it will be quicker on subsequent runs. Note: make sure to have enough disk space available., _(*90)

In case you want to run manually commands, such as the symfony console:, _(*91)

./teststack/teststack console cache:clear

Or easily get to a database shell prompt:, _(*92)

./teststack/teststack dbconsole

Or command-line shell prompt to the Docker container where tests are run:, _(*93)

./teststack/teststack shell

The tests in the Docker container run using the version of debian/php/eZPlatform kernel specified in the file Tests/environment/.euts.2.5.env, as specified in env var TESTSTACK_CONFIG_FILE. If no value is set for that environment variable, a file named .euts.env is looked for. If no such file is present, some defaults are used, you can check the documentation in ./teststack/README.md to find out what they are. If you want to test against a different version of eZ/php/debian, feel free to: - create the .euts.env file, if it does not exist - add to it any required var (see file teststack/.euts.env.example as guidance) - rebuild the test stack - run tests the usual way, _(*94)

You can even keep multiple test stacks available in parallel, by using different env files, eg: - create a file .euts.env.local and add to it any required env var, starting with a unique COMPOSE_PROJECT_NAME - build the new test stack via ./teststack/teststack. -e .euts.env.local build - run the tests via: ./teststack/teststack -e .euts.env.local runtests, _(*95)

Major version upgrades

Upgrading from version 5.x to version 6

Make sure you read carefully all the BC notes in the release notes, _(*96)

Run the migration named 20220101000200_FixExecutedMigrationsPaths.php, eg:, _(*97)

php bin/console kaliop:migration:migrate --path vendor/kaliop/ezmigrationbundle/MigrationVersions

Upgrading from version 4.x to version 5

Make sure you read carefully all the BC notes in the release notes, _(*98)
Nothing else is required, unless you have one of the following:, _(*99)
- code which extends the migration bundle code/apis
- old migrations, that you want to play again with the updated bundle, which have text values which include the string '[reference:xxx]' where 'xxx' stands for any sequence of characters
For both cases, the fix is to apply manual changes to your code / migrations., _(*100)

Upgrading from version 3.x to version 4

Make sure you read carefully all the BC notes in the release notes, _(*101)
Nothing else is required, unless you have one of the following:, _(*102)
- code which extends the migration bundle code/apis
- code which depends on parsing the output of the migrate command and relies on its exact format
For both cases, the fix is to apply manual changes to your code., _(*103)

Upgrading from version 2.x to version 3

Make sure you read carefully all the BC notes in the release notes, _(*104)
Nothing else is required, unless you have one of the following:, _(*105)
- migrations definitions generated using extension versions 1.x or 2.x, yet to be applied
- code which extends the migration bundle code/apis
For both cases, the fix is to apply manual changes to your code/migrations., _(*106)

Upgrading from version 1.x to version 2

Please read the dedicated documentation page, _(*107)

, _(*108)

, _(*109)

The Versions

23/07 2018

dev-master

9999999-dev

Kaliop eZ-Migration Bundle

symfony-bundle ezmigrationbundle