krzysztof-gzocha/searcher

Searcher is a framework-agnostic search query builder. Search queries are written using Criterias and can be run against MySQL, MongoDB, ElasticSearch or even files.

Wednesday, October 11, 2017
by krzysztof-gzocha
Repository
11 Watchers
114 Stars
5,033 Installations

PHP
1 Dependents
0 Suggesters
8 Forks
0 Open issues
34 Versions
8 % Grown

The README.md

, _(*1)

Searcher

What is that?

Searcher is a framework-agnostic search query builder. Search queries are written using criterias and can be run against MySQL, MongoDB, ElasticSearch, files or whatever else you like. Latest version is supporting only PHP 7. Now tested also with Humbug, _(*2)

See this presentation to understand better

Why?

Have you ever seen code responsible for searching for something based on many different criteria? It can become quite a mess! Imagine you have a form with 20 fields and all of them have some impact on searching conditions. It's not a great idea to pass a whole form to some service at let it parse everything in one place. Thanks to this library you can split the responsibility of building query criteria to several smaller classes. One class per filter. One CriteriaBuilder per Criteria. This way, inside CriteriaBuilder you care only about one Criteria, which makes it a lot more readable and maintanable. You can later use exactly the same Criteria for different searches, with different CriteriaBuilder and even different SearchingContext which can use even different databases. You can even use searcher to find files on your system thanks to FinderSearchingContext., _(*3)

Full documentation

Full documentation can be found at http://searcher.rtfd.io/, _(*4)

Installation

You can install the library via composer by typing in terminal:, _(*5)

$ composer require krzysztof-gzocha/searcher

Integration

Integration with Symfony is done in SearcherBundle, _(*6)

Idea

CriteriaBuilder - will build new conditions for single Criteria,
Criteria - model that will be passed to CriteriaBuilder. You just need to hydrate it somehow, so it will be useful. Criteria can hold multiple fields inside and all (or some) of them might be used inside CriteriaBuilder,
SearchingContext - context of single search. This service should know how to fetch results from constructed query and it holds something called QueryBuilder, but it can be anything that works for you - any service. This is an abstraction layer between search and database. There are different contexts for Doctrine's ORM, ODM, Elastica, Files and so on. If there is no context for you you can implement one - it's shouldn't be hard,
Searcher - holds collection of CriteriaBuilder and will pass Criteria to appropriate CriteriaBuilder.

Example

Let's say we want to search for people whose age is in some filtered range. In this example we will use Doctrine's QueryBuilder, so we will use QueryBuilderSearchingContext and will specify in our CriteriaBuidler that it should interact only with Doctrine\ORM\QueryBuilder, but remember that we do not have to use only Doctrine., _(*7)

1. Criteria

First of all we would need to create AgeRangeCriteria - the class that will holds values of minimal and maximal age. There are already implemented default Criteria in here., _(*8)

class AgeRangeCriteria implements CriteriaInterface
{
    private $minimalAge;
    private $maximalAge;

    /**
    * Only required method.
    * If will return true, then it will be passed to some of the CriteriaBuilder(s)
    */
    public function shouldBeApplied(): bool
    {
        return null !== $this->minimalAge && null !== $this->maximalAge;
    }

    // getters, setters, whatever
}

2. CriteriaBuilder

In second step we would like to specify conditions that should be imposed for this model. That's why we would need to create AgeRangeCriteriaBuilder, _(*9)

class AgeRangeCriteriaBuilder implements CriteriaBuilderInterface
{
    public function buildCriteria(
        CriteriaInterface $criteria,
        SearchingContextInterface $searchingContext
    ) {
        $searchingContext
            ->getQueryBuilder()
            ->andWhere('e.age >= :minimalAge')
            ->andWhere('e.age <= :maximalAge')
            ->setParameter('minimalAge', $criteria->getMinimalAge())
            ->setParameter('maximalAge', $criteria->getMaximalAge());
    }

    public function allowsCriteria(
        CriteriaInterface $criteria
    ): bool
    {
        return $criteria instanceof AgeRangeCriteria;
    }

    /**
    * You can skip this method if you will extend from AbstractORMCriteriaBuilder.
    */
    public function supportsSearchingContext(
        SearchingContextInterface $searchingContext
    ): bool
    {
        return $searchingContext instanceof QueryBuilderSearchingContext;
    }
}

3. Collections

In next steps we would need to create collections for both: Criteria and CriteriaBuidler., _(*10)

$builders = new CriteriaBuilderCollection();

$builders->addCriteriaBuilder(new AgeRangeCriteriaBuilder());
$builders->addCriteriaBuilder(/** rest of builders */);

```php $ageRangeCriteria = new AgeRangeCriteria();, _(*11)

// We have to populate the model before searching $ageRangeCriteria->setMinimalAge(23); $ageRangeCriteria->setMaximalAge(29);, _(*12)

$criteria = new CriteriaCollection(); $criteria->addCriteria($ageRangeCriteria); $criteria->addCriteria(/** rest of criteria */);, _(*13)


#### 4. SearchingContext
Now we would like to create our `SearchingContext` and populate it with QueryBuilder taken from Doctrine ORM.
```php
$context  = new QueryBuilderSearchingContext($queryBuilder);

$searcher = new Searcher($builders, $context);
$searcher->search($criteriaCollection); // Yay, we have our results!

If there is even small chance that your QueryBuilder will return null when you are expecting traversable object or array then you can use WrappedResultsSearcher instead of normal Searcher class. It will act exactly the same as Searcher, but it will return ResultCollection, which will work only with array or \Traversable and if result will be just null your code will still work. Here is how it will looks like:, _(*14)

$searcher = new WrappedResultsSearcher(new Searcher($builders, $context));
$results = $searcher->search($criteriaCollection);  // instance of ResultCollection
foreach ($results as $result) {
    // will work!
}

foreach ($results->getResults() as $result) {
    // Since ResultCollection has method getResults() this will also work!
}

Order

In order to sort your results you can make use of already implemented Criteria. You don't need to implement it from scratch. Keep in mind that you still need to implement your CriteriaBuilder for it (this feature is still under development). Let's say you want to order your results and you need value p.id in your CriteriaBuidler to do it, but you would like to show it as pid to end-user. Nothing simpler! This is how you can create OrderByCriteria:, _(*15)

$mappedFields = ['pid' => 'p.id', 'valueForUser' => 'valueForBuilder'];
$criteria = new MappedOrderByAdapter(
    new OrderByCriteria('pid'),
    $mappedFields
);
// $criteria->getMappedOrderBy() = 'p.id'
// $criteria->getOrderBy() = 'pid'

Of course you don't need to use MappedOrderByAdapter - you can use just OrderByCriteria, but then user will know exactly what fields are beeing used to sort., _(*16)

Pagination

Criteria for pagination is also implemented and you don't need to do it, but keep in mind that you still need to implement CriteriaBuilder that will make use of it and do actual pagination (this feature is under development). Let's say you want to allow your end-user to change pages, but not number of items per page. You can use this example code:, _(*17)

$criteria = new ImmutablePaginationAdapter(
  new PaginationCriteria($page = 1, $itemsPerPage = 50)
);
// $criteria->setItemsPerPage(250);    <- user can try to change it
// $criteria->getItemsPerPage() = 50   <- but he can't actualy do it
// $criteria->getPage() = 1

Of course if you want to allow user to change number of items per page also you can skip the ImmutablePaginationAdapter and use just PaginationCriteria., _(*18)

Contributing

All ideas and pull requests are welcomed and appreciated :) If you have any problem with usage don't hesitate to create an issue, we can figure your problem out together., _(*19)

Development

Command to run test: composer test.
All unit tests are tested with padric/humbug library for mutation testing, aiming to keep Mutation Score Indicator equal or close to 100%., _(*20)

To run mutation tests you need to install humbug and run: humbug in main directory. Output should be stored in humbuglog.txt., _(*21)

Thanks to

In alphabetical order - https://github.com/chkris - https://github.com/pawelhertman - https://github.com/ustrugany - https://github.com/wojciech-olszewski, _(*22)

License

License: MIT
Author: Krzysztof Gzocha
, _(*23)

The Versions

11/10 2017

dev-master

9999999-dev http://searcher.rtfd.io

Searcher is a framework-agnostic search query builder. Search queries are written using Criterias and can be run against MySQL, MongoDB, ElasticSearch or even files.

library searcher

Searcher is a framework-agnostic search query builder. Search queries are written using Criterias and can be run against MySQL, MongoDB, ElasticSearch or even files.

krzysztof-gzocha/searcher

The README.md

Searcher

What is that?

See this presentation to understand better

Why?

Full documentation

Installation

Integration

Idea

Example

1. Criteria

2. CriteriaBuilder

3. Collections

Order

Pagination

Contributing

Development

Thanks to

License

The Versions

dev-master

The Requires

The Development Requires

by Krzysztof Gzocha

dev-abstract-criteria-builder-join

The Requires

The Development Requires

by Krzysztof Gzocha

dev-master-3

The Requires

The Development Requires

by Krzysztof Gzocha

3.4.1

The Requires

The Development Requires

by Krzysztof Gzocha

5.0.0

The Requires

The Development Requires

by Krzysztof Gzocha

4.0.0

The Requires

The Development Requires

by Krzysztof Gzocha

dev-master-4.0

The Requires

The Development Requires

by Krzysztof Gzocha

4.0.0-alpha

The Requires

The Development Requires

by Krzysztof Gzocha

3.4.0

The Requires

The Development Requires

by Krzysztof Gzocha

dev-doctrine_searching_context_parameters

The Requires

The Development Requires

by Krzysztof Gzocha

3.3.2

The Requires

The Development Requires

by Krzysztof Gzocha

3.3.1

The Requires

The Development Requires

by Krzysztof Gzocha

3.3.0

The Requires

The Development Requires

by Krzysztof Gzocha

3.2.0

The Requires

The Development Requires

by Krzysztof Gzocha

3.1.2