#! /usr/local/bin/python #-*- coding: utf-8 -*- __author__ = "Cedric Bonhomme" __version__ = "$Revision: 0.2 $" __date__ = "$Date: 2010/31/01 $" __copyright__ = "Copyright (c) 2010 Cedric Bonhomme" __license__ = "GPLv3" import sqlite3 import cherrypy import ConfigParser from datetime import datetime from cherrypy.lib.static import serve_file config = ConfigParser.RawConfigParser() config.read("./cfg/pyAggr3g470r.cfg") path = config.get('global','path') bindhost = "0.0.0.0" cherrypy.config.update({ 'server.socket_port': 12556, 'server.socket_host': bindhost}) path = { '/css/style.css': {'tools.staticfile.on': True, 'tools.staticfile.filename':path+'css/style.css'} } htmlheader = """\n\n\n\n pyAggr3g470r - RSS Feed Reader """ htmlfooter = """""" htmlnav = """

pyAggr3g470r - RSS Feed Reader

pyAggr3g470r (source code) """ class Root: def index(self): self.dic = {} html = htmlheader html += htmlnav html += """
""" html += """

Search

""" html += """
""" html += """Management of feed""" html += """
""" self.dic = self.retrieve_feed() for rss_feed in self.dic.keys(): html += '

' + rss_feed.encode('utf-8') + "

" for article in self.dic[rss_feed]: html += article[1].encode('utf-8') + " - " + \ '' + article[2].encode('utf-8') + "" + \ """ - [description]""" % (article[0].encode('utf-8'),) + \ "
" html += htmlfooter return html def f(self): """ """ return "Hello world !" def description(self, article_id): """ Display the description of an article. """ html = htmlheader html += htmlnav html += """
""" for rss_feed in self.dic.keys(): for article in self.dic[rss_feed]: if article_id == article[0]: html += article[4].encode('utf-8') html += """
\nComplete story""" % article[3].encode('utf-8') html += htmlfooter return html def retrieve_feed(self): list_of_articles = None try: conn = sqlite3.connect("./var/feed.db", isolation_level = None) c = conn.cursor() list_of_articles = c.execute("SELECT * FROM rss_feed").fetchall() c.close() except: pass if list_of_articles is not None: dic = {} for article in list_of_articles: if article[5] not in dic: dic[article[5]] = [(article[0], article[1], article[2], article[3], article[4], article[6])] else: dic[article[5]].append((article[0], article[1], article[2], article[3], article[4], article[6])) # sort articles by date for each feeds for feeds in dic.keys(): dic[feeds].sort(lambda x,y: compare(y[1], x[1])) return dic return {} index.exposed = True f.exposed = True description.exposed = True def compare(stringtime1, stringtime2): """ Compare two dates in the format 'yyyy-mm-dd hh:mm:ss'. """ date1, time1 = stringtime1.split(' ') date2, time2 = stringtime2.split(' ') year1, month1, day1 = date1.split('-') year2, month2, day2 = date2.split('-') hour1, minute1, second1 = time1.split(':') hour2, minute2, second2 = time2.split(':') datetime1 = datetime(year=int(year1), month=int(month1), day=int(day1), \ hour=int(hour1), minute=int(minute1), second=int(second1)) datetime2 = datetime(year=int(year2), month=int(month2), day=int(day2), \ hour=int(hour2), minute=int(minute2), second=int(second2)) if datetime1 < datetime2: return -1 elif datetime1 > datetime2: return 1 else: return 0 if __name__ == '__main__': root = Root() cherrypy.quickstart(root, config=path)