/** * Commit transaction. * * @return void */ public function commit() { cubrid_commit($this->link); if ($this->autoCommit && !cubrid_get_autocommit($this->link)) { cubrid_set_autocommit($this->link, CUBRID_AUTOCOMMIT_TRUE); } }
function trans_commit() { if (!$this->trans_enabled) { return TRUE; } if ($this->_trans_depth > 0) { return TRUE; } cubrid_commit($this->conn_id); if ($this->auto_commit && !cubrid_get_autocommit($this->conn_id)) { cubrid_set_autocommit($this->conn_id, CUBRID_AUTOCOMMIT_TRUE); } return TRUE; }
/** * Commit Transaction * * @access public * @return bool */ function trans_commit() { 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_commit($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 transCommit() { cubrid_commit($this->connect); if (!cubrid_get_autocommit($this->connect)) { cubrid_set_autocommit($this->connect, CUBRID_AUTOCOMMIT_TRUE); } return true; }
function cubrid_mysql_commit($link_identifier) { return cubrid_commit($link_identifier); }
/** * Commit Transaction * * @return bool */ protected function _trans_commit() { if (!cubrid_commit($this->conn_id)) { return FALSE; } if ($this->auto_commit && !cubrid_get_autocommit($this->conn_id)) { return cubrid_set_autocommit($this->conn_id, CUBRID_AUTOCOMMIT_TRUE); } return TRUE; }
exit(1); } $retval = check_table_existence($conn, "largetable"); if ($retval == -1) { exit(1); } elseif ($retval == 1) { printf("this table is created\n"); } else { printf("#####start: create largetable#####\n"); $cubrid_req = cubrid_execute($conn, "CREATE TABLE largetable(a int AUTO_INCREMENT, b clob)"); if (!$cubrid_req) { printf("Failed to create test table: [%d] %s\n", cubrid_error_code(), cubrid_error_msg()); exit(1); } $req = cubrid_prepare($conn, "insert into largetable(b) values (?)"); $importName = array("largeFile/large.txt"); for ($i = 0; $i < count($importName); $i++) { $lob = cubrid_lob2_new($conn, "CLOB"); cubrid_lob2_import($lob, $importName[$i]); cubrid_lob2_bind($req, 1, $lob, "CLOB"); cubrid_execute($req); cubrid_lob2_close($lob); } cubrid_close_prepare($req); if (!cubrid_commit($conn)) { exit(1); } } ?>
public static function commit() { @cubrid_commit(self::$dbProperties['handle']); }
/** * DB transaction commit * this method is private * @return boolean */ function _commit() { $connection = $this->_getConnection('master'); @cubrid_commit($connection); return TRUE; }
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++; if ($inserted % 1000 === 0) { printf("%d record inserted.\n", $inserted); } cubrid_close_request($result); } cubrid_commit($dh); cubrid_disconnect($dh); printf("Done. %d record inserted, %d errors.\n", $inserted, $error_count);
public function commitTrans($bCommit = true) { if ($bCommit) { cubrid_commit($this->_conn); } else { cubrid_rollback($this->_conn); } $this->_transMode = false; $this->_transFailedCnt = 0; cubrid_set_autocommit($this->_conn, CUBRID_AUTOCOMMIT_TRUE); $this->Logging("++ CommitTrans"); }
<?php include "connect.inc"; header('Content-type: text/html; charset=euc-kr'); $conn = cubrid_connect($host, $port, $db, "dba", $passwd); $sql = "insert into cubridsus9278(b) values('aaaa')"; $i = 0; while ($i < 300) { $result = cubrid_execute($conn, $sql); if ($result == true) { cubrid_commit($conn); } else { cubrid_rollback($conn); } $i++; }
public function testCubridCci6_t10() { // case : ac on // multi_connection tname? if (OUTPUT_FUNCTION_NAME == true) { echo "\r\nRunning: " . __FUNCTION__ . " = "; } try { $this->sql = "create table t10(code int unique, s string) "; cubrid_execute($this->con, $this->sql); for ($count = 0; $count < 10; $count++) { $this->sql = "delete from t10 "; cubrid_execute($this->con, $this->sql); cubrid_commit($this->con); for ($i = 0; $i < 1000; $i++) { $this->sql = "insert into t10 values({$i}, 'aaa')"; $this->req = cubrid_execute($this->con, $this->sql); } $this->sql = "select count(*) from t10"; $this->req = cubrid_execute($this->con, $this->sql); $str = cubrid_fetch_row($this->req); echo $str[0]; $this->assertEquals($str[0], 1000); echo "\r\n-----Running:---------------{$count} "; } echo "\r\n#### case Cci6_t10 OK #### "; } catch (Exception $e) { echo "\r\n#### Catch Cci6_t10 Exception #### "; } $this->sql = "drop table t10"; cubrid_execute($this->con, $this->sql); cubrid_commit($this->con); $this->req = null; }
/** * @brief 커밋 **/ function commit() { if (!$force && (!$this->isConnected() || !$this->transaction_started)) { return; } @cubrid_commit($this->fd); $this->transaction_started = false; }