Working with Database Transactions.

Original message was deleted

tuto1902•9/13/23, 3:35 PM

If I understand correctly. You need to update the stock_qty every time there's an insert/update on the item_restock table, grabbing the sum of item_restock.restock_qty and saving it to items.stock_qty. Am I right?

If that's the case, you could combine model observers with database transactions. Observing the createdcreated and updatedupdated events on the ItemRestock model and using transactions to update the Items model

Transactions are very simple:

use Illuminate\Support\Facades\DB;
 
DB::transaction(function () {
    // do your updates here
});

use Illuminate\Support\Facades\DB;
 
DB::transaction(function () {
    // do your updates here
});

Here are the links for both subjects (Observers and Transactions)
https://laravel.com/docs/10.x/database#database-transactions
https://laravel.com/docs/10.x/eloquent#observers

Laravel - The PHP Framework For Web Artisans

Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.

Laravel - The PHP Framework For Web Artisans

Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.

tuto1902•9/13/23, 4:18 PM

Not sure about checking for them but you can use atomic locks to fight them. Here's a video explaining how the work
(Povilas to the rescue)
https://www.youtube.com/watch?v=zybiFatkoCo

YouTubeLaravel Daily

Laravel: Avoid Race Conditions with Atomic Locks in Cache

Example of when/how race conditions happen and one way to avoid them.

Official Docs on Atomic Locks: https://laravel.com/docs/9.x/cache#atomic-locks

- - - -
      Support the channel by checking out my products:
My Laravel courses: https://laraveldaily.com/courses?mtm_campaign=20230122-youtube-atomic-locks
Laravel QuickAdminPanel: https://quic...

Working with Database Transactions.

Similar Threads

Similar Threads

Similar Threads