Feature/variable hourly dist table

Trello card

Important

In this commit, the CUPS data import process is developed, allowing the processing of a CSV that contains 500 CUPS with 8760 coefficients for each one. The implementation carried out has processed the CSV in 20 minutes in a local environment:

Local Environment Memory Specifications

	Total	Used	Free	Share	Buffer/Cache	Avaible
Memory	15Gi	6,0Gi	321Mi	1,2Gi	9,1Gi	7,9Gi
Swap	2,0Gi	0,0Ki	2,0Gi	-	-	-

odoo.conf configuration

To handle this process efficiently, the timeouts were customized in odoo.conf as shown below:

limit_time_cpu = 360

Importance for Production

When pushing these changes to production, it is essential to perform extensive testing to ensure that the production server efficiently handles the workload. The resources available on the production server, especially memory and odoo.conf settings, should be considered and adjusted as necessary to replicate the behavior observed in the local environment.

energy_selfconsumption/models/distribution_table.py

 from odoo import _, api, fields, models
 from odoo.exceptions import ValidationError
 
-
 STATE_VALUES = [
     ("draft", _("Draft")),
     ("validated", _("Validated")),
@@ -9,7 +8,10 @@ STATE_VALUES = [
     ("active", _("Active")),
 ]
 
-TYPE_VALUES = [("fixed", _("Fixed"))]
+TYPE_VALUES = [
+    ("fixed", _("Fixed")),
+    ("variable_schedule", _("Variable schedule")),
+]
 
 
 class DistributionTable(models.Model):
@@ -49,16 +51,22 @@ class DistributionTable(models.Model):
 
     @api.model
     def create(self, vals):
-        vals['name'] = self.env.ref('energy_selfconsumption.distribution_table_sequence', False).next_by_id()
-        return super(DistributionTable, self).create(vals)
+        vals["name"] = self.env.ref(
+            "energy_selfconsumption.distribution_table_sequence", False
+        ).next_by_id()
+        return super().create(vals)
 
-    @api.constrains('supply_point_assignation_ids')
+    @api.constrains("supply_point_assignation_ids")
     def _supply_point_constrain(self):
         for record in self:
-            if record.state in ('validated', 'process', 'active'):
-                raise ValidationError(_("The supply point can't be removed because the distribution table state is {table_state}").format(table_state=record.state))
-     
-    @api.onchange('selfconsumption_project_id')
+            if record.state in ("validated", "process", "active"):
+                raise ValidationError(
+                    _(
+                        "The supply point can't be removed because the distribution table state is {table_state}"
+                    ).format(table_state=record.state)
+                )
+
+    @api.onchange("selfconsumption_project_id")
     def _onchange_selfconsumption_project_id(self):
         self.supply_point_assignation_ids = False