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

24.

Doing Crazy things with Foundry & Fixtures

|

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 Chapter

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

8 Comments

Sort By

Login or Register to join the conversation

Nicolas-M 4 years ago edited

Either with the first solution or "The Simpler Solutions", I get this error :

<blockquote>[Semantical Error] line 0, col 58 near 'tag WHERE q.askedAt': Error: Class App\Entity\Question has no association named tags</blockquote>

in the Doctrine query :

<blockquote>Doctrine\ORM\Query\QueryException
in C:\xampp\htdocs\cauldron_overflow\vendor\doctrine\orm\lib\Doctrine\ORM\Query\QueryException.php (line 49)

 *     * @return QueryException     */    public static function semanticalError($message, $previous = null)    {        return new self('[Semantical Error] ' . $message, 0, $previous);    }    /**     * @return QueryException     */

</blockquote>

I checked my code many times but to no avail.

Maybe something is wrong in QuestionRepository.php :


     /**
      * @return Question[] Returns an array of Question objects
      */
    public function findAllAskedOrderedByNewest()
    {
        return $this->addIsAskedQueryBuilder()
            ->orderBy('q.askedAt', 'DESC')
            ->leftJoin('q.tags', 'tag')
            ->addSelect('tag')
            ->getQuery()
            ->getResult()
        ;
    }

Any idea?
Thanks....

|

Victor SFCASTS Nicolas-M 4 years ago

Hey Nicolas,

Did you download the course code and start from start/ directory? Or are you applying changes on your personal project or a fresh Symfony version?

Looks like you have a bad mapping in your project, try to run "bin/console doctrine:schema:validate" first and check the output - does it have both OK or mapping is failed? If failed - try to double-check and fix your mapping and try that query one more time.

Cheers!

|

Nicolas-M Victor 4 years ago

Thanks Victor,
I indeed downloaded the course and started from scratch - not from a previous course.

Everything was fine until now.

I ran "bin/console doctrine:schema:validate" and the output seems correct:

nicolas@MURCIA MINGW64 /c/xampp/htdocs/cauldron_overflow (master)
$ bin/console doctrine:schema:validate

Mapping
-------

[OK] The mapping files are correct.

Database
--------

[OK] The database schema is in sync with the mapping files.

Yours truly...

|

Victor SFCASTS Nicolas-M 4 years ago edited

Hey Nicolas,

Please, make sure you have $tags property in the Question entity. It probably should be $questionTags property in the query, i.e. try:


     /**
      * @return Question[] Returns an array of Question objects
      */
    public function findAllAskedOrderedByNewest()
    {
        return $this->addIsAskedQueryBuilder()
            ->orderBy('q.askedAt', 'DESC')
            ->leftJoin('q.questionTags', 'tag')
            ->addSelect('tag')
            ->getQuery()
            ->getResult()
        ;
    }

I suppose it will work now. I just downloaded the course code and see that the property is named as "questionTags" instead of just "tags".

Cheers!

|

Nicolas-M Victor 4 years ago

Hey Victor,
The right answer to my issue is in fact in the next Chapter (Chapter 25 - JOINing Across Multiple Relationships).
I tested the Frontend too soon, at the end of Chapter 24 - unlike what Ryan did.
I am so sorry for the disturbance, and you can delete my post which might not be very useful to other users.
Thank again for your help, quick and useful.

|

Victor SFCASTS Nicolas-M 4 years ago

Hey Nicolas,

Ah, ok, glad you found the solution! And let's keep the thread, it might be still useful for others ;)

Cheers!

|

Ralf-B 4 years ago

At about 1:58 in the video it should be:
"Normally when we use QuestionTagFactory, it creates a new Question object." not QuestionFactory

|

Victor SFCASTS Ralf-B 4 years ago

Hey Ralf,

The sentence "Normally when we use QuestionFactory, it creates a new Question object" is correct, we're talking about QuestionFactory in that sentence, not about QuestionTagFactory. QuestionTagFactory cannot create Question object because it creates QuestionTag object. You're probably misleaded because on the video the QuestionTagFactory text was selected, but we were talking about it in the previous sentence :)

Cheers!

|

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 Chapter