/**
* @param QueryRequest $qr
* @return array
* @throws TypeNotValidException
* @throws ValidationFailedException
*/
public function getResults(QueryRequest $qr)
{
// if the query request is cached then call the cached version!
$configurations = ["time" => $qr->getConfig()->getExecutionLimit(), "rows" => $qr->getConfig()->getQueryLimit(), "chartType" => $qr->getConfig()->getTypeOfChart(), "offset" => $qr->getConfig()->getOffset(), "connection" => $qr->getConfig()->getDatabaseConnection(), "cronExpression" => $qr->getCronExpression()];
if ($this->hasDependency(LiveStrategy::DEPENDENCY_NAME)) {
try {
$dependencies = $this->getDependencies();
/** @var QueryValidatorService $queryValidator */
$queryValidator = $dependencies[LiveStrategy::DEPENDENCY_NAME];
$query = $qr->getQuery()->getQuery();
$queryValidator->isValidQuery($query, $configurations["connection"]);
$results = $queryValidator->validateQueryExecution($query, $configurations);
return $results;
} catch (OffLimitsException $e) {
$exception = new ValidationFailedException("Query validation has failed. {$e->getMessage()}", $e->getCode(), $e);
throw $exception;
}
}
throw new TypeNotValidException(ExceptionMessage::DEPENDENCY_NOT_AVAILABLE(", QueryValidator was absent"), 500);
}
/**
* @param QueryRequest $query
* @param SymfonyStyle $io
* @param DateTime $date
* @throws \QCharts\CoreBundle\Exception\WriteReadException
*/
protected function updateQuery(QueryRequest $query, SymfonyStyle $io, DateTime $date)
{
$modes = QueryUpdateCommand::getModes();
$dateFormat = SnapshotService::FILE_DATE_FORMAT;
/** @var SnapshotService $snapshotService */
$snapshotService = $this->getContainer()->get("qcharts.core.snapshot_service");
/** @var QueryRepository $qrRepo */
$qrRepo = $this->getContainer()->get("qcharts.query_repo");
$cron = CronExpression::factory($query->getCronExpression());
$queryDate = $query->getConfig()->getFetchedOn()->format($dateFormat);
$io->newLine();
$io->section("QCharts checking: '{$query->getTitle()}' with date: {$queryDate}");
if ($cron->isDue($date)) {
//update it!
$duration = $snapshotService->updateSnapshot($query);
$io->newLine(1);
$io->note("QCharts updating:");
$io->table(['Title', 'CronExpression', 'Last fetch', 'Mode', 'Query execution time'], [[$query->getTitle(), $query->getCronExpression(), $query->getConfig()->getFetchedOn()->format($dateFormat), $modes[$query->getConfig()->getIsCached()], "{$duration} secs."]]);
$qrRepo->setUpdatedOn($query, $date);
}
$io->success("QCharts '{$query->getTitle()}' is up to date, next run: {$cron->getNextRunDate()->format($dateFormat)}");
$io->progressAdvance(1);
$io->newLine(2);
}
