How to make a combined set of fields unique in Mongodb in Python

Question

I want to create a table where two of its fields combine to form an index field. My Python code for creating the table is as follows. What I want to do is make the combined fields course_name and group_name unique so that no two groups with the same course_name and group_name can be created. Can someone please help me with this?

class SocialGroup(Document):
    timestamp = DateTimeField(default=datetime.now)
    course_name = StringField()
    group_name = StringField(choices=[('A', 1), ('B', 1), ('C', 1),('D', 1), ('E', 1), ('F', 1), ('None',1)], default="None")

markus-hinsche · Accepted Answer · 2021-05-11 18:25:33Z

14

You can specify indexes in the meta dict of the class:

class SocialGroup(Document):
    timestamp = DateTimeField(default=datetime.now)
    course_name = StringField()
    group_name = StringField(choices=[('A', 1), ('B', 1), ('C', 1),('D', 1), ('E', 1), ('F', 1), ('None',1)], default="None")
    meta = {
        'indexes': [
            {'fields': ('course_name', 'group_name'), 'unique': True}
        ]
    }

edited May 11, 2021 at 18:25

markus-hinsche

1,43216 silver badges27 bronze badges

answered Feb 21, 2013 at 13:26

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Comments

Hieu · Accepted Answer · 2017-01-27 10:58:04Z

From: http://docs.mongoengine.org/guide/defining-documents.html#uniqueness-constraints

You may also specify multi-field uniqueness constraints by using unique_with, which may be either a single field name, or a list or tuple of field names

In your case:

class SocialGroup(Document):
    timestamp = DateTimeField(default=datetime.now)
    course_name = StringField()
    group_name = StringField(choices=[('A', 1), ('B', 1), ('C', 1),('D', 1), ('E', 1), ('F', 1), ('None',1)], default="None",
                             unique_with='course_name')

Or more complicated:

group_name = StringField(choices=[('A', 1), ('B', 1), ('C', 1),('D', 1), ('E', 1), ('F', 1), ('None',1)], default="None",
                         unique_with=['course_name', 'another_field', 'more_field'])

Collectives™ on Stack Overflow

How to make a combined set of fields unique in Mongodb in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related