@cmddevelop/query-parameters

@cmddevelop/query-parameters

Converts URL query string into a Mongoose friendly object. Create and object with key values for Mongoose options and filtering.

This library was build using this mongoose-query-parser as a starting point. Thank you for the good work. It was used as a starting point to develop this for a custom application.

Features

• Supports the most of MongoDB operators ($in, $regexp, $exists) and features including skip, sort, limit, population
• Additionally, there is a key word of page that can be applied in order to work with mongoose-paginate
• Auto type casting of Number, RegExp, Date, Boolean and null
• String templates/predefined queries (i.e. firstName=${my_vip_list})
• Allows customization of keys and options in query string

Installation

npm i @cmddevelop/query-parameters

Usage

API

import { QueryParser } from '@cmddevelop/query-parameters';

const parser = new QueryParser(options?: ParserOptions)
parser.parse(query: string, predefined: any) : QueryOptions

Arguments

• ParserOptions: object for advanced options (See below) [optional]
• query: query string part of the requested API URL (ie, firstName=John&limit=10). Works with already parsed object too (ie, {status: 'success'}) [required]
• predefined: object for predefined queries/string templates [optional]

Returns

• QueryOptions: object contains the following properties:
  • filter which contains the query criteria
  • populate which contains the query population. Please see Mongoose Populate for more details
  • select which contains the query projection
  • sort, skip, limit which contains the cursor modifiers for paging purpose

Filtering operators

MongoDB	URI	Example	Result
$eq	key=val	type=public	{filter: {type: 'public'}}
$gt	key>val	count>5	{filter: {count: {$gt: 5}}}
$gte	key>=val	rating>=9.5	{filter: {rating: {$gte: 9.5}}}
$lt	key<val	createdAt<2017-10-01	{filter: {createdAt: {$lt: 2017-09-30T14:00:00.000Z}}}
$lte	key<=val	score<=-5	{filter: {score: {$lte: -5}}}
$ne	key!=val	status!=success	{filter: {status: {$ne: 'success'}}}
$in	key=val1,val2	country=GB,US	{filter: {country: {$in: ['GB', 'US']}}}
$nin	key!=val1,val2	lang!=fr,en	{filter: {lang: {$nin: ['fr', 'en']}}}
$exists	key	phone	{filter: {phone: {$exists: true}}}
$exists	!key	!email	{filter: {email: {$exists: false}}}
$regex	key=/value/<opts>	email=/@gmail\.com$/i	{filter: {email: /@gmail.com$/i}}
$regex	key!=/value/<opts>	phone!=/^06/	{filter: {phone: { $not: /^06/}}}

For more advanced usage ($or, $type, $elemMatch, etc.), pass any MongoDB query filter object as JSON string in the filter query parameter, ie:

Populate operators

• Useful to populate sub-document(s) in query. Works with MongooseJS. Please see Mongoose Populate for more details
• Allows to populate only selected fields
• Default operator key is populate

Skip / Limit / Page operators

• Useful to limit the number of records returned
• Default operator keys are skip or page, and limit