genkgo / migrations
Installs: 18 614
Dependents: 0
Suggesters: 0
Security: 0
Stars: 8
Watchers: 4
Forks: 1
Open Issues: 0
Requires
- php: ~8.2.0 || ~8.3.0
- ext-pdo: *
Requires (Dev)
- friendsofphp/php-cs-fixer: ^3.0
- phpstan/phpstan: ^1.0
- phpunit/phpunit: ^9.5.26
README
Library to make migrations easy.
Installation
Requires PHP 8.0 or later. It is installable and autoloadable via Composer as genkgo/migrations.
Quality
To run the unit tests at the command line, issue vendor/bin/phpunit -c phpunit.xml
. PHPUnit is required.
This library attempts to comply with PSR-1, PSR-2, and PSR-4. If you notice compliance oversights, please send a patch via pull request.
Getting Started
Create a migration file
Create a migration file, define how to update and undo the changes in your application.
<?php use Genkgo\Migrations\AbstractMigration; class migration_2014_11_13_11_55 extends AbstractMigration { public function up() { // your changes here } public function down() { // undo changes here } }
Migrate
The adapter keeps the history of the already executed migrations. The current library comes with a MySQL and Sqlite adapter. To add a new adapter, create one yourself and issue a pull request. Set the adapter, create a new list (from a list of files in a directory) and execute.
<?php use PDO; use Genkgo\Migrations\Factory; use Genkgo\Migrations\Adapters\PdoSqliteAdapter; $adapter = new PdoSqliteAdapter(new PDO('sqlite::memory:')); $factory = new Factory($adapter); $directory = __DIR__.'/migrations'; $list = $this->factory->newListFromDirectory($directory); $result = $list->migrate();
Inject dependencies
You can inject your dependencies, e.g. some database abstraction layer like in the sample below.
<?php use PDO; use Genkgo\Migrations\Factory; use Genkgo\Migrations\Adapters\PdoSqliteAdapter; use Vendor\DatabaseAbstractLayer\SchemaGenerator; $adapter = new PdoSqliteAdapter(new PDO('sqlite::memory:')); $factory = new Factory($adapter, function ($classname) { return new $classname(new SchemaGenerator()); });
And then use it the migration file.
<?php use Genkgo\Migrations\AbstractMigration; use Vendor\DatabaseAbstractLayer\SchemaGenerator; class migration_2014_11_13_11_55 extends AbstractMigration { private $schema; public function __construct(SchemaGenerator $schema) { $this->schema = $schema; } public function up() { // your changes here } public function down() { // undo changes here } }
The example below uses auto resolution of Aura.Di.
<?php use PDO; use Genkgo\Migrations\Factory; use Genkgo\Migrations\Adapters\PdoSqliteAdapter; $adapter = new PdoSqliteAdapter(new PDO('sqlite::memory:')); $factory = new Factory($adapter, function ($classname) use ($di) { return $di->newInstance($classname); });
Multiple lists
You can have multiple migration lists, e.g. for each plugin one list. Just put the migration files in the right namespace. See example below.
<?php namespace Vendor\MyPlugin; use Genkgo\Migrations\AbstractMigration; class migration_2014_11_13_11_55 extends AbstractMigration { public function up () { } public function down () { } }
And then migrate.
$directory = __DIR__. '/migrations'; $list = $this->factory->newListFromDirectory($directory,'Vendor\\Plugin\\'); $list->migrate();
Contributing
- Found a bug? Please try to solve it yourself first and issue a pull request. If you are not able to fix it, at least give a clear description what goes wrong. We will have a look when there is time.
- Want to see a feature added, issue a pull request and see what happens. You could also file a bug of the missing feature and we can discuss how to implement it.