pagemachine/typo3-phinx

Phinx integration for TYPO3

1.1.11 2023-09-26 09:57 UTC

Requires

• php: ^7.4 || ^8.0
• robmorgan/phinx: >= 0.11.0 < 1.0
• typo3/cms-core: ^10.4 || ^11.5 || ^12.4

Requires (Dev)

• cakephp/cakephp-codesniffer: ^5.0
• ergebnis/composer-normalize: ^2.3
• php-parallel-lint/php-console-highlighter: ^1.0.0
• php-parallel-lint/php-parallel-lint: ^1.2
• phpstan/phpstan: ^1.0.0
• saschaegerer/phpstan-typo3: ^1.0.0
• slevomat/coding-standard: ^8.0
• squizlabs/php_codesniffer: ^3.1

GPL-3.0-or-later

• Mathias Brodala

README

This package provides a integration of the Phinx database migration tool for TYPO3.

All Phinx commands have been wrapped as phinx:<command> and can be executed using the TYPO3 CLI or TYPO3 Console:

# Create a new migration
typo3cms phinx:create

# Migrate the database
typo3cms phinx:migrate

# Rollback the last or to a specific migration
typo3cms phinx:rollback

# Show migration status
typo3cms phinx:status

# Create a new database seeder
typo3cms phinx:seed:create

# Run database seeders
typo3cms phinx:seed:run

Notice that these wrapper commands are executed by TYPO3, thus the full API like DataHandler can be used in migrations.

Migrations

The following paths are used for migrations:

• vendor/*/*/Migrations/Phinx
• vendor/*/*/Classes/Migrations/Phinx

The following paths are used for TYPO3v11 and older:

• typo3conf/ext/*/Migrations/Phinx
• typo3conf/ext/*/Classes/Migrations/Phinx

Examples to create a migration in a TYPO3 project:

• typo3cms phinx:create --path packages/provider/Classes/Migrations/Phinx MyMigration

Note

If one Migrations directory exists already, you can omit --path. However, should multiple exist, you will receive a prompt and have to select the desired location.

Seeds

The following paths are used for seeds:

• vendor/*/*/Migrations/Phinx/Seeds
• vendor/*/*/Classes/Migrations/Phinx/Seeds

The following paths are used for TYPO3v11 and older:

• typo3conf/ext/*/Migrations/Phinx/Seeds
• typo3conf/ext/*/Classes/Migrations/Phinx/Seeds

Examples to create a seed in a TYPO3 project:

• typo3cms phinx:seed:create --path packages/provider/Classes/Migrations/Phinx/Seed MySeeder

Note

If one Migrations/Seed directory exists already, you can omit --path. However, should multiple exist, you will receive a prompt and have to select the desired location.

Testing

All tests can be executed with the shipped Docker Compose definition:

docker compose run --rm app composer build