/** * execute this query * @return mixed */ private function execute($sql) { if (!$this->link) { $this->connect(); } $start = microtime(true); $error = ''; $this->result = $this->link->query($sql); if (false === $this->result) { $error = implode(';', $this->link->errorInfo()); writeLog($error . ': ' . $sql, 1); throw new DatabaseErrorException($error, $sql); } if (DEBUG > 0) { $this->queries[] = array(kataFunc::getLineInfo(), trim($sql), false !== $this->result ? $this->result->rowCount() : '', $error, microtime(true) - $start . 'sec'); } }
/** * execute this query * @return mixed */ private function execute($sql) { if (!$this->isConnected()) { $this->connect(); } $start = microtime(true); $this->result = mysql_query($sql, $this->link); if (false === $this->result) { switch (mysql_errno($this->link)) { case 1062: throw new DatabaseDuplicateException(mysql_error($this->link)); break; default: writeLog(mysql_error($this->link) . ': ' . $sql, 1); throw new DatabaseErrorException(mysql_error($this->link), $sql); break; } } if (DEBUG > 0) { $this->queries[] = array(kataFunc::getLineInfo(), trim($sql), mysql_affected_rows($this->link), mysql_error($this->link), microtime(true) - $start . 'sec'); } }
/** * execute this query * @return mixed */ private function execute($sql) { if (!$this->link) { $this->connect(); } $start = microtime(true); $this->result = mssql_query($sql, $this->link); if (false === $this->result) { $msg = mssql_get_last_message(); //TODO another way would be to check @@ERROR for errors 2601/2627 which is ALSO language dependend *facepalm* if (stripos($msg, 'duplicate') !== false) { DatabaseDuplicateException($msg); } else { writeLog($msg . ': ' . $sql, 1); throw new DatabaseErrorException($msg, $sql); } } if (DEBUG > 0) { $this->queries[] = array(kataFunc::getLineInfo(), trim($sql), '', mssql_get_last_message(), microtime(true) - $start . 'sec'); } }
/** * execute this query * @return mixed */ private function execute($sql) { if (!$this->link) { $this->connect(); } $start = microtime(true); $error = 0; $this->result = $this->link->query($sql); if (false === $this->result) { writeLog($this->link->lastErrorMsg() . ': ' . $sql, 1); throw new DatabaseErrorException($this->link->lastErrorMsg()); } if (DEBUG > 0) { $this->queries[] = array(kataFunc::getLineInfo(), trim($sql), $this->link->changes(), $this->link->lastErrorMsg(), microtime(true) - $start . 'sec'); } }
/** * set key only if the stored casToken equals our castoken (=key is unchanged) * @param float $casToken castoken previously obtained by readCas * @param string $id keyname * @param string $value keyvalue * @param integer $ttl time to live in seconds * @param string|bool $forceMethod method to use * @return boolean */ public function compareAndSwap($casToken, $id, $value, $ttl = 0, $forceMethod = false) { if (DEBUG > 2) { $this->results[] = array(kataFunc::getLineInfo(), 'read', $id, '*caching off*', 0); return false; } $startTime = microtime(true); $this->initialize(); $id = CACHE_IDENTIFIER . '-' . $id; if (false === $forceMethod) { $this->method = $this->defaultMethod; } else { $this->method = $forceMethod; } if (self::CM_MEMCACHED == $this->method) { $this->initMemcached(true); $r = $this->memcachedClass->cas($casToken, $id, $value, $ttl); $done = true; if ($r && $this->memcachedClass->getResultCode() == Memcached::RES_SUCCESS) { $done = true; } $done = false; if (DEBUG > 0) { $this->results[] = array(kataFunc::getLineInfo(), 'read', $id, $done ? 'swapped' : 'my data is stale', microtime(true) - $startTime); } return $done; } throw new Exception('ExtCacheUtil: compareAndSwap works only with memcache(d)'); }
function read($id, $forceMethod = false) { if (DEBUG > 2) { $this->results[] = array(kataFunc::getLineInfo(), 'read', $id, '*caching off*', 0); return false; } if ($this->useRequestCache && isset($this->requestCache[$id])) { $data = $this->requestCache[$id]; if (DEBUG > 0) { $this->results[] = array(kataFunc::getLineInfo(), 'reqCache', $id, kataFunc::getValueInfo($data), 0); } return $data; } $startTime = microtime(true); $this->initialize(); $data = $this->_read($id, $forceMethod); if (DEBUG > 0) { $this->results[] = array(kataFunc::getLineInfo(), 'read', $id, kataFunc::getValueInfo($data), microtime(true) - $startTime); } if ($this->useRequestCache) { $this->requestCache[$id] = $data; } return $data; }