Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Doctrine Migrations

Avatar for Austin Morris Austin Morris
February 11, 2014
Technology
130
1

Doctrine Migrations

It's like source control for you database!

Avatar for Austin Morris

Austin Morris

February 11, 2014

More Decks by Austin Morris

See All by Austin Morris
Apigility
Avatar for Austin Morris austinsmorris
0
190
SOLID Demotivators
Avatar for Austin Morris austinsmorris
1
430
An Introduction to Design Patterns
Avatar for Austin Morris austinsmorris
1
170

Other Decks in Technology

See All in Technology
DMMブックスのNext.js化を加速させるAI活用 / Migrating DMM Books to Next.js with AI
Avatar for Kentaro Matsushita kentarom
0
190
Distributed Transactions Under Fire: Building a Zero-Oversell Flash Sale Platform with Amazon Aurora DSQL
Avatar for Yuuki Yamashita yama3133
1
110
Dylib Hijacking on macOS: Dead or Alive?
Avatar for Patrick Wardle patrickwardle
0
130
Introduction to Bill One Development Engineer
Avatar for Sansan, Inc. sansan33
PRO
0
480
わたしが知り合いゼロの勉強会に 行けるようになるまで
Avatar for R-524 r5ni4
2
840
Point Cloud as a Foreign Language for Multi-modal Large Language Model
Avatar for Takuya MINAGAWA takmin
0
310
アクセスキーが漏れた日にやるべきこと- 無効化の先にある本当の対応
Avatar for kazzpapa3 kazzpapa3
0
360
『自分で判断できるか』を基準に、プロダクトのハンズオン研修でAI利用の線を引いてみた / Where We Drew the Line on AI in Hands-on Training
Avatar for yuki honyanya
1
450
Claude Codeの体系的な理解と知識のフック
Avatar for Oikon oikon48
8
6k
全社に広がるMCPサーバーを、 どう安全に管理するか MCPass開発の舞台裏
Avatar for k.muguruma mtpooh
3
180
EMの役割で 変わったこと・変わらなかったこと
Avatar for SansanTech sansantech
PRO
1
190
500名弱規模の組織のPythonプロジェクト(dbt) をどう管理するか？
Avatar for Noriaki Hiraki hiracky16
0
370

Featured

See All Featured
Sam Torres - BigQuery for SEOs
Avatar for Tech SEO Connect techseoconnect
PRO
0
500
More Than Pixels: Becoming A User Experience Designer
Avatar for Michelle Schulp Hunt marktimemedia
3
510
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
Applied NLP in the Age of Generative AI
Avatar for Ines Montani inesmontani
PRO
4
2.4k
Crafting Experiences
Avatar for Bethany Jepchumba bethany
1
270
Distributed Sagas: A Protocol for Coordinating Microservices
Avatar for Caitie McCaffrey caitiem20
333
23k
The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs
Avatar for Ines Montani inesmontani
PRO
3
3.7k
Paper Plane
Avatar for Katie Cordina Lindsey katiecoart
PRO
2
53k
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
45
9.2k
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
450
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
39
3.4k
Helping Users Find Their Own Way: Creating Modern Search Experiences
Avatar for Dan Newman danielanewman
31
3.3k

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 [email protected]