q2m

A URL query object to MongoDB query

- $eq
- $ne
- $exists
- $exists
- $gt
- $gte
- $lt
- $lte
- $in
- $nin
- $or (1)
- $or (2)
- $and
- $nor
- $regex
- date
- date

Why

I needed to query MongoDB database from the URL. Basically transfrom the params passed via GET to a properly written MongoDB query object.

Example

First, get the library via npm install q2m or yarn install q2m. Then:

``js
const { parse } = require('q2m');

parse({ foo: 'bar' });
// { foo: { $eq: 'bar' }}
`

Mapping

_(The conversion from query string to object in the examples below is made with qs )_

$3

Query string: foo=bar

Object:
`json
{
"foo": "bar"
}
`

Output:
`json
{
"foo": {
"$eq": "bar"
}
}
`

$3

Query string: foo=!bar

Object:
`json
{
"foo": "!bar"
}
`

Output:
`json
{
"foo": {
"$ne": "bar"
}
}
`

$3

Query string: foo==bar

Object:
`json
{
"foo": "=bar"
}
`

Output:
`json
{
"foo": {
"$exists": true
}
}
`

$3

Query string: foo=!=bar

Object:
`json
{
"foo": "!=bar"
}
`

Output:
`json
{
"foo": {
"$exists": false
}
}
`

$3

Query string: foo=>20

Object:
`json
{
"foo": ">20"
}
`

Output:
`json
{
"foo": {
"$gt": 20
}
}
`

$3

Query string: foo=>=20

Object:
`json
{
"foo": ">=20"
}
`

Output:
`json
{
"foo": {
"$gte": 20
}
}
`

$3

Query string: foo=<20

Object:
`json
{
"foo": "<20"
}
`

Output:
`json
{
"foo": {
"$lt": 20
}
}
`

$3

Query string: foo=<=20

Object:
`json
{
"foo": "<=20"
}
`

Output:
`json
{
"foo": {
"$lte": 20
}
}
`

$3

Query string: foo[]=a&foo[]=b

Object:
`json
{
"foo": [
"a",
"b"
]
}
`

Output:
`json
{
"foo": {
"$in": [
"a",
"b"
]
}
}
`

$3

Query string: foo![]=a&foo![]=b

Object:
`json
{
"foo!": [
"a",
"b"
]
}
`

Output:
`json
{
"foo": {
"$nin": [
"a",
"b"
]
}
}
`

$3

Query string: or[0][a]=>20&or[1][b]=$bar

Object:
`json
{
"or": [
{
"a": ">20"
},
{
"b": "$bar"
}
]
}
`

Output:
`json
{
"$or": [
{
"a": {
"$gt": 20
}
},
{
"b": {
"$regex": "bar",
"$options": "i"
}
}
]
}
`

$3

Object:
`json
{
"or": [
{
"a": "$foo"
},
{
"b": [
"n",
"m"
]
}
]
}
`

Output:
`json
{
"$or": [
{
"a": {
"$options": "i",
"$regex": "foo"
}
},
{
"b": {
"$in": [
"n",
"m"
]
}
}
]
}
`

$3

Query string: and[0][a]=>20&and[1][b]=$bar

Object:
`json
{
"and": [
{
"a": ">20"
},
{
"b": "$bar"
}
]
}
`

Output:
`json
{
"$and": [
{
"a": {
"$gt": 20
}
},
{
"b": {
"$regex": "bar",
"$options": "i"
}
}
]
}
`

$3

Query string: nor[0][a]=>20&nor[1][b]=$bar

Object:
`json
{
"nor": [
{
"a": ">20"
},
{
"b": "$bar"
}
]
}
`

Output:
`json
{
"$nor": [
{
"a": {
"$gt": 20
}
},
{
"b": {
"$regex": "bar",
"$options": "i"
}
}
]
}
`

$3

Query string: foo=$bar

Object:
`json
{
"foo": "$bar"
}
`

Output:
`json
{
"foo": {
"$regex": "bar",
"$options": "i"
}
}
`

$3

Query string: foo=2023-6-7

Object:
`json
{
"foo": "2023-6-7"
}
`

Output:
`json
{
"foo": {
"$eq": ""
}
}
`

$3

Query string: foo=<2023-6-7

Object:
`json
{
"foo": "<2023-6-7"
}
`

Output:
`json
{
"foo": {
"$lt": ""
}
}
``