[ipfire.org.git] / webapp / backend / banners.py

#!/usr/bin/python

from databases import Databases
from misc import Singleton

class Banners(object):
	__metaclass__ = Singleton

	@property
	def db(self):
		return Databases().webapp

	def list(self):
		return self.db.query("SELECT * FROM banners")

	def get_random(self):
		return self.db.get("SELECT * FROM banners ORDER BY RAND() LIMIT 1")


if __name__ == "__main__":
	b = Banners()

	print b.list()

	print "--- RANDOM ---"

	for i in range(5):
		print i, b.get_random()
Commit	Line	Data
940227cb MT	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()