How to create a create_index python method for mongodb

Question

in mongodb's cmd you use the command:

db.test2.createIndex({ "type" : 1, "amount" : 1, "loss" : 1, "price" : 1, "create_date" : 1 }, {unique:true})

in python i can write methods for the 'find_one' command easily ie:

@staticmethod
def find_one(collection, query):
    return Database.DATABASE[collection].find_one(query)

however writing one to create an index throws an error, ie:

@staticmethod
def create_index(collection):
    return Database.DATABASE[collection].createIndex({ "type" : 1, "amount" : 1, "loss" : 1, "price" : 1, "create_date" : 1 }, {unique:true})

gives the error:

return Database.DATABASE[collection].createIndex({ "type" : 1, "amount" : 1, "loss" : 1, "price" : 1, "create_date" : 1 }, {unique:true})
NameError: name 'unique' is not defined

Abhay PS · Accepted Answer · 2016-12-14 14:59:38Z

3

The method for creating index in pymongo is create_index. You should do something like this -

my_collection.create_index([("type", pymongo.ASCENDING),("amount", pymongo.ASCENDING),("loss", pymongo.ASCENDING),("price", pymongo.ASCENDING),("create_date", pymongo.ASCENDING)], unique=True)

Check the documentation here

answered Dec 14, 2016 at 14:59

Abhay PS

4,2155 gold badges29 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

How to create a create_index python method for 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