Doctrine2 migrations de migrer vers le bas et de migrer à partir du navigateur et pas de ligne de commande

J'ai vu ce doc sur Symfony site web : http://symfony.com/doc/current/bundles/DoctrineMigrationsBundle/index.html#usage

Il est doctrine:migrations:execute qui vous permet d'exécuter une seule migration de la version haut ou vers le bas à la main... mais jamais essayé, désolé.

Espérons que cette aide !

Nous tenir au courant.

Voici comment vous pouvez exécuter les migrations à partir du navigateur:

compositeur.json

{
    "require": {
        "doctrine/dbal": "*",
        "doctrine/migrations": "dev-master"
    },
    "minimum-stability": "dev",
    "autoload": {
        "psr-0": {"": "src/"}
    }
}

src/Acme/Migrations/Version1.php

<?php # src/Acme/Migrations/Version1.php
namespace Acme\Migrations;

use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;

/**
 * Class Version1
 *
 * Notice that file and class names MUST be Version*.php
 *
 * @package Acme\Migrations
 */
class Version1 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        $users = $schema->createTable('users');
        $users->addColumn('id', 'integer', array('unsigned' => true, 'autoincrement' => true));
        $users->addColumn('username', 'string', array('length' => 128));
        $users->addColumn('password', 'string', array('length' => 128));
        $users->setPrimaryKey(array('id'));

        //You can also add any queries
        //$this->addSql('CREATE TABLE addresses (id INT NOT NULL, street VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        $schema->dropTable('users');

        //$this->addSql('DROP TABLE addresses');
    }

    //Use this functions to prepare your migrations
    //public function preUp(Schema $schema) {}
    //public function postUp(Schema $schema) {}
    //public function preDown(Schema $schema) {}
    //public function postDown(Schema $schema) {}
}

index.php

<?php # index.php
use Doctrine\DBAL\DriverManager;
use Doctrine\DBAL\Migrations\Configuration\Configuration;
use Doctrine\DBAL\Migrations\Migration;
use Doctrine\DBAL\Migrations\OutputWriter;
require_once 'vendor/autoload.php';
$nl = PHP_SAPI == 'cli' ? PHP_EOL : '<br>'; //Optional will be used for output
$to = null; //Optional integer - migrate to version, if null - will migrate to latest available version
#region Optional get argument
$index = PHP_SAPI == 'cli' ? 1 : 'to';
$arguments = PHP_SAPI == 'cli' ? $argv : $_REQUEST;
$to = isset($arguments[$index]) && filter_var($arguments[$index], FILTER_VALIDATE_INT) ? intval($arguments[$index]) : null;
#endregion
#region Doctrine Connection
//Silex: $app['db']
//Symfony controller: $this->get('database_connection')
$db = DriverManager::getConnection(array(
'dbname' => 'doctine_migrations',
'user' => 'root',
'password' => 'root',
'host' => 'localhost',
'driver' => 'pdo_mysql',
'charset' => 'utf8',
'driverOptions' => array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'
)
));
#endregion
#region Config
$config = new Configuration($db /*, new OutputWriter(function ($message) { echo $message . PHP_EOL; })*/); //OutputWriter is optional and by default do nothing, accepts closure for writing logs
//$config->setName('My Migrations'); //Optional name for your migrations
$config->setMigrationsTableName('version'); //Table name that will store migrations log (will be created automatically, default name is: doctrine_migration_versions)
$config->setMigrationsNamespace('Acme\\Migrations'); //Namespace of your migration classes, do not forget escape slashes, do not add last slash
$config->setMigrationsDirectory('src/Acme/Migrations'); //Directory where your migrations are located
$config->registerMigrationsFromDirectory($config->getMigrationsDirectory()); //Load your migrations
#endregion
$migration = new Migration($config); //Create Migration based on provided configuration
$versions = $migration->getSql($to); //Retrieve SQL queries that should be run to migrate you schema to $to version, if $to == null - schema will be migrated to latest version
#region Some dummy output
foreach ($versions as $version => $queries) {
echo 'VERSION: ' . $version . $nl;
echo '----------------------------------------------' . $nl . $nl;
foreach ($queries as $query) {
echo $query . $nl . $nl;
}
echo $nl . $nl;
}
#endregion
try {
$migration->migrate($to); //Execute migration!
echo 'DONE' . $nl;
} catch (Exception $ex) {
echo 'ERROR: ' . $ex->getMessage() . $nl;
}

Maintenant, vous pouvez:

L'exécuter à partir de la console:

php index.php - va migrer à lates version

php index.php 2 - va migrer vers la version 2 (si la version actuelle est la plus - il migrera vers le bas

Exécuter à partir du navigateur web:

http://localhost/index.php et http://localhost/index.php?to=2 va faire la même chose.