Changeset 75ea229 for music

Timestamp:

05/12/25 10:08:51 (5 days ago)

Author:

ManuelTrajcev <manueltrajcev7@…>

Branches:

master

Parents:

d715225

Message:

update

Location:

music

Files:

• __pycache__/models.cpython-312.pyc (modified) ( previous)
• migrations/0006_alter_deletedcustomerlog_options_and_more.py (added)
• migrations/0007_alter_price_options.py (added)
• migrations/__pycache__/0006_alter_deletedcustomerlog_options_and_more.cpython-312.pyc (added)
• migrations/__pycache__/0007_alter_price_options.cpython-312.pyc (added)
• models.py (modified) (4 diffs)
• triggers/insert_price_on_track_insert.sql (added)
• triggers/insert_price_on_track_update.sql (added)

music/models.py

@@ -127 +127 @@
     class Meta:
         db_table = 'invoice'
+        managed = False
 
 
@@ -138 +139 @@
     class Meta:
         db_table = 'invoice_line'
+        managed = False
 
 
@@ -158 +160 @@
     class Meta:
         db_table = 'playlist_track'
+        managed = False
         unique_together = (('playlist', 'track'),)
 
@@ -173 +176 @@
     class Meta:
         db_table = 'deleted_customer_log'
+        managed = False
 
     def __str__(self):
         return f"{self.first_name} {self.last_name} - Deleted on {self.deleted_at} - Total Spent: ${self.total_spent} from {self.invoice_count} invoices"
+
+class Price(models.Model):
+    price_id = models.AutoField(primary_key=True)
+    value = models.DecimalField(max_digits=10, decimal_places=2)
+    date = models.DateTimeField()
+    track_id = models.ForeignKey(Track, on_delete=models.DO_NOTHING, db_column='track_id')
+
+    class Meta:
+        managed = False
+        db_table = 'price'
+
+    def __str__(self):
+        return f"{self.track_id} - {self.value} - {self.date}"