Chapters

24 Chapters | 1:14:57 |

01

Setup

2:10
02

Part Entity

3:12
03

Many To One: The King of Relationships

4:36
04

Setting the Relation

2:51
05

Setting Relations in Foundry

4:24
06

Fetching a Relation's Data

4:16
07

The Two Sides of a Relation: Owning vs Inverse

3:52
08

Orphan Removal

3:01
09

Ordering a Relation and "fetch" type

3:30
10

The Clever Criteria System

4:03
11

Listing Parts

2:34
12

Joining to Avoid the N+1 Trap

3:35
13

Adding a Search + the Request Object

3:54
14

Droid Entity for the ManyToMany Relationship

2:41
15

Many-To-Many Relationship

2:45
16

Setting Many To Many Relations

3:12
17

Accessing Data on a ManyToMany

2:48
18

Many To Many with Foundry

2:52
19

Joining Across a Many-to-Many Relationship

2:17
20

Many-to-Many but with Extra Data

2:59
21

Persisting the More Complex Many-to-Many Relationship

3:11
22

Hiding the Join Entity

1:37
23

Re-adding addDroid(): Hide that Join Entity!

1:46
24

Cascade Persist

2:51

> Symfony > Symfony, Doctrine Relations & Warp Drive Basics

Buy Access to Course

04.

Setting the Relation

|

|

Autoplay

Previous Challenge

Next Challenge

Login or register to check out the script

6 Comments

Sort By

Login or Register to join the conversation

alimack 4 months ago

Make sure you haven't left the line in the AppFixtures that creates 50 parts - took me all afternoon to work out this was making the load fail.

2 |

Victor SFCASTS alimack 4 months ago edited

Hey @alimack ,

Thanks for this tip!

Cheers!

|

giorgiocba 11 months ago

Hi, in Windows 10 and docker engine $part->setStarship($starship); not work.
Error
An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column "starship_id" of
relation "starship_part" does not exist
LINE 1: ...part (name, price, notes, created_at, updated_at, starship_i...
The first line in StarshipPart table does not exist

|

MolloKhan SFCASTS giorgiocba 11 months ago edited

Hey @giorgiocba

Sorry for my late response. I believe you didn't update your database after adding the starship relationship. Could you take a look?

Cheers!

|

Bart-V 11 months ago

When you do :

symfony console doctrine:query:sql 'SELECT * FROM starship WHERE id = 75'

I cannt see part_id is 1.
Even when I try to do the query myself, I dont see part_id anywhere... Did I miss something?

|

Victor SFCASTS Bart-V 11 months ago

Hey Bart,

You may have a different ID locally, depending on how many times you reloaded your fixtures. First of all, make sure you reloaded the fixtures. Then, you can find the correct ID with this command:

symfony console doctrine:query:sql 'SELECT * FROM starship_part'

And finally use the ID from the output in that last command:

symfony console doctrine:query:sql 'SELECT * FROM starship WHERE id = %your_id_here%'

If you still don't see it - make sure you have the exact same code in AppFixtures.php as on the video, probably you missed the flush() call there?. You can expand the full code block here: https://symfonycasts.com/screencast/doctrine-relations/setting-relation#codeblock-e528363598

Cheers!

|

This tutorial works perfectly with both Symfony 7 & 8!

Symfony 7

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=8.2",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "babdev/pagerfanta-bundle": "^4.5", // v4.5.0
        "doctrine/dbal": "^4", // 4.2.3
        "doctrine/doctrine-bundle": "^2.13", // 2.14.0
        "doctrine/doctrine-migrations-bundle": "^3.3", // 3.4.1
        "doctrine/orm": "^3.3", // 3.3.2
        "knplabs/knp-time-bundle": "^2.2", // v2.4.0
        "pagerfanta/doctrine-orm-adapter": "^4.7", // v4.7.1
        "php-cs-fixer/shim": "^3.46", // v3.73.1
        "phpdocumentor/reflection-docblock": "^5.3", // 5.6.1
        "phpstan/phpdoc-parser": "^2.0", // 2.1.0
        "stof/doctrine-extensions-bundle": "^1.12", // v1.13.0
        "symfony/asset": "7.2.*", // v7.2.0
        "symfony/asset-mapper": "7.2.*", // v7.2.3
        "symfony/console": "7.2.*", // v7.2.1
        "symfony/dotenv": "7.2.*", // v7.2.0
        "symfony/flex": "^2", // v2.5.0
        "symfony/framework-bundle": "7.2.*", // v7.2.4
        "symfony/http-client": "7.2.*", // v7.2.4
        "symfony/monolog-bundle": "^3.0", // v3.10.0
        "symfony/property-access": "7.2.*", // v7.2.3
        "symfony/property-info": "7.2.*", // v7.2.3
        "symfony/runtime": "7.2.*", // v7.2.3
        "symfony/serializer": "7.2.*", // v7.2.4
        "symfony/stimulus-bundle": "^2.13", // v2.23.0
        "symfony/twig-bundle": "7.2.*", // v7.2.0
        "symfony/ux-turbo": "^2.13", // v2.23.0
        "symfony/yaml": "7.2.*", // v7.2.3
        "symfonycasts/tailwind-bundle": "^0.9.0", // v0.9.0
        "twig/extra-bundle": "^2.12|^3.0", // v3.20.0
        "twig/twig": "^2.12|^3.0" // v3.20.0
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^4.0", // 4.0.0
        "symfony/debug-bundle": "7.2.*", // v7.2.0
        "symfony/maker-bundle": "^1.52", // v1.62.1
        "symfony/stopwatch": "7.2.*", // v7.2.4
        "symfony/web-profiler-bundle": "7.2.*", // v7.2.4
        "zenstruck/foundry": "^2.2" // v2.3.8
    }
}

Previous Challenge

Next Challenge