在laravel中实现事务回滚的方法
吾爱主题
阅读:170
2021-08-30 14:15:00
评论:0
之前做项目用到了事务回滚这个机制。我把代码贴出来多多交流给点意见,我用的是laravel 5.1bane版本的,
?1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | public static function createDeal( $to_status , $params , $new_balance , $update = true) { \DB::beginTransaction(); try { $update_order_status = \DB::table( 'wallet_order' ) ->where( 'order_id' , $params [ 'order_id' ]) ->update([ 'to_status' => $to_status , 'update_time' => $params [ 'pay_time' ]]); if (! $update_order_status ) { throw new \Exception( "update order error" ); } $create_deal_status = \DB::table( 'wallet_deal' ) ->insert( $params ); if (! $create_deal_status ) { throw new \Exception( "create deal error" ); } if ( $update ) { $update_manage_status = self::updateManage([ 'balance' => $new_balance , 'update_time' => $params [ 'pay_time' ]], $params [ 'from_user' ]); if (! $update_manage_status ) { throw new \Exception( "update manage error" ); } } else { $manage_params = [ 'user_id' => intval ( $params [ 'from_user' ]), 'balance' => $new_balance , 'add_time' => $params [ 'pay_time' ], 'update_time' => $params [ 'pay_time' ], ]; $create_manage_status = self::createManage( $manage_params ); if (! $create_manage_status ) { throw new \Exception( "create manage error" ); } } \DB::commit(); } catch (\Exception $e ) { |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | //异常处理进行回滚,自己想对应的业务 \DB::rollback(); $trouble_params = [ 'order_id' => $params [ 'order_id' ], 'deal_id' => $params [ 'deal_id' ], 'from_user' => $params [ 'from_user' ], 'to_user' => $params [ 'to_user' ], 'total_amount' => $params [ 'total_amount' ], 'add_time' => $params [ 'pay_time' ], 'type' => $params [ 'type' ], 'to_status' => $to_status ]; \DB::connection( 'mongodb' ) ->table( 'wallet_trouble' ) ->insert( $trouble_params ); } finally { self::createLog( $params , $to_status ); } } |
以上这篇在laravel中实现事务回滚的方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持服务器之家。
原文链接:https://blog.csdn.net/chen529834149/article/details/77161485
声明
1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,请转载时务必注明文章作者和来源,不尊重原创的行为我们将追究责任;3.作者投稿可能会经我们编辑修改或补充。