From a4916103efb2d97896c456ff0e83064b21e85d25 Mon Sep 17 00:00:00 2001 From: Pepper Date: Wed, 20 May 2015 11:16:13 -0400 Subject: first commit in a while --- feeder/feeder-build.py | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100755 feeder/feeder-build.py (limited to 'feeder/feeder-build.py') diff --git a/feeder/feeder-build.py b/feeder/feeder-build.py new file mode 100755 index 0000000..7633c3f --- /dev/null +++ b/feeder/feeder-build.py @@ -0,0 +1,45 @@ +#!/usr/bin/python + +import db +#TEMPLATE_PATH = "/var/www/scannerjammer.com/diornights/httpdocs/" +#f = file (TEMPLATE_PATH+"template.html", "r") +#template = f.read() +#f.close() + +DB = db.db () + +sql = "SELECT * FROM dior_fb WHERE date > %s ORDER BY likes DESC" +DB.execute(sql, (db.now() - 86400*3)) +rows = DB.cursor.fetchall () + +def is_image (url): + return url[-3:].lower() in ["gif","jpg","png"] or url[-4:].lower == "jpeg" + +boxes = [] +count = 0 +for row in rows: + # 0 id 1 fbid 2 date 3 likes 4 comments 5 authorfbid 6 author 7 link 8 description + if row[3] < 1: + continue + if is_image (row[7]): + boxes.append("

%s - %d likes
" % (row[7], row[6], row[3])) + count += 1 + if count == 2: + boxes.append(""" +
+ +
+ """) + +#out = file(TEMPLATE_PATH+"index.html", "w") +#out.write( template.replace("%%REPORT%%", "".join(boxes)) ) +#out.close () + -- cgit v1.2.3-70-g09d2