A really simple migrations library. It is currently not meant to be used in production but nobody's going to stop you if you really want to. Use at your own risk.
Installing it is easy, just require turanct/bdsm
as a development dependency in your composer.json
file, and configure a bin-dir
. The bdsm executable will be available in your bin directory when you've run composer install
.
{
"require-dev": {
"turanct/bdsm": "dev-master"
},
"config": {
"bin-dir": "bin"
}
}
The bdsm
executable expects a .bdsm.php
file in the working directory of your project. In this file you can do all necessary bootstrapping. It just needs to return an array with these elements:
- The directory where we can find migrations
- The file in which we can log which migrations we ran
- A database adapter, implementing the really simple
Bdsm\Database
interface
<?php
use Bdsm\Database;
final class MyDatabaseAdapter implements Database
{
public function query($query)
{
var_dump($query);
}
}
return array(
__DIR__ . '/migrations',
__DIR__ . '/.bdsm.log.json',
new MyDatabaseAdapter(),
);
In this case, we provided a directory migrations
in which the migrations will live, and a log file .bdsm.log.json
to which the system can log. The database adapter in this example will not actually connect to a database, but it will print out every query issued.
We're ready to create our first migration right now! Run the bdsm
command with the create
parameter.
$ bin/bdsm create
Migration "Migration1441375998" created...
You can also pass a custom migration name as a parameter. A new migration will be created in our migrations directory with these contents:
<?php
use Bdsm\Migration;
use Bdsm\Database;
final class Migration1441375998 implements Migration
{
public function up(Database $database)
{
}
public function down(Database $database)
{
}
}
We can now simply script the up and down actions for our migration, and then check it's status. It should be red.
$ bin/bdsm status
✘ Migration1441375998
Running it is as simple as bdsm up Migration1441375998
. Note that you can run all migrations at once using bdsm up
without arguments.
$ bin/bdsm up Migration1441375998
Do you want to migrate UP migration Migration1441375998? (Y/n)
Migrated...
Another look at the migration status shows us that we succeeded!
$ bin/bdsm status
✔︎ Migration1441375998
Migrating down is exactly the same procedure, but with down
instead of up
commands.
BDSM has unit tests, located in the tests
directory. These tests are written using phpunit. To run them, make sure you did a composer install
and run phpunit.
$ sbin/phpunit
Feel free to fork and send pull requests!
This library is MIT licensed. See also LICENSE.md