Chapters

27 Chapters | 2:45:18 |

01

The Answer Entity

5:32
02

The ManyToOne Relation

8:35
03

Saving Relations

3:58
04

Relations in Foundry

4:41
05

Foundry: Always Pass a Factory Instance to a Relation

4:57
06

Fetching Relations

6:58
07

Rendering Answer Data & Saving Votes

6:02
08

Owning Vs Inverse Sides of a Relation

7:11
09

Relation OrderBy & fetch=EXTRA_LAZY

7:22
10

Filtering to Return only Approved Answers

9:40
11

Collection Criteria for Custom Relation Queries

6:33
12

Most Popular Answers Page

6:23
13

The |u Filter & String Component

4:11
14

Joining Across a Relationship & The N + 1 Problem

6:30
15

Search, the Request Object & OR Query Logic

8:05
16

The 4 (2?) Possible Relation Types

4:02
17

ManyToMany Relation

4:53
18

Saving Items in a ManyToMany Relation

6:36
19

Handling ManyToMany in Foundry

4:01
20

Joining Across a ManyToMany

5:22
21

ManyToMany... with Extra Fields on the Join Table?

6:57
22

When a Migration Falls Apart

6:23
23

QuestionTag Fixtures & DateTimeImmutable with Faker

4:07
24

Doing Crazy things with Foundry & Fixtures

8:59
25

JOINing Across Multiple Relationships

3:52
26

Pagination with Pagerfanta

6:20
27

Themed Pagination Links

7:07

> Symfony 5 >

Course Overview

Mastering Doctrine Relations

Discover the magic of Doctrine Relations in Symfony: Learn to create ManyToOne and ManyToMany relations and querying with Joins.

Buy Access

2945 students
EN Captions
EN Script
Certificate of Completion

Your Guides

Ryan Weaver

About this course

This tutorial also works great for Symfony 6!

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=8.1",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "babdev/pagerfanta-bundle": "^3.3", // v3.3.0
        "composer/package-versions-deprecated": "^1.11", // 1.11.99.3
        "doctrine/doctrine-bundle": "^2.1", // 2.4.2
        "doctrine/doctrine-migrations-bundle": "^3.0", // 3.1.1
        "doctrine/orm": "^2.7", // 2.9.5
        "knplabs/knp-markdown-bundle": "^1.8", // 1.9.0
        "knplabs/knp-time-bundle": "^1.11", // v1.16.1
        "pagerfanta/doctrine-orm-adapter": "^3.3", // v3.3.0
        "pagerfanta/twig": "^3.3", // v3.3.0
        "sensio/framework-extra-bundle": "^6.0", // v6.2.1
        "stof/doctrine-extensions-bundle": "^1.4", // v1.6.0
        "symfony/asset": "5.3.*", // v5.3.4
        "symfony/console": "5.3.*", // v5.3.7
        "symfony/dotenv": "5.3.*", // v5.3.7
        "symfony/flex": "^1.3.1", // v1.21.6
        "symfony/framework-bundle": "5.3.*", // v5.3.7
        "symfony/monolog-bundle": "^3.0", // v3.7.0
        "symfony/runtime": "5.3.*", // v5.3.4
        "symfony/stopwatch": "5.3.*", // v5.3.4
        "symfony/twig-bundle": "5.3.*", // v5.3.4
        "symfony/validator": "5.3.*", // v5.3.14
        "symfony/webpack-encore-bundle": "^1.7", // v1.12.0
        "symfony/yaml": "5.3.*", // v5.3.6
        "twig/extra-bundle": "^2.12|^3.0", // v3.3.1
        "twig/string-extra": "^3.3", // v3.3.1
        "twig/twig": "^2.12|^3.0" // v3.3.2
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^3.3", // 3.4.0
        "symfony/debug-bundle": "5.3.*", // v5.3.4
        "symfony/maker-bundle": "^1.15", // v1.33.0
        "symfony/var-dumper": "5.3.*", // v5.3.7
        "symfony/web-profiler-bundle": "5.3.*", // v5.3.5
        "zenstruck/foundry": "^1.1" // v1.13.1
    }
}

In the part 1 of the Doctrine Tutorial we got some serious work done with Doctrine: creating entity classes, making custom queries, migrations, Docker setup & more!

But... we ignored one of the biggest part of Doctrine: relations / associations! And thanks to tooling inside of Symfony, creating database relationships - ManyToOne, ManyToMany, etc - has never been easier. So let's go!

Generating a ManyToOne relationship (association)
Relation annotations / PHP 8 attributes
The OneToMany inverse side of a relation
Handling relationships in fixtures with Foundry
The owning versus inverse sides of a relation
Doing magic with the ArrayCollection (Criteria)
Querying with Joins
ManyToMany Relations

So let's cook up some relationships and take our Cauldron Overflow app to the next level!

Next courses in the Symfony 5: The Fundamentals section of the Symfony 5 Track!

16 Comments

Sort By

Ilya E. 3 years ago

Hello, when is the release date? Can't wait... =)

| Reply |

Victor SFCASTS Ilya E. 3 years ago

Hey Ilya,

Thank you for your interest in SymfonyCasts tutorials! This course should be the next after "Symfony UX: Turbo" that is releasing right now. I think this should happen in about 2 weeks.

Thank you for your patience!

Cheers!

2 | Reply |

Nick-F Victor 3 years ago

Is this almost ready for launch?

| Reply |

weaverryan SFCASTS Nick-F 3 years ago

Yup! I'm building it this week - Turbo had a few more chapters than I expected. I'm hoping to release this next week :)

| Reply |

Nick-F weaverryan 3 years ago

Looking forward to it! These doctrine courses are the reason I got a subscription. I'm currently working on a massive warehouse management database and my implementation of foundry for testing is incredibly hacky

1 | Reply |

weaverryan SFCASTS Nick-F 3 years ago edited

Hey Nick F.!

> Looking forward to it! These doctrine courses are the reason I got a subscription

Sweet!

> my implementation of foundry for testing is incredibly hacky

We won't be talking about Foundry and testing in this tutorial. But if you have any specific questions, I'd be happy to do my best to answer them here :).

Cheers!

| Reply |

Nick-F weaverryan 3 years ago

Is there a mistake in the course description then? One of the topics is "Handling relationships in fixtures with Foundry"

| Reply |

weaverryan SFCASTS Nick-F 3 years ago

Oh, yes! We will cover that - just not using Foundry specifically inside of tests :).

| Reply |

weaverryan SFCASTS weaverryan 3 years ago

Ok, it'll release NEXT week actually - but right away on Monday, then we'll move through quickly. Thanks for your patience on this one - I had some "things" come up personally that were straining my work time!

| Reply |

Lionel-F 3 years ago

Hi, Would you deal with connections to multiple databases and make:migration/doctrine:migration:migrate to multiple databases (I don't know if this one is possible ...) ?

| Reply |

Victor SFCASTS Lionel-F 3 years ago

Hey Lionel,

Unfortunately, Maker bundle only generates migrations for MySQL database. But in case you have configured multiple connections to multiple DB in your project, you can use DoctrineMigrationBundle's commands, e.g. "bin/console doctrine:migrations:diff --conn=CONN" Where CONN is your connection. Or just add --help option to any Symfony command to see more options that you can use. I believe the --conn option is exactly what you need in your case.

I hope this helps!

Cheers!

1 | Reply |

abdouniabdelkarim Victor 3 years ago edited

Hello victor , Doctrine Migrations also generate migrations for PostgreSQL.

| Reply |

Victor SFCASTS abdouniabdelkarim 3 years ago

Hey Abdelkarim,

Yes, DoctrineMigrationsBundle does, but Maker does not IIRC :)

Cheers!

| Reply |

abdouniabdelkarim Victor 3 years ago

maker works also with PosgreSQL ;)

| Reply |

Victor SFCASTS abdouniabdelkarim 3 years ago

Hey Abdelkarim,

Ah, really? I didn't know :) IIRC it didn't at some point in time. Thanks for confirming it works, then it's an easy win with Maker as well

Cheers!

| Reply |

Lionel-F Victor 3 years ago

Ty I will ty this :)

| Reply |

Mastering Doctrine Relations

Your Guides

About this course

Next courses in the Symfony 5: The Fundamentals section of the Symfony 5 Track!

Charming Development in Symfony 5

Doctrine, Symfony & the Database

Symfony 5 Fundamentals: Services, Config & Environments

16 Comments