/** * Rollback transaction. */ public function rollback() { cubrid_rollback($this->link); if ($this->autoCommit && !cubrid_get_autocommit($this->link)) { cubrid_set_autocommit($this->link, CUBRID_AUTOCOMMIT_TRUE); } }
/** * Rollback Transaction * * @access public * @return bool */ function trans_rollback() { if (!$this->trans_enabled) { return TRUE; } // When transactions are nested we only begin/commit/rollback the outermost ones if ($this->_trans_depth > 0) { return TRUE; } cubrid_rollback($this->conn_id); if ($this->auto_commit && !cubrid_get_autocommit($this->conn_id)) { cubrid_set_autocommit($this->conn_id, CUBRID_AUTOCOMMIT_TRUE); } return TRUE; }
public function transRollback() { cubrid_rollback($this->connect); if (!cubrid_get_autocommit($this->connect)) { cubrid_set_autocommit($this->connect, CUBRID_AUTOCOMMIT_TRUE); } return TRUE; }
function cubrid_mysql_rollback($link_identifier) { return cubrid_rollback($link_identifier); }
/** * Rollback Transaction * * @return bool */ protected function _trans_rollback() { if (!cubrid_rollback($this->conn_id)) { return FALSE; } if ($this->auto_commit && !cubrid_get_autocommit($this->conn_id)) { cubrid_set_autocommit($this->conn_id, CUBRID_AUTOCOMMIT_TRUE); } return TRUE; }
/** * DB transaction rollback * this method is private * @return boolean */ function _rollback($transactionLevel = 0) { $connection = $this->_getConnection('master'); $point = $transactionLevel - 1; if ($point) { $this->_query("ROLLBACK TO SP" . $point, $connection); } else { @cubrid_rollback($connection); } return TRUE; }
<?php include_once "connect.inc"; header('Content-type: text/html; charset=euc-kr'); //var_dump($connect_url); $conn = cubrid_connect_with_url($connect_url); $sql = "SELECT a from foo"; $result = cubrid_execute($conn, $sql); $pResult = cubrid_fetch($result); echo $pResult[0]; echo "<br/>"; cubrid_close_request($result); cubrid_rollback($conn); cubrid_disconnect($conn);
$is_exist = false; } if ($is_exist === false) { $result = cubrid_execute($dh, "CREATE TABLE \"" . $db["table"] . "\" (\n \"index\" INTEGER NOT NULL,\n \"addr1\" CHARACTER VARYING(12) NOT NULL,\n \"addr2\" CHARACTER VARYING(30) NOT NULL,\n \"addr3\" CHARACTER VARYING(64) NOT NULL,\n \"addr4\" CHARACTER VARYING(24) NOT NULL,\n \"zipcode\" CHARACTER(7) NOT NULL\n );"); if ($result === false) { printf("DB Error %d (%d): %s\n", cubrid_error_code(), cubrid_error_code_facility(), cubrid_error_msg()); cubrid_rollback($dh); cubrid_disconnect($dh); exit(0); } cubrid_close_request($result); cubrid_commit($dh); $result = cubrid_execute($dh, "CREATE UNIQUE INDEX \"" . $db["table"] . "_idx\"\n ON \"" . $db["table"] . "\" (\"index\" ASC);"); if ($result === false) { printf("Cannot create index.\n"); cubrid_rollback($dh); } else { cubrid_close_request($result); cubrid_commit($dh); } } $error_count = 0; $inserted = 0; foreach ($addr_list as $val) { $result = cubrid_execute($dh, sprintf("INSERT INTO \"%s\" (\"index\", \"addr1\", \"addr2\",\n \"addr3\", \"addr4\", \"zipcode\") VALUES\n (%d, '%s', '%s', '%s', '%s', '%s');", $db["table"], $val[5], $val[1], $val[2], $val[3], $val[4], $val[0])); if ($result === false) { $error_count++; printf("Insert Error! Index: %d, Error Count: %d\n", $val[5], $error_count); continue; } $inserted++;
public function rollbackTrans() { cubrid_rollback($this->_conn); $this->_transMode = false; $this->_transFailedCnt = 0; cubrid_set_autocommit($this->_conn, CUBRID_AUTOCOMMIT_TRUE); $this->Logging("++ RollbackTrans"); }
public function testCubridCci4() { if (OUTPUT_FUNCTION_NAME == true) { echo "\r\nRunning: " . __FUNCTION__ . " = "; } try { $table = "t1"; $this->sql = "create table t1(code int unique, s string) "; cubrid_execute($this->con, $this->sql); cubrid_commit($this->con); for ($i = 0; $i < 100; $i++) { $this->sql = "insert into t1 values({$i}, 'aaa')"; $this->req = cubrid_execute($this->con, $this->sql); } cubrid_rollback($this->con); $this->sql = "select count(*) from t1"; $this->req = cubrid_execute($this->con, $this->sql); $str = cubrid_fetch_row($this->req); echo $str[0]; $this->assertEquals($str[0], 0); echo "\r\n#### case Cci4 OK #### "; } catch (Exception $e) { echo "\r\n#### Catch Cci4 Exception #### "; } $this->sql = "drop table t1"; cubrid_execute($this->con, $this->sql); cubrid_commit($this->con); $this->req = null; }
/** * DB transaction rollback * this method is private * @return boolean */ function _rollback() { $connection = $this->_getConnection('master'); @cubrid_rollback($connection); return TRUE; }
/** * @brief 롤백 **/ function rollback() { if (!$this->isConnected() || !$this->transaction_started) { return; } @cubrid_rollback($this->fd); $this->transaction_started = false; }
function trans_rollback() { if (!$this->trans_enabled) { return TRUE; } if ($this->_trans_depth > 0) { return TRUE; } cubrid_rollback($this->conn_id); if ($this->auto_commit && !cubrid_get_autocommit($this->conn_id)) { cubrid_set_autocommit($this->conn_id, CUBRID_AUTOCOMMIT_TRUE); } return TRUE; }