From 6c559d487f96a85194e432248a4055945157ef82 Mon Sep 17 00:00:00 2001 From: cedricbonhomme Date: Fri, 5 Feb 2010 13:10:45 +0100 Subject: Unread articles are now in bold (new field in the SQLite database). New tabs for articles's description are opened with the _rel=noreferrer_ option in order to separates processes (useful with Chromium). --- feedgetter.py | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'feedgetter.py') diff --git a/feedgetter.py b/feedgetter.py index a16585d8..b65a25e9 100644 --- a/feedgetter.py +++ b/feedgetter.py @@ -44,7 +44,8 @@ class FeedGetter(object): self.c.execute('''create table if not exists rss_feed (article_date text, article_title text, \ article_link text PRIMARY KEY, article_description text, \ - feed_title text, feed_site_link text)''') + feed_title text, feed_site_link text, \ + article_readed text)''') self.conn.commit() self.c.close() @@ -110,13 +111,14 @@ class FeedGetter(object): article_id = sha256_hash.hexdigest() try: - self.c.execute('insert into rss_feed values (?,?,?,?,?,?)', (\ + self.c.execute('insert into rss_feed values (?,?,?,?,?,?,?)', (\ datetime(*article.updated_parsed[:6]), \ article.title.encode('utf-8'), \ article.link.encode('utf-8'), \ description, \ a_feed.feed.title.encode('utf-8'), \ - a_feed.feed.link.encode('utf-8'))) + a_feed.feed.link.encode('utf-8'), \ + "0")) except sqlite3.IntegrityError: pass -- cgit