Laravel 5.1：如何执行一系列交易？

Question

I have the follow relationships: A Student has a "one-to-one" relationship with a Person. A Person has a "many-to-many" relationship with Address.

I want to persist the data: first create the Person, after create the Addresses and then create the Student.

But I want to rollback the transations if any error occur during the persistence in any of these tables. Ex.: If I save the Person and the Addresses, and the Student fails, I want to rollback everything.

How to handle this with Eloquent?

Thanks.

Answer 1

Laravel provides vary simple way to handle this kind of situation.

DB::transaction(function () {
    //all your codes 
});

From laravel Documentation :

To run a set of operations within a database transaction, you may use the transaction method on the DB facade. If an exception is thrown within the transaction Closure, the transaction will automatically be rolled back. If the Closure executes successfully, the transaction will automatically be committed. You don't need to worry about manually rolling back or committing while using the transaction method.

Also if you want to do it manually , you can do it using

    DB::beginTransaction();
    //your codes
    DB::commit();

To learn more about transactions, read official document Here