]>
git.ipfire.org Git - ipfire.org.git/blob - webapp/backend/ads.py
f7abe5885488c6194e6c93d6825080fb5e8eaf82
3 from __future__
import division
8 from misc
import Object
10 class Advertisements(Object
):
11 def get(self
, where
=None):
12 query
= "SELECT * FROM advertisements \
13 WHERE NOW() BETWEEN date_start AND date_end AND published = %s"
17 query
+= " AND location = %s"
20 query
+= " ORDER BY RANDOM() LIMIT 1"
22 ad
= self
.db
.get(query
, *args
)
24 return Advert(self
.backend
, ad
.id, ad
)
28 def __init__(self
, backend
, id, data
=None):
29 Object
.__init
__(self
, backend
)
36 if self
.__data
is None:
37 self
.__data
= self
.db
.get("SELECT * FROM advertisements WHERE id = %s", self
.id)
44 return self
.data
.company
56 return """<a href="%s" target="_blank">%s</a>""" % (self
.url
, self
.text
or self
.company
)
58 def update_impressions(self
):
59 self
.db
.execute("UPDATE advertisements SET impressions = impressions + 1 WHERE id = %s", self
.id)