Best way to rollback or use transaction | Laravel | Page 1

faint forge Aug 2, 2024, 1:34 AM

#

I am creating a system which create 2 things. An organization in the organization table and a profile in the profile table.
The point would be that when you create an organization, it automatically creates you a profile.
So I have a route that creates an organization and one that create a profile. Should I call my route inside a transaction, should I call the static function instead of the route.
I am kinda lost and I wanna make sure that if one save() gets an error, everything is reversed. I read about transaction and rollback and I'm not really sure how to go

public function Create(Request $request)
{
    $validatedData = $request->validate([
        'address' => ['required', 'max:255'],
    ]);

    $org = new Organization();
    $org->address = $validatedData['address'];
    $org->save();
    // Create the profile would be here, be either calling the route or the function that is called by the route
}

Here is my orgnization function, it's really simple.
I just wanna make sure to go the right way and the most optimized one

lofty light Aug 2, 2024, 8:03 AM

#

To make sure you use transaction, use either the "callback" or the "functional" way :
https://laravel.com/docs/10.x/database#database-transactions

Then, if the only fact the creating an organization MUST create a new profile, use an event listener/Observer on the creating()/created() event.
https://laravel.com/docs/10.x/eloquent#observers

#

For avoiding duplicates, you can choose to create a "Service" class that could perform your double used action. Or create two actions for two situations (create from data array, or from organization data)

faint forge Aug 4, 2024, 7:12 PM

#

Thanks i'll look into that

faint forge Aug 6, 2024, 10:51 PM

#

lofty light To make sure you use transaction, use either the "callback" or the "functional" ...

Can I begin in a function and commit in an other if everything is successfull ? I was asking how I can make it work, like begin the transaction in my organization creation function and rollback in my profile creation function if there is a problem ?