/**
* 測(cè)試事務(wù)
*/
public function actionTest(){
//創(chuàng)建事務(wù)
$tr = Yii::$app->db->beginTransaction();
try {
for($i=1;$i<=3;$i++){
$test = new Areas();
$test->name = 'name'.$i;
$test->sort=1;
if($test->save()){
echo "save $i | ";
}
}
$test = new Areas();
$test->name = 'ab'.$i;
$test->sorta=1; //寫入不存在的字段
if(!$test->save()){
"save fail"; //如果沒有寫入就輸出
}
//提交
$tr->commit();
} catch (Exception $e) {
//回滾
$tr->rollBack();
echo "rollback";
}
}

save 1 | save 2 | save 3 | rollback

/**
* 測(cè)試事務(wù)
*/
public function actionTest(){
//創(chuàng)建事務(wù)
$tr = Yii::$app->db->beginTransaction();
try {
for($i=1;$i<=3;$i++){
$test = new Areas();
$test->name = 'name'.$i;
$test->sort=1;
if($test->save()){
echo "save $i | ";
}
}
$test = new Areas();
$test->name = null; //數(shù)據(jù)庫設(shè)計(jì)name不能為空,人為造成寫入失敗。
$test->sort=1; //寫入不存在的字段
if(!$test->save()){
echo "save fail"; //如果沒有寫入就輸出
}
//提交
$tr->commit();
} catch (Exception $e) {
//回滾
$tr->rollBack();
echo "rollback";
}
}

save 1 | save 2 | save 3 | save fail

/**
* 測(cè)試事務(wù)
*/
public function actionTest(){
//創(chuàng)建事務(wù)
$tr = Yii::$app->db->beginTransaction();
try {
for($i=1;$i<=3;$i++){
$test = new Areas();
$test->name = 'name'.$i;
$test->sort=1;
if($test->save()){
echo "save $i | ";
}
}
$test = new Areas();
$test->name = null; //數(shù)據(jù)庫設(shè)計(jì)name不能為空,人為造成寫入失敗。
$test->sort=1; //寫入不存在的字段
if(!$test->save()){
throw new \yii\db\Exception(); //手動(dòng)拋出異常,再由下面捕獲。
}
//提交
$tr->commit();
} catch (Exception $e) {
//回滾
$tr->rollBack();
echo "rollback";
}
}

save 1 | save 2 | save 3 | rollback

//Controller
/**
* 測(cè)試事務(wù)-注冊(cè)用戶
*/
public function actionReg()
{
//獲取請(qǐng)求
$request = Yii::$app->request;
//設(shè)定返回格式
$response = Yii::$app->response;
$response->format = \yii\web\Response::FORMAT_JSON; //返回json
//測(cè)試代碼,去掉驗(yàn)證身份步驟
$name = $request->get("name");
$gender = $request->get("gender");
$sign = $request->get("sign");
//測(cè)試代碼,省略參數(shù)校驗(yàn)步驟
$tr = Yii::$app->db->beginTransaction();
try {
//得到uid
$uid = App::getSeNo();
UserProfile::add($uid, $name, $gender, 1, $sign);
$user_balance = UserBalance::initUserBalance($uid);
$tr->commit(); //提交數(shù)據(jù)
} catch (Exception $e) {
//回滾
$tr->rollBack();
return $e->getMessage(); //返回自定義異常信息
}
return $user_balance;
}
//UserProfile
/**
* 添加用戶信息
* @param $user_id
* @param $nikename
* @param $gender
* @param $user_type
* @param string $intro
* @return UserProfile
* @throws \Exception
*/
public static function add($user_id, $nikename, $gender,$user_type,$intro="") {
$model = new UserProfile();
$model->gender = $gender;
$model->nikename = $nikename;
$model->user_id = $user_id;
$model->user_type=$user_type;
$model->intro=$intro;
$model->update_time = time();
$insert =$model->insert();
if(!$insert){
throw new Exception("沒有寫入用戶資料");
}
return $model;
}
//UserBalance
/**
* 初始化用戶的可提現(xiàn)余額
* @param $user_id
*/
public static function initUserBalance($user_id){
$info=self::find()->where(['user_id'=>$user_id])->one();
if(!$info ){
$model=new UserBalance();
$model->user_id = $user_id;
$model->price= "0";
$model->update_time=time();
$insert = $model->insert();
if(!$insert){
throw new Exception("沒有初始化用戶余額");
}
$info=$model;
}
return $info->attributes;
}

{"id":124,"user_id":1473179883,"price":"0","update_time":1473179883}

"沒有初始化用戶余額"

class Connection extends Component
{
// 保存當(dāng)前連接的有效Transaction對(duì)象
private $_transaction;
// 已經(jīng)緩存有事務(wù)對(duì)象，且事務(wù)對(duì)象有效，則返回該事務(wù)對(duì)象
// 否則返回null
public function getTransaction()
{
return $this->_transaction && $this->_transaction->getIsActive() ? $this->_transaction : null;
}
// 看看啟用事務(wù)時(shí)，是如何使用事務(wù)對(duì)象的
public function beginTransaction($isolationLevel = null)
{
$this->open();
// 緩存的事務(wù)對(duì)象有效，則使用緩存中的事務(wù)對(duì)象
// 否則創(chuàng)建一個(gè)新的事務(wù)對(duì)象
if (($transaction = $this->getTransaction()) === null) {
$transaction = $this->_transaction = new Transaction(['db' => $this]);
}
$transaction->begin($isolationLevel);
return $transaction;
}
}