MCPcopy Create free account
hub / github.com/Rello/analytics / query

Method query

lib/Db/FlexibleStorageMapper.php:236–314  ·  view source on GitHub ↗

* @param list > $projection * @param list ,operator:string,value:mixed}> $filters * @param list ,direction:string}> $sort * @return list > */

(int $datasetId, array $projection, array $filters, array $sort, bool $aggregate, int $limit, int $offset)

Source from the content-addressed store, hash-verified

234 * @return list<array<string,mixed>>
235 */
236 public function query(int $datasetId, array $projection, array $filters, array $sort, bool $aggregate, int $limit, int $offset): array {
237 $this->parameterCounter = 0;
238 $sql = $this->db->getQueryBuilder();
239 $sql->from(self::RECORD_TABLE, 'r')
240 ->where($sql->expr()->eq('r.dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT)));
241
242 $required = [];
243 foreach ($projection as $item) {
244 $required[(int)$item['column']['id']] = $item['column'];
245 }
246 foreach ($filters as $filter) {
247 $required[(int)$filter['column']['id']] = $filter['column'];
248 }
249 foreach ($sort as $item) {
250 $required[(int)$item['column']['id']] = $item['column'];
251 }
252 foreach ($required as $column) {
253 $alias = $this->valueAlias($column);
254 $sql->leftJoin('r', self::VALUE_TABLE, $alias, $sql->expr()->andX(
255 $sql->expr()->eq($alias . '.dataset_id', 'r.dataset_id'),
256 $sql->expr()->eq($alias . '.record_id', 'r.id'),
257 $sql->expr()->eq($alias . '.column_id', $sql->createNamedParameter((int)$column['id'], IQueryBuilder::PARAM_INT))
258 ));
259 }
260
261 if (!$aggregate) {
262 $sql->selectAlias('r.id', 'record_id');
263 }
264 $dimensionSort = [];
265 foreach ($projection as $item) {
266 $column = $item['column'];
267 $field = $this->valueAlias($column) . '.' . FlexibleColumnResolver::valueField($column);
268 $outputAlias = 'c_' . (int)$column['id'];
269 if ($aggregate && $column['role'] === 'measure') {
270 $aggregation = $item['aggregation'];
271 $expression = match ($aggregation) {
272 'sum' => $sql->func()->sum($field),
273 'min' => $sql->func()->min($field),
274 'max' => $sql->func()->max($field),
275 'count' => $sql->func()->count($field),
276 'avg' => $sql->createFunction('AVG(' . $field . ')'),
277 'count_distinct' => $sql->createFunction('COUNT(DISTINCT ' . $field . ')'),
278 default => throw new \InvalidArgumentException('Unsupported aggregation'),
279 };
280 $sql->selectAlias($expression, $outputAlias);
281 } else {
282 $sql->selectAlias($field, $outputAlias);
283 if ($aggregate) {
284 $sql->addGroupBy($field);
285 $dimensionSort[] = $outputAlias;
286 }
287 }
288 }
289
290 $this->applyFilters($sql, $filters);
291 foreach ($sort as $item) {
292 $column = $item['column'];
293 $outputAlias = 'c_' . (int)$column['id'];

Callers

nothing calls this directly

Calls 5

valueAliasMethod · 0.95
applyFiltersMethod · 0.95
eqMethod · 0.80
valueFieldMethod · 0.80
countMethod · 0.80

Tested by

no test coverage detected