duanlangwen9597 2017-07-21 07:39
浏览 587
已采纳

如何在laravel中使用db transaction?

I try this :

public function destroy($id)
{
    DB::beginTransaction();
    try {
        $product = $this->product_repository->find($id);
        $result = $product->categories()->detach();
        if($result) {
            list($status,$instance) = $this->product_repository->delete($id);
        }
        DB::commit();
        return ['status'=>true,'data'=>$status];
    } catch (\Exception $e) {
        DB::rollback();
        return ['status'=>false, 'message'=>$e->getMessage()];
    }
}

If the code executed, $this->product_repository->delete($id) not work / not success delete.

But this : $product->categories()->detach();, it works / success deleted.

How to if delete product failed, delete category also failed?

  • 写回答

2条回答 默认 最新

  • dongpao1926 2017-07-21 07:42
    关注

    You can't add return statement inside transaction that halts entire process and DB::rollback() is executed.

    To switch the return, You can define a boolean variable and make false while you catch exception.

    Like this:

    public function destroy($id)
    {
    
        $success = true;
    
        DB::beginTransaction();
    
        try{
    
            // Your Code
    
            $product = $this->product_repository->find($id);
            $result = $product->categories()->detach();
    
            if($result) {
                list($status,$instance) = $this->product_repository->delete($id);
            }
    
            DB::commit();
    
        }catch(\Exception $e){
    
            DB::rollback();
    
            $success = false;
    
        }
    
        if($success){
            // Return data for successful delete
        }
    
        else{
            // Return data for unsuccessful delete
        }
    }
    

    Hope you understand.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥30 用arduino开发esp32控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿