PHP Connection::beginTransaction方法代码示例

 /**
  * Return next job from the queue.
  * @return Job|boolean the job or false if not found.
  */
 protected function fetchJob()
 {
     //Avoiding multiple job.
     $transaction = $this->db->beginTransaction();
     $row = $this->fetchLatestRow();
     if ($row == false || !$this->flagRunningRow($row)) {
         $transaction->rollBack();
         return false;
     }
     $transaction->commit();
     $job = $this->deserialize($row['data']);
     $job->id = $row['id'];
     $job->header['timestamp'] = $row['timestamp'];
     return $job;
 }

 /**
  * 批量插入订单的基本信息
  * @param array $orderBaseArray
  * @throws \yii\db\Exception
  */
 public function insertOrderBase(array $orderBaseArray)
 {
     if (!empty($orderBaseArray)) {
         $tableName = 't_oms_order';
         $tableFields = [];
         $tableValues = [];
         foreach ($orderBaseArray as $orderBase) {
             if (empty($tableFields)) {
                 $tableFields = array_keys($orderBase);
             }
             $tableValues[] = array_values($orderBase);
         }
         $transaction = $this->db->beginTransaction();
         $this->db->createCommand()->batchInsert($tableName, $tableFields, $tableValues)->execute();
         $transaction->commit();
     }
 }

 /**
  * Starts a transaction.
  * @param string|null $isolationLevel The isolation level to use for this transaction.
  * See [[Transaction::begin()]] for details.
  * @return Transaction the transaction initiated
  */
 public function beginTransaction($isolationLevel = null)
 {
     $transaction = parent::beginTransaction(null);
     if ($isolationLevel !== null) {
         $transaction->setIsolationLevel($isolationLevel);
     }
     return $transaction;
 }

 /**
  * Applies migration
  *
  * @param array $migration
  * @return void
  * @throws \yii\db\Exception
  */
 protected function applyMigration($migration)
 {
     ob_start();
     if ($this->direction == 'up') {
         $appliedMigrations = $this->getAppliedMigrations();
         if (!isset($appliedMigrations[$migration['name']])) {
             $migrateObj = $this->createMigration($migration);
             if (method_exists($migrateObj, 'safeUp')) {
                 $transaction = $this->_db->beginTransaction();
                 try {
                     if ($migrateObj->safeUp() !== false) {
                         $this->addMigrationHistory($migration);
                         $transaction->commit();
                     } else {
                         $transaction->rollBack();
                     }
                 } catch (Exception $e) {
                     $transaction->rollBack();
                     $this->error = $e;
                 }
             } else {
                 try {
                     if ($migrateObj->up() !== false) {
                         $this->addMigrationHistory($migration);
                     }
                 } catch (Exception $e) {
                     $this->error = $e;
                 }
             }
         }
     } elseif ($this->direction == 'down') {
         $migrateObj = $this->createMigration($migration);
         if (method_exists($migrateObj, 'safeDown')) {
             $transaction = $this->_db->beginTransaction();
             try {
                 if ($migrateObj->safeDown() !== false) {
                     $this->removeMigrationHistory($migration);
                     $transaction->commit();
                 } else {
                     $transaction->rollBack();
                 }
             } catch (Exception $e) {
                 $transaction->rollBack();
                 $this->error = $e;
             }
         } else {
             try {
                 if ($migrateObj->down() !== false) {
                     $this->removeMigrationHistory($migration);
                 }
             } catch (Exception $e) {
                 $this->error = $e;
             }
         }
     }
     ob_end_clean();
 }

 /**
  * Обновление базы данных
  */
 public function import(array $translateArray)
 {
     $query = new Query();
     $transaction = $this->_db->beginTransaction();
     try {
         // Обходим каждую категорию
         foreach ($translateArray as $category => &$messages) {
             // обходим каждую константу
             foreach ($messages as $constant => &$message) {
                 // Достаем константу с переводов в указанной категории
                 $selectCategory = $query->from($this->_sourceMessageTable)->where(['category' => $category, 'message' => $constant])->createCommand($this->_db)->queryOne();
                 // Если такая константа уже существует, необходимо обновить перевод
                 if ($selectCategory) {
                     $constantId = $selectCategory['id'];
                 } else {
                     // Если такой константы нет, создадим ее
                     $insert = $this->_db->createCommand()->insert($this->_sourceMessageTable, ['category' => $category, 'message' => $constant])->execute();
                     $constantId = $this->_db->lastInsertID;
                 }
                 // обходим каждый перевод сообщения
                 foreach ($message as $lang => &$translate) {
                     // Достаем перевод исходя из константы и языка
                     $selectTranslate = $query->from($this->_messageTable)->where(['id' => $constantId, 'language' => $lang])->createCommand($this->_db)->queryOne();
                     // Если такой перевод есть, небходимо его обновить
                     if ($selectTranslate) {
                         // Обновляем только в том случае, если действительно есть изменения
                         if ($selectTranslate['translation'] !== $translate && $this->_update) {
                             $update = $this->_db->createCommand()->update($this->_messageTable, ['translation' => $translate], ['id' => $constantId, 'language' => $lang])->execute();
                         }
                     } else {
                         // Если перевода нет, вносим его
                         $insert = $this->_db->createCommand()->insert($this->_messageTable, ['id' => $constantId, 'language' => $lang, 'translation' => $translate])->execute();
                     }
                 }
             }
         }
         $transaction->commit();
         return true;
     } catch (\Exception $e) {
         $transaction->rollBack();
         throw new InvalidParamException($e->getMessage());
     }
 }

 /**
  * @param int|string $userId
  * @param string $key
  * @return bool
  * @throws \yii\db\Exception
  */
 public function delete($userId, $key)
 {
     $transaction = $this->db->beginTransaction();
     $result = $this->deleteFromDb($userId, $key) && $this->deleteFromCache($userId, $key);
     if ($result) {
         $transaction->commit();
     } else {
         $transaction->rollBack();
     }
     return $result;
 }

 public function beginTransaction()
 {
     $this->db->beginTransaction();
 }

 /**
  * @throws \yii\base\InvalidConfigException
  * @throws \yii\db\Exception
  */
 public function actionUpdate()
 {
     $assignments = $this->getAllAssignments();
     $useTransaction = $this->authManager instanceof \yii\rbac\DbManager && $this->useTransaction === true;
     $transaction = null;
     if ($useTransaction) {
         $transaction = $this->db->beginTransaction();
     }
     try {
         $this->authManager->removeAll();
         $this->updateRules();
         $this->updateRoles();
         $this->updatePermission();
         $this->updateInheritanceRoles();
         $this->updateInheritancePermissions();
         if (!empty($assignments)) {
             $this->restoreAssignments($assignments);
         }
         if ($transaction !== null) {
             $transaction->commit();
         }
     } catch (\Exception $e) {
         $this->stderr($e->getMessage() . PHP_EOL);
         if ($transaction !== null) {
             $transaction->rollBack();
         }
     }
     if ($this->authManager instanceof \yii\rbac\DbManager) {
         $this->authManager->invalidateCache();
     }
 }