diff options
Diffstat (limited to 'feeder/feeder-build.py')
| -rwxr-xr-x | feeder/feeder-build.py | 45 |
1 files changed, 45 insertions, 0 deletions
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("<div class='box'><img src='%s' /><br/>%s - %d likes</div>" % (row[7], row[6], row[3])) + count += 1 + if count == 2: + boxes.append(""" + <div id="feed" class="box"> + <ul> + <li>Follow us @</li> + <li><a href="http://www.facebook.com/diornights"><img src="/img/icons/facebook_32.png" class="icon"></a></li> + <li><a href="http://twitter.com/diornights/"><img src="/img/icons/twitter_32.png" class="icon"></a></li> + <li><a href="http://vimeo.com/diornights"><img src="/img/icons/vimeo_32.png" class="icon"></a></li> + <!-- <li><a href="http://diornights.tumblr.com/"><img src="/img/icons/tumblr_32.png" class="icon"></a></li> + <li><a href="http://diornights.bandcamp.com/"><img src="/img/icons/bandcamp_32.png" class="icon"></a></li> --> + <li><a href="http://www.youtube.com/user/diornights"><img src="/img/icons/youtube_32.png" class="icon"></a></li> + </ul> + </div> + """) + +#out = file(TEMPLATE_PATH+"index.html", "w") +#out.write( template.replace("%%REPORT%%", "".join(boxes)) ) +#out.close () + |