Chapters

24 Chapters | 1:14:57 |

01

Configuración

2:10
02

Parte Entidad

3:12
03

Muchos a uno: el rey de las relaciones

4:36
04

Establecer la relación

2:51
05

Establecer relaciones en la Fundición

4:24
06

Obtener los datos de una relación

4:16
07

Las dos caras de una relación: Propia vs Inversa

3:52
08

Eliminación de huérfanos

3:01
09

Ordenar una Relación y tipo "buscar

3:30
10

El ingenioso sistema de criterios

4:03
11

Listado de piezas

2:34
12

Unir para evitar la trampa del N+1

3:35
13

Añadir una búsqueda + el objeto de petición

3:54
14

Entidad Droide para la Relación Muchos a Muchos

2:41
15

Relación Muchos-Muchos

2:45
16

Establecer relaciones de muchos a muchos

3:12
17

Acceder a los datos de un ManyToMany

2:48
18

Muchos a muchos con Foundry

2:52
19

Unir a través de una relación de muchos a muchos

2:17
20

Muchos-a-Muchos pero con Datos Extra

2:59
21

Persistencia de la relación muchos-muchos más compleja

3:11
22

Ocultar la Entidad de Unión

1:37
23

Volver a añadir addDroid(): ¡Oculta esa Entidad Unida!

1:46
24

Persistir en cascada

2:51

> Symfony > Conceptos básicos de Symfony, Doctrine Relations y Warp Drive

Buy Access to Course

12.

Unir para evitar la trampa del N+1

|

|

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 Challenge

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

Kazuki-M 11 months ago

Hi, I'm working with the following code from the tutorial:

return $this->createQueryBuilder('sp')
    ->orderBy('sp.price', 'DESC')
    ->innerJoin('sp.starship', 's')
    ->addSelect('s')
    ->getQuery()
    ->getResult();

I see that this query selects all columns from the Starship table.
Is it possible to write the query to select only the name column from the Starship table, while still getting all the columns from the StarshipPart table?
I would like to know if this is technically possible for my own learning.

|

MolloKhan SFCASTS Kazuki-M 11 months ago

Yes, you can define any field you want from the query, like this ->addSelect(s.id, s.name). The result will be something like this:

[
    0 => [
        0 => StarshipPart object,
        'id' => 1010
        'name' => 'Millennium Falcon',
    ],
    ...
]

Cheers!

1 |

Kazuki-M MolloKhan 11 months ago

Thanks for your help.

I found that using addSelect with specific columns resulted in an array, which I didn't expect.

However, I discovered the PARTIAL keyword, which I hadn't learned yet. It allowed me to select specific data while still getting an object.

        $qb = $this->createQueryBuilder("sp")
            ->orderBy("sp.price", "DESC")
            ->innerJoin("sp.starship", "s")
            ->select("sp", "PARTIAL s.{id, name}")
            ->addSelect("s");

P.S. I verified this for my own learning.

|

MolloKhan SFCASTS Kazuki-M 11 months ago

Yea, that's the downside of selecting multiple stuff. About using partial, just be aware that your objects are not fully hydrated so you may not want them to be used in other parts of your system

1 |

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 Chapter

Next Challenge