Doctrine Migrations
Parameters
# app/config/parameters.yml
parameters:
database_host: ~
database_port: ~
database_name: ~
database_user: ~
database_password: ~
database_path: '%kernel.root_dir%/../var/rdbms/chorke.sqlite '
mailer_transport: smtp
mailer_host: 127.0.0.1
mailer_user: ~
mailer_password: ~
secret: ff1a949ebf4d50f1f51a1fb3864f52e9e5c9e136
Doctrine Config
# app/config/config.yml
doctrine:
dbal:
driver: pdo_sqlite
path: '%database_path%'
charset: UTF8
orm:
auto_generate_proxy_classes: '%kernel.debug%'
naming_strategy: doctrine.orm.naming_strategy.underscore
auto_mapping: true
Database Creation
# var/sqlite/.gitkeep
mkdir -p ./var/rdbms/;\
touch ./var/rdbms/.gitkeep
# sqlite database create by doctrine
bin/console doctrine:database:create
# doctrine migrations dependency require
composer require doctrine/doctrine-migrations-bundle "^1.0"
Migrations Config
Finally, be sure to enable the bundle in AppKernel.php
by including the following:
// app/AppKernel.php
public function registerBundles()
{
$bundles = array(
//...
new Doctrine\Bundle\MigrationsBundle\DoctrineMigrationsBundle(),
);
}
# app/config/config.yml
doctrine_migrations:
dir_name: "%kernel.root_dir%/DoctrineMigrations"
namespace: Application\Migrations
table_name: T00000
name: Application Migrations
organize_migrations: false
Doctrine Entities
// src/WebappBundle/Entity/T00E00.php
namespace Chorke\Bundle\WebappBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
/**
* T00E00
*
* @ORM\Table(name="t00e00", uniqueConstraints={
* @ORM\UniqueConstraint(name="UNIQ_T00E00_HOST", columns={"host"})
* })
* @ORM\Entity(repositoryClass="Chorke\Bundle\WebappBundle\Repository\T00E00Repository")
*/
class T00E00
{
/**
* @var int
*
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
* @ORM\Column(name="id", type="integer")
*/
private $id;
/**
* @var string
*
* @ORM\Column(name="name_native", type="string", length=255, nullable=true)
*/
private $nameNative;
/**
* @var string
*
* @ORM\Column(name="name_english", type="string", length=255)
*/
private $nameEnglish;
/**
* @var string
*
* @ORM\Column(name="host", type="string", length=255, unique=true)
*/
private $host;
/**
* @var string
*
* @ORM\Column(name="site", type="string", length=255)
*/
private $site;
// getter and setter omitted
}
// src/WebappBundle/Entity/T00I00.php
namespace Chorke\Bundle\WebappBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
/**
* T00I00
*
* @ORM\Table(name="t00i00", uniqueConstraints={
* @ORM\UniqueConstraint(name="UNIQ_T00I00_SITE_CODE", columns={"site_code"})
* })
* @ORM\Entity(repositoryClass="Chorke\Bundle\WebappBundle\Repository\T00I00Repository")
*/
class T00I00
{
/**
* @var int
*
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
* @ORM\Column(name="id", type="integer")
*/
private $id;
/**
* @var string
*
* @ORM\Column(name="name_english", type="string", length=255)
*/
private $nameEnglish;
/**
* @var string
*
* @ORM\Column(name="name_native", type="string", length=255)
*/
private $nameNative;
/**
* @var string
*
* @ORM\Column(name="site_code", type="string", length=4, unique=true)
*/
private $siteCode;
// getter and setter omitted
}
Migration Differ
bin/console doctrine:migrations:diff
will generate
// src/DoctrineMigrations/Version20180113140052.php
namespace Application\Migrations;
use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;
/**
* Auto-generated Migration: Please modify to your needs!
*/
class Version20180113140052 extends AbstractMigration
{
/**
* @param Schema $schema
*/
public function up(Schema $schema)
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'sqlite', 'Migration can only be executed safely on \'sqlite\'.');
$this->addSql('CREATE TABLE t00e00 (id INTEGER NOT NULL, name_native VARCHAR(255) DEFAULT NULL, name_english VARCHAR(255) NOT NULL, host VARCHAR(255) NOT NULL, site VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_T00E00_HOST ON t00e00 (host)');
$this->addSql('CREATE TABLE t00i00 (id INTEGER NOT NULL, name_english VARCHAR(255) NOT NULL, name_native VARCHAR(255) NOT NULL, site_code VARCHAR(4) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_T00I00_SITE_CODE ON t00i00 (site_code)');
}
/**
* @param Schema $schema
*/
public function down(Schema $schema)
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'sqlite', 'Migration can only be executed safely on \'sqlite\'.');
$this->addSql('DROP TABLE t00e00');
$this->addSql('DROP TABLE t00i00');
}
}