CODEWITHSUNDEEP
arraysmongodbmongodb-querypymongo
Mahamutha M
Mahamutha M

Reputation: 1287

PyMongo - How to compare the given array exactly matches with the document

I have a MongoDB document with the following attributes:

{
  "label": [
    "ibc",
    "ibd",
    "ibe"
  ],
  "location": "vochelle st"
}

and I have to return the document only if the documents label exactly matches the given array i.e., ["ibc","ibd"] and for the same, I am using the query:

db.collection.find({"location":"vochelle st","dock_label":{"$all":["ibc", "ibd"]}})

Actual Response:

{
  "label": [
    "ibc",
    "ibd",
    "ibe"
  ],
  "location": "vochelle st"
}

Expected Response:

{}

Since the label "ibe" doesn't exist in the given array, the expected result has to be the empty dictionary.

Upvotes: 0

Views: 216

Answers (3)

David SN
David SN

Reputation: 3519

If you want to check if the array exactly matches your input, you don't need any operator, just compare it with your value:

db.collection.find({"location":"vochelle st","label": ["ibc", "ibd"]})

Upvotes: 1

YuTing
YuTing

Reputation: 6629

Give $size in your query

db.collection.find({
  location: "vochelle st",
  label: {
    $all: [
      "ibc",
      "ibd"
    ],
    $size: 2
  }
})

mongoplayground

Upvotes: 1

Yong Shun
Yong Shun

Reputation: 51125

  1. Use $setIntersection to intersect both label and input array.
  2. Compare both intersected array (from 1) and label arrays are matched via $eq.
db.collection.find({
  "location": "vochelle st",
  $expr: {
    $eq: [
      {
        $setIntersection: [
          "$label",
          [
            "ibc",
            "ibd"
          ]
        ]
      },
      "$label"
    ]
  }
})

Sample Mongo Playground

Upvotes: 1

Related Questions