Database Migrations
With a Subscription, click any sentence in the script to jump to that part of the video!
Login SubscribeGoogle for DoctrineMigrationsBundle. To install it, copy the composer require line. But again, we don't need to have the version - Composer will find the best version for us:
Tip
If you are on Symfony 3.2 or higher, you don't have to specify the bundle's version
composer require doctrine/doctrine-migrations-bundle:1.1While Jordi is preparing that for us, let's keep busy. Copy the new statement from the docs and paste that into the AppKernel class:
| ... lines 1 - 5 | |
| class AppKernel extends Kernel | |
| { | |
| public function registerBundles() | |
| { | |
| $bundles = array( | |
| ... lines 11 - 20 | |
| new Doctrine\Bundle\MigrationsBundle\DoctrineMigrationsBundle(), | |
| ... lines 22 - 23 | |
| ); | |
| ... lines 25 - 33 | |
| } | |
| ... lines 35 - 54 | |
| } |
Beautiful!
We already know that the main job of a bundle is to give us new services. But this bundle primarily gives us something different: a new set of console commands. Run bin/console with no arguments:
./bin/consoleHiding in the middle is a whole group starting with doctrine:migrations. These are our new best friend.
The Migrations Workflow
Our goal is to find a way to safely update our database schema both locally and on production.
To do this right, drop the database entirely to remove all the tables: like we have a new project.
./bin/console doctrine:database:drop --forceThis is the only time you'll need to do this. Now, re-create the database:
./bin/console doctrine:database:createNow, instead of running doctrine:schema:update, run:
./bin/console doctrine:migrations:diffThis created a new file in app/DoctrineMigrations. Go open that up:
| ... lines 1 - 10 | |
| class Version20160207083131 extends AbstractMigration | |
| { | |
| public function up(Schema $schema) | |
| { | |
| // this up() migration is autogenerated, please modify it to your needs | |
| $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql"); | |
| $this->addSql("CREATE TABLE genus (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, sub_family VARCHAR(255) NOT NULL, species_count INT NOT NULL, fun_fact VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB"); | |
| } | |
| public function down(Schema $schema) | |
| { | |
| // this down() migration is autogenerated, please modify it to your needs | |
| $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql"); | |
| $this->addSql("DROP TABLE genus"); | |
| } | |
| } |
Check this out: the up() method executes the exact SQL that we would have gotten from the doctrine:schema:update command. But instead of running it, it saves it into this file. This is our chance to look at it and make sure it's perfect.
When you're ready, run the migration with:
./bin/console doctrine:migrations:migrateDone! Obviously, when you deploy, you'll also run this command. But here's the really cool part: this command will only run the migration files that have not been executed before. Behind the scenes, this bundle creates a migrations_versions table that keep strack of which migration files it has already executed. This means you can safely run doctrine:migrations:migrate on every deploy: the bundle will take care of only running the new files.
Tip
You can run migration in reverse in case something fails. Personally, I never
do this and I never worry about down() being correct. If you have a migration
failure, it's a bad thing and it's better to diagnose and fix it manually.
Making Columns nullable
In newAction(), I'll add some code that sets fake data on the subFamily and speciesCount properties. But, I'll keep funFact blank: maybe some genuses just aren't very fun:
| ... lines 1 - 11 | |
| class GenusController extends Controller | |
| { | |
| ... lines 14 - 16 | |
| public function newAction() | |
| { | |
| $genus = new Genus(); | |
| $genus->setName('Octopus'.rand(1, 100)); | |
| $genus->setSubFamily('Octopodinae'); | |
| $genus->setSpeciesCount(rand(100, 99999)); | |
| ... lines 23 - 28 | |
| } | |
| ... lines 30 - 74 | |
| } |
Ok, head over to /genus/new to try it out! Woh, a huge explosion!
Integrity constraint violation: 1048 Column
fun_factcannot be null
Here's the deal: Doctrine configures all columns to be required in the database by default. If you do want a column to be "nullable", find the column and add nullable=true:
| ... lines 1 - 10 | |
| class Genus | |
| { | |
| ... lines 13 - 34 | |
| /** | |
| * @ORM\Column(type="string", nullable=true) | |
| */ | |
| private $funFact; | |
| ... lines 39 - 79 | |
| } |
Creating Another Migration
Of course, just because we made this change doesn't mean that our table was automatically updated behind the scenes. Nope: we need another migration. No problem! Go back to the terminal and run:
./bin/console doctrine:migrations:diffOpen up the new migration file: ALTER TABLE genus CHANGE fun_fact to have a default of null. This look perfect. Run it with:
./bin/console doctrine:migrations:migrateSo easy! Refresh the page again: no errors. Migrations are awesome.
Leave a comment!
-
2018-10-01 Diego Aguiar -
2018-09-29 Leif__ -
2018-09-27 Diego Aguiar
-
2018-09-27 Leif__
-
2018-02-15 Diego Aguiar
-
2018-02-15 Neil Sweeney -
2018-02-14 weaverryan -
2018-02-14 Lluís Puig Ferrer -
2017-12-18 Diego Aguiar
-
2017-12-17 Darmanto Yang
-
2017-11-15 Victor Bocharsky -
2017-11-15 Andy @ melt -
2017-11-15 Diego Aguiar
-
2017-11-14 Andy @ melt
-
2017-11-14 Diego Aguiar
-
2017-11-13 Andy @ melt
-
2017-11-12 Diego Aguiar
-
2017-11-10 Andy @ melt
-
2017-10-30 Diego Aguiar
-
2017-10-30 kaizoku -
2017-10-27 Diego Aguiar
-
2017-10-27 axa
-
2017-10-27 axa
-
2017-05-31 Diego Aguiar
-
2017-05-31 Céline Ollagnier -
2017-05-30 Diego Aguiar
-
2017-05-29 Céline Ollagnier
-
2017-05-29 Diego Aguiar
-
2017-05-29 Céline Ollagnier
-
2017-05-29 Diego Aguiar
-
2017-05-29 Céline Ollagnier
-
2017-04-28 jian su -
2017-04-27 Victor Bocharsky
-
2017-04-27 jian su
-
2017-04-25 Victor Bocharsky
-
2017-04-25 jian su
-
2017-04-24 Victor Bocharsky
-
2017-04-23 jian su
-
2017-04-20 Julia Shishik
-
2017-04-19 Victor Bocharsky
-
2017-04-18 Julia Shishik
-
2017-04-18 Victor Bocharsky
-
2017-04-18 Julia Shishik
-
2017-03-15 Victor Bocharsky
-
2017-03-15 Peter Tsiampas -
2017-03-14 Peter Tsiampas
-
2017-03-08 Tony C
-
2017-03-08 weaverryan
-
2017-03-08 Tony C
-
2017-02-13 Victor Bocharsky
-
2017-02-11 Peter Tsiampas
-
2017-01-19 Victor Bocharsky
-
2017-01-19 Д. Энхбаяр -
2017-01-18 Victor Bocharsky
-
2017-01-18 Д. Энхбаяр
-
2016-10-30 Max -
2016-10-30 weaverryan
-
2016-10-28 Max
-
2016-10-28 Victor Bocharsky
-
2016-10-26 Max
-
2016-10-19 Shairyar Baig -
2016-10-16 weaverryan
-
2016-10-16 Shairyar Baig
-
2016-09-25 weaverryan
-
2016-09-24 Peter Stephens
-
2016-09-21 Victor Bocharsky
-
2016-09-21 Peter Stephens
-
2016-09-21 Peter Stephens
-
2016-09-20 Victor Bocharsky
-
2016-09-20 Peter Stephens
-
2016-09-19 weaverryan
-
2016-09-18 Peter Stephens
-
2016-08-12 claire
-
2016-08-11 weaverryan
-
2016-08-11 claire
-
2016-07-04 Dan Costinel -
2016-07-04 Victor Bocharsky
-
2016-07-03 Dan Costinel
-
2016-03-21 weaverryan
-
2016-03-18 Hikaru Shindo
