国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

PHP框架是如何處理MySQL事務(wù)多次開啟和事務(wù)操作嵌套的?求框架源碼
迷茫
迷茫 2017-04-10 17:23:03
0
2
782

一般的PHP框架是如何處理MySQL事務(wù)多次開啟和事務(wù)操作嵌套的?求框架源碼

迷茫
迷茫

業(yè)精于勤,荒于嬉;行成于思,毀于隨。

reply all(2)
左手右手慢動(dòng)作

哈哈,最近剛把這個(gè)功能提交到ThinkPHP主線上,原理是記錄事務(wù)的嵌套數(shù)量,只在最外層提交事務(wù)。你可以參考參考:

public function startTrans()
{
    $this->initConnect(true);
    if (!$this->_linkID) {
        return false;
    }
    //數(shù)據(jù)rollback 支持
    if (0 == $this->transTimes) {
        // 記錄當(dāng)前操作PDO
        $this->transPdo = $this->_linkID;
        $this->_linkID->beginTransaction();
    }
    $this->transTimes++;
    return;
}

public function commit()
{
    if ($this->transTimes == 1) {
        // 由嵌套事物的最外層進(jìn)行提交
        $result = $this->_linkID->commit();
        $this->transTimes = 0;
        $this->transPdo = null;
        if (!$result) {
            $this->error();
            return false;
        }
    } else {
        $this->transTimes--;
    }
    return true;
}

public function rollback()
{
    if ($this->transTimes > 0) {
        $result = $this->_linkID->rollback();
        $this->transTimes = 0;
        $this->transPdo = null;
        if (!$result) {
            $this->error();
            return false;
        }
    }
    return true;
}

https://github.com/youmingdot/thinkphp/blob/master/ThinkPHP/Library/Think/Db/Driver.class.php#L267-L328

大家講道理

https://github.com/yeaha/owl/blob/master/src/Service/DB/Adapter.php#L132-L183

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template