constrain added and unlink method extended

This the link to the Trello card

energy_project/models/inscription.py

-from odoo import _, fields, models
+from odoo import _, api, fields, models
+from odoo.exceptions import ValidationError
 
 
 class Inscription(models.Model):
@@ -30,3 +31,30 @@ class Inscription(models.Model):
         string="Partner",
     )
     effective_date = fields.Date(required=True)
+
+    def has_matching_supply_assignations(self):
+        matching_tables = self.project_id.selfconsumption_id.distribution_table_ids.filtered(
+            lambda table: table.state in ('validated', 'process', 'active')
+        )
+        matching_assignations = matching_tables.mapped('supply_point_assignation_ids').filtered(
+            lambda assignation: assignation.supply_point_id.partner_id == self.partner_id
+        )
+        return matching_assignations
+
+    def get_matching_supply_assignations_to_remove(self):
+        supply_point_assignations = self.env['energy_selfconsumption.supply_point_assignation'].search([
+                    ('supply_point_id.partner_id', '=', self.partner_id.id),
+                    ('selfconsumption_project_id', '=', self.project_id.id),
+                    ('distribution_table_id.state', '=', 'draft')
+                ])
+        return supply_point_assignations
+
+    def unlink(self):
+        matching_assignations = self.has_matching_supply_assignations()
+        if len(matching_assignations) > 0:
+            table_states = ', '.join(matching_assignations.distribution_table_id.mapped('state'))
+            raise ValidationError(_("The inscription cannot be deleted. It is related to a distribution table with state: {table_state}").format(table_state=table_states))
+        supply_point_assignations = self.get_matching_supply_assignations_to_remove()
+        if supply_point_assignations:
+            supply_point_assignations.unlink()
+        return super(Inscription, self).unlink()