From: Frédéric Péters <fpeters@0d.be>
Date: Mon, 23 Nov 2015 18:27:37 +0000 (+0100)
Subject: fix selection of past/future episodes
X-Git-Tag: v2021~54
X-Git-Url: https://git.0d.be/?p=django-panik-combo.git;a=commitdiff_plain;h=821670a8ffa7f13359de9d1613fa1f481383f3d0;ds=sidebyside

fix selection of past/future episodes
---

diff --git a/panikombo/models.py b/panikombo/models.py
index 38da84b..3a74383 100644
--- a/panikombo/models.py
+++ b/panikombo/models.py
@@ -114,16 +114,16 @@ class EpisodeAutoSelectionCell(CellBase):
                     select={ 'first_diffusion': 'emissions_diffusion.datetime', },
                     select_params=(False, True),
                     where=['''datetime = (SELECT MIN(datetime) FROM emissions_diffusion
-                                           WHERE episode_id = emissions_episode.id AND
-                                                 emissions_diffusion.datetime >= CURRENT_TIMESTAMP)'''],
+                                           WHERE episode_id = emissions_episode.id) AND
+                                                 datetime >= CURRENT_TIMESTAMP'''],
                     tables=['emissions_diffusion'])
         elif self.period == 2:
             episodes_queryset = episodes_queryset.extra(
                     select={ 'first_diffusion': 'emissions_diffusion.datetime', },
                     select_params=(False, True),
                     where=['''datetime = (SELECT MIN(datetime) FROM emissions_diffusion
-                                           WHERE episode_id = emissions_episode.id AND
-                                                 emissions_diffusion.datetime < CURRENT_TIMESTAMP)'''],
+                                           WHERE episode_id = emissions_episode.id) AND
+                                                 datetime < CURRENT_TIMESTAMP'''],
                     tables=['emissions_diffusion'])
 
         return episodes_queryset