planet: Add a view counter for the posts

diff --git a/webapp/backend/planet.py b/webapp/backend/planet.py
index 5beb90ff1e878d143be19e3ad3db094ca1cd5ae8..c4f432075bacc20b6ddbf764cf44fad86fd87349 100644 (file)
--- a/webapp/backend/planet.py
+++ b/webapp/backend/planet.py
@@ -115,6 +115,9 @@ class PlanetEntry(Object):
        def is_published(self):
                return self.status == "published"
 
+       def increase_view_counter(self):
+               self.db.execute("UPDATE planet SET views = views + 1 WHERE id = %s", self.id)
+
 
 class Planet(Object):
        def get_authors(self):

diff --git a/webapp/handlers_planet.py b/webapp/handlers_planet.py
index 162359e9094b7623c3ab0cf3538b39a3d8fffc4f..cd8cf348e7a95b4027ce8280e04e2f1147887326 100644 (file)
--- a/webapp/handlers_planet.py
+++ b/webapp/handlers_planet.py
@@ -43,6 +43,9 @@ class PlanetPostingHandler(PlanetBaseHandler):
                if not entry:
                        raise tornado.web.HTTPError(404)
 
+               # Update the view counter
+               entry.increase_view_counter()
+
                self.render("planet/posting.html",
                        author=entry.author, entry=entry)