Changeset bfca48b for music

Timestamp:

04/28/25 17:28:23 (3 weeks ago)

Author:

ManuelTrajcev <manueltrajcev7@…>

Branches:

master

Children:

17ed1da

Parents:

0e077ef

Message:

+4 views with controlers and templates

Location:

music

Files:

• __pycache__/urls.cpython-312.pyc (modified) ( previous)
• __pycache__/views.cpython-312.pyc (modified) ( previous)
• urls.py (modified) (1 diff)
• views.py (modified) (1 diff)
• views/avg_price_per_artist.sql (added)
• views/media_type_percentage.sql (added)
• views/most_listened_genre_per_customer.sql (added)
• views/rank_list_artists.sql (added)

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('artist/avg-track-duration', views.avg_track_duration, name='avg_track_duration'),
+    path('artist/avg-track-price', views.avg_price_per_artist, name='avg_track_price'),
+    path('artist/most-popular', views.rank_list_artists, name='rank_list_artists'),
     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'),
+    path('customer/genre', views.most_listened_genre_per_customer, name='most_listened_genre_per_customer'),
+    path('media-type/percentage', views.media_type_percentage, name='media_type_percentage'),
+    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

@@ -62 +62 @@
 
     return render(request, 'rank_list_most_active_customers.html', {'data': data})
+
+
+def avg_price_per_artist(request):
+    with connection.cursor() as cursor:
+        cursor.execute("SELECT * FROM avg_price_per_artist;")
+        rows = cursor.fetchall()
+
+    data = [{'name': row[0], 'avg_price_per_track': row[1]} for row in rows]
+
+    return render(request, 'avg_price_per_artist.html', {'data': data})
+
+
+def rank_list_artists(request):
+    with connection.cursor() as cursor:
+        cursor.execute("SELECT * FROM rank_list_artists;")
+        rows = cursor.fetchall()
+
+    data = [{'name': row[0], 'num_invoices': row[1]} for row in rows]
+
+    return render(request, 'rank_list_artists.html', {'data': data})
+
+
+
+def media_type_percentage(request):
+    with connection.cursor() as cursor:
+        cursor.execute("SELECT * FROM media_type_percentage;")
+        rows = cursor.fetchall()
+
+    data = [{'name': row[0], 'num_of_tracks': row[1], 'percentage': row[2]} for row in rows]
+
+    return render(request, 'media_type_percentage.html', {'data': data})
+
+
+def most_listened_genre_per_customer(request):
+    with connection.cursor() as cursor:
+        cursor.execute("SELECT * FROM most_listened_genre_per_customer;")
+        rows = cursor.fetchall()
+
+    data = [{'first_name': row[0], 'last_name': row[1], 'most_listened_genre': row[2]} for row in rows]
+
+    return render(request, 'most_listened_genre_per_customer.html', {'data': data})