#!/usr/bin/env nodejs
/*global describe, it*/
'use strict';
var mocha = require('mocha'); // jshint ignore:line
var expect = require('chai').expect;
var mongofilter = require('../dist/commonjs/mongofilter.js').mongofilter;
var testValues = [
{"id":1,"name":"toto","age":17} //0
,{"id":2,"name":"tito","age":18} //1
,{"id":3,"name":"tata","age":16} //2
,{"id":4,"name":"titi","age":20} //3
,{"id":5,"name":"tati","age":32} //4
,{"id":6,"name":"tato","age":52} //5
,{"id":7,"name":"tita","age":12} //6
,{"id":7,"name":"ti+ta","age":12}//7
];
function getTestAssertValues(){
for(var i=0,l=arguments.length,res=[];i<l;i++){
res.push(testValues[arguments[i]]);
}
return res;
}
function getFilteredValues(query){
return testValues.filter(mongofilter(query));
}
describe("basic comparison filters", function() {
it('should handle implicit comparison {prop:val}', function () {
expect(getFilteredValues({age:12})).to.eql(getTestAssertValues(6,7));
});
it('should handle "$eq" comparison {prop:{$eq:val}}', function () {
expect(getFilteredValues({age:{$eq:12}})).to.eql(getTestAssertValues(6,7));
});
it('should handle "$e" alias comparison {prop:{$e:val}}', function () {
expect(getFilteredValues({age:{$e:12}})).to.eql(getTestAssertValues(6,7));
});
it('should handle "$neq" comparison {prop:{$neq:val}}', function () {
expect(getFilteredValues({age:{$neq:12}})).to.eql(getTestAssertValues(0,1,2,3,4,5));
});
it('should handle "$ne" alias comparison {prop:{$ne:val}}', function () {
expect(getFilteredValues({age:{$ne:12}})).to.eql(getTestAssertValues(0,1,2,3,4,5));
});
it('should handle "$gt" comparison {prop:{$gt:val}}', function () {
expect(getFilteredValues({age:{$gt:17}})).to.eql(getTestAssertValues(1,3,4,5));
});
it('should handle "$gte" comparison {prop:{$gte:val}}', function () {
expect(getFilteredValues({age:{$gte:17}})).to.eql(getTestAssertValues(0,1,3,4,5));
});
it('should handle "$lt" comparison {prop:{$lt:val}}', function () {
expect(getFilteredValues({age:{$lt:17}})).to.eql(getTestAssertValues(2,6,7));
});
it('should handle "$lte" comparison {prop:{$lte:val}}', function () {
expect(getFilteredValues({age:{$lte:17}})).to.eql(getTestAssertValues(0,2,6,7));
});
});
describe("basic IN filters", function() {
it('should handle implicit array comparison {prop:[val,val,...]}', function () {
expect(getFilteredValues({age:[12,17]})).to.eql(getTestAssertValues(0,6,7));
});
it('should handle "$in" comparison {prop:{$in:[val,val,...]}}', function () {
expect(getFilteredValues({age:{$in:[12,17]}})).to.eql(getTestAssertValues(0,6,7));
});
it('should handle "$nin" comparison {prop:{$nin:[val,val,...]}}', function () {
expect(getFilteredValues({age:{$nin:[12,17]}})).to.eql(getTestAssertValues(1,2,3,4,5));
});
});
describe("basic LIKE filters", function () {
it('should handle "$like" comparison with starting "%" {prop:{$like:"%val"}}', function () {
expect(getFilteredValues({name:{$like:'%to'}})).to.eql(getTestAssertValues(0,1,5));
});
it('should handle "$like" comparison with "%" in arbitrary place to match a single char{prop:{"LIKE":"v%l"}}', function () {
expect(getFilteredValues({name:{$like:'t%ta'}})).to.eql(getTestAssertValues(2,6,7));
});
it('should handle "$like" comparison with leading and ending "%" {prop:{$like:"%a%"}}', function () {
expect(getFilteredValues({name:{$like:'%at%'}})).to.eql(getTestAssertValues(2,4,5));
});
it('should handle "$like" comparison with multiple "_" {prop:{$like:"__l"}}', function () {
expect(getFilteredValues({name:{$like:'__to'}})).to.eql(getTestAssertValues(0,1,5));
});
it('should handle "$like" comparison starting and ending "_" {prop:{$like:"_a_"}}', function () {
expect(getFilteredValues({name:{$like:'_i__'}})).to.eql(getTestAssertValues(1,3,6));
});
it('should handle "$nlike" comparison {prop:{$nlike:"%val"}}', function () {
expect(getFilteredValues({name:{$nlike:'%to'}})).to.eql(getTestAssertValues(2,3,4,6,7));
});
it('should handle "$nlike" comparison {prop:{$nlike:"v%al"}}', function () {
expect(getFilteredValues({name:{$nlike:'t%ta'}})).to.eql(getTestAssertValues(0,1,3,4,5));
});
it('should handle "$nlike" comparison {prop:{$nlike:"%val%"}}', function () {
expect(getFilteredValues({name:{$nlike:'%at%'}})).to.eql(getTestAssertValues(0,1,3,6,7));
});
it('should handle "$nlike" comparison {prop:{$nlike:"__val"}}', function () {
expect(getFilteredValues({name:{$nlike:'__to'}})).to.eql(getTestAssertValues(2,3,4,6,7));
});
it('should handle "$nlike" comparison {prop:{$nlike:"_val__"}}', function () {
expect(getFilteredValues({name:{$nlike:'_i__'}})).to.eql(getTestAssertValues(0,2,4,5,7));
});
});
describe("basic REGEX filters", function () {
it('should handle "$regex" comparison {prop:{$regex:"val$"}}', function () {
expect(getFilteredValues({name:{$regex:"to$"}})).to.eql(getTestAssertValues(0,1,5));
});
it('should handle "$regex" comparison {prop:{$regex:"/val$/"}}', function () {
expect(getFilteredValues({name:{$regex:"/to$/"}})).to.eql(getTestAssertValues(0,1,5));
});
it('should handle "$regex" comparison {prop:{$regex:/^val$/}}', function () {
expect(getFilteredValues({name:{$regex:/^(t.)\1$/}})).to.eql(getTestAssertValues(0,2,3));
});
});
describe("basic AND/OR/NOR testing", function () {
it('should handle implicit "$and" comparison {prop:{$regex:"val$"},prop:val}', function () {
expect(getFilteredValues({name:{$regex:"to$"},age:52})).to.eql(getTestAssertValues(5));
});
it('should handle "$or" comparison {$or:[{prop:val},{prop:val},...]}', function () {
expect(getFilteredValues({$or:[{age:12},{age:52}]})).to.eql(getTestAssertValues(5,6,7));
});
it('should handle "$or" comparison {$or:{prop:val,prop:val}}', function () {
expect(getFilteredValues({$or:{name:"tito",age:52}})).to.eql(getTestAssertValues(1,5));
});
it('should handle "$nor" comparison {$nor:[{prop:val},{prop:val},...]}', function () {
expect(getFilteredValues({$nor:[{age:[52,18]},{name:'tito'}]})).to.eql(getTestAssertValues(0,2,3,4,5,6,7));
expect(getFilteredValues({$nor:[{id:7},{name:'tita'}]})).to.eql(getTestAssertValues(0,1,2,3,4,5,7));
});
it('should handle "$nor" comparison {$nor:{prop:val,prop:val}}', function () {
expect(getFilteredValues({$nor:{age:[52,18],name:'tito'}})).to.eql(getTestAssertValues(0,2,3,4,5,6,7));
expect(getFilteredValues({$nor:{id:7, name:'tita'}})).to.eql(getTestAssertValues(0,1,2,3,4,5,7));
});
it('should handle "$not" comparison {$not: {prop: val}}', function () {
expect(getFilteredValues({$not:{age:12}})).to.eql(getTestAssertValues(0,1,2,3,4,5));
});
it('should handle "$not" comparison {$not: {prop: val, prop: val}}', function () {
expect(getFilteredValues({$not:{age:12, name: 'toto'}})).to.eql(getTestAssertValues(1,2,3,4,5));
});
it('should handle "$not" comparison {$not: [{prop: val}, {prop: val}]}', function () {
expect(getFilteredValues({$not:[{age:12}, {name: 'toto'}]})).to.eql(getTestAssertValues(1,2,3,4,5));
});
});
describe('predicate logical methods', function () {
it('should have a "and" method', function () {
var predicate = mongofilter({name:{$regex:"to$"}});
expect(testValues.filter(predicate.and({age:52}))).to.eql(getTestAssertValues(5));
});
it('should have an "or" method', function () {
var predicate = mongofilter({age:52});
expect(testValues.filter(predicate.or({name: 'tito'}))).to.eql(getTestAssertValues(1,5));
expect(testValues.filter(predicate.or({age:12}))).to.eql(getTestAssertValues(5,6,7));
});
});
|
Download
