oxid-esales / oxideshop-doctrine-migration-wrapper
OXID eShop database migrations using doctrine
Requires
- php: >=8.2
- doctrine/migrations: ^3.0
- oxid-esales/oxideshop-facts: *
- symfony/console: *
Requires (Dev)
- ext-pdo: *
- mikey179/vfsstream: ^1.6
- oxid-esales/oxideshop-ce: *
- phpspec/prophecy-phpunit: ^v2.0
- phpunit/phpunit: ^10.4
- symfony/filesystem: *
- symfony/yaml: *
- dev-b-8.0.x
- v5.3.0
- v5.2.0
- v5.1.0
- v5.0.0
- v4.0.0
- v3.4.0
- v3.3.0
- v3.2.0
- v3.1.1
- v3.1.0
- v3.0.0
- v2.1.3
- v2.1.2
- v2.1.1
- v2.1.0
- v2.0.0
- v2.0.0-beta.7
- v2.0.0-beta.6
- v2.0.0-beta.5
- v2.0.0-beta.4
- v2.0.0-beta.3
- v2.0.0-beta.2
- v2.0.0-beta.1
- v2.0.0-alpha.3
- v2.0.0-alpha.2
- v2.0.0-alpha.1
- v1.0.0
- dev-b-8.0.x-remove-OXDEV-7790
- dev-b-7.3.x-update-phpunit-dependency-OXDEV-7947
- dev-b-7.2.x
- dev-b-7.3.x
- dev-b-8.0.x-no-config-inc-OXDEV-7248
- dev-b-7.1.x
- dev-b-7.0.x
- dev-b-7.0.x-github-action-refac-OXDEV-6832
- dev-b-6.5.x
- dev-b-7.0-enable_flags-OXDEV-4222
- dev-b-6.4.x
- dev-b-6.4.x-development_setup_to_readme
- dev-b-6.3.x
- dev-b-2.x
- dev-b-3.x
- dev-b-1.x
This package is auto-updated.
Last update: 2024-11-04 16:22:42 UTC
README
Description
OXID eShop uses database migrations for:
- eShop editions migration (CE, PE and EE)
- Project specific migrations
- Modules migrations
At the moment OXID eShop uses "Doctrine 2 Migrations" and it's integrated via OXID eShop migration components.
Doctrine Migrations runs migrations with a single configuration. But there was a need to run migration for one or all the projects and modules (CE, PE, EE, PR and a specific module). For this reason Doctrine Migration Wrapper was created.
Running migrations - CLI
Script to run migrations is installed within composer bin directory. It accepts two parameters:
- Doctrine Command
- Suite Type (CE, PE, EE, PR or a specific module_id)
vendor/bin/oe-eshop-db_migrate <Doctrine_Command> <Suite_Type>
To get comprehensive information about Doctrine 2 Migrations and available commands as well, please see official documentation.
Example:
vendor/bin/oe-eshop-db_migrate migrations:migrate
This command will run all the migrations which are in OXID eShop specific directories. For example if you have OXID eShop Enterprise edition, migration tool will run migrations in this order:
- Community Edition migrations (executed always)
- Professional Edition migrations (executed when eShop has PE or EE)
- Enterprise Edition migrations (executed when eShop has EE)
- Project specific migrations (executed always)
- Module migrations (executed when eShop has at least one module with migration)
Suite Types (Generate migration for a single suite)
It is also possible to run migrations for specific suite by defining <Suite_Type> parameter in the command. This variable defines what type of migration it is. There are 5 suite types:
- PR - For project specific migrations. It should be always used for project development.
- CE - Generates migration file for OXID eShop Community Edition. It's used for product development only.
- PE - Generates migration file for OXID eShop Professional Edition. It's used for product development only.
- EE - Generates migration file for OXID eShop Enterprise Edition. It's used for product development only.
- <module_id> - Generates migration file for OXID eShop specific module. It’s used for module development only.
Example 1:
vendor/bin/oe-eshop-db_migrate migrations:generate
This command generates migration versions for all the suite types.
Example 2:
vendor/bin/oe-eshop-db_migrate migrations:generate EE
In this case it will be generated only for Enterprise Edition in vendor/oxid-esales/oxideshop_ee/migration directory.
Use Migrations Wrapper without CLI
Doctrine Migration Wrapper is written in PHP and also could be used without command line interface. To do so:
- Create
Migrations
object withMigrationsBuilder->build()
- Call
execute
method with needed parameters
Installation
Development installation
Note
The following commands have to be executed in the php-container of your already installed eshop.
Register and update the migration wrapper repository with your branch in the composer.json of the eshop
composer config repositories.oxid-esales/oxideshop-doctrine-migration-wrapper git https://github.com/OXID-eSales/oxideshop-doctrine-migration-wrapper composer require oxid-esales/oxideshop-doctrine-migration-wrapper:dev-b-6.4.x
Setup ce-shop for wrapper
cd vendor/oxid-esales/oxideshop-doctrine-migration-wrapper/ git clone --branch=b-6.4.x https://github.com/OXID-eSales/oxideshop_ce.git source_ce composer config repositories.oxid-esales/oxideshop-ce path source_ce/ cd source_ce composer require --no-update oxid-esales/oxideshop-doctrine-migration-wrapper:* cd ..
Adjust cloned shop component requirements to fit our wrapper version and install wrapper development dependencies with
--no-plugins
composer require --dev --no-plugins oxid-esales/oxideshop-ce:*
cp tests/testData/source/config.inc.php.dist tests/testData/source/config.inc.php
Adjust MySQL credentials in the tests specific config.inc.php
to use an empty or non existing Database.
The config.inc.php
could look like this:
<?php /** * Copyright © OXID eSales AG. All rights reserved. * See LICENSE file for license details. */ // Database connection information $this->dbType = 'pdo_mysql'; $this->dbHost = 'mysql'; // database host name $this->dbPort = '3306'; // database port $this->dbName = 'example2'; // database name $this->dbUser = 'root'; // database user name $this->dbPwd = 'root'; // database user password
Now, while being in the wrapper directory, its possible to run the tests for wrapper
./vendor/bin/phpunit tests/
Note
Tests doesn't destroy your current shop installation if configured correctly (to use different database)!
Note
If you want to use the CLI in the eShop, you have to rename the vendor folder. Otherwise the CLI doesn't work.
Bugs and Issues
If you experience any bugs or issues, please report them in the section OXID eShop (all versions) of https://bugs.oxid-esales.com.