Chapters

23 Chapters | 2:22:24 |

01

Installing Doctrine

7:54
02

make:docker:database

5:24
03

docker-compose & Exposed Ports

4:46
04

docker-compose Env Vars & Symfony

4:59
05

doctrine:database:create & server_version

4:49
06

Entity Class

7:57
07

Migrations

5:34
08

Persisting to the Database

8:42
09

Fetching Data & The Repository

5:28
10

Entity objects in Twig

4:55
11

"5 Minutes Ago" Strings

3:15
12

Custom Repository Class

8:10
13

DQL & The Query Builder

6:49
14

Reusing Query Logic & Param Converters

3:35
15

Automatic Controller Queries: Param Converter

3:28
16

Smarter Entity Methods

7:57
17

Request Object & POST Data

8:08
18

Update Query & Rich vs Anemic Models

7:58
19

Data Fixtures

5:18
20

Foundry: Fixture Model Factories

5:56
21

Foundry Tricks

7:28
22

Sluggable: Doctrine Extensions

5:57
23

Timestampable & Failed Migrations

8:01

> Symfony 5 > Doctrine, Symfony & the Database

Buy Access to Course

14.

Reusing Query Logic & Param Converters

|

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

Trendency 3 years ago edited

`
public function findAllAskedOrderedByNewest()

{

    return $this->addIsAskedQueryBuilder()
        ->orderBy('q.askedAt', 'DESC')
        ->getQuery()
        ->getResult()
    ;
}

private function addIsAskedQueryBuilder(): QueryBuilder
{
    return $this->getOrCreateQueryBuilder()
    ->andWhere('q.askedAt IS NOT NULL');
}

private function getOrCreateQueryBuilder(QueryBuilder  $qb  = null ):QueryBuilder{
    return $qb ?: $this->createQueryBuilder('q');
}

`

QueryBuilder $qb does not need to be specified for addIsAskedQueryBuilder because getOrCreateQueryBuilder is already specified

right ?

|

Victor SFCASTS Trendency 3 years ago

Hey Sandor,

Yes, you're correct! The QueryBuilder instance is already created in getOrCreateQueryBuilder() and because we return it there - we can just use it upstream in addIsAskedQueryBuilder() and return it again so we could continue with the chain in findAllAskedOrderedByNewest() as well :)

Cheers!

|

zahariastefan462 4 years ago

Once a query was made, $qb will return to be null?
In witch conditions $qb will be null?
Thank you in advance

|

MolloKhan SFCASTS zahariastefan462 4 years ago edited

Hey zahariastefan462

I believe you got confused by our custom private method getOrCreateQueryBuilder(). It accepts an optional QueryBuilder but it will alwasy return one.

Cheers!

1 |

zahariastefan462 MolloKhan 4 years ago

Thank you for reply. I think I understood now.

|

Farah 5 years ago

I don't understand why you don't delete the ->andWhere('q.askedAt IS NOT NULL') line. Isn't that the purpose of the addIsAskedQueryBuilder to be able to avoid duplicate code?

|

weaverryan SFCASTS Farah 5 years ago

Hi @Farah!

OMG, that's 100% my fault! I was so focused on the refactoring that I forget to actually take *advantage* of the refactoring. Yes, I intended to remove, because it's now redundant. I'll add a note to the video so that others don't get confused.

Thanks for the message on this!

|

Farah weaverryan 5 years ago

Thank you very much for your reply! I just got confused for a second. I totally get being focused on a task and forgetting everything else haha! Keep up the amazing tutorials they‘re seriously the best out there and actually help me so much at me new job!

|

This tutorial also works great for Symfony 6!

Symfony 5 Doctrine 2

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": "^7.4.1",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "composer/package-versions-deprecated": "^1.11", // 1.11.99
        "doctrine/doctrine-bundle": "^2.1", // 2.1.1
        "doctrine/doctrine-migrations-bundle": "^3.0", // 3.0.2
        "doctrine/orm": "^2.7", // 2.8.2
        "knplabs/knp-markdown-bundle": "^1.8", // 1.9.0
        "knplabs/knp-time-bundle": "^1.11", // v1.16.0
        "sensio/framework-extra-bundle": "^6.0", // v6.2.1
        "sentry/sentry-symfony": "^4.0", // 4.0.3
        "stof/doctrine-extensions-bundle": "^1.4", // v1.5.0
        "symfony/asset": "5.1.*", // v5.1.2
        "symfony/console": "5.1.*", // v5.1.2
        "symfony/dotenv": "5.1.*", // v5.1.2
        "symfony/flex": "^1.3.1", // v1.21.6
        "symfony/framework-bundle": "5.1.*", // v5.1.2
        "symfony/monolog-bundle": "^3.0", // v3.5.0
        "symfony/stopwatch": "5.1.*", // v5.1.2
        "symfony/twig-bundle": "5.1.*", // v5.1.2
        "symfony/webpack-encore-bundle": "^1.7", // v1.8.0
        "symfony/yaml": "5.1.*", // v5.1.2
        "twig/extra-bundle": "^2.12|^3.0", // v3.0.4
        "twig/twig": "^2.12|^3.0" // v3.0.4
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^3.3", // 3.4.0
        "symfony/debug-bundle": "5.1.*", // v5.1.2
        "symfony/maker-bundle": "^1.15", // v1.23.0
        "symfony/var-dumper": "5.1.*", // v5.1.2
        "symfony/web-profiler-bundle": "5.1.*", // v5.1.2
        "zenstruck/foundry": "^1.1" // v1.5.0
    }
}

Previous Chapter

Next Chapter