#! /usr/local/bin/python #-*- coding: utf-8 -*- __author__ = "Cedric Bonhomme" __version__ = "$Revision: 0.3 $" __date__ = "$Date: 2010/02/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): """ Main page containing the list of feeds and articles. """ self.dic = self.load_feed() html = htmlheader html += htmlnav html += """
\n""" html += """

Search

\n""" html += """
\n""" html += """Management of feed\n""" html += "
\n" html += "Your feeds:
\n" for rss_feed in self.dic.keys(): html += """%s
\n""" % (rss_feed.encode('utf-8'), \ rss_feed.encode('UTF-8')) html += """
\n
\n""" for rss_feed in self.dic.keys(): html += '

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

\n" for article in self.dic[rss_feed]: html += article[1].encode('utf-8') + " - " + \ '' + article[2].encode('utf-8') + "" + \ """ - [description]""" % (article[0].encode('utf-8'),) + \ "
\n" html += "
\n" html += htmlfooter return html def f(self): """ """ return "Hello world !" def description(self, article_id): """ Display the description of an article in a new Web page. """ 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 load_feed(self): """ Load feeds in a dictionary. """ 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 # The key of dic is the title of the feed: # dic[feed_title] = (article_id, article_date, article_title, article_link, article_description, feed_link) dic = {} if list_of_articles is not None: 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 dic 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)