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} ] }