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")
Advertisement
Answer
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}
]
}