PHP code example of crcms / elasticsearch

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

crcms / elasticsearch example snippets

// select config path
$config = nfig);

$builder->index('index')->type('type')->create([
    'key' => 'value'
]);

// return a collection
$builder->index('index')->type('type')->createCollection([
    'key' => 'value'
]);

$builder->index('index')->type('type')->update([
    'key' => 'value1'
]);

$builder->index('index')->type('type')->delete($result->_id);

$builder = $builder->index('index')->type('type');
	
//SQL:select ... where id = 1 limit 1;
$result = $builder->whereTerm('id',1)->first();

//SQL:select ... where (key=1 or key=2) and key1=1
$result = $builder->where(function (Query $inQuery) {
    $inQuery->whereTerm('key',1)->orWhereTerm('key',2)
})->whereTerm('key1',1)->get();

$builder->take(10)->get(); // or limit(10)
$builder->offset(10)->take(10)->get(); // or skip(10)

$builder->whereTerm('key',value)->first();

$builder->whereMatch('key',value)->first();

$builder->whereBetween('key',[value1,value2])->first();

$builder->whereIn('key',[value1,value2])->first();

$builder->whereTerm('key',value)->orWhereTerm('key2',value)->first();

$result = $builder->where(function (Builder $inQuery) {
    $inQuery->whereTerm('key',1)->orWhereTerm('key',2)
})->whereTerm('key1',1)->get();

public function select($columns): self

public function where($column, $operator = null, $value = null, $leaf = 'term', $boolean = 'and'): self

public function orWhere($field, $operator = null, $value = null, $leaf = 'term'): self

public function whereMatch($field, $value, $boolean = 'and'): self

public function orWhereMatch($field, $value, $boolean = 'and'): self

public function whereTerm($field, $value, $boolean = 'and'): self

public function whereIn($field, array $value)

public function orWhereIn($field, array $value)

public function orWhereTerm($field, $value, $boolean = 'or'): self

public function whereRange($field, $operator = null, $value = null, $boolean = 'and'): self

public function orWhereRange($field, $operator = null, $value = null): self

public function whereBetween($field, array $values, $boolean = 'and'): self

public function whereNotBetween($field, array $values): self

public function orWhereNotBetween(string $field, array $values): self

public function whereExists($field, $boolean = 'and'): self

public function whereNotExists($field, $boolean = 'and'): self

public function orWhereBetween($field, array $values): self

public function orderBy(string $field, $sort): self

public function scroll(string $scroll): self

public function aggBy($field, $type): self

public function select($columns): self

public function get(): Collection

public function paginate(int $page, int $perPage = 15): Collection

public function first()

public function byId($id)

public function byIdOrFail($id): stdClass

public function chunk(callable $callback, $limit = 2000, $scroll = '10m')

public function create(array $data, $id = null, $key = 'id'): stdClass

public function update($id, array $data): bool

public function delete($id)

public function count(): int

//open log
$builder->enableQueryLog();

//all query log
dump($build->getQueryLog());

//last query log
dump($build->getLastQueryLog());

getElasticSearch() // or search()

php artisan vendor:publish --provider="CrCms\ElasticSearch\LaravelServiceProvider"