@author Ross Riley
/**
* @param ContentQueryParser $contentQuery
*
* @return QueryResultset
*/
public function __invoke(ContentQueryParser $contentQuery)
{
$params = $contentQuery->getEntityManager()->createQueryBuilder()->getConnection()->getParams();
if (strpos($params['driver'], 'mysql') !== false) {
$contentQuery->setDirective('order', 'RAND()');
} else {
$contentQuery->setDirective('order', 'RANDOM()');
}
return call_user_func_array($contentQuery->getHandler('select'), [$contentQuery]);
}
/**
* @param ContentQueryParser $contentQuery
*
* @return SearchQueryResultset
*/
public function __invoke(ContentQueryParser $contentQuery)
{
$set = new SearchQueryResultset();
foreach ($contentQuery->getContentTypes() as $contenttype) {
$query = $contentQuery->getService('search');
$repo = $contentQuery->getEntityManager()->getRepository($contenttype);
$query->setQueryBuilder($repo->createQueryBuilder($contenttype));
$query->setContentType($contenttype);
$searchParam = $contentQuery->getParameter('filter');
$query->setParameters($contentQuery->getParameters());
$query->setSearch($searchParam);
$contentQuery->runDirectives($query);
$result = $repo->queryWith($query);
if ($result) {
if (count($result) > 0) {
$weighter = $contentQuery->getService('search_weighter');
$weighter->setContentType($contenttype);
$weighter->setResults($result);
$weighter->setSearchWords($query->getSearchWords());
$scores = $weighter->weight();
$set->add($result, $contenttype, $scores);
} else {
$set->add($result, $contenttype);
}
}
}
if ($query->getSingleFetchMode()) {
return $set->current();
} else {
return $set;
}
}
public function postgresSearch(ContentQueryParser $contentQuery)
{
$set = new SearchQueryResultset();
foreach ($contentQuery->getContentTypes() as $contenttype) {
$repo = $contentQuery->getEntityManager()->getRepository($contenttype);
$query = $repo->createQueryBuilder($contenttype);
$config = $contentQuery->getService('search_config');
$search = $contentQuery->getParameter('filter');
$adapter = new PostgresSearch($query, $config, explode(' ', $search));
$adapter->setContentType($contenttype);
$result = $repo->findWith($adapter->getQuery());
$set->add($result, $contenttype);
}
return $set;
}
/**
* @param ContentQueryParser $contentQuery
*
* @return mixed
*/
public function __invoke(ContentQueryParser $contentQuery)
{
if (is_numeric($contentQuery->getIdentifier())) {
$contentQuery->setParameter('id', $contentQuery->getIdentifier());
} else {
$contentQuery->setParameter('slug', $contentQuery->getIdentifier());
}
if (count($contentQuery->getContentTypes()) === 1) {
$contentQuery->setDirective('returnsingle', true);
}
return call_user_func_array($contentQuery->getHandler('select'), [$contentQuery]);
}
/**
* @param ContentQueryParser $contentQuery
*
* @return QueryResultset
*/
public function __invoke(ContentQueryParser $contentQuery)
{
$set = new QueryResultset();
/** @var SelectQuery $query */
$query = $contentQuery->getService('select');
foreach ($contentQuery->getContentTypes() as $contentType) {
$repo = $contentQuery->getEntityManager()->getRepository($contentType);
$query->setQueryBuilder($repo->createQueryBuilder($contentType));
$query->setContentType($contentType);
/** Run the parameters through the whitelister. If we get a false back from this method it's because there
* is no need to continue with the query.
*/
$params = $this->whitelistParameters($contentQuery->getParameters(), $repo);
if (!$params && count($contentQuery->getParameters())) {
continue;
}
/** Continue and run the query add the results to the set */
$query->setParameters($params);
$contentQuery->runDirectives($query);
$result = $repo->queryWith($query);
if ($result) {
$set->add($result, $contentType);
}
}
if ($query->getSingleFetchMode()) {
return $set->current();
} else {
return $set;
}
}
public function register(Application $app)
{
$app['query'] = function ($app) {
$runner = new Query($app['query.parser']);
return $runner;
};
$app['query.parser'] = $app->share(function ($app) {
$parser = new ContentQueryParser($app['storage']);
$parser->addService('select', $app['query.select']);
return $parser;
});
$app['query.parser.handler'] = $app->share(function ($app) {
return new QueryParameterParser($app['storage']->createExpressionBuilder());
});
$app['query.select'] = $app->share(function ($app) {
return new SelectQuery($app['storage']->createQueryBuilder(), $app['query.parser.handler']);
});
}
/**
* @param ContentQueryParser $contentQuery
*
* @return QueryResultset
*/
public function __invoke(ContentQueryParser $contentQuery)
{
$set = new QueryResultset();
foreach ($contentQuery->getContentTypes() as $contenttype) {
$query = $contentQuery->getService('select');
$repo = $contentQuery->getEntityManager()->getRepository($contenttype);
$query->setQueryBuilder($repo->createQueryBuilder($contenttype));
$query->setContentType($contenttype);
$query->setParameters($contentQuery->getParameters());
$contentQuery->runDirectives($query);
$result = $repo->queryWith($query);
if ($result) {
$set->add($result, $contenttype);
}
}
if ($query->getSingleFetchMode()) {
return $set->current();
} else {
return $set;
}
}
/**
* @param ContentQueryParser $contentQuery
*
* @return QueryResultset
*/
public function __invoke(ContentQueryParser $contentQuery)
{
$contentQuery->setDirective('order', '-id');
return call_user_func_array($contentQuery->getHandler('select'), [$contentQuery]);
}
public function testNativeSearchHandlerFallback()
{
$app = $this->getApp();
$qb = new ContentQueryParser($app['storage'], $app['query.select']);
$qb->addService('search', $app['query.search']);
$qb->addService('search_weighter', $app['query.search_weighter']);
$qb->setQuery('pages/nativesearch/4');
$qb->setParameters(['filter' => 'lorem ipsum']);
$res = $qb->fetch();
$this->assertEquals(4, $res->count());
}
public function testSingleItemMode()
{
$app = $this->getApp();
$qb = new ContentQueryParser($app['storage'], $app['query.select']);
$qb->setQuery('pages/5');
$qb->setParameter('printquery', true);
$qb->parse();
$this->assertEquals(['pages'], $qb->getContentTypes());
$this->assertEquals('namedselect', $qb->getOperation());
$this->assertEquals('5', $qb->getIdentifier());
$this->expectOutputString('SELECT pages.* FROM bolt_pages pages WHERE pages.id = :id_1');
$res = $qb->fetch();
$this->assertInstanceOf('Bolt\\Storage\\Entity\\Content', $res);
}
public function testRemoveOperation()
{
$app = $this->getApp();
$qb = new ContentQueryParser($app['storage'], $app['query.select']);
$qb->addOperation('featured');
$this->assertTrue(in_array('featured', $qb->getOperations()));
$qb->removeOperation('featured');
$this->assertFalse(in_array('featured', $qb->getOperations()));
}