How to pass variable in find() method in mongo db using python

Question

   TPID=[318,205,2624,2635]
   Tid= len(TPID)
    try:
        mclient = MongoClient(host="tgl-mongodb22.rctanalytics.com", port=27017)
        Db = mclient['sitereft4']
        Db.authenticate('st_sitereference', 'rlQ2YnPKNlS0')
        coll = Db['shopper_journey_sitedata']
        for i in range(Tid):
            data = coll.find({"third_party_site_id":318})
            for datas in data:
                None
        print(datas["st_site_id"])

In place of 318 i need to pass the variable "Tid" so that it should run for all values. how to do it ? i tried below one it didn't worked: data = coll.find({"third_party_site_id":Tid[i]})

I tried that too, its not working.

Raghavendra K
– Raghavendra K

2020-08-03 08:32:14 +00:00
Commented Aug 3, 2020 at 8:32 — Raghavendra K
– Raghavendra K, Commented Aug 3, 2020 at 8:32

Harrison · Accepted Answer · 2020-08-02 17:43:02Z

1

If your goal is to find each site id in TPID=[318,205,2624,2635]

Structure the for loop logic as:

for i in TPID:
    data = coll.find({"third_party_site_id":i})
    print(data)

answered Aug 2, 2020 at 17:43

Harrison

1862 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass variable in find() method in mongo db using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related