Changeset d715225 for music/models.py

Timestamp:

05/07/25 11:05:41 (10 days ago)

Author:

ManuelTrajcev <manueltrajcev7@…>

Branches:

master

Children:

75ea229

Parents:

d1a8cb0

Message:

deleted customer log trigger

File:

• music/models.py (modified) (3 diffs)

music/models.py

@@ -113 +113 @@
 class Invoice(models.Model):
     invoice_id = models.AutoField(primary_key=True)
-    customer = models.ForeignKey(Customer, on_delete=models.CASCADE, db_column='customer_id')
+    customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, db_column='customer_id', null=True)
     invoice_date = models.DateTimeField()
     billing_address = models.CharField(max_length=70, blank=True, null=True)
@@ -158 +158 @@
     class Meta:
         db_table = 'playlist_track'
-        managed = False
         unique_together = (('playlist', 'track'),)
 
@@ -170 +169 @@
     last_name = models.CharField(max_length=20)
     deleted_at = models.DateTimeField()
-
+    total_spent = models.DecimalField(max_digits=10, decimal_places=2)
+    invoice_count = models.IntegerField()
     class Meta:
         db_table = 'deleted_customer_log'
-        managed = False
 
     def __str__(self):
-        return f"{self.first_name} {self.last_name} {self.deleted_at}"
+        return f"{self.first_name} {self.last_name} - Deleted on {self.deleted_at} - Total Spent: ${self.total_spent} from {self.invoice_count} invoices"