/** * (non-PHPdoc) * @see \Koldy\Cache\Driver\AbstractCacheDriver::has() */ public function has($key) { $this->checkKey($key); $select = new Select($this->config['table']); $select->setConnection($this->config['connection']); $select->field('expires_at')->where('id', $key); $cacheRecord = $select->fetchFirst(); if ($cacheRecord === false) { return false; } return $cacheRecord['expires_at'] > time(); }
/** * Get the session data from database * * @param string $sessionid * @return \stdClass|false if data doesn't exist in database */ private function getDbData($sessionid) { $select = new Select($this->config['table']); $select->field('time', 'time')->field('data', 'data')->where('id', $sessionid)->setConnection($this->config['connection']); return $select->fetchFirstObj(); }
/** * Rebuild stack_trace table * CAUTION!!!! If you have a lot of records, this could take hours or days do get done! */ public static function rebuild() { Status::calculationStarted(); Status::setCalculationStatus('Initializing'); Status::setCalculationStatus('Reseting stack_trace_ids to NULL'); Db::query('UPDATE crash_archive SET stack_trace_id = NULL'); Status::setCalculationStatus('Emptying stack_trace table'); Db::query('TRUNCATE TABLE stack_trace'); $stacks = array(); // foreach (Stack\Trace::all() as $r) { // $stacks[$r['hash']] = (int) $r['id']; // } $total = \Crash\Archive::count(); $index = 0; $start = 0; do { $query = new Select('crash_archive'); $query->field('id')->where('id', '>', $start)->where('id', '<=', $start + 100000); Status::setCalculationStatus("Taking IDs from {$start} to " . ($start + 100000)); $records = $query->fetchAll(); $sizeofIds = count($records); foreach ($records as $r) { $id = (int) $r['id']; $crash = new \Crash\Archive(array('id' => $id)); $stackTrace = $crash->getMeta('stack_trace'); if ($stackTrace !== null) { $summary = static::getSummary($stackTrace); $md5 = md5($summary); if (isset($stacks[$md5])) { $stackTraceId = $stacks[$md5]; } else { $tmp = \Stack\Trace::create(array('hash' => $md5, 'summary' => $summary, 'created_at' => $crash->created_at)); $stackTraceId = (int) $tmp->id; $stacks[$md5] = $stackTraceId; } $crash->stack_trace_id = $stackTraceId; $crash->save(); Log::info("Updated #{$id} with stack={$stackTraceId}"); } else { Log::info("Crash report #{$id} is skipped because stack_trace is missing in meta table"); } if ($index % 25 == 0) { $percent = round($index / $total * 100, 2); Status::setCalculationStatus("Working on {$index}/{$sizeofIds} {$percent}%"); } $index++; } $start += 100000; } while (sizeof($records) > 0); Status::setCalculationStatus('Started stack trace recalculation!'); Log::info('Started recalculation of stack_trace counts'); static::recalculate(); Status::calculationFinished('all'); }