solr-query-builder
v1.0.1
Published
solr query builder
Downloads
1,616
Readme
solr query builder
A query builder for Solr based in it query syntax.
It has the only purpose to build the q=
part of the solr query. For the rest of the query you may want use the solr-node-client.
Available queries
where
equals
in
begin
(begins a new block(
)end
(closes the current block)
)or
any
between
betweenWithOpenIntervals
lt
gt
lte
gte
Installation
Install via npm:
$ npm install solr-query-builder
Usage
var SolrQueryBuilder = require('solr-query-builder'),
var qb = new SolrQueryBuilder();
// example values to query
var opt = {
city: [ 'Florianopolis', 'New York', 'Tokyo' ],
status: 'open',
age: 33,
startDate: '2014-03-22T14:04:48.691Z',
endDate: '2018-03-22T14:04:48.691Z',
offset_date: '2015-03-22T14:04:48.691Z',
offset_id: '507f1f77bcf86cd799439011',
name: 'Claus'
};
// building the query
if (opt.city) qb.where('city').in(opt.city);
if (opt.status) qb.where('status', opt.status);
if (opt.age) qb.where('age').equals(opt.age);
if (opt.startDate || opt.endDate) {
qb.where('birthDate').between(opt.startDate, opt.endDate);
}
if (opt.offset_date && opt.offset_id) {
qb.begin()
.where('birthDate').lt(opt.offset_date)
.or()
.begin()
.where('birthDate').equals(opt.offset_date)
.where('_id').lt(opt.offset_id)
.end()
.end();
}
if (opt.name) {
qb.any({
firstName: opt.name,
middleName: opt.name,
lastName: opt.name
}, { contains: true });
}
// parses the query object to query string
var queryResult = qb.build();
console.log(queryResult);
// city: ("Florianopolis" "New York" "Tokyo") AND status: "open" AND age: 33 AND birthDate: [2014-03-22T14:04:48.691Z TO 2018-03-22T14:04:48.691Z] AND ( birthDate: {* TO 2015-03-22T14:04:48.691Z} OR ( birthDate: "2015-03-22T14:04:48.691Z" AND _id: {* TO 507f1f77bcf86cd799439011} ) ) AND ( firstName: (*Claus*) OR middleName: (*Claus*) OR lastName: (*Claus*) )
Usage with solr-node-client
var solr = require('solr-client');
var SolrQueryBuilder = require('solr-query-builder'),
var qb = new SolrQueryBuilder();
// build your query using the query solr-query-builder...
var client = solr.createClient();
var query = client.createQuery()
.q(qb.build())
.start(0)
.rows(10);
Contributing
It is required to use editorconfig and please write and run specs before pushing any changes:
npm test
License
Copyright (c) 2014 Max Claus Nunes. This software is licensed under the MIT License.