update homepage to use new soundfile template

[panikweb.git] / panikweb / views.py

diff --git a/panikweb/views.py b/panikweb/views.py
index 6ba67b0e7ec2125f44171b4e0c112dbbf799e725..706aff00e0e742288bbef060812546cb752407c4 100644 (file)
--- a/panikweb/views.py
+++ b/panikweb/views.py
@@ -414,8 +414,8 @@ class Home(TemplateView):
                          'datetime': datetime(2007, 1, day+1)})
         context['days'] = days
 
-        context['episodes'] = Episode.objects.prefetch_related('emission__categories').filter(
-                soundfile__podcastable=True, soundfile__fragment=False) \
+        context['soundfiles'] = SoundFile.objects.prefetch_related('episode__emission__categories').filter(
+                podcastable=True, fragment=False) \
                 .select_related().extra(select={
                     'first_diffusion': 'emissions_diffusion.datetime', },
                     select_params=(False, True),
@@ -424,17 +424,6 @@ class Home(TemplateView):
                                         WHERE episode_id = emissions_episode.id)'''],
                     tables=['emissions_diffusion'],).order_by('-first_diffusion') [:6]
 
-        # get all related soundfiles in a single query
-        soundfiles = {}
-        for soundfile in SoundFile.objects.select_related().filter(podcastable=True,
-                fragment=False, episode__in=[x.id for x in context['episodes']]):
-            soundfiles[soundfile.episode_id] = soundfile
-
-        # replace dynamic property by a static attribute, to avoid database
-        # lookups
-        for episode in context['episodes']:
-            episode.main_sound = soundfiles.get(episode.id)
-
         context['newsletter_form'] = SubscribeForm()
 
         return context