URL model: use self.urlitem_set to let orm caching work for item.shorturl (optimize one unneeded query on view)
authorTero Marttila <terom@fixme.fi>
Mon, 02 Sep 2013 02:21:42 +0300
changeset 69 f7db1b752763
parent 68 182ac4b328ec
child 70 e8a8d490df2f
URL model: use self.urlitem_set to let orm caching work for item.shorturl (optimize one unneeded query on view)
qrurls/models.py
--- a/qrurls/models.py	Mon Sep 02 02:10:28 2013 +0300
+++ b/qrurls/models.py	Mon Sep 02 02:21:42 2013 +0300
@@ -87,7 +87,7 @@
         now = self.now(now)
 
         try :
-            return URLItem.objects.filter(shorturl=self, published__lt=now).order_by('-published')[0]
+            return self.urlitem_set.filter(published__lt=now).order_by('-published')[0]
         except IndexError :
             return None
 
@@ -96,7 +96,7 @@
         now = self.now(now)
 
         try :
-            return URLItem.objects.filter(shorturl=self, published__gt=now).order_by('published')[0]
+            return self.urlitem_set.filter(published__gt=now).order_by('published')[0]
         except IndexError :
             return None
 
@@ -104,7 +104,7 @@
         """The last URLItem available."""
 
         try :
-            return URLItem.objects.filter(shorturl=self).order_by('-published')[0]
+            return self.urlitem_set.order_by('-published')[0]
         except IndexError :
             return None