sift
mongodb query style array filtering
Last updated 6 years ago by crcn .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ npm install sift 
SYNC missed versions from official npm registry.

validate objects & filter arrays with mongodb queries

Build Status

For extended documentation, checkout http://docs.mongodb.org/manual/reference/operator/query/

Features:

Node.js Examples

import sift from "sift";

//intersecting arrays
var result = ["hello", "sifted", "array!"].filter(
  sift({ $in: ["hello", "world"] })
); //['hello']

//regexp filter
var result = ["craig", "john", "jake"].filter(sift(/^j/)); //['john','jake']

// function filter
var testFilter = sift({
  //you can also filter against functions
  name: function(value) {
    return value.length == 5;
  }
});

var result = [
  {
    name: "craig"
  },
  {
    name: "john"
  },
  {
    name: "jake"
  }
].filter(testFilter); // filtered: [{ name: 'craig' }]

//you can test *single values* against your custom sifter
testQuery({ name: "sarah" }); //true
testQuery({ name: "tim" }); //false\

Browser Examples

<html>
  <head>
    <script
      src="https://raw.github.com/crcn/sift.js/master/sift.min.js"
      type="text/javascript"
    ></script>
    <script type="text/javascript">
      //regexp filter
      var sifted = sift(/^j/, ["craig", "john", "jake"]); //['john','jake']
    </script>
  </head>
  <body></body>
</html>

API

.sift(query: MongoQuery, options?: SiftOptions): Function

  • query - the filter to use against the target array
  • options - select - value selector - expressions - custom expressions

With an array:

["craig", null].filter(sift({ $exists: true })); //['craig']

Without an array, a sifter is returned:

var existsFilter = sift({ $exists: true });

existsFilter("craig"); //true
existsFilter(null); //false
["craig", null].filter(existsFilter); //['craig']

With a selector:

var omitNameFilter = sift({ $exists: true }, function(user) {
  return !!user.name;
});

[
  {
    name: "Craig"
  },
  {
    name: null
  }
].filter(omitNameFilter);

With your sifter, you can also test values:

siftExists(null); //false
siftExists("craig"); //true

Supported Operators:

See MongoDB's advanced queries for more info.

$in

array value must be $in the given query:

Intersecting two arrays:

//filtered: ['Brazil']
["Brazil", "Haiti", "Peru", "Chile"].filter(
  sift({ $in: ["Costa Rica", "Brazil"] })
);

Here's another example. This acts more like the $or operator:

[{ name: "Craig", location: "Brazil" }].filter(
  sift({ location: { $in: ["Costa Rica", "Brazil"] } })
);

$nin

Opposite of $in:

//filtered: ['Haiti','Peru','Chile']
["Brazil", "Haiti", "Peru", "Chile"].filter(
  sift({ $nin: ["Costa Rica", "Brazil"] })
);

$exists

Checks if whether a value exists:

//filtered: ['Craig','Tim']
sift({ $exists: true }, ["Craig", null, "Tim"]);

You can also filter out values that don't exist

//filtered: [{ name: 'Craig', city: 'Minneapolis' }]
[{ name: "Craig", city: "Minneapolis" }, { name: "Tim" }].filter(
  sift({ city: { $exists: false } })
);

$gte

Checks if a number is >= value:

//filtered: [2, 3]
[0, 1, 2, 3].filter(sift({ $gte: 2 }));

$gt

Checks if a number is > value:

//filtered: [3]
[0, 1, 2, 3].filter(sift({ $gt: 2 }));

$lte

Checks if a number is <= value.

//filtered: [0, 1, 2]
[0, 1, 2, 3].filter(sift({ $lte: 2 }));

$lt

Checks if number is < value.

//filtered: [0, 1]
[0, 1, 2, 3].filter(sift({ $lt: 2 }));

$eq

Checks if query === value. Note that $eq can be omitted. For $eq, and $ne

//filtered: [{ state: 'MN' }]
[{ state: "MN" }, { state: "CA" }, { state: "WI" }].filter(
  sift({ state: { $eq: "MN" } })
);

Or:

//filtered: [{ state: 'MN' }]
[{ state: "MN" }, { state: "CA" }, { state: "WI" }].filter(
  sift({ state: "MN" })
);

$ne

Checks if query !== value.

//filtered: [{ state: 'CA' }, { state: 'WI'}]
[{ state: "MN" }, { state: "CA" }, { state: "WI" }].filter(
  sift({ state: { $ne: "MN" } })
);

$mod

Modulus:

//filtered: [300, 600]
[100, 200, 300, 400, 500, 600].filter(sift({ $mod: [3, 0] }));

$all

values must match everything in array:

//filtered: [ { tags: ['books','programming','travel' ]} ]
[
  { tags: ["books", "programming", "travel"] },
  { tags: ["travel", "cooking"] }
].filter(sift({ tags: { $all: ["books", "programming"] } }));

$and

ability to use an array of expressions. All expressions must test true.

//filtered: [ { name: 'Craig', state: 'MN' }]

[
  { name: "Craig", state: "MN" },
  { name: "Tim", state: "MN" },
  { name: "Joe", state: "CA" }
].filter(sift({ $and: [{ name: "Craig" }, { state: "MN" }] }));

$or

OR array of expressions.

//filtered: [ { name: 'Craig', state: 'MN' }, { name: 'Tim', state: 'MN' }]
[
  { name: "Craig", state: "MN" },
  { name: "Tim", state: "MN" },
  { name: "Joe", state: "CA" }
].filter(sift({ $or: [{ name: "Craig" }, { state: "MN" }] }));

$nor

opposite of or:

//filtered: [ { name: 'Tim', state: 'MN' }, { name: 'Joe', state: 'CA' }]
[
  { name: "Craig", state: "MN" },
  { name: "Tim", state: "MN" },
  { name: "Joe", state: "CA" }
].filter(sift({ $nor: [{ name: "Craig" }, { state: "MN" }] }));

$size

Matches an array - must match given size:

//filtered: ['food','cooking']
[{ tags: ["food", "cooking"] }, { tags: ["traveling"] }].filter(
  sift({ tags: { $size: 2 } })
);

$type

Matches a values based on the type

[new Date(), 4342, "hello world"].filter(sift({ $type: Date })); //returns single date
[new Date(), 4342, "hello world"].filter(sift({ $type: String })); //returns ['hello world']

$regex

Matches values based on the given regular expression

["frank", "fred", "sam", "frost"].filter(
  sift({ $regex: /^f/i, $nin: ["frank"] })
); // ["fred", "frost"]
["frank", "fred", "sam", "frost"].filter(
  sift({ $regex: "^f", $options: "i", $nin: ["frank"] })
); // ["fred", "frost"]

$where

Matches based on some javascript comparison

[{ name: "frank" }, { name: "joe" }].filter(
  sift({ $where: "this.name === 'frank'" })
); // ["frank"]
[{ name: "frank" }, { name: "joe" }].filter(
  sift({
    $where: function() {
      return this.name === "frank";
    }
  })
); // ["frank"]

$elemMatch

Matches elements of array

var bills = [
  {
    month: "july",
    casts: [
      {
        id: 1,
        value: 200
      },
      {
        id: 2,
        value: 1000
      }
    ]
  },
  {
    month: "august",
    casts: [
      {
        id: 3,
        value: 1000
      },
      {
        id: 4,
        value: 4000
      }
    ]
  }
];

var result = bills.filter(
  sift({
    casts: {
      $elemMatch: {
        value: { $gt: 1000 }
      }
    }
  })
); // {month:'august', casts:[{id:3, value: 1000},{id: 4, value: 4000}]}

$not

Not expression:

["craig", "tim", "jake"].filter(sift({ $not: { $in: ["craig", "tim"] } })); //['jake']
["craig", "tim", "jake"].filter(sift({ $not: { $size: 5 } })); //['tim','jake']

sub object Searching

var people = [
  {
    name: "craig",
    address: {
      city: "Minneapolis"
    }
  },
  {
    name: "tim",
    address: {
      city: "St. Paul"
    }
  }
];

var sifted = people.filter(sift({ address: { city: "Minneapolis" } })); // count = 1

//or
var sifted = people.filter(sift({ "address.city": "minneapolis" })); //count = 1

Custom expressions

var filter = sift(
  {
    $customMod: 2
  },
  {
    expressions: {
      $customMod: function(query, value) {
        return query % value;
      }
    }
  }
);

[1, 2, 3, 4, 5].filter(filter); // 1, 3, 5

Current Tags

  • 8.0.1                                ...           beta (6 years ago)
  • 17.1.3                                ...           latest (7 months ago)

155 Versions

  • 17.1.3                                ...           7 months ago
  • 17.1.2                                ...           7 months ago
  • 17.1.1                                ...           7 months ago
  • 17.1.0                                ...           7 months ago
  • 17.0.1                                ...           2 years ago
  • 16.0.1                                ...           2 years ago
  • 16.0.0                                ...           3 years ago
  • 15.1.3                                ...           3 years ago
  • 15.1.2                                ...           3 years ago
  • 15.1.1                                ...           3 years ago
  • 15.1.0                                ...           3 years ago
  • 15.0.0                                ...           3 years ago
  • 14.0.3                                ...           3 years ago
  • 14.0.2                                ...           3 years ago
  • 14.0.1                                ...           3 years ago
  • 14.0.0                                ...           3 years ago
  • 13.5.4                                ...           3 years ago
  • 13.5.3                                ...           4 years ago
  • 13.5.2                                ...           4 years ago
  • 13.5.1                                ...           4 years ago
  • 13.5.0                                ...           4 years ago
  • 13.4.0                                ...           4 years ago
  • 13.3.5                                ...           4 years ago
  • 13.3.4                                ...           4 years ago
  • 13.3.3                                ...           4 years ago
  • 13.3.1                                ...           4 years ago
  • 13.3.0                                ...           4 years ago
  • 13.2.0                                ...           4 years ago
  • 13.1.10                                ...           4 years ago
  • 13.1.9                                ...           4 years ago
  • 13.1.8                                ...           4 years ago
  • 13.1.7                                ...           4 years ago
  • 13.1.6                                ...           4 years ago
  • 13.1.5                                ...           4 years ago
  • 13.1.4                                ...           4 years ago
  • 13.1.3                                ...           4 years ago
  • 13.1.2                                ...           4 years ago
  • 13.1.1                                ...           4 years ago
  • 13.1.0                                ...           4 years ago
  • 13.0.6                                ...           4 years ago
  • 13.0.5                                ...           4 years ago
  • 13.0.4                                ...           4 years ago
  • 13.0.3                                ...           4 years ago
  • 13.0.2                                ...           5 years ago
  • 13.0.0                                ...           5 years ago
  • 12.0.1                                ...           5 years ago
  • 12.0.0                                ...           5 years ago
  • 11.1.8                                ...           5 years ago
  • 11.1.7                                ...           5 years ago
  • 11.1.6                                ...           5 years ago
  • 11.1.5                                ...           5 years ago
  • 11.1.4                                ...           5 years ago
  • 11.1.3                                ...           5 years ago
  • 11.1.2                                ...           5 years ago
  • 11.1.1                                ...           5 years ago
  • 11.1.0                                ...           5 years ago
  • 11.0.10                                ...           5 years ago
  • 11.0.9                                ...           5 years ago
  • 11.0.8                                ...           5 years ago
  • 11.0.7                                ...           5 years ago
  • 11.0.6                                ...           5 years ago
  • 11.0.5                                ...           5 years ago
  • 11.0.4                                ...           5 years ago
  • 11.0.2                                ...           5 years ago
  • 11.0.1                                ...           5 years ago
  • 11.0.0                                ...           5 years ago
  • 10.0.0                                ...           5 years ago
  • 9.0.7                                ...           5 years ago
  • 9.0.6                                ...           5 years ago
  • 9.0.4                                ...           5 years ago
  • 9.0.3                                ...           5 years ago
  • 9.0.2                                ...           5 years ago
  • 9.0.1                                ...           5 years ago
  • 9.0.0                                ...           5 years ago
  • 8.5.1                                ...           5 years ago
  • 8.5.0                                ...           5 years ago
  • 8.4.0                                ...           5 years ago
  • 8.3.5                                ...           5 years ago
  • 8.3.4                                ...           5 years ago
  • 8.3.3                                ...           6 years ago
  • 8.3.2                                ...           6 years ago
  • 8.3.1                                ...           6 years ago
  • 8.2.0                                ...           6 years ago
  • 8.3.0                                ...           6 years ago
  • 8.0.1                                ...           6 years ago
  • 8.0.0                                ...           6 years ago
  • 7.0.1                                ...           6 years ago
  • 7.0.0                                ...           6 years ago
  • 6.0.0                                ...           6 years ago
  • 5.1.0                                ...           7 years ago
  • 5.0.0                                ...           7 years ago
  • 4.0.0                                ...           7 years ago
  • 3.3.12                                ...           7 years ago
  • 3.3.11                                ...           7 years ago
  • 3.3.10                                ...           7 years ago
  • 3.3.9                                ...           8 years ago
  • 3.3.8                                ...           8 years ago
  • 3.3.7                                ...           8 years ago
  • 3.3.6                                ...           8 years ago
  • 3.3.5                                ...           8 years ago
  • 3.3.4                                ...           8 years ago
  • 3.3.3                                ...           8 years ago
  • 3.3.2                                ...           8 years ago
  • 3.3.1                                ...           8 years ago
  • 3.3.0                                ...           8 years ago
  • 3.2.7                                ...           8 years ago
  • 3.2.6                                ...           8 years ago
  • 3.2.5                                ...           8 years ago
  • 3.2.4                                ...           8 years ago
  • 3.2.3                                ...           8 years ago
  • 3.2.2                                ...           8 years ago
  • 3.2.1                                ...           9 years ago
  • 3.2.0                                ...           9 years ago
  • 3.1.1                                ...           9 years ago
  • 3.1.0                                ...           9 years ago
  • 3.0.0                                ...           9 years ago
  • 2.0.10                                ...           9 years ago
  • 2.0.9                                ...           9 years ago
  • 2.0.8                                ...           9 years ago
  • 2.0.7                                ...           9 years ago
  • 2.0.6                                ...           9 years ago
  • 2.0.5                                ...           9 years ago
  • 2.0.4                                ...           9 years ago
  • 2.0.3                                ...           9 years ago
  • 2.0.2                                ...           9 years ago
  • 2.0.0                                ...           9 years ago
  • 1.1.1                                ...           9 years ago
  • 1.1.0                                ...           10 years ago
  • 1.0.6                                ...           10 years ago
  • 1.0.1                                ...           10 years ago
  • 1.0.0                                ...           10 years ago
  • 0.5.6                                ...           10 years ago
  • 0.5.0                                ...           10 years ago
  • 0.4.5                                ...           10 years ago
  • 0.2.4                                ...           10 years ago
  • 0.2.3                                ...           10 years ago
  • 0.2.2                                ...           10 years ago
  • 0.2.1                                ...           10 years ago
  • 0.1.0                                ...           10 years ago
  • 0.0.18                                ...           10 years ago
  • 0.0.17                                ...           10 years ago
  • 0.0.16                                ...           11 years ago
  • 0.0.15                                ...           11 years ago
  • 0.0.13                                ...           11 years ago
  • 0.0.12                                ...           12 years ago
  • 0.0.10                                ...           12 years ago
  • 0.0.9                                ...           12 years ago
  • 0.0.8                                ...           12 years ago
  • 0.0.7                                ...           12 years ago
  • 0.0.6                                ...           12 years ago
  • 0.0.5                                ...           12 years ago
  • 0.0.4                                ...           13 years ago
  • 0.0.3                                ...           13 years ago
  • 0.0.2                                ...           13 years ago
  • 0.0.1                                ...           13 years ago
Maintainers (2)
Downloads
Total 1
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 0
Last Month 1
Dependencies (0)
None
Dev Dependencies (13)
Dependents (2)

© 2010 - cnpmjs.org x YWFE | Home | YWFE