brokerexchange/elasticbuilder

Query Builder for Elasticsearch.

v7.1.2 2023-11-09 17:59 UTC

MIT

• Brian Mix

• generator
• query
• elasticsearch
• builder
• laravel
• eloquent

README

Query DSL Builder for Elasticsearch queries

Use ElasticBuilder to combine multiple queries/filters/aggregations into Elasticsearch Query DSL within Laravel projects!

License

ElasticBuilder is released under the MIT Open Source License, https://opensource.org/licenses/MIT

Copyright

ElasticBuilder © Broker Exchange Network 2018

Overview

ElasticBuilder is a Laravel 5.x Framework Package consisting of Static Methods and Abstract classes you can use to build Elasticsearch query DSL AND map your query input arguments to the DSL as it is generated. Also handles paging arguments, sorting, and aggregations. Provides Laravel Framework Service Provider and Facade, as well as a Trait you can apply to your eloquent models.

Installation

ElasticBuilder must use Elasticsearch 1.x or greater, and Laravel 5.x

• Add "brokerexchange/elasticbuilder": "^1.0.0" to your composer.json file
• Run composer update
• Add provider ElasticBuilder\ElasticBuilderServiceProvider::class to your list of providers in app/config/app.php of your laravel project
• Add facade 'Eb' => ElasticBuilder\Eb::class to your list of aliases in app/config/app.php of your laravel project

Examples

Facade

Example of using a Facade

Here is how you add a clause to a query (in this case must clause to bool query).

<?php
$query = Eb::boolean()
    ->must(Eb::term('category_id',1))
    ->filter(Eb::range('published_at',['lte' => Carbon::now()->toIso8601String(),'gte' => Carbon::now()->subDay(10)->toIso8601String()]));
var_dump($query);

<?php
$query = \Eb::multi_match(['title^3','summary^1','body','userName^2','categoryName^2','tag_string^1'],'lorim ipsum','and','cross_fields');
var_dump($query);

Trait

Apply the trait class to an eloquent model (possibly one already using Elasticquent/Elasticquent or similar package)

<?php
    use ElasticBuilder\ElasticBuilderTrait;

    /**
     * Class Article
     * @package App
     */
    class Article extends Model
    {
        use ElasticBuilderTrait;

Now you can use a static bool,dismax,boosting etc query from within a model simlilar to the eloquent query builder!

<?php
    Article::bool()->filter(Eb::term('category_id','1);

or

<?php
    Article::dis_max()->query(Eb::match('body',$keywords));

Bool query with aggregation as eloquent model trait

<?php

    //trait example
    $results = $article->boolean()
        ->must(Eb::match('body','keyword search string'))
        ->aggregate(Eb::agg()->terms('categories','category_id'))->get(); //returns Elasticquent Results Object
            
    var_dump($results);
       
       
    //trait exaple with paging
    $results = $article->boolean()
       ->must(Eb::match('body','keyword search string'))
       ->aggregate(Eb::agg()->terms('categories','category_id'))->paginate(20); //returns Elasticquent Paginator Object
       
    var_dump($results);

<?php
if($this->request->has('search')){
    $search = $this->request->get('search');
    $match = \Eb::multi_match(['title^3','summary^1','body','userName^2','categoryName^2','tag_string^1'],$search,'and','cross_fields');
} else {
    $match = \Eb::match_all();
}
$this->must($match);

Here is an example of adding a filter to the bool query from within the extended class

<?php
$filter = \Eb::range('published_at',['lte' => Carbon::now()->toIso8601String()]);
$this->filter($filter);

Other

More Examples

<?php
$query = Article::agg()
    ->terms('categories','category_id');
var_dump($query);