Doctrine Migrations

It's like source control for you database!

Transcript

1. Doctrine Migrations It’s like source control for your database! Austin Morris Varsity News Network (We’re hiring!)
2. WTF?
3. Doctrine Migrations • Programmatic database version control. • Easy schema deployment. • Let the ORM do the work! http://docs.doctrine-project.org/projects/doctrine-migrations/en/latest/
4. Installation
5. composer.json
6. Update Doctrine CLT
7. cli-config.php (Doctrine 2.4)
8. Configure Migrations
9. migrations.yml
10. New Commands!
11. $ vendor/bin/doctrine list migrations
12. Demo!
13. MyMDB
14. MyMDB.Entity.Movie.dcm.yml
15. Add $views
16. MyMDB.Entity.Movie.dcm.yml
17. Create Version $ vendor/bin/doctrine migrations:diff
18. MyMDB\DoctrineMigrations\VersionYYYYMMDDHHMMSS
19. $ vendor/bin/doctrine migrations:migrate
20. MyMDB
21. MyMDB
22. What else? • Migrate up and down (revert). • Migrate across multiple versions. • Migrate to specific versions. • Dry-run migrations. • Manipulate data during migrations. • Symfony has DoctrineMigrationsBundle
23. Problems? • Kris?
24. Questions? @austinsmorris austin.morris@gmail.com