Skip to content

Microland/elasticsearc-orm

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

elasticsearch - orm-a basic Elasticsearch query API

npm package

Install

  npm install elasticsearch-orm-v1

Directory

  • [Create connection] (#user-content-create connection)
  • [Index related] (#user-content-index related)
  • [Documentation related] (#user-content-documentation related)
  • [Query related] (#user-content-query related)
  • [Using aggregate] (#user-content-using aggregate)
  • [Pagination related] (#user-content-pagination related)
  • [Settings] (#user-content-Settings)
  • [Cluster-related Interface] (#user-content-cluster-related interface)
  • [Query API] (#user-content-query api)
  • [Aggregate API] (#user-content-aggregate api)

Create a connection

  const orm = require('elasticsearch-orm-v1');
  const instance = orm({
      'domain':'127.0.0.1',
      'port':9200
  });

  instance.on ('connected', () =>{
      console.log ('connected');
  });

  instance.on ('error', (e) =>{
    console.log('connection exception', e);
  });

Index related

Create an index

Generate an index type

  const demoIndex = instance.register ('demoIndex',{
      'index': 'demoindex',
      'type':'demotype'
    },{
        'title':{
            'type':'text'
        },
        'age':{
            'type': 'integer'
        },
        'location':{
            'type': 'geo_point'
        }
      },{
        'number_of_shards': 2,
        'number_of_replicas': 4
      });

Synchronous index: if the index has not been created, it will follow mappings and settingscreate 'index, if the index has been created, it will automatically determine which mappings are new, and these new mappings' addto the index.the sync method returns a Promise object, so you can use the await keyword.

   await demoIndex.sync.();

Index health values

    const health = await demoIndex.health();

Index State

    const stat = await demoIndex.stat.();

Index statistics

    const state = await demoIndex.state();

SET index alias

    const result = await demoIndex.alias (['alias_name']);

Remove alias

    const result = await demoIndex.removeAlias (['alias_name']);

Refresh

    const result = await demoIndex.refresh();

Rinse

    const result = await demoIndex.flush.();

Force merge

    const result = await demoIndex.forceMerge();

Test the word breaker

    const result = await demoIndex.analyze ('I love Beijing Tiananmen', 'ik_max_word');

Open an index

    const result = await demoIndex.open();

Close an index

    const result = await demoIndex.close.();

Documentation related

Create a document

the create method returns a Promise object that uses the await keyword to return the newly created document ID

let id = await demoIndex.create({
    'title': 'Demo Title',
    'age', 12,
    'location':{
      'lon':100.1,
      'lat':40.2
    }
  });

Specify the document ID to create the document

  await demoIndex.create({
    'title': 'Demo Title',
    'age', 12,
    'location':{
      'lon':100.1,
      'lat':40.2
    }
  }, 'document_id');

Specifying a document routing

  await demoIndex.create({
    'title': 'Demo Title',
    'age', 12,
    'location':{
      'lon':100.1,
      'lat':40.2
    }
  }, 'document_id', 'routing_hash');

Specifying a parent node

  await demoIndex.create({
    'title':'Title',
    'age':123
    }, null, null,{
      'parent': 'parent_id'
    })

Update documentation

  await demoIndex.update ('docuemnt_id',{
    'title': "Demo Title 2",
    'age':13
  })

Specifying a document routing

  await demoIndex.update ('document_id',{
    'title': 'Demo Title 2',
    'age':14
    }, 'routing_hash')

Delete document

  await demoIndex.delete(id);
  await demoIndex.delete (['id1', 'id2'])

Get documents by id

If the id does not exist, an Error is returned

  let doc = await demoIndex.get(id);

Query related

Build simple queries

    let ret = await demoIndex.query();

ret object returns even a child object, one is list, is the result of extracting a good _source array, the other is orgResult, is the original content returned by es

Query conditions

For a single query, see [query API] (#user-content-query api)

  let ret = await demoIndex.term ('age', 12).query();

Multiple query conditions

  let ret = await demoIndex
      .term('age', 12)
      .match ('title',"")
      .query();

must, should, not inquiry

  const Condition = require("elasticsearch-orm-v1").Condition;
  let ret = await demoIndex
    .must (new Condition().term('age', 12))
    .should(new Condition().match ('title', 'Tiel'))
    .not (new Condition().exists('age'))
    .query();

filter query

  const Condition = require("elasticsearch-orm-v1").Condition;
  let ret = await demoIndex
            .filter (new Condition().matchAll())
            .query();

Building nested queries

const Condition = require("elasticsearch-orm-v1").Condition;
let condition = new Condition();
condition.term('age', 12)
    .match ('title','Title')
    .not (new conditional()
    .range('age',0, 10));
let ret = await demoIndex
    .should(condition)
    .exists ('location')
    .query();

Working with aggregations

Use basic aggregation

You can get the result of the aggregation through the orgresult object's original return value. see the complete aggregation API at [aggregation API] (#user-content-aggregation api)

  const Aggs = require('elasticsearch-orm').Aggs.;
  let ret = await demoIndex
      .exists('age')
      .aggs(new Aggs('avg_age').avg('age'))
      .query();

Aggregated sub-aggregations

  const Aggs = require('elasticsearch-orm').Aggs.;
  let aggs = new Aggs ('test_aggs').terms ('title');
  aggs.aggs(new Aggs('sub_aggs').valueCount('age'));
  let ret = await demoIndex
      .exist('age')
      .aggs(aggs)
      .query();

Pagination related

Pagination

  let ret = await demoIndex
      .from(0)
      .size (15)
      .query();

Use the scroll

Initiate a scroll

    await demoIndex.query({
        'scroll':'1m'
    })

Perform scrolling

    await demoIndex.scroll(scrollId,{
        'scroll':'1m'
    });

Clear a scroll

    await demoIndex.clearScroll(scrollId);

Sort

  let ret = await demoIndex
      .sort ('age','asc')
      .sort ('title','asc', 'min')
      .query();

Or ...

  let ret = await demoIndex
      .sort.({
          'age':{
              'order': 'desc',
              'mode': 'min'
          }
      })
      .query();

Settings

If debug is set to true, the request body, url, and return value of each request are printed

  let instance = orm({
    'domain':'127.0.0.1',
    'port':9200
  });
  instance.set ("debug", true);

You can set the method of debug

  instance.set ("log", console.log);

Set request timeout in milliseconds (default is 30s)

  instance.set ('timeout', 5000);

Cluster-related interfaces

Get cluster health values

    const health = await instance.health();

Get cluster status

    const state = await instance.state();

Get cluster statistics

    const stat = await instance.stat.();

Get Index list

    const result = await instance.indices();

Node information

    const result = await instance.nodes();

Node status

    const result = await instance.nodeStat ('node_id');

Close a node

    const result = await instance.shutDown ('node_id');

Query API

Text matching

match query

  let condition = new Condition();
  condition.match ('title', 'content1 content2');
  condition.match ('title', 'content1 content2',{
    'operator':'and'
    });

The generated query json is

  {
    "match":{
        "title": "content1 content2",
        "operator": "and"
    }
  }

the field argument can be an array

  condition.match (['title', 'description'], 'content1 content2');
  condition.match (['title', 'description'], 'content1 content2',{
      'type': 'best_fields'
    });

The generated query json is

  {
    "multi_match":{
        "query": "content1 content2",
        "type": "best_fields",
        "fields": ["title","description"]
    }
  }

Phrase query matchPhrase and matchPhrasePrefix

condition.matchPhrase('title', 'content1 content2');
condition.matchPrasePrefix ('title', 'content1 content2');
condition.matchPhrase('title', 'content1 content2',{
  'analyzer': 'test_analyzer'
  });

Generate query json

  {
    "match_phrase":{
      "title":{
        "query": "content1 content2",
        "analyzer": "test_analyzer"
      }
    }
  }
  {
    "match_phrase_prefix":{
      "title":{
        "query": "content1 content2"
      }
    }
  }

Exact value

term query

condition.term('age', 13);
condition.term('age',[13,15]);

Generate query json

  {
    "term.":{
        "age": 13
    }
  }
  {
    "terms.":{
        "age":[13,15]
    }
  }

exists query

condition.exists('age');
condition.exists (['age','title']);

Generating json

{
  "exists.":{
    "field": "age"
  }
}
{
  "exists.":{
    "fields":["age", " title"]
  }
}

range query

condition.range('age', 1);
condition.range('age',1, 10);
condition.range('age', null, 10);
condition.range('age', 1, 10, true, false);

Generating json

  {
    "range.":{
        "age":{
            "gt":1
        }
    }
  }
  {
    "range.":{
        "age":{
            "gt":1,
            "lt": 10
        }
    }
  }
  {
    "range.":{
        "age":{
            "lt": 10
        }
    }
  }
  {
    "range.":{
        "age":{
            "gte": 1,
            "lt": 10
        }
    }
  }

Using the Range object

const Range = require ('elasticsearch-orm').Range.();
let range = new Range(1);
range = new Range(1,10);
range = new Range(1,10, false, true);
range = new Range(). gt(1,true). lt (10, false);
condition.range(range);

prefix, wildcard and fuzzy

condition.prefix ('title', 'Tre');
condition.wildcard ('title', 'Tre * hao');
condition.fuzzy ('title',{
  'value': 'ki',
  'boost':1.0
})

Generating json files

{
  "prefix":{
    "title": "Tre"
  }
}
{
  "wildcard.":{
    "title": "Tre * hao"
  }
}
{
  "fuzzy.":{
    "title":{
        "value": "ki",
        "boost":1.0
    }
  }
}

Geographic location query

geoShape

condition.geoShape ('location','circle',
  [{
  'lon': 100.0,
  'lat': 41.0
  }],
  {
    'radius': "100m",
    "relation": "within"
    })

Generating json

  {
    "geo_shape":{
        "location":{
            "shape.":{
              "type": "circle",
              "coordinates.":[{
                "lon":100.0,
                "lat":41.0
              }],
              "relation": "within"
            }
        }
    }
  }

geoDistance

  condition.geoDistance ('location',{
    'lon': 100.0,
    'lat':31.0
    }, '100m');

Generating json

  {
    "geo_distance":{
      "distance": "100m",
      "location":{
        "lon":100.0,
        "lat":31.0
      }
    }
  }

geoPolygon

condition.geoPolygon ('location',[{
  'lon': 100.0,
  'lat':41.1
  },{
    'lon':101.0,
    'lat':42.1
   },{
     'lot':102.3,
     'lat':42.4
    }])

Generating json

{
  "geo_polygon.":{
      "location":{
          "points":[{
                  "lon":100.0,

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 100.0%