PHP Transaction::execute方法代码示例

 public function drop($playerId)
 {
     $t = new Transaction();
     // Award any outstanding match to the opposing player.
     $sql = 'SELECT match_id ' . 'FROM player_match ' . 'WHERE wins IS NULL AND player_id = ' . Q($playerId);
     $matchId = D()->value($sql, null);
     if ($matchId !== null) {
         $sql = 'UPDATE player_match ' . 'SET wins = 0 ' . 'WHERE match_id = ' . Q($matchId) . ' AND player_id = ' . Q($playerId);
         $t->execute($sql);
         $sql = 'UPDATE player_match ' . 'SET wins = 1 ' . 'WHERE match_id = ' . Q($matchId) . ' AND player_id <> ' . Q($playerId);
         $t->execute($sql);
     }
     // Drop player from any unstarted events.
     $sql = 'DELETE pe ' . 'FROM player_event AS pe ' . 'INNER JOIN event AS e ON pe.event_id = e.id ' . 'WHERE NOT started AND player_id = ' . Q($playerId);
     $t->execute($sql);
     // Drop player from any started events.
     $sql = 'UPDATE player_event ' . 'SET dropped = TRUE ' . 'WHERE player_id = ' . Q($playerId) . ' AND event_id IN (SELECT event_id FROM event WHERE NOT finished)';
     $t->execute($sql);
     return $t->commit();
 }

 public function report($wins, $opponentWins)
 {
     if (!$this->awaitingResult()) {
         $msg = 'Tried to report when not awaiting result.';
         throw new IllegalStateException($msg);
     }
     $t = new Transaction();
     $entries = [$this->playerId => $wins, $this->opponentId => $opponentWins];
     foreach ($entries as $playerId => $playerWins) {
         $sql = 'UPDATE player_match SET wins = ' . Q($playerWins) . ' WHERE match_id = ' . Q($this->matchId) . ' AND player_id = ' . Q($playerId);
         $t->execute($sql);
     }
     $t->commit();
 }

   /**
    * Test if we get an error back, if we violate a unique constraint
    */
   public function testCreateAndExecuteTransactionWithTransactionErrorUniqueConstraintOnSave()
   {
       if (isCluster($this->connection)) {
           // don't execute this test in a cluster
           return;
       }
       $writeCollections = array($this->collection1->getName());
       $readCollections = array($this->collection2->getName());
       $action = '
 function () {
   var db = require("internal").db;
   db.' . $this->collection1->getName() . '.save({ _key : "hello" });
   db.' . $this->collection1->getName() . '.save({ _key : "hello" });
 }';
       $transaction = new Transaction($this->connection);
       $transaction->setWriteCollections($writeCollections);
       $transaction->setReadCollections($readCollections);
       $transaction->setAction($action);
       $e = null;
       try {
           $transaction->execute();
       } catch (ServerException $e) {
       }
       $details = $e->getDetails();
       $expectedCutDownMessage = "unique constraint violated";
       $this->assertTrue($e->getCode() == 400 && strstr($details['errorMessage'], $expectedCutDownMessage) !== false, 'Did not return code 400 with first part of the message: "' . $expectedCutDownMessage . '", instead returned: ' . $e->getCode() . ' and "' . $details['errorMessage'] . '"');
   }