How can I create an index with pymongo

Question

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?

Linked question isn't exactly the same and has no useful answers and a dead link comment. Answer here is useful and has relevant documentation link. — Danny Varod, Oct 16 '22 at 00:44

score 52 · Accepted Answer · edited Sep 22 '21 at 16:03

52

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')

edited Sep 22 '21 at 16:03

Kevin Tindall

375
5
16

answered Nov 05 '15 at 10:03

chridam

100,957
23
236
235

when I use the db.command('text', 'foo', search=query) to search the index, how can I query several words? – Maximilian Nov 05 '15 at 10:29
3

@PeterFox Good question but I would suggest you create a new question for that then we can take it from there. – chridam Nov 05 '15 at 10:30
How do we ensure that the index is unique? Where can we pass that index type is unique? – Kayvan Shah Apr 01 '23 at 02:01

How can I create an index with pymongo

1 Answers1

Linked

Related