#!/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 ()