From b244701ad7e4b2e27802d5c5b661db86f2549610 Mon Sep 17 00:00:00 2001
From: cedricbonhomme <devnull@localhost>
Date: Mon, 1 Feb 2010 22:05:06 +0100
Subject: Release 0.4. The main page display only 10 articles by feeds. For
 each feeds a page present the list of all articles. The SQLite base is
 smaller than before (removed hashed value). And a lot of improvements.

---
 feedgetter.py | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

(limited to 'feedgetter.py')

diff --git a/feedgetter.py b/feedgetter.py
index ec750496..936a4cd2 100644
--- a/feedgetter.py
+++ b/feedgetter.py
@@ -2,7 +2,7 @@
 #-*- coding: utf-8 -*-
 
 __author__ = "Cedric Bonhomme"
-__version__ = "$Revision: 0.3 $"
+__version__ = "$Revision: 0.4 $"
 __date__ = "$Date: 2010/02/01 $"
 __copyright__ = "Copyright (c) 2010 Cedric Bonhomme"
 __license__ = "GPLv3"
@@ -37,8 +37,8 @@ class FeedGetter(object):
         self.conn = sqlite3.connect("./var/feed.db", isolation_level = None)
         self.c = self.conn.cursor()
         self.c.execute('''create table if not exists rss_feed
-                    (article_id text PRIMARY KEY, article_date text, \
-                    article_title text, article_link text, article_description text, \
+                    (article_date text, article_title text, \
+                    article_link text PRIMARY KEY, article_description text, \
                     feed_title text, feed_site_link text)''')
         self.conn.commit()
         self.c.close()
@@ -105,8 +105,7 @@ class FeedGetter(object):
             article_id = sha256_hash.hexdigest()
 
             try:
-                self.c.execute('insert into rss_feed values (?,?,?,?,?,?,?)', (\
-                        article_id, \
+                self.c.execute('insert into rss_feed values (?,?,?,?,?,?)', (\
                         datetime(*article.updated_parsed[:6]), \
                         article.title.encode('utf-8'), \
                         article.link.encode('utf-8'), \
-- 
cgit