All Projects → roaatech → Php Es Mapper

roaatech / Php Es Mapper

Licence: mit
An elasticsearch simple mapping ORM for php

Projects that are alternatives of or similar to Php Es Mapper

Ship Hold
data access framework for Postgresql on nodejs
Stars: ✭ 110 (+340%)
Mutual labels:  builder, orm, query-builder
Elasticsearch
The missing elasticsearch ORM for Laravel, Lumen and Native php applications
Stars: ✭ 375 (+1400%)
Mutual labels:  orm, query-builder, elasticsearch
Loukoum
A simple SQL Query Builder
Stars: ✭ 305 (+1120%)
Mutual labels:  builder, query-builder
React Querybuilder
A QueryBuilder component for React
Stars: ✭ 315 (+1160%)
Mutual labels:  builder, query-builder
Hibernate Search
Hibernate Search: full-text search for domain model
Stars: ✭ 382 (+1428%)
Mutual labels:  orm, elasticsearch
Elastichd
Elasticsearch 可视化DashBoard, 支持Es监控、实时搜索,Index template快捷替换修改,索引列表信息查看, SQL converts to DSL等
Stars: ✭ 2,993 (+11872%)
Mutual labels:  elastic, elasticsearch
Helk
The Hunting ELK
Stars: ✭ 3,097 (+12288%)
Mutual labels:  elastic, elasticsearch
Elastic Builder
A Node.js implementation of the elasticsearch Query DSL 👷
Stars: ✭ 367 (+1368%)
Mutual labels:  query-builder, elasticsearch
Android Orma
An ORM for Android with type-safety and painless smart migrations
Stars: ✭ 442 (+1668%)
Mutual labels:  orm, query-builder
Graphql Compose Elasticsearch
Hide Elastic Search REST API behind GraphQL.
Stars: ✭ 498 (+1892%)
Mutual labels:  elastic, elasticsearch
Gocqlx
All-In-One: CQL query builder, ORM and migration tool
Stars: ✭ 512 (+1948%)
Mutual labels:  orm, query-builder
database
Database SQL builder, written in Go, provides a convenient to creating and running database queries.
Stars: ✭ 26 (+4%)
Mutual labels:  builder, query-builder
AdvancedSQL
The best Java query builder/SQL connector.
Stars: ✭ 23 (-8%)
Mutual labels:  builder, query-builder
Elasticsearch Rails
Elasticsearch integrations for ActiveModel/Record and Ruby on Rails
Stars: ✭ 2,896 (+11484%)
Mutual labels:  elastic, elasticsearch
indexeddb-orm
Indexed DB ORM
Stars: ✭ 53 (+112%)
Mutual labels:  builder, query-builder
Diesel
A safe, extensible ORM and Query Builder for Rust
Stars: ✭ 7,702 (+30708%)
Mutual labels:  orm, query-builder
Phalcon Mongodb Odm
MongoDB ODM for Phalcon framework for new mongodb php extension with query builder and rich functionality
Stars: ✭ 42 (+68%)
Mutual labels:  builder, query-builder
Bodybuilder
An elasticsearch query body builder 💪
Stars: ✭ 1,093 (+4272%)
Mutual labels:  builder, elasticsearch
Pfelk
pfSense/OPNsense + ELK
Stars: ✭ 417 (+1568%)
Mutual labels:  elastic, elasticsearch
Elasticsql
convert sql to elasticsearch DSL in golang(go)
Stars: ✭ 687 (+2648%)
Mutual labels:  elastic, elasticsearch

ElasticSearch PHP ORM and Query Builder (es-mapper)

This is a simple ORM mapper for ElasticSearch for PHP.

ElasticSearch DSL query builder for PHP.

Collaborators required

If you can join me in updating and maintaining this project, please send a message to [email protected]

Requirements

  • PHP 5.4+
  • Elasticsearch PHP SDK v>=1 and <2
  • ElasticSearch server 1.6. ES2 is not tested, so use with care.

Installation

Composer

composer require itvisionsy/php-es-orm

Manual download

Head to the latest version here then download using one download button.

How to use?

For the Query Builder, read this README instead

That is simple:

Per index query:

  1. Create a class extending the main query class (for general index use) .
  2. Fill in the abstract methods. They are self-descriptive.
  3. Use the created class ::find($type, $id), ::query($type, array $query =[]), and ::all($type) You will get a list of Model objects where you can object-property access to get all the info. i.e. $model->name to get the name property, ...

Per type query

  1. Create a class extending the type query class. OR create a class extending the main query class and implementing the TypeQueryInterface interface and use the TypeQueryTrait trait
  2. Fill in the abstract methods. They are self-descriptive.
  3. Use the methods: ::find($id), ::all(), and ::query(array $query=[]). You will get a list of Model objects the same way described above.

Please note

Methods' parameters are mapped to original elasticsearch methods and parameters as follows:

Querying for data

The query class is just a simple interface allows you to send DSL queries, or perform other ElasticSearch requests. The ::query() method for example will expect to receive an assoc-array with a well-formed DSL query.

However, you can use the query builder to builder the query and get a well-formed DSL array out of it.

You can use a type-query query builder to build the query and execute it directly:

$result = TypeQuery::builder()
    ->where('key1','some value')
    ->where('key2',$intValue,'>')
    ->where('key3','value','!=')
    ->where('key4', ['value1','value2'])
    ->execute();
//$result is a \ItvisionSy\EsMapper\Result instance

Or you can use a generic query builder to build the query then you can modify it using other tools:

//init a builder object
$builder = \ItvisionSy\EsMapper\QueryBuilder::make();

//build the query using different methods
$query = $builder
                ->where('key1','some value') //term clause
                ->where('key2',$intValue,'>') //range clause
                ->where('key3','value','!=') //must_not term clause
                ->where('key4', ['value1','value2']) //terms clause
                ->where('email', '@hotmail.com', '*=') //wildcard search for all @hotmail.com emails
                ->sort('key1','asc') //first sort option
                ->sort('key2',['order'=>'asc','mode'=>'avg']) //second sort option
                ->from(20)->size(20) //results from 20 to 39
                ->toArray();

//modify the query as you need
$query['aggs']=['company'=>['terms'=>['field'=>'company']]];

//then execute it against a type query
$result = TypeQuery::query($query);
//$result is a \ItvisionSy\EsMapper\Result instance

Please refer to this file for more detailed information.

Retrieving results

The returned result set implements the ArrayAccess interface to access specific document inside the result. i.e.

$result = SomeQuery::all();

You can then get a document like this:

$doc = $result[1]; //gets the second document

Or you can use the dot notation like that:

$result->fetch('hits.hits.0'); //for any absolute access

Accessing document data

On the model object, you can access the results in many ways:

  1. using the object attribute accessor $object->attribute
    • if the attribute starts with underscore (_) then it will try to fetch it first from the meta information, then the attributes, and then from the internal object properties.
    • if the attribute starts with two underscores (__) then it will try to fetch first from the internal object properties, then attributes, then meta.
    • if not precedence underscores, then it will try to fetch from the attributes, then meta, then internal object properties.
  2. using the $object->getAttributes()[attribute], as the getAttributes() will return the document data as an array (first level only).
  3. using the $object->getAttributes($attribute1, $attribute2, ...) which will return a single (or array) value[s] depending on the requested attributes

Creating new documents

Either way will work:

  1. Use the index query static method

    IndexQuery::create(array $data, $type, $id=null, array $parameters=[])
    
  2. Use the type query static method:

TypeQuery::create(array $data, $id=null, array $parameters=[])

Updating a document

You can update an already indexed document by:

  1. Either Re-indexing a document with the same type and id, OR
  2. Or update(array $data, array $parameters=[]) method on the model's object:
TypeQuery::find(1)->update(['new_key'=>'value','old_key'=>'new value'],[]);

Deleting a document

The same way you can update a document, you can delete it:

  1. Calling the static method ::delete($type, $id) on the index query
  2. Calling the method ->delete() on model's object.

Adding extra methods

You may need to add extra custom methods like top($numOfDocs) or anything else. To do so, you need to create the method name you wish as protected in the query sub-class. The name should be prefixed with _ (i.e. _top) then, you can either

  • Call it prefixed with get, so to call the _top(500) method, just call getTop(500) and it will be mapped as public static and as public.

  • Override the _allowPublicAccess static protected method to add extra methods to expose. Please note that when overriding, don't forget to merge with the parent results not to lose the old ones:

    protected _allowPublicAccess(){
        return array_merge(parent::_allowPublicAccess(), ['top','any',...]);
    }
    

    This way you will save the allowed methods from the parent.

Extending the Model class

You can extend the Model class easily. Just extend it! In case you were using the namespaces, you can set the models namespace in the query class by overriding the modelNamespace public method. This method should return a string ending with
After that, you need to call the ->setModelClass($class) on the query result object.

Examples

Please check tests/ folder. Basically, the case1.php is the main file.

\
|
+-- TestsIndexQuery (TestsIndexQuery.php)   Main index query class.
|   |                                       Maps results to \Models\ namespace.
|   |
|   +-- \FooTypeQuery (FooTypeQuery.php)    Type index query class.
|   |
|   +-- \BarTypeQuery (BarTypeQuery.php)    Type index query class. 
|
|-- Models\
    |
    +-- Foo (FooMode.php)                   Foo model class
    |
    +-- Bar (BarModel.php)                  Bar model class

License

This code is published under MIT license.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].