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

08.

Persisting to the Database

|

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

19 Comments

Sort By

Login or Register to join the conversation

MattWelander 3 years ago

I am editing an entity, and upon some manual validation error I want to write a log message to the DB, but when I flush that message, the entity under editing is also flushed to DB. I have tried entityManager->clear() but that throws errors about entity configuration (seems like I need additional cascade configuration on my entities in order to use that).

Is there no simple way of just reversing the entityManager->persist()?

What I want is to be able to NOT persist some of the entities previously called ->persist() on (or fetched from the DB thus automatically being persisted).

Code:

public function editAction(Request $request, price $price)
{
    $deleteForm = $this->createDeleteForm($price);
    $editForm = $this->createForm(\App\Form\priceType::class, $price);
    $editForm->handleRequest($request);

    if ($editForm->isSubmitted() && $editForm->isValid()) {
        
        //check start before stop
        if ( $price->getDateFrom() >= $price->getDateTo()) {
            //$this->em->clear(); //not working
            $this->helper->flash('fail','Du kan inte sätta prisavtalets startdatum till efter eller samma som dess slutdatum, då skulle det inte tillämpas på någon extraöppning.',$price->getACRGroup());
            return $this->render('price/edit.html.twig', array(
                'price' => $price,
                'edit_form' => $editForm->createView(),
                'delete_form' => $deleteForm->createView(),
            ));
        }

    public function flash($type,$message,$unit=null) {        

        //REMEMBER when using this logger - use it AFTER your entity work is done (either flushed or $em->clear()

        // currently $type can be 'success', 'fail' or 'warning'.

        //find out (from services.yaml) if this install is set up to store every message (fails and warnings also) or just success (success means something was changed so always store a log on that)
        if (
            ($type == 'fail' && $this->globalParameters->get('systemlog_save_errors') == 0)
            ||
            ($type == 'warning' && $this->globalParameters->get('systemlog_save_warnings') == 0)
            ) {
            return false;
        }
        
        if ($type == 'fail') {
            $type = 'error';
        }

        //This is important as the flush() below will otherwise flush ANY ENTITY IN EDIT unless that was explicitly removed from entityManager ( $em->clear() ). DANGER! You will easily and inadvertently save unverified data.
        /*
        if ($type == 'error') {
            $this->em->clear(); //not working
        }
        */

        //create log entry
        $em = $this->em;
        $now = new \DateTime("now");
        
        $entity  = new Systemlog();
        $entity->setACRGroup($unit);
        $entity->setemail($this->security->getUser()->getEmail());
        $entity->setTime($now);
        $entity->setEventType($type);
        $entity->setEventMessage($message);
        
        $em->persist($entity);
        $em->flush();
    }

|

weaverryan SFCASTS MattWelander 3 years ago

Hey Matt!

Yea, this is a weird thing about Doctrine... it doesn't "come up" much, but it is a bit inflexible :/. You could, at one point, call $em->flush($entity), but that was deprecated and apparently was never guaranteed to work.

What I sometimes do in this situation is opt for a quick, manual, DQL insert query for the log entry, instead of creating and persisting an entity. I don't do this frequently, but it's an option.

Is there no simple way of just reversing the entityManager->persist()?

I have very little experience using this, but I believe this is what detach() is for:

$em->detach($price);

Let me know if that works :).

Cheers!

|

PZon 3 years ago

Hi.
Sorry I bother you, but I'm stuck on this chapter. When I try to run app with "new" method I got an error:

PDOException>Exception>DriverException
An exception occurred in the driver: could not find driver
in C:\xampp\htdocs\symfonycast\cauldron_overflow\vendor\doctrine\dbal\src\Driver\API\PostgreSQL\ExceptionConverter.php (line 87)

    // We have to match against the SQLSTATE in the error message in these cases.
    if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
        return new ConnectionException($exception, $query);
    }
    return new DriverException($exception, $query);
}

}

Sorry I don't know what cause an error?
I would be grateful for your help.

|

Jesse-Rushlow PZon 3 years ago

Howdy!

No bother at all! This sounds like your PHP instance does not have the required PDO drivers to interact with a database. A quick way to check, in a terminal run php -i | grep "pdo" & you should see something similar to:

Configure Command =>  './configure'  '--with-openssl' '--with-pdo-pgsql' '--with-zlib' '--with-pdo-mysql' '--with-curl' '--with-zip' '--enable-intl' '--enable-mbstring' '--with-sodium' '--enable-gd'
API Extensions => pdo_mysql
pdo_mysql
pdo_mysql.default_socket => /tmp/mysql.sock => /tmp/mysql.sock
pdo_pgsql
pdo_sqlite

Couple of questions to get those installed if they're missing:

1) What version of PHP are you using? php -v Will show you.
2) What Operating System are you using
3) Do you remember how you installed PHP onto your computer? e.g. using apt-get install php or compiled PHP source code, etc..

Thank You!

|

PZon Jesse-Rushlow 3 years ago

Hi. Thanks for quick response.

Answers:
ad1.
c:\xampp\htdocs\symfonycast\cauldron_overflow>php -v<br />PHP 7.4.24 (cli) (built: Sep 21 2021 13:38:25) ( ZTS Visual C++ 2017 x64 )<br />Copyright (c) The PHP Group<br />Zend Engine v3.4.0, Copyright (c) Zend Technologies
ad2. Windows 11
ad3. I have installed PHP with XAMPP

And maybe some useful info regarding PDO:
PDO
PDO support => enabled
PDO drivers => mysql, sqlite
pdo_mysql
PDO Driver for MySQL => enabled
Client API version => mysqlnd 7.4.24
pdo_sqlite
PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.31.1

thanks a million

|

Jesse-Rushlow PZon 3 years ago

Awesome! That's very helpful. I think instead of trying to install the Postgres PDO driver for PHP, you might be better off using MySQL/MariaDB seeing as XAMPP already has that configured for you.

In your .env file, you should have a DATABASE_URL="postgresql........." line and right above/below you'll see another that is commented out: # DATABASE_URL="mysql.........". Remove the comment from the mysql line and add it to the postgresql line. This tells Symfony to use MySQL/MariaDB instead of Postgres. You'll need to set the correct username, password, host, etc to match XAMPP's configuration. But this should get you on the right track.

If you really want to stick with Postgres, and that's not a bad thing, you'll need to install postgres for windows if it's not already installed: https://www.postgresql.org/download/windows/ I'd recommend either version 13 or 14 for now. Then uncomment the following lines in your php.ini file:

extension=php_pdo_pgsql.dll
extension=php_pgsql.dll

And, if I'm not mistaken, add LoadFile "C:\xampp\php\libpq.dll" to your httpd.conf ensuring that the path is correct to libpq.dll.

Restarting XAMPP and running php -i | grep "pdo" will tell you if you have the PDO_PGSQL configured correctly.

I hope this helps, but do let use know if you have any trouble!

|

Tim C. 4 years ago

So, I'm trying to run all this stuff on a separate CENTOS box than my local machine, and for the most part everything is working as intended as I go through the tutorials. I have a tomcat running that I use as a URL instead of localhost.

But I can't for the life of me get the persist to the DB working.

I have the docker running.
I can connect to the docker shell and run MYSQL and everything as expected.
The problem comes when I try to persist to the DB. I get a connection refused error, which I am assuming is because it can't find the DB.

I've tried replacing the URL (@127.0.0.1:3306) with the URL I am running via apache (@http://cauldron.server.local:3306) but that hasn't worked.

I could use some help. Running using localhost just isn't an option for me.

|

Victor SFCASTS Tim C. 4 years ago

Hey Tim,

Please, double-check the DB credentials you're using, i.e. check DATABASE_URL in your .env and .env.local files. Make sure that you entered the valid credentials - not only DB host and port, but also username and password. something like this:

DATABASE_URL="mysql://db_user:db_password@127.0.0.1:3306/db_name?serverVersion=5.7&charset=utf8mb4"

Try to use the correct IP instead of that cauldron.server.local, it may help as well. Btw, do you use MySQL as your DB provider? I'd also recommend you to double-check your DB credentials with a MySQL GUI client - fill the credentials you're using there and try to connect. Most probably your credentials are just invalid. But if you can connect there - just use the same credentials for DATABASE_URL (don't forget to make changes in all .env files where you set DATABASE_URL just in case).

There's another option to use Docker locally for running this project. Probably take a look?

Cheers!

|

Tim C. Victor 4 years ago

No, I know the credentials are correct. I was just giving a shortened database_url above to show the area that I think needed to be looked at. As I said above I can connect through the docker shell using the same credentials that I have in the database_url. Truth is I don't even think it is getting far enough to worry about the credentials yet, it isn't even getting as far as finding the DB to ask for credentials.

I guess what I am asking is if I run the docker with the MySQL (Yes it is MySQL) is it going to use the same apache/tomcat and use the same URL as the project itself or do I need to set up a conf.d file for the dockerised port, or something else entirely? I am not the most knowledgeable when it comes to tomcat/apache and know just enough to get things mostly working for a project and I can /usually/ figure it out, but this one has me stumped.

UPDATE:
It's moot now. I found an online MySQL host and am using that now without worrying about Docker.

|

Jakub 5 years ago

Why symfony doesn't see Question.php as a part of a project? It doesn't want to autocomplete the use statement and it even don't see it at all

|

Victor SFCASTS Jakub 5 years ago

Hey HudyWeas,

I'm not sure, if you could provide a screenshot so I could better understand what you mean about "as a part of a project". But as I replied to another your comment - please, make sure you have PhpStorm's Symfony plugin installed and enabled for your project - it gives you most of the autocompletion in projects based on Symfony.

Cheers!

|

Assist software 5 years ago

Hello
I'm new to the symfony world and I encountered a problem at
$entityManager->persist($question);
I did exactly as in the tutorial and I came across this error:
An exception occurred in driver: could not find driver

Doctrine\DBAL\Exception\
DriverException

Doctrine\DBAL\Driver\PDO\
Exception
could not find driver

PDOException
could not find driver

I have the database on the docker because I did not install mysql locally
but I can connect to it
I don't understand what the problem is
I tried to add the extension pdo_mysql in php.ini but without success I use ubuntu and I am new in this operating system :)

PS: sorry for my english

|

sadikoff Assist software 5 years ago edited

Hey Assist software

Which php version are you using? is it installed on the OS? if it's OS package, than you should install php-mysql extension and it will add PDO drive, you can do it with sudo apt-get install php-mysql

Cheers!

|

Maike L. 5 years ago edited

hi again,
I get this error when trying to flush:
An exception occurred in driver: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

this is my databse url:
<br /> DATABASE_URL="mysql:/root:password@127.0.0.1:3306/db_name?serverVersion=5.7"<br />

my password is correct.

any ideas?

|

Victor SFCASTS Maike L. 5 years ago edited

Hey Payman,

Yes, you clearly does not have access with the given credentials. Are you sure that those credentials are used for the Symfony environment you're trying to load your application with? If so, please, make sure they are really valid, like check the host, port, database name, user and password. Also, the way you wrote it is incorrect, it should have 2 slashes after "mysql", i.e.:


DATABASE_URL="mysql://root:password@127.0.0.1:3306/db_name?serverVersion=5.7"

I hope this helps! If not, probably you don't have needed permissions for root user, I mean it might not be allowed to access the DB from your PHP script. The easiest solution would be to create another user, e.g. name it "admin" and grant all the necessary permissions to it, then update the DATABASE_URL.

Cheers!

|

akincer 5 years ago edited

Using single quotes like in this video to query on the CLI resulted in the error:

Too many arguments, expected arguments "command" "sql".

Switching to double quotes fixed it though.

|

MolloKhan SFCASTS akincer 5 years ago

Hey there,

That's weird, maybe it's related to your shell, or you may have had a non-closed quote?

|

akincer MolloKhan 5 years ago

I'm doing this on Windows 10 so I'm sure it's the shell.

|

MolloKhan SFCASTS akincer 5 years ago

I'd think the same. Windows just don't like to work as expected :D

|

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