PHP rollbackUserTransaction示例

示例#1

文件： SiteObjectController.class.php 项目： BackupTheBerlios/limb-svn

 protected function _rollbackTransaction()
 {
   rollbackUserTransaction();
 }

示例#2

文件： DbMysqlTest.class.php 项目： BackupTheBerlios/limb-svn

  function testTransactions()
  {
    $db =& DbFactory :: instance();

    startUserTransaction();

    $db->sqlInsert("founding_fathers", array('first' => 'Richard', 'last' => 'Nixon', 'dog_name' => null));
    $db->sqlInsert("founding_fathers", array('first' => 'Richard', 'last' => 'Nixon2', 'dog_name' => null));
    $db->sqlInsert("founding_fathers", array('first' => 'Richard', 'last' => 'Nixon3', 'dog_name' => null));

    rollbackUserTransaction();

    $db->sqlSelect("founding_fathers", '*', 'last="Nixon"');
    $this->assertEqual(sizeof($db->getArray()), 0);

    startUserTransaction();

    $db->sqlInsert("founding_fathers", array('first' => 'Richard', 'last' => 'Nixon', 'dog_name' => null));
    $db->sqlInsert("founding_fathers", array('first' => 'Richard', 'last' => 'Nixon2', 'dog_name' => null));
    $db->sqlInsert("founding_fathers", array('first' => 'Richard', 'last' => 'Nixon3', 'dog_name' => null));

    commitUserTransaction();

    $db->sqlSelect("founding_fathers", '*', 'last="Nixon" OR last="Nixon2" OR last="Nixon3"');
    $this->assertEqual(sizeof($db->getArray()), 3);

    startUserTransaction();

    $db->sqlInsert("founding_fathers", array('first' => 'Richard', 'last' => 'Nixxxxx', 'dog_name' => null));

    $db->sqlSelect("founding_fathers", '*', 'last="Nixxxxx"');
    $arr = $db->getArray();
    $this->assertEqual(sizeof($arr), 1);
    $this->assertEqual($arr[0]['last'], 'Nixxxxx');

    rollbackUserTransaction();

    $db->sqlSelect("founding_fathers", '*', 'last="Nixxxxx"');
    $arr = $db->getArray();
    $this->assertEqual(sizeof($arr), 0);
  }