function affected() { if (is_null($this->affected)) { $this->affected = pg_affected_rows($this->q); } return $this->affected; }
public function affectedRows() { if (!is_resource($this->result)) { return false; } return pg_affected_rows($this->result); }
function execute() { $this->queryId = parent::execute(); if (is_resource($this->queryId)) { return pg_affected_rows($this->queryId); } }
function comprobar_operacion($res, &$error) { if (pg_affected_rows($res) == 0) { $error[] = "No se ha podido modificar el artículo."; throw new Exception(); } }
public function __construct($result, $sql, $as_object = FALSE, $params = NULL, $total_rows = NULL) { parent::__construct($result, $sql, $as_object, $params); if ($as_object === TRUE) { $this->_as_object = 'stdClass'; } if ($total_rows !== NULL) { $this->_total_rows = $total_rows; } else { switch (pg_result_status($result)) { case PGSQL_TUPLES_OK: $this->_total_rows = pg_num_rows($result); break; case PGSQL_COMMAND_OK: $this->_total_rows = pg_affected_rows($result); break; case PGSQL_BAD_RESPONSE: case PGSQL_NONFATAL_ERROR: case PGSQL_FATAL_ERROR: throw new Database_Exception(':error [ :query ]', array(':error' => pg_result_error($result), ':query' => $sql)); case PGSQL_COPY_OUT: case PGSQL_COPY_IN: throw new Database_Exception('PostgreSQL COPY operations not supported [ :query ]', array(':query' => $sql)); default: $this->_total_rows = 0; } } }
public function affected_rows() { if ($this->last_execute_result === null) { return 0; } return pg_affected_rows($this->last_execute_result); }
protected function updateAffectedRows($result) { $this->affected_rows += pg_affected_rows($result); if ($this->affected_rows != 0 && $this->affected_rows % 500 == 0) { echo get_class($this) . " has affected " . $this->affected_rows . " row(s)...\n"; } }
public function SetData($setQuery) { $this->Connect(); //var_dump('????', $setQuery, "???"); $result = pg_query($this->connectionHandle, $setQuery); return pg_affected_rows($result); }
function sqlQuery($query) { if (!$query) { return false; } if (b1n_DEBUG) { echo '<pre style="text-align: left">QUERY: ' . $query . '</pre>'; } if (!$this->sqlIsConnected()) { user_error('DB NOT CONNECTED'); return false; } $result = pg_query($this->sqlGetLink(), $query); if (is_bool($result)) { return pg_affected_rows($result); } $num = pg_num_rows($result); if ($num > 0) { for ($i = 0; $i < $num; $i++) { $row[$i] = pg_fetch_array($result, $i, PGSQL_ASSOC); } return $row; } return true; }
public static function castResult($result, array $a, Stub $stub, $isNested) { $a['num rows'] = pg_num_rows($result); $a['status'] = pg_result_status($result); if (isset(self::$resultStatus[$a['status']])) { $a['status'] = new ConstStub(self::$resultStatus[$a['status']], $a['status']); } $a['command-completion tag'] = pg_result_status($result, PGSQL_STATUS_STRING); if (-1 === $a['num rows']) { foreach (self::$diagCodes as $k => $v) { $a['error'][$k] = pg_result_error_field($result, $v); } } $a['affected rows'] = pg_affected_rows($result); $a['last OID'] = pg_last_oid($result); $fields = pg_num_fields($result); for ($i = 0; $i < $fields; ++$i) { $field = array('name' => pg_field_name($result, $i), 'table' => sprintf('%s (OID: %s)', pg_field_table($result, $i), pg_field_table($result, $i, true)), 'type' => sprintf('%s (OID: %s)', pg_field_type($result, $i), pg_field_type_oid($result, $i)), 'nullable' => (bool) pg_field_is_null($result, $i), 'storage' => pg_field_size($result, $i) . ' bytes', 'display' => pg_field_prtlen($result, $i) . ' chars'); if (' (OID: )' === $field['table']) { $field['table'] = null; } if ('-1 bytes' === $field['storage']) { $field['storage'] = 'variable size'; } elseif ('1 bytes' === $field['storage']) { $field['storage'] = '1 byte'; } if ('1 chars' === $field['display']) { $field['display'] = '1 char'; } $a['fields'][] = new EnumStub($field); } return $a; }
function safe_dml_query($query, $verbose = True) { global $conn; if ($verbose) { echo "------------------------\n"; echo "Executing PG query: {$query}\n"; } $time_start = microtime(true); pg_send_query($conn, $query) or die("Failed to execute query {$query}"); while (pg_connection_busy($conn)) { if (microtime(true) - $time_start > 30) { if (rand(0, 10) == 0) { echo "Busy for " . round((microtime(true) - $time_start) * 1000) . " ms -"; } sleep(5); } usleep(2000); } $res = pg_get_result($conn); if (pg_result_error($res) != null) { die("Error during query: " . pg_result_error($res) . "\n"); } $time_end = microtime(true); $rows = pg_affected_rows($res); if ($verbose) { echo "Done executing {$query}: {$rows} touched\n"; $t = round(($time_end - $time_start) * 1000); echo "Query time: {$t} ms\n"; echo "------------------------\n"; } }
/** * @param resource from pg_query() or pg_get_result() * @param string SQL used to create this result * @param resource from pg_connect() or pg_pconnect() * @param boolean|string * @return void */ public function __construct($result, $sql, $link, $return_objects) { // PGSQL_COMMAND_OK <- SET client_encoding = 'utf8' // PGSQL_TUPLES_OK <- SELECT table_name FROM information_schema.tables // PGSQL_COMMAND_OK <- INSERT INTO pages (name) VALUES ('gone soon') // PGSQL_COMMAND_OK <- DELETE FROM pages WHERE id = 2 // PGSQL_COMMAND_OK <- UPDATE pb_users SET company_id = 1 // PGSQL_FATAL_ERROR <- SELECT FROM pages switch (pg_result_status($result)) { case PGSQL_EMPTY_QUERY: $this->total_rows = 0; break; case PGSQL_COMMAND_OK: $this->total_rows = pg_affected_rows($result); break; case PGSQL_TUPLES_OK: $this->total_rows = pg_num_rows($result); break; case PGSQL_COPY_OUT: case PGSQL_COPY_IN: Kohana_Log::add('debug', 'PostgreSQL COPY operations not supported'); break; case PGSQL_BAD_RESPONSE: case PGSQL_NONFATAL_ERROR: case PGSQL_FATAL_ERROR: throw new Database_Exception(':error [ :query ]', array(':error' => pg_result_error($result), ':query' => $sql)); } $this->link = $link; $this->result = $result; $this->return_objects = $return_objects; $this->sql = $sql; }
public function Afficher() { if (isset($_SESSION["compte"]) && !empty($_SESSION["compte"])) { // - gestion spécifique de la page $account_id = $_SESSION['compte']->id; $djun_name = $_SESSION['djun_choisi']->nom; // - On supprime le D'jun $sql = "DELETE FROM \"libertribes\".\"AVATAR\" WHERE compte_id = {$account_id} and avatar_nom ='{$djun_name}'"; $result = $this->db_connexion->Requete($sql); if (!$result || pg_affected_rows($result) == 0) { // - redirection vers la page djun_suppression avec un message d'erreur header('Location: index.php?page=djun_suppression&erreur=1'); exit; } // restructurer la variable de session avatar s'il y a plusieurs avatars $avatars = array(); $i = 0; foreach ($_SESSION['avatars'] as $avatar) { if ($avatar->nom != $_SESSION['djun_choisi']->nom) { $avatars[$i] = $avatar; $i++; } } unset($_SESSION['avatars']); $_SESSION['avatars'] = $avatars; unset($_SESSION['djun_choisi']); unset($_SESSION["avatar_name"]); // - redirection vers la page TDB header('Location: index.php?page=tdb'); } else { header('Location: index.php?page=connexion&erreur=3'); exit; } }
public function query($string = '') { if ($string != '') { $this->query = $this->escape($string); } else { $this->query = $this->select . $this->insert . $this->update . $this->delete . $this->create . $this->from . $this->join . $this->where . $this->group . $this->order . $this->limit; } $this->insert = " RETURNING id"; $this->result = pg_exec($this->connection, $this->query); $this->inserted_id = $this->result; $this->error = pg_errormessage($this->connection); $this->affected_rows = pg_affected_rows($this->result); $this->select = ''; $this->insert = ''; $this->update = ''; $this->delete = ''; $this->create = ''; $this->from = ''; $this->join = ''; $this->where = ''; $this->group = ''; $this->order = ''; $this->limit = ''; return $this; }
public function rowsAffected($result) { $affectedRows = pg_affected_rows($result); if (!$affectedRows) { $affectedRows = pg_num_rows($result); } return $affectedRows; }
function affectedRows($ressource = null) { if ($ressource !== null && get_class($ressource) == 'CopixDbResultSetPostgreSQL') { return pg_affected_rows($ressource->_idResult); } else { return -1; } }
public function affected_rows() { $num_rows = pg_affected_rows($this->_result); if (-1 == $num_rows) { throw new DatabaseResultException('Number of rows failed'); } return $num_rows; }
function comprobar_insercion($res, &$error) { if (!$res && pg_affected_rows($res) != 1) { $error[] = "no se ha podido llevar a cabo la operación."; $res = pg_query("rollback"); throw new Exception(); } }
function wpsql_affected_rows() { if ($GLOBALS['pg4wp_result'] === false) { return 0; } else { return pg_affected_rows($GLOBALS['pg4wp_result']); } }
public function delete() { if ($this->id == 0) { return false; } $result = pg_query('update cars set deleted=TRUE where id=\'' . pesc($this->id) . '\''); self::getRows(true); return pg_affected_rows($result) > 0; }
public function insertado($sql) { $resultado = pg_query($this->conexion, $sql); if (!$resultado) { echo 'Postgres Error: ' . pg_last_error(); exit; } return pg_affected_rows($resultado); }
function registrosAfectados($resultado) { if (pg_affected_rows($resultado)) { $mensaje = "Operacion exitosa"; } else { $mensaje = "Error en la operacion"; } header('location:../Index.php?dato=' . $mensaje); }
public function queryExecute($query) { $result = pg_query($this->connection, $query); if (pg_affected_rows($result) === 1) { return true; } else { return $this->convertToArray($result); } }
/** * The constructor. * @access public * @param integer $resourceId The resource id for this query. */ function PostgreSQLUpdateQueryResult($resourceId) { // ** parameter validation $resourceRule = ResourceValidatorRule::getRule(); ArgumentValidator::validate($resourceId, $resourceRule, true); // ** end of parameter validation $this->_resourceId = $resourceId; $this->_numberOfRows = pg_affected_rows($this->_resourceId); }
function sql_affectedrows() { if ($this->db_connect_id) { $result = @pg_affected_rows($this->db_connect_id); return $result; } else { return false; } }
/** * @param resource $Result query result resource */ public function __construct($Result) { $this->setAffectedRows(pg_affected_rows($Result)); $Rows = array(); while ($row = pg_fetch_assoc($Result)) { $Rows[] = $row; } $this->setResult($Rows); }
private function executeUpdate($query, $params) { $result = pg_prepare($this->connection, "query", $query); if ($params) { $resultSet = pg_execute($this->connection, "query", $params); } else { $resultSet = pg_execute($this->connection, "query"); } return pg_affected_rows($resultSet); }
function execute_dml($sql) { $this->conn = pg_connect($this->conn_str); $res = pg_query($sql) or die(pg_last_error() . "<script>alert('error');history.go(-1);</script>"); if (pg_affected_rows($res) > 0) { return 1; } else { return 2; } }
public function exec(&$statement) { if ($result = @pg_query($this->link, $statement)) { if (is_resource($result)) { pg_free_result($result); return 0; } return pg_affected_rows($this->link); } return false; }
/** * Устанавливает или проверяет статус дня рождения. * * @param integer $status статус * * @return integer 1 в случае успеха, 0 в случае ошибки */ public function setStatus($status) { if (pg_affected_rows(settings::SetVariable('birthday' . $this->year, 'status', $status))) { return 1; } $sql = "INSERT INTO settings (id, module, variable, value) SELECT COALESCE(MAX(id),0)+1, 'birthday{$this->year}', 'status', '{$status}' FROM settings"; if (pg_query(DBConnect(), $sql)) { return 1; } return 0; }