In the part 1 of the Doctrine Tutorial we created a freakin' awesome setup: with Doctrine: entities, queries, migrations and fixtures.
But, we're missing a big, giant, huge, important piece! Database relations! And once you've mastered these, you'll be unstoppable! But... a lot of information out there make Doctrine relations look over-complicated. And actually, they're simple and beautiful, especially with some recent changes in Symfony 4:
Generating a ManyToOne relationship (association)
The annotations for a relation
The OneToMany inverse side of a relation
Referencing objects across fixture classes
The owning versus inverse sides of a relation
Doing magic with the ArrayCollection (Criteria)
Querying with Joins
ManyToMany Relations
Pagination!
Help us bring "The Space Bar" app to the galaxy, with, (inter) stellar database relations. Yep, that's the level of humor you can expect!
Overview
Syllabus
- 01. Adding a Comment Entity
- 02. Adding the ManyToOne Relation
- 03. Saving Relations
- 04. Fetching Relations
- 05. Owning Vs Inverse Relations
- 06. Fixture References & Relating Objects
- 07. Awesome Random Fixtures
- 08. OrderBy & fetch EXTRA_LAZY
- 09. Giving the Comments an isDeleted Flag
- 10. Collection Magic with Criteria
- 11. Twig Block Tricks
- 12. The Twig Extensions Library
- 13. Request Object & Query OR Logic
- 14. Query Joins & Solving the N+1 Problem
- 15. Pagination
- 16. The 4 (2?) Possible Relation Types
- 17. ManyToMany Relationship
- 18. Saving a ManyToMany Relation + Joins
- 19. ManyToMany Joins & When to Avoid ManyToMany
Taught by
Ryan Weaver