This module is used to query a single MongoDB collection written with mongoose dynamically with simple query parameters using MongoDB query types 'AND' and 'OR' with MongoDB filter options eg '$gt' as 'gt', '$gte' as 'gte', '$lt' as 'lt', '$lte' as 'lte', '$eq' as 'eq' and 'cn' for case insensitive query for contains replacing MongoDB regex expression eg '/.*Will Abule.*/i' you can also write your own MongoDB queries as expressions.
\n\nThe client(s) consuming your API just has to follow simple roles or better a query structure and it dynamically query and return an object as the result containing five fields data, pageSize, records, pageNumber, and total.
\n\ndata representing the queried data, pageSize representing the bash of data returned, records representing the total records found based on the filter, pageNumber representing the current paginated page, and total representing the number of pages.
\n\n\n\t
\n
\n\t
\n
run npm i -s mongodb-collection-query-with-mongoose\n\n
\n\t
\n
Post model file
const mongoose = require("mongoose");\nconst postSchema = new mongoose.Schema({\n title: {\n type: String,\n required: true,\n },\n description: {\n type: String,\n },\n imageUrl: {\n type: String,\n required: true,\n unique: true\n },\n userId: {\n type: String\n },\n tags: {\n type: Array\n },\n date: {\n type: Date,\n required: true,\n default: Date.now\n }\n});\nconst Post = mongoose.model("Post", postSchema);\nmodule.exports.postScheama = postScheama;\nmodule.exports.Post = Post;\n\n\n\t
\n
post route file
const getResReq = require("mongodb-collection-query-with-mongoose");\n\nrouter.get("/post", async (req, res) => {\n try {\n const setect = "\\_id title userId description imageUrl"\nconst response = await Promise.all([getResReq(query, Post, select)]);\nconst { data, type, msg, status } = response[0];\nif (type === "error")\nreturn res\n.status(status)\n.send({ message: `internal server error`, error: msg });\n\n return res.send(data);\n\n} catch {\n return res.status(500).send({ message : `internal server error`, error: data })\n }\n});\n\n\n\nNOTE: As a backend developer you can write your own additional query eg from v1.0.5
const searchFilter = JSON.parse(req.query.searchFilters).rules;\nconst result = searchFilter.push({\n option: "expression",\n filed: "tags"\n data: { $all: ['red', 'blank'] }\n})\n\n// note any mongodb query will work just specify the query at the "data" and doc field at "field " and this can also be done from the client as well if you so which.\n\n
\n\t
\n
\n\t
\n
don't install the package for reading only if your backend developer uses this library
\n\n\n\t
\n
filter (boolean): If you want the collection to filtered or not, if true the search filter is required
\n\npageSize (number): The page size that is the number of bashes you want records to be sent
\n\npageNumber (number): The page from the filtered collection
\n\nsortName (string): What field in the document to want the result to be sorted with eg a collection of users can be sorted by fristName
\n\nsort (string): the sort order either ascending as 'asc' or descending as 'desc'
\n\nsearchFilter (string): a stringified object with the following fields: searchOption, and rules
\n\nsearchOption: either 'AND' or 'OR' in uppercase. AND will return data if all search rules evaluate to true, 'OR' will return data if all one or multiple of the rules are set to true.
\n\nrules: An array of objects, each object must have the following fields
\n\nfield: The document field
\n\noption: how you want it to be quired. This is to be set to either the following
\n\ncn (contains)
\n\neq (equal)
\n\nne (not equal)
\n\ngt (greater than)
\n\ngte (greater than or equal)
\n\nlt (less than)
\n\nlte (less than or equal)
\n\nin (in an array)
\n\nnin (not in an array)
\n\nrange ( for querying data in range)
\n\nexpression ( for writing your own MongoDB queries)
\n\n\n\t
\n
data: The value of the field
\n\ntype: The data type of the data. it must be set to either of the following
\n\nnumber
\n\nfloat
\n\nstring
\n\ndate
\n\nboolean
\n\n\n\t
\n
query filter rules
\n\ncn: (contains): can only be used for string values.
\n\neq: (equal: operator matches documents where the value of a field equals the specified value.)
\n\nne: (not equal: selects those documents where the value of the field is greater than (i.e. >) the specified value.)
gt: (greater than: selects the documents where the value of the field is greater than or equal to (i.e. >=) a specified value (e.g. value.))
gte: (greater than or equal: selects the documents where the value of the field is greater than or equal to (i.e. >=) a specified value (e.g. value.))
lt: (less than: selects the documents where the value of the field is less than (i.e. <) the specified value.)
lte: (less than or equal: selects the documents where the value of the field is less than or equal to (i.e. <=) the specified value.)
in: (operator selects the documents where the value of a field equals any value in the specified array.l)
\n\nnin: (less than or equal: operator selects the documents whose field holds an array with no element equal to a value in the specified array (e.g. <value1>, <value2>, etc.).)
expression: ( for writing your own MongoDB queries)
\n\nrange: this example will explain better
\n\nif I want to filter the list of posts where name is 'will' and the date is greater than the date seven days ago but less than or equal to today date. This can be written as follows
const searchFilters = {\n searchOption:"OR",\n rules:[{\n field:"name",\n option:"cn",\n type:"string",\n data:"will"\n },{\n field:"date",\n type:"range",\n data: [\n {\n option:"gt",\n type:"data",\n data: new Date(new Date().setDate(new Date().getDate() - 7))\n },\n {\n option:"lte",\n type:"date",\n data: new Date()\n },\n ]\n }]\n}\n\nNOTE: The range type is an array with a max and min length of 2 and option and type can be omitted.
\n\n\n\t
\n
\n\t
\n
Example So if you want to query a collection of users that the name or the email contains will
const searchFilters = {\n searchOption:"OR",\n rules:[{\n field:"name",\n option:"cn",\n type:"string",\n data:"will"\n },{\n field:"email",\n option:"cn",\n type:"string",\n data:"will"\n }]\n}\n\nif you want to query a collection of post that the title or the description contains will and userId is 1234
const searchFilters = {\n searchOption:"AND",\n rules:[{\n field:"title",\n option:"cn",\n type:"string",\n data:"will"\n },{\n field:"description",\n option:"cn",\n type:"string",\n data:"will"\n },{\n field:"userId",\n option:"eq",\n type:"string",\n data:"will"\n }]\n}\n\nif you want to sort the result in a descending by name then I will do something like this
const query = {\n sort : 'desc',\n sortName : 'title',\n}\n\nif you want to the result to be filtered I will do something like this
const query = {\n filter : true,\n searchFilters : JSON.stringify(searchFilters)\n}\n\n
\n\t
\n
if you want the result to brought by 10 batches starting from page 1 I will do something like this
const query = {\n pageNumber : 1,\n pageSize : 10\n}\n\n
\n\t
\n
so the end result will look like this
const searchFilters = {\n searchOption:"AND",\n rules:[{\n field:"title",\n option:"cn",\n type:"string",\n data:"will"\n },{\n field:"description",\n option:"cn",\n type:"string",\n data:"will"\n },{\n field:"userId",\n option:"eq",\n type:"string",\n data:"will"\n }]\n}const query = {\n filter : true,\n pageNumber : 1,\n pageSize : 10\n sort : 'desc',\n sortName : 'title',\n searchFilters : JSON.stringify(searchFilters)\n}\n\n\n\t
\n
Result for the API will look like this
Result : {\n data: array,\n pageSize: array,\n records: number,\n pageNumber: number,\n total: number\n}\n\n\n\t
\n
data (array): The data found in the collections eg post collection
\n\npageSize (number): The batch was returned data found in the collections eg post collection
\n\nrecords (number): The total records found in the collections eg post collection
\n\npageNumber (number): The page you specified records should start from in the collections eg post collection
\n\ntotal (number): The number of pages in the collections eg post collection
\n\n\n\t
\n
A useful example to help you combine query
const searchFilters = {\n searchOption:"AND",\n rules:[{\n field:"title",\n option:"cn",\n type:"string",\n data:"will"\n },{\n field:"description",\n option:"ne",\n type:"string",\n data:"test"\n },{\n field:"userId",\n option:"eq",\n type:"string",\n data:"will"\n },{\n field:"tags",\n option:"in", // or nin\n type:"array",\n data:["is", 3, 12.2, true, new Date()]\n },{\n field:"date",\n type:"range",\n data: [\n {\n option:"gte", // or gt\n type:"data",\n data: new Date(new Date().setDate(new Date().getDate() - 7))\n },\n {\n option:"lte",// or lt\n type:"date",\n data: new Date()\n },\n ]\n }]\n}\n","readmeFilename":"README.md"}