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);
}
/**
* Tests explicit commit function.
*/
public function testCommit()
{
// by default auto-commit is TRUE.
$exch = DriverTestManager::getExchange('RecordCount');
$count_sql = $exch->getSql();
$rs = $this->conn->executeQuery($count_sql, ResultSet::FETCHMODE_NUM);
$rs->next();
$total = $rs->getInt(1);
// $this->assertEquals((int) $exch->getResult(), $total);
// now begin a transaction
$this->conn->setAutoCommit(false);
$exch = DriverTestManager::getExchange('ConnectionTest.setAutoCommit.DELTRAN1');
$deleted1 = $this->conn->executeUpdate($exch->getSql());
$exch = DriverTestManager::getExchange('ConnectionTest.setAutoCommit.DELTRAN2');
$deleted2 = $this->conn->executeUpdate($exch->getSql());
$total_should_be = $total - ($deleted1 + $deleted2);
$this->conn->commit();
// compare the actual total w/ what we expect
$rs = $this->conn->executeQuery($count_sql, ResultSet::FETCHMODE_NUM);
$rs->next();
$new_actual_total = $rs->getInt(1);
$this->assertEquals($total_should_be, $new_actual_total, 0, "Failed to find correct num of records after explicit transaction commit.");
$this->conn->setAutoCommit(true);
}
/**
* Commit a transaction. This method takes care of releasing the
* connection after the commit. In databases that do not support
* transactions, it only returns the connection.
*
* @param Connection $con The Connection for the transaction.
* @return void
* @throws PropelException
*/
public static function commit($con)
{
if ($con === null) {
throw new PropelException(
"Connection object was null. "
. "This could be due to a misconfiguration. "
. "Check the logs and Propel properties "
. "to better determine the cause.");
}
try {
if ($con->getAutoCommit() === false) {
$con->commit();
$con->setAutoCommit(true);
}
} catch (SQLException $e) {
throw new PropelException($e);
}
}
/**
* Unlocks the specified table.
*
* @param Connection $con The Creole connection to use.
* @param string $table The name of the table to unlock.
* @throws SQLException No Statement could be created or executed.
*/
public function unlockTable(Connection $con, $table)
{
// Tables in Sybase are unlocked when a commit is issued. The
// user may have issued a commit but do it here to be sure.
$con->commit();
}
}
$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);
$conn->commit();
}
/**
* @see Connection::commit()
*/
public function commit()
{
$this->log("Committing transaction.");
return $this->childConnection->commit();
}
/**
* Commit transaction.
*/
public function commit() {
$this->connection->commit();
}
/**
* 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;
}
public function commit()
{
if ($this->_connection) {
$this->_connection->commit();
}
}
/**
* @see Connection::commit()
*/
public function commit()
{
krumo('DBArrayConnection commit ');
die;
$this->log("Committing transaction.");
return $this->childConnection->commit();
}
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());
}
}
