Updating an Entity

It's a bit weird that it's not part of the tutorial since this is so important. I assume you need to write your own query to handle it so that it does an update and reads the current counter in a single query instead of separately, then theoretically there shouldn't be any race condition. You can use Doctrine's DQL for that, though I'm not sure where to put this query, inside the Entity?

Hey Anon,

Well, that's kinda performance and highload issue, this tutorial is not about it :) And it may depends on the query, so difficult to say. But all your queries are better to put into entity repository.

Cheers!

The query would be pretty simple, just something like UPDATE App\Entity\Article u SET u.heartCount = u.heartCount + 1 WHERE u.id = :article_id.

But since this is an update query, and all the examples in this tutorial are select queries, and all updates to entities seem to be done within entities I'm not sure what the proper place for an update query is. Maybe something to mention in the tutorial? Cheers for the response, I thought this comment would get lost since the other comments are a year old.

Hey there!

I think you can just place that query inside the corresponding repository class

// some entity repository
public function someUpdateMethod() 
{
$qb = $this->createQueryBuilder('u');
$qb->update()
        ->set('u.someField', 'new data')
        ->getQuery()
        ->execute();
}

Cheers!

Hey Mike P.

I wouldn't rely on the database for that feature because of what you said. It will increase the resources usage of the server (Unless you don't expect high traffic). The first thing that comes to my mind is to use Google Analytics to track all the searches performed and then consume their API to get a list of the searches, and cache the result for 10 minutes or so.
There might be better tools for what you want to do that I'm not aware of, so I recommend you to investigate a little bit before jumping to the implementation

Cheers!

Hey Robert

Looks like your route configured properly, looks like your ajax request not working, probably you may have errors in your browser console, can you check it?

Cheers!

Hey Oleksii V.

To fully delete an entity what you need to do is first delete the entity class file, and then create a migration that will DROP the related table of the entity
To change a property the flow is basically the same, you have to add a new property to the entity (add its metadata), and then create a migration that will update its table

I hope it helps. Cheers!

Thank You!

Hey toporovvv

Nice catch! Those code blocks were totally wrong, I've already fixed them :)

Have a nice day

Hey abdouniabdelkarim

Thanks for informing us! I already fixed it :)

Have a nice day