diff options
| author | Étienne Loks <etienne.loks@peacefrogs.net> | 2012-10-26 17:51:13 +0200 |
|---|---|---|
| committer | Étienne Loks <etienne.loks@peacefrogs.net> | 2012-10-26 17:51:13 +0200 |
| commit | a5d90cfbcd74648750e695c68fac6e7c4e933f45 (patch) | |
| tree | e40fa9ce28e71f85e6c478332fe80ee6f30ef917 /chimere/feeds.py | |
| parent | 6a8995c959c8337e91ab4f01e810c610e0462c0e (diff) | |
| download | Chimère-a5d90cfbcd74648750e695c68fac6e7c4e933f45.tar.bz2 Chimère-a5d90cfbcd74648750e695c68fac6e7c4e933f45.zip | |
Feeds: Fix feeds by area (refs #378)
Diffstat (limited to 'chimere/feeds.py')
| -rw-r--r-- | chimere/feeds.py | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/chimere/feeds.py b/chimere/feeds.py index 100dd6b..53444ac 100644 --- a/chimere/feeds.py +++ b/chimere/feeds.py @@ -220,9 +220,6 @@ class LatestPOIsByZoneID(BaseFeed): return reverse('chimere:feeds-areaid', args=['', obj.id]) def items(self, obj): - sql = 'select * from "chimere_marker" where ' + obj.getIncludeSql() - sql += ' and "chimere_marker".available_date is not null' - sql += ' and "chimere_marker".status=\'A\'' - sql += ' order by "chimere_marker".available_date desc limit 15' - q = Marker.objects.raw(sql) + q = Marker.objects.filter(available_date__isnull=False, status='A') + q = q.filter(obj.getIncludeMarker()).order_by('-available_date')[:15] return q |