PHP Connection::beginTransaction方法代码示例

 public function testTransactionCommit()
 {
     $this->createTable();
     $this->connection->beginTransaction();
     $this->connection->query("INSERT INTO cat (name, colour) VALUES (?, ?)", array('Nennek', 'black'));
     $this->connection->commit();
     $statement = $this->connection->query("SELECT count(*) AS c FROM cat");
     $row = $this->connection->fetch($statement);
     $count = array_shift($row);
     $this->assertEquals(3, $count);
 }

function importDataGuru($inputFileName, $idSekolah)
{
    try {
        /**  Identify the type of $inputFileName  **/
        $inputFileType = PHPExcel_IOFactory::identify($inputFileName);
        /**  Create a new Reader of the type that has been identified  **/
        $objReader = PHPExcel_IOFactory::createReader($inputFileType);
        /**  Load $inputFileName to a PHPExcel Object  **/
        $objReader->setReadDataOnly(true);
        $objPHPExcel = $objReader->load($inputFileName);
    } catch (Exception $e) {
        die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());
    }
    $worksheets;
    $conn;
    $nameSheet;
    $noRow = 0;
    try {
        $conn = new Connection();
        $conn->beginTransaction();
        $worksheets = $objPHPExcel->getAllSheets();
        $idGuru;
        foreach ($worksheets as $worksheet) {
            $nameSheet = $worksheet->getTitle();
            //guru
            $noRow = 2;
            while (true) {
                $username = $worksheet->getCell('B' . $noRow)->getCalculatedValue();
                $password = $worksheet->getCell('C' . $noRow)->getCalculatedValue();
                $nip = $worksheet->getCell('D' . $noRow)->getCalculatedValue();
                $nama = $worksheet->getCell('E' . $noRow)->getCalculatedValue();
                if ($username == null) {
                    break;
                }
                $idGuru = $conn->setGuru($nip, $nama, null, null, null, null, null, null, null, $username, $password, $idSekolah, null);
                //$idGuru=$conn->setGuru($nip, $nama, $tempatLahir, $tglLahir, $jk, $alamat, $telp, $hp, $email, $username, $password, $idSekolah, $foto);
                $noRow++;
            }
        }
        $conn->commit();
        echo 'Data import succesfully';
    } catch (Exception $e) {
        $conn->rollback();
        die('Error in Sheet ' . $nameSheet . ' row ' . $noRow . ' : ' . $e->getMessage());
    }
}

if ($_SESSION["level"] != "admin" && $_SESSION["level"] != "admin_sekolah") {
    die("<center> <h1> Forbidden Access </h1> </center>");
}
$conn = new Connection();
?>

<?php 
if (isset($_POST["btnSubmit"]) && $_POST["token"] == $_SESSION["token"]) {
    $judul = $_POST['judul'];
    $isi = $_POST['isi'];
    $idSekolah = null;
    if ($_SESSION["level"] == "admin_sekolah") {
        $idSekolah = $conn->isExistSekolah($_SESSION["idSekolah"]);
    }
    $idUser = $_SESSION['id'];
    $conn->beginTransaction();
    $conn->insertArtikel($judul, $isi, $idSekolah, $idUser);
    $conn->commit();
}
if (isset($_POST["btnSimpan"]) && $_POST["token"] == $_SESSION["token"]) {
    $idArtikel = $_POST['id'];
    $judul = $_POST['judul'];
    $isi = $_POST['isi'];
    $conn->beginTransaction();
    $conn->updateArtikelData($idArtikel, $judul, $isi);
    $conn->commit();
}
if (isset($_POST["btnDelete"]) && $_POST["token"] == $_SESSION["token"]) {
    $idArtikel = $_POST['id'];
    $conn->beginTransaction();
    $conn->deleteArtikel($idArtikel);

	/**
	 * Begin transaction.
	 */
	public function beginTransaction() {
		$this->connection->beginTransaction();
	}

 /**
  * Execute this migration version up or down and and return the SQL.
  *
  * @param string $direction   The direction to execute the migration.
  * @param string $dryRun      Whether to not actually execute the migration SQL and just do a dry run.
  * @return array $sql
  * @throws Exception when migration fails
  */
 public function execute($direction, $dryRun = false)
 {
     $this->_sql = array();
     $this->_connection->beginTransaction();
     try {
         $start = microtime(true);
         $this->_state = self::STATE_PRE;
         $fromSchema = $this->_sm->createSchema();
         $this->_migration->{'pre' . ucfirst($direction)}($fromSchema);
         if ($direction === 'up') {
             $this->_outputWriter->write("\n" . sprintf('  <info>++</info> migrating <comment>%s</comment>', $this->_version) . "\n");
         } else {
             $this->_outputWriter->write("\n" . sprintf('  <info>--</info> reverting <comment>%s</comment>', $this->_version) . "\n");
         }
         $this->_state = self::STATE_EXEC;
         $toSchema = clone $fromSchema;
         $this->_migration->{$direction}($toSchema);
         $this->addSql($fromSchema->getMigrateToSql($toSchema, $this->_platform));
         if ($dryRun === false) {
             if ($this->_sql) {
                 $count = count($this->_sql);
                 foreach ($this->_sql as $query) {
                     $this->_outputWriter->write('     <comment>-></comment> ' . $query);
                     $this->_connection->executeQuery($query);
                 }
             } else {
                 $this->_outputWriter->write(sprintf('<error>Migration %s was executed but did not result in any SQL statements.</error>', $this->_version));
             }
             if ($direction === 'up') {
                 $this->markMigrated();
             } else {
                 $this->markNotMigrated();
             }
         } else {
             foreach ($this->_sql as $query) {
                 $this->_outputWriter->write('     <comment>-></comment> ' . $query);
             }
         }
         $this->_state = self::STATE_POST;
         $this->_migration->{'post' . ucfirst($direction)}($toSchema);
         $end = microtime(true);
         $this->_time = round($end - $start, 2);
         if ($direction === 'up') {
             $this->_outputWriter->write(sprintf("\n  <info>++</info> migrated (%ss)", $this->_time));
         } else {
             $this->_outputWriter->write(sprintf("\n  <info>--</info> reverted (%ss)", $this->_time));
         }
         $this->_connection->commit();
         return $this->_sql;
     } catch (SkipMigrationException $e) {
         $this->_connection->rollback();
         // now mark it as migrated
         if ($direction === 'up') {
             $this->markMigrated();
         } else {
             $this->markNotMigrated();
         }
         $this->_outputWriter->write(sprintf("\n  <info>SS</info> skipped (Reason: %s)", $e->getMessage()));
     } catch (\Exception $e) {
         $this->_outputWriter->write(sprintf('<error>Migration %s failed during %s. Error %s</error>', $this->_version, $this->getExecutionState(), $e->getMessage()));
         $this->_connection->rollback();
         $this->_state = self::STATE_NONE;
         throw $e;
     }
     $this->_state = self::STATE_NONE;
 }