webapp/backend/banners.py

   1 #!/usr/bin/python
   2
   3 from databases import Databases
   4 from misc import Singleton
   5
   6 class Banners(object):
   7         __metaclass__ = Singleton
   8
   9         @property
  10         def db(self):
  11                 return Databases().webapp
  12
  13         def list(self):
  14                 return self.db.query("SELECT * FROM banners")
  15
  16         def get_random(self):
  17                 return self.db.get("SELECT * FROM banners ORDER BY RAND() LIMIT 1")
  18
  19
  20 if __name__ == "__main__":
  21         b = Banners()
  22
  23         print b.list()
  24
  25         print "--- RANDOM ---"
  26
  27         for i in range(5):
  28                 print i, b.get_random()