Add UniqueConstraint to the Filter model

- The UniqueConstraint includes every field, except for id and description.

2 files changed, 63 insertions, 1 deletions

diff --git a/pydis_site/apps/api/migrations/0080_unique_constraint_filters.py b/pydis_site/apps/api/migrations/0080_unique_constraint_filters.py
new file mode 100644
index 00000000..0b3b4162
--- /dev/null
+++ b/pydis_site/apps/api/migrations/0080_unique_constraint_filters.py
@@ -0,0 +1,36 @@
+# Generated by Django 3.1.14 on 2022-03-22 16:31
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('api', '0079_new_filter_schema'),
+    ]
+
+    operations = [
+        migrations.AddConstraint(
+            model_name='filter',
+            constraint=models.UniqueConstraint(fields=(
+                'dm_content',
+                'dm_embed',
+                'infraction_type',
+                'infraction_reason',
+                'infraction_duration',
+                'content',
+                'additional_field',
+                'filter_list',
+                'guild_pings',
+                'filter_dm',
+                'dm_pings',
+                'delete_messages',
+                'bypass_roles',
+                'enabled',
+                'send_alert',
+                'enabled_channels',
+                'disabled_channels',
+                'disabled_categories'
+            ), name='unique_filters'),
+        ),
+    ]
diff --git a/pydis_site/apps/api/models/bot/filters.py b/pydis_site/apps/api/models/bot/filters.py
index f8bbfd14..708ceadc 100644
--- a/pydis_site/apps/api/models/bot/filters.py
+++ b/pydis_site/apps/api/models/bot/filters.py
@@ -113,7 +113,7 @@ class FilterList(FilterSettingsMixin):
         return f"Filter {FilterListType(self.list_type).label}list {self.name!r}"
 
 
-class Filter(FilterSettingsMixin):
+class FilterBase(FilterSettingsMixin):
     """One specific trigger of a list."""
 
     content = models.CharField(max_length=100, help_text="The definition of this filter.")
@@ -173,3 +173,29 @@ class Filter(FilterSettingsMixin):
 
     def __str__(self) -> str:
         return f"Filter {self.content!r}"
+
+    class Meta:
+        """Metaclass for FilterBase to make it abstract model."""
+
+        abstract = True
+
+
+class Filter(FilterBase):
+    """
+    The main Filter models based on `FilterBase`.
+
+    The purpose to have this model is to have access to the Fields of the Filter model
+    and set the unique constraint based on those fields.
+    """
+
+    class Meta:
+        """Metaclass Filter to set the unique constraint."""
+
+        constraints = (
+            UniqueConstraint(
+                fields=tuple(
+                    [field.name for field in FilterBase._meta.fields
+                     if field.name != "id" and field.name != "description"]
+                ),
+                name="unique_filters"),
+        )