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

This tutorial has a new version, check it out!

> Symfony 5 > Symfony 5: Mastering Doctrine Relations

Buy Access to Course

08.

Owning Vs Inverse Sides of a Relation

|

Autoplay

Keep on Learning!

If you liked what you've learned so far, dive in! Subscribe to get
access to this tutorial plus video, code and script downloads.

Start your All-Access Pass

Buy just this tutorial for $12.00

Previous Chapter

Next Challenge

With a Subscription, click any sentence in the script to jump to that part of the video!

Login Subscribe

Login or register to check out the script

11 Comments

Sort By

Login or Register to join the conversation

Francois 2 years ago edited

I have two related questions question:

Is the owning side identical to the entity where we first declare the relation?
Own which side of the ownership can an entity object be safely deleted: owner or inverse?

I ask these questions because I have created an entity that describes a document layout for a specific user. I have created two ManyToOne relations inside the layout entity that relates to the user entity and to the document entity.

When I delete a document in the database, I get an SQL error about the document, which can not be deleted. Should I have defined a OneToMany relation in the user and document entities that relate them to a layout entity?

I am quite puzzled

|

MolloKhan SFCASTS Francois 2 years ago edited

Is the owning side identical to the entity where we first declare the relation?
The owning side determines which table/entity is holding the ID of the related entity record (docs: https://www.doctrine-project.org/projects/doctrine-orm/en/3.0/reference/unitofwork-associations.html#:~:text=The owning side has to,side of a bidirectional association.)

Own which side of the ownership can an entity object be safely deleted: owner or inverse?
In a ManyToOne you can delete any records without problems, but if you try to delete a OneToMany, for example, a Book has many Pages, if you try to delete a Book, it will throw an error because of the related Page records. In this case, you'll need to enable the "cascade: remove" feature so all Pages will be also deleted when you remove a Book
(blog post about it https://yusufbiberoglu.medium.com/cascade-persist-remove-in-doctrine-559ac967e451)

I hope I clarified things a bit and you can structure your project better. Cheers!

|

Yuki-K 3 years ago

Hi

I was wondering why, when I close the terminal (stop the mysql container inside docker) and hit docker compose up again, the datas remain in the project.
I thought database holds the datas, but where the datas go when I close my terminal and stop the mysql container?
Is it because stop the container doesn't mean delete and databases and recreate them, but instead
changing the port number to the same database?

docker makes me headache, Help me! lol

Cheers!

|

sadikoff Yuki-K 3 years ago edited

Hey @Yuki-K

woh that's complex question, by default if you didn't configured to store data on your local drive iit stores it inside the container, and it keeps data saved until you didn't destroyed it. But if you want a persisted data you should map you local filesystem with container filesystem so in this case you will not lose any data even if container will be dropped.

Cheers!

1 |

PeterM 3 years ago

The question asks us to pick the answer that is incorrect, but they're all correct.

|

MolloKhan SFCASTS PeterM 3 years ago

Hey Peter,

Yes, this is a tricky question, and that's why the right option is the one that says [SPOILER ALERT] "All of these statements are true"

Cheers!

|

PeterM MolloKhan 3 years ago

But the question is for what is is not true. So by selecting that answer you're saying it's not true that all of the statements are true, i.e. they're all false.

|

MolloKhan SFCASTS PeterM 3 years ago

Ohh I think I got your point. Do you think if we reword the option to say something like "None, all of these statements are correct" would make more sense?

|

VERMON 4 years ago

Hi, just to point out that there is no more subtitle from this video, then re-appear on the 11th: "Collection Criteria for Custom Relation Queries"

|

weaverryan SFCASTS VERMON 4 years ago

Thanks for pointing that out - we'll get it fixed up - we had a hiccup with our subtitling system and we need to reprocess a couple of them!

1 |

VERMON weaverryan 4 years ago

You're welcome. Thanks for your reactivity !

|

Symfony 5.3 Doctrine 2

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=8.2",
        "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
    }
}

Previous Chapter

Next Challenge