doudi2431
2017-10-23 08:05
浏览 756
已采纳

Laravel:如何验证DB :: transaction函数是否正常工作?

I have used DB::transaction function in my controller like this,

public function store(){        
    $plant = new Plant;

    DB::transaction(function()
    {
        Plant::create(request(['name','plant_code','place']));    
    });    
}

I want to know the way I have used the function is ok and i need to verify is it working correctly?

图片转代码服务由CSDN问答提供 功能建议

我在我的控制器中使用了 DB :: transaction 这样的函数,

  public function store(){
 $ plant = new Plant; 
 
 DB :: transaction(function()
 {
 Plant :: create(request([  'name','plant_code','place'])); 
});  
} 
   
 
 

我想知道我使用该功能的方式是否正常,我需要验证它是否正常工作? < / DIV>

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

  • douhua1760 2017-10-23 08:46
    最佳回答

    As the documentation illustrate you have two choices :

    1. Automatic transaction with Closure :

    You may use the transaction method on the DB facade to run a set of operations within a database transaction. 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

    DB::transaction(function () {
        // Interacting with the database
        DB::insert(...);
        DB::insert(...);
        DB::insert(...);
    });
    
    1. Manually Using Transactions :

    If you would like to begin a transaction manually and have complete control over rollbacks and commits, you may use the beginTransaction method on the DB facade:

    DB::beginTransaction();
    

    You can rollback the transaction via the rollBack method:

    DB::rollBack();
    

    Lastly, you can commit a transaction via the commit method:

    DB::commit();
    

    The manually use of the transactions is linked to the try catch block like this :

    DB::beginTransaction();
    
    try {
        // Interacting with the database
        DB::insert(...);
        DB::insert(...);
        DB::insert(...);
    
        DB::commit();    // Commiting  ==> There is no problem whatsoever
    } catch (\Exception $e) {
        DB::rollback();   // rollbacking  ==> Something went wrong
    }
    

    For testing the transaction you can run your example without throwing any exception ==> expected result : all fine the Plant will be created.

    And if you throw an exception the transaction will be rollbacked and the Plant will not be created in the database :

    public function store(){        
        $plant = new Plant;
    
        DB::transaction(function()
        {
            Plant::create(request(['name','plant_code','place']));    
            throw new ModelNotFoundException("Just for testing :)");
        });    
    }
    

    Add use Illuminate\Database\Eloquent\ModelNotFoundException; at the top of the controller ;)

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题