Mongoengine unique_with

Question

I am using mongoengine with MongoDB. I have to make a Document in which the tuple (merchant_id, order_id, event_type) has to be a unique key.

Till now, I have always dealt with uniqueness being limited to two fields. So the following works-

merchant_id = StringField(required = True)
order_id = StringField(required = True, unique_with = 'merchant_id')

Now, I'm trying to do this for three fields -

merchant_id = StringField(required = True)
order_id =  StringField(required = True)
event_type = StringField(
    required = True,
    unique_with = ['merchant_id', 'order_id'])

But this doesn't work. I'm not getting an error in the module. But if I enter data as -

merchant_id = 'Merchant1'
order_id = 'Order1'
event_type = 'Event1'

and then try to add another data with the same merchant_id and order_id but a different event_id, then it gives an error about being a duplicate key.

I have also tried:

merchant_id = StringField(required = True)
order_id =  StringField(required = True)
event_type = StringField(
    required = True,
    unique_with = ('merchant_id', 'order_id'))

Answer 1

You can specify indexes in the meta dict of the class

meta = {
    'indexes': [
        {'fields': ('merchant_id', 'order_id'), 'unique': True}
    ]
}