return Databases().webapp
def get(self, slug):
- wish = self.db.get("SELECT id FROM wishlist WHERE slug = %s", slug)
+ wish = self.db.get("SELECT * FROM wishlist WHERE slug = %s", slug)
if wish:
return Wish(self, wish.id)
wishes = []
for row in self.db.query(query):
- wish = Wish(self, row.id)
+ wish = Wish(self, row.id, row)
wishes.append(wish)
return wishes
def get_all_running(self):
- return self.get_all_by_query("SELECT id FROM wishlist \
+ return self.get_all_by_query("SELECT * FROM wishlist \
WHERE DATE(NOW()) >= date_start AND DATE(NOW()) <= date_end AND published = 'Y'\
ORDER BY prio ASC, date_end ASC")
def get_all_finished(self):
- return self.get_all_by_query("SELECT id FROM wishlist \
+ return self.get_all_by_query("SELECT * FROM wishlist \
WHERE DATE(NOW()) > date_end AND published = 'Y' ORDER BY date_end ASC")
class Wish(object):
- def __init__(self, wishlist, id):
+ def __init__(self, wishlist, id, data=None):
self.wishlist = wishlist
self.id = id
- self.__data = None
+ self.__data = data
def __cmp__(self, other):
return cmp(self.date_end, other.date_end)
def percentage(self):
return (self.donated / self.goal) * 100
+ @property
+ def percentage_bar(self):
+ if self.percentage > 100:
+ return 100
+
+ return self.percentage
+
@property
def running(self):
if self.remaining_days < 0: