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

04.

JOINs

|

|

Autoplay

Previous Challenge

Next Challenge

Login or register to check out the script

2 Comments

Sort By

Login or Register to join the conversation

Daniyal-J 2 years ago

But how can I create a one-to-many relationship in the first place?

1 |

Victor SFCASTS Daniyal-J 2 years ago

Hey Daniyal,

We don't focus too much on how to create relationships in this tutorial because this tutorial is about a different topic, specifically, how to work with Doctrine queries. So here we're mostly working on an existent DB structure. You can spy on how the relationship is created in the entity mapping, but if you want to learn more on how to create it - take a look at e.g.: https://symfonycasts.com/screencast/symfony3-doctrine-relations/many-to-one-relation - or try our advanced search to find more related content. For example, we talk a lot about Doctrine and its relationships in our latest Symfony Doctrine course: https://symfonycasts.com/screencast/symfony-doctrine

Cheers!

3 |

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 Challenge