Creating indexes - MongoDB

Question

My "table" looks like this:

{'name':'Rupert', 'type':'Unicorn', 'actions':[
    {'time':0, 'position':[0,0], 'action':'run'},
    {'time':50, 'position':[50,0], 'action':'stoprun'},
    {'time':50, 'position':[50,0], 'action':'jump'},
    {'time':55, 'position':[50,0], 'action':'laugh'},
    ...
]}

Is there any way I can index the items within the actions list? Or do I have to split them up into further tables?

It would be a lot more convenient for me to keep the actions within the current table row.

jpoppe · Accepted Answer · 2014-11-21 13:30:57Z

12

Example for pymongo:

import pymongo

mongo = pymongo.Connection('localhost')
collection = mongo['database']['hosts']
collection.ensure_index('host_name', unique=True)

edited Nov 21, 2014 at 13:30

answered Jun 26, 2011 at 9:16

jpoppe

2,36726 silver badges26 bronze badges

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

1 Comment

scharfmn Over a year ago

If you want to drop the duplicates: collection.ensure_index('host_name', unique=True, drop_dups=True)

RadiantHex · Accepted Answer · 2010-07-24 15:13:49Z

8

Thanks to skot in #mongodb!!

One solution is:

[...].ensureIndex({"actions.time":1})

for creating an index on the time field within the actions list.

answered Jul 24, 2010 at 15:13

RadiantHex

25.7k47 gold badges157 silver badges251 bronze badges

1 Comment

romanlv Over a year ago

given code is javascript, the actual method is 'ensure_index' in python

Collectives™ on Stack Overflow

Creating indexes - MongoDB

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related