/** * Add exception to output queue * * @param \Exception $exception * @param boolean $debug */ protected function addException(\Exception $exception) { echo get_class($exception) . '# [' . $exception->getCode() . ']' . ':' . $exception->getMessage() . PHP_EOL; if (Util\Debug::isActivated()) { echo "file:\t" . $exception->getFile() . PHP_EOL; echo "line:\t" . $exception->getLine() . PHP_EOL; } }
/** * Render response and send it to the client */ public function send() { if (Util\Debug::isActivated()) { $this->add(Util\Debug::getInstance()); } $this->response->setContent($this->render()); return $this->response; }
/** * Add exception to output queue * * @param \Exception $exception * @param boolean $debug */ protected function addException(\Exception $exception) { $exceptionType = explode('\\', get_class($exception)); $exceptionInfo = array('message' => $exception->getMessage(), 'type' => end($exceptionType), 'code' => $exception->getCode()); if (Util\Debug::isActivated()) { $debugInfo = array('file' => $exception->getFile(), 'line' => $exception->getLine(), 'backtrace' => $exception->getTrace()); $this->json['exception'] = array_merge($exceptionInfo, $debugInfo); } else { $this->json['exception'] = $exceptionInfo; } }
/** * Determine context, format and uuid of the raw request * * @param Request $request A Request instance * @param int $type The type of the request (for Symfony compatibility, not implemented) * * @return Response A Response instance */ public function handleRaw(Request $request, $type = HttpKernelInterface::MASTER_REQUEST) { // workaround for https://github.com/symfony/symfony/issues/13617 $pathInfo = $request->server->has('PATH_INFO') ? $request->server->get('PATH_INFO') : ''; if (0 === strlen($pathInfo)) { $pathInfo = $request->getPathInfo(); } $format = pathinfo($pathInfo, PATHINFO_EXTENSION); if (!array_key_exists($format, self::$viewMapping)) { if (empty($pathInfo)) { throw new \Exception('Missing or invalid PATH_INFO'); } elseif (empty($this->format)) { throw new \Exception('Missing format'); } else { throw new \Exception('Unknown format: \'' . $this->format . '\''); } } // initialize debugging if (($debugLevel = $request->query->get('debug')) || ($debugLevel = Util\Configuration::read('debug'))) { if ($debugLevel > 0 && !Util\Debug::isActivated()) { new Util\Debug($debugLevel, $this->em); } } else { // make sure static debug instance is removed Util\Debug::deactivate(); } $class = self::$viewMapping[$format]; $this->view = new $class($request, $format); $path = explode('/', substr($pathInfo, 1, strrpos($pathInfo, '.') - 1)); list($context, $uuid) = array_merge($path, array(null)); // verify route if (!array_key_exists($context, self::$controllerMapping)) { throw new \Exception(empty($context) ? 'Missing context' : 'Unknown context: \'' . $context . '\''); } return $this->handler($request, $context, $uuid); }
/** * Add exception to output queue * * @param \Exception $exception * @param boolean $debug */ protected function addException(\Exception $exception) { $exceptionType = explode('\\', get_class($exception)); $xmlException = $this->xmlDoc->createElement('exception'); $xmlException->setAttribute('code', $exception->getCode()); $xmlException->setAttribute('type', end($exceptionType)); $xmlException->appendChild($this->xmlDoc->createElement('message', $exception->getMessage())); if (Util\Debug::isActivated()) { $xmlException->appendChild($this->xmlDoc->createElement('file', $exception->getFile())); $xmlException->appendChild($this->xmlDoc->createElement('line', $exception->getLine())); $xmlException->appendChild($this->convertTrace($exception->getTrace())); } $this->xmlRoot->appendChild($xmlException); }
/** * Render response and send it to the client */ public function send() { if (Util\Debug::isActivated()) { $this->add(Util\Debug::getInstance()); } $this->render(); $this->response->send(); }
/** * Core data aggregation * * @param int $channel_id id of channel to perform aggregation on * @param string $interpreter interpreter class name * @param string $mode aggregation mode (full, delta) * @param string $level aggregation level (day...) * @param int $period delta days to aggregate * @return int number of rows */ protected function aggregateChannel($channel_id, $interpreter, $mode, $level, $period) { $format = self::getAggregationDateFormat($level); $type = self::getAggregationLevelTypeValue($level); $weighed_avg = $interpreter == 'Volkszaehler\\Interpreter\\SensorInterpreter'; $sqlParameters = array($type); $sql = 'REPLACE INTO aggregate (channel_id, type, timestamp, value, count) '; if ($weighed_avg) { // get interpreter's aggregation function $aggregationFunction = $interpreter::groupExprSQL('agg.value'); // SQL query similar to MySQLOptimizer group mode $sql .= 'SELECT channel_id, ? AS type, ' . 'MAX(agg.timestamp) AS timestamp, ' . 'COALESCE( ' . 'SUM(agg.val_by_time) / (MAX(agg.timestamp) - MIN(agg.prev_timestamp)), ' . $aggregationFunction . ') AS value, ' . 'COUNT(agg.value) AS count ' . 'FROM ( ' . 'SELECT channel_id, timestamp, value, ' . 'value * (timestamp - @prev_timestamp) AS val_by_time, ' . 'GREATEST(0, IF(@prev_timestamp = NULL, NULL, @prev_timestamp)) AS prev_timestamp, ' . '@prev_timestamp := timestamp ' . 'FROM data ' . 'CROSS JOIN (SELECT @prev_timestamp := NULL) AS vars ' . 'WHERE '; } else { // get interpreter's aggregation function $aggregationFunction = $interpreter::groupExprSQL('value'); $sql .= 'SELECT channel_id, ? AS type, MAX(timestamp) AS timestamp, ' . $aggregationFunction . ' AS value, COUNT(timestamp) AS count ' . 'FROM data WHERE '; } // selected channel only if ($channel_id) { $sqlParameters[] = $channel_id; $sql .= 'channel_id = ? '; } // since last aggregation only if ($mode == 'delta') { if ($channel_id) { // selected channel $sqlTimestamp = 'SELECT UNIX_TIMESTAMP(DATE_ADD(' . 'FROM_UNIXTIME(MAX(timestamp) / 1000, ' . $format . '), ' . 'INTERVAL 1 ' . $level . ')) * 1000 ' . 'FROM aggregate ' . 'WHERE type = ? AND channel_id = ?'; if ($ts = $this->conn->fetchColumn($sqlTimestamp, array($type, $channel_id), 0)) { $sqlParameters[] = $ts; $sql .= 'AND timestamp >= ? '; } } else { // all channels $sqlParameters[] = $type; $sql .= 'AND timestamp >= IFNULL((' . 'SELECT UNIX_TIMESTAMP(DATE_ADD(' . 'FROM_UNIXTIME(MAX(timestamp) / 1000, ' . $format . '), ' . 'INTERVAL 1 ' . $level . ')) * 1000 ' . 'FROM aggregate ' . 'WHERE type = ? AND aggregate.channel_id = data.channel_id ' . '), 0) '; } } // selected number of periods only if ($period) { $sql .= 'AND timestamp >= (SELECT UNIX_TIMESTAMP(DATE_SUB(DATE_FORMAT(NOW(), ' . $format . '), INTERVAL ? ' . $level . ')) * 1000) '; $sqlParameters[] = $period; } // up to before current period $sql .= 'AND timestamp < UNIX_TIMESTAMP(DATE_FORMAT(NOW(), ' . $format . ')) * 1000 '; if ($weighed_avg) { // close inner table $sql .= 'ORDER BY timestamp ' . ') AS agg '; } $sql .= 'GROUP BY channel_id, ' . Interpreter\Interpreter::buildGroupBySQL($level); if (Util\Debug::isActivated()) { echo Util\Debug::getParametrizedQuery($sql, $sqlParameters) . "\n"; } $rows = $this->conn->executeUpdate($sql, $sqlParameters); return $rows; }