Searching using pymongo from mongodb

Question

I am using a flask application to query the data from mongodb. Document from the mongodb is in the following format.

[{'organization_name': 'Example 1', 'date': '2021-10-15', 'url': 'https://www.example1.com/events/performances/641/2019-10-13/'}, {'organization_name': 'Example 2', 'date': '2021-10-21', 'url': 'https://file2.org/masterworks'}, {'organization_name': 'Example 3', 'date': '2021-10-21', 'url': 'https://file2.org/masterworks2'}]

Right now the query and search based on url is performing like this

    filter_stuff = {'url': 1, 'organization_name': 1, 'date':1, '_id': 0}
    data = eventcol.find({'url': url}, filter_stuff)

Here the search only works for exact complete url. How can the search be possible like if any part of url is given, all those data having that part is returned as result.

If search is file2 then the result be documents of https://file2.org/masterworks and https://file2.org/masterworks2 and if search is events then the result be https://www.example1.com/events/performances/641/2019-10-13/

To search with part of a given search string use regex search: See mongodb.com/docs/manual/reference/operator/query/regex — prasad_
– prasad_, Commented Apr 22, 2022 at 6:00

PCDSandwichMan · Accepted Answer · 2022-04-22 06:17:10Z

1

Could you do something like this?

from pymongo import MongoClient

client = MongoClient()
db = client.test

def main(search_string):
    collection = db.eventcol
    for doc in collection.find({"url": {"$regex": search_string}}):
        print(doc)

answered Apr 22, 2022 at 6:17

PCDSandwichMan

2,1581 gold badge15 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Searching using pymongo from mongodb

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