Chapters

16 Chapters | 1:26:33 |

01

Doctrina DQL

7:38
02

El QueryBuilder

2:02
03

yDónde() y oDónde()

7:06
04

JOINs

3:45
05

Consultas de reducción JOINs y addSelect

5:22
06

Relaciones EXTRA_LAZY

6:07
07

SELECCIONA la SUMA (o CUENTA)

6:15
08

Seleccionar campos específicos

5:09
09

Seleccionar en un nuevo objeto DTO

3:40
10

Consultas SQL sin procesar

6:52
11

Reutilizar consultas en el Generador de consultas

4:42
12

Criterios: Filtrar colecciones de relaciones

9:09
13

Filtros: Modificar consultas automáticamente

6:59
14

DONDE EN()

2:07
15

Utilizar RAND() u otras funciones no compatibles

3:11
16

Utilizar GROUP BY para buscar y contar en una sola consulta

6:29

> Symfony > Hazte profesional con las consultas de Doctrine

Buy Access to Course

11.

Reutilizar consultas en el Generador de consultas

|

|

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 $6.00

Previous Challenge

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

4 Comments

Sort By

Login or Register to join the conversation

Claudio-B 3 years ago edited

Before aksing, thank you so much for your great job.

I get this error:

App\Model\CategoryFortuneStats::__construct(): Argument #1 ($fortunesPrinted) must be of type int, null given, called in C:\wamp64\www\mixed_vinyl\src\Repository\FortuneCookieRepository.php on line .."

if a category is empty (0 fortuneCoockie). How to check the case in CategoryFortuneStats constructor?

Thank you in advance
Claudio

|

Victor SFCASTS Claudio-B 3 years ago edited

Hey @Claudio-B ,

Well, you just need make sure you pass an integer to the constructor of your CategoryFortuneStats, i.e. instead of null pass 0 for example. To avoid multiple checks in multiple places before new CategoryFortuneStats() you can make sure your repository method that calculates the number always returns an integer, i.e. do something like this:

if ($result === null) {
    return 0;
}

But if you want to do this check in the constructor of CategoryFortuneStats - just allow passing null for that fortunesPrinted argument, i.e.

public function __construct(?int $fortunesPrinted)
{
    if ($fortunesPrinted === null) {
        $fortunesPrinted = 0;
    }
    $this->fortunesPrinted = $fortunesPrinted;
}

Something like this, I hope this helps! :)

Cheers!

|

Claudio-B Victor 3 years ago

Very kind of you!
Ciao!

|

Victor SFCASTS Claudio-B 3 years ago

Glad it helped! :)

Cheers!

|

Symfony 6 Doctrine 2

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=8.2",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "beberlei/doctrineextensions": "^1.3", // v1.3.0
        "doctrine/doctrine-bundle": "^2.7", // 2.9.1
        "doctrine/doctrine-migrations-bundle": "^3.2", // 3.2.2
        "doctrine/orm": "^2.13", // 2.15.1
        "symfony/asset": "6.2.*", // v6.2.7
        "symfony/console": "6.2.*", // v6.2.10
        "symfony/dotenv": "6.2.*", // v6.2.8
        "symfony/flex": "^2", // v2.2.5
        "symfony/framework-bundle": "6.2.*", // v6.2.10
        "symfony/proxy-manager-bridge": "6.2.*", // v6.2.7
        "symfony/runtime": "6.2.*", // v6.2.8
        "symfony/twig-bundle": "6.2.*", // v6.2.7
        "symfony/webpack-encore-bundle": "^1.16", // v1.16.1
        "symfony/yaml": "6.2.*" // v6.2.10
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^3.4", // 3.4.4
        "symfony/maker-bundle": "^1.47", // v1.48.0
        "symfony/stopwatch": "6.2.*", // v6.2.7
        "symfony/web-profiler-bundle": "6.2.*", // v6.2.10
        "zenstruck/foundry": "^1.22" // v1.32.0
    }
}

Previous Challenge

Next Chapter