Chapters

15 Chapters | 1:02:10 |

01

Installing Doctrine

3:51
02

Database Setup & Docker

3:53
03

Starship Entity

4:44
04

Migrations

2:34
05

Inserting Data via Fixtures

4:01
06

Fetching with DQL, the QueryBuilder & find()

4:47
07

Cosmic Queries: the Repository Class

5:15
08

Alien Tech for Fixtures: Foundry & Faker

4:29
09

Pagination

5:51
10

Starship Upgrade: Adding Slug and Timestamp Fields

5:06
11

Auto Slug and Timestamps with Doctrine Extensions

3:34
12

High-Tech Controllers: Auto-inject Entities

4:23
13

Black Hole: Deleting Entities

3:25
14

Ship Upgrades: Updating an Entity

3:36
15

Quantum Refactor: Rich Entities

2:42

> Symfony > Doctrine, Symfony 7 & the Database

Buy Access to Course

04.

Migrations

|

|

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 Challenge

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

kdesilva 7 months ago edited HIGHLIGHTED

In recent versions of the Doctrine bundle, you may need to change the below from

symfony console doctrine:query:sql 'select * from doctrine_migration_versions'

to

symfony console dbal:run-sql 'select * from doctrine_migration_versions'

2 |

Victor SFCASTS kdesilva 7 months ago edited

Hey @kdesilva ,

You're absolutely right, it was changed in the Doctrine bundle v3. We will add a note about it :)

Cheers!

|

skipper-henrik 11 months ago

I shortly had a typo while creating an entity with make:entity

So I do wonder how I can got just one step back with my database. This should use the down() method, shouldn't? So may you show us how to rollback?

Thank you!

|

kbond SFCASTS skipper-henrik 11 months ago edited

Hey @skipper-henrik!

So... confession time. I've never done a rollback with Doctrine migrations. I only move forward (up).

If this happened in a real app (that already had the bad migration deployed): keep the wrong migration, make the necessary adjustments to your entity and generate a second migration (run make:migration again). The up() should be generated making the corrections automatically.

Locally, if you haven't yet deployed the wrong migration, do the following:

Delete the wrong migration from your code.
If you have already run the wrong migration locally, reset your database.
Make the adjustments in your entity.
Run make:migration again.

I do think this is the most common approach to mistakes. Rollbacks can get complicated (especially when integrated into automated deployments).

I hope this helps!

--Kevin

1 |

This tutorial works perfectly with both Symfony 7 & 8!

Symfony 7.1 Doctrine 3

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": "^3", // 3.9.4
        "doctrine/doctrine-bundle": "^2.13", // 2.13.2
        "doctrine/doctrine-migrations-bundle": "^3.3", // 3.4.0
        "doctrine/orm": "^3.3", // 3.3.1
        "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.65.0
        "phpdocumentor/reflection-docblock": "^5.3", // 5.6.0
        "phpstan/phpdoc-parser": "^1.25", // 1.33.0
        "stof/doctrine-extensions-bundle": "^1.12", // v1.13.0
        "symfony/asset": "7.1.*", // v7.1.6
        "symfony/asset-mapper": "7.1.*", // v7.1.9
        "symfony/console": "7.1.*", // v7.1.8
        "symfony/dotenv": "7.1.*", // v7.1.9
        "symfony/flex": "^2", // v2.4.7
        "symfony/framework-bundle": "7.1.*", // v7.1.6
        "symfony/http-client": "7.1.*", // v7.1.9
        "symfony/monolog-bundle": "^3.0", // v3.10.0
        "symfony/property-access": "7.1.*", // v7.1.6
        "symfony/property-info": "7.1.*", // v7.1.9
        "symfony/runtime": "7.1.*", // v7.1.7
        "symfony/serializer": "7.1.*", // v7.1.9
        "symfony/stimulus-bundle": "^2.13", // v2.22.0
        "symfony/twig-bundle": "7.1.*", // v7.1.6
        "symfony/ux-turbo": "^2.13", // v2.22.0
        "symfony/yaml": "7.1.*", // v7.1.6
        "symfonycasts/tailwind-bundle": "^0.7.1", // v0.7.1
        "twig/extra-bundle": "^2.12|^3.0", // v3.16.0
        "twig/twig": "^2.12|^3.0" // v3.16.0
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^3.6", // 3.7.1
        "symfony/debug-bundle": "7.1.*", // v7.1.6
        "symfony/maker-bundle": "^1.52", // v1.61.0
        "symfony/stopwatch": "7.1.*", // v7.1.6
        "symfony/web-profiler-bundle": "7.1.*", // v7.1.9
        "zenstruck/foundry": "^2.2" // v2.3.1
    }
}

Previous Challenge

Next Challenge