How can I create an index with pymongo

mongodb indexing pymongo fuzzy-search text-search
Maximilian picture Maximilian · Nov 5, 2015 · Viewed 25.5k times · Source

I want to enable text-search at a specific field in my Mongo DB. I want to implement this search in python (-> pymongo). When I follow the instructions given in the internet:

db.foo.ensure_index(('field_i_want_to_index', 'text'), name="search_index")

I get the following error message:

    Traceback (most recent call last):
    File "CVE_search.py", line 8, in <module>
    db.foo.ensure_index(('field_i_want_to_index', 'text'), name="search_index")
 File "/usr/local/lib/python2.7/dist-packages/pymongo/collection.py", line 1599, in ensure_index
        return self.create_index(key_or_list, cache_for, **kwargs)
      File "/usr/local/lib/python2.7/dist-packages/pymongo/collection.py", line 1466, in create_index
        index_doc = helpers._index_document(keys)
      File "/usr/local/lib/python2.7/dist-packages/pymongo/helpers.py", line 100, in _index_document
            for (key, value) in index_list:
    ValueError: too many values to unpack

Is there a different/better way to create an index in pymongo?

Answer

chridam picture chridam · Nov 5, 2015

Use the create_index method where you pass in the keys as an array and TEXT as the index direction :

collection.create_index([('field_i_want_to_index', pymongo.TEXT)], name='search_index', default_language='english')

Related questions

Can I do a MongoDB "starts with" query on an indexed subdocument field?

I'm trying to find documents where a field starts with a value. Table scans are disabled using notablescan. This works: db.articles.find({"url" : { $regex : /^http/ }}) This doesn't: db.articles.find({"source.homeUrl" : { $regex : /^http/ }}) I get the error: error: { "$…

Read More
MongoDB querying performance for over 5 million records

We've recently hit the >2 Million records for one of our main collections and now we started to suffer for major performance issues on that collection. They documents in the collection have about 8 fields which you can filter by using …

Read More
How to create indexes in MongoDB via .NET

I've programmatically created a new document collection using the MongoDB C# driver. At this point I want to create and build indexes programmatically. How can I do that?

Read More