Changeset 0e077ef for music

Timestamp:

04/26/25 08:25:45 (3 weeks ago)

Author:

ManuelTrajcev <manueltrajcev7@…>

Branches:

master

Children:

bfca48b

Parents:

d7662b5

Message:

2 views wtih controllers and templates added

Location:

music

Files:

• __pycache__/models.cpython-312.pyc (modified) ( previous)
• __pycache__/urls.cpython-312.pyc (modified) ( previous)
• __pycache__/views.cpython-312.pyc (modified) ( previous)
• models.py (modified) (1 diff)
• tests.py (modified) (1 diff)
• urls.py (modified) (1 diff)
• views.py (modified) (3 diffs)
• views/avg_song_duration_per_artist.sql (added)
• views/rang_list_most_active_customers_view.sql (added)

music/models.py

@@ -163 +163 @@
     def __str__(self):
         return f"{self.playlist} - {self.track}"
-
-
-#VIEWS
-
-class tracks_count_per_genre(models.Model):
-    genre = models.CharField(max_length=20, blank=True, null=True)
-    count = models.IntegerField(blank=True, null=True)
-
-    class Meta:
-        db_table = 'tracks_count_per_genre'
-        managed = False
-
-    def __str__(self):
-        return f"{self.genre} - {self.count}"

music/tests.py

@@ -8 +8 @@
 django.setup()
 
-from music.models import Artist
-artists = Artist.objects.raw('SELECT * FROM music_artist')
-for artist in artists:
-    print(artist.name)

music/urls.py

@@ -5 +5 @@
     path('album/', views.album_list, name='album_list'),
     path('artist/', views.artist_list, name='artist_list'),
+    path('artist/avg_track_duration', views.avg_track_duration, name='avg_track_duration'),
     path('track/', views.track_list, name='track_list'),
     path('track/per_genre', views.tracks_count_per_genre, name='track_count_per_genre'),
+    path('customer/rank_list', views.rank_list_most_active_customers, name='rank_list_most_active_customers'),
 ]

music/views.py

@@ -15 +15 @@
     heading = request.GET.get('model', 'All Albums')
     data = Album.objects.values_list('title', flat=True)
-    return render(request, 'album_list.html', {'data': data, 'heading': heading})
+    return render(request, 'list.html', {'data': data, 'heading': heading})
 
 
@@ -21 +21 @@
     heading = request.GET.get('model', 'All Tracks')
     data = Track.objects.values_list('name', flat=True)
-    return render(request, 'album_list.html', {'data': data, 'heading': heading})
+    return render(request, 'list.html', {'data': data, 'heading': heading})
 
 
+def artist_list(request):
+    heading = request.GET.get('model', 'All Artists')
+    data = Artist.objects.values_list('name', flat=True)
+    print(data)
+    return render(request, 'list.html', {'data': data, 'heading': heading})
+
+
+# VIEWS
 def tracks_count_per_genre(request):
     with connection.cursor() as cursor:
@@ -35 +43 @@
 
 
-def artist_list(request):
-    heading = request.GET.get('model', 'All Artists')
-    data = Artist.objects.values_list('name', flat=True)
+def avg_track_duration(request):
+    with connection.cursor() as cursor:
+        cursor.execute("SELECT * FROM avg_track_duration_per_artist;")
+        rows = cursor.fetchall()
+
+    data = [{'artist': row[0], 'avg': row[1]} for row in rows]
     print(data)
-    return render(request, 'album_list.html', {'data': data, 'heading': heading})
+
+    return render(request, 'avg_track_duration.html', {'data': data})
+
+
+def rank_list_most_active_customers(request):
+    with connection.cursor() as cursor:
+        cursor.execute("SELECT * FROM rank_list_most_active_customers_view;")
+        rows = cursor.fetchall()
+
+    data = [{'name': row[0], 'total_orders': row[1], 'total_money_spent': row[2]} for row in rows]
+
+    return render(request, 'rank_list_most_active_customers.html', {'data': data})