diff options
| author | cedricbonhomme <devnull@localhost> | 2010-02-01 22:05:06 +0100 |
|---|---|---|
| committer | cedricbonhomme <devnull@localhost> | 2010-02-01 22:05:06 +0100 |
| commit | b244701ad7e4b2e27802d5c5b661db86f2549610 (patch) | |
| tree | cae19b2650324c44eaad2c162d76004889b8e604 /feedgetter.py | |
| parent | Added a menu to access more faster to feeds and some improvements of the CSS. (diff) | |
| download | newspipe-b244701ad7e4b2e27802d5c5b661db86f2549610.tar.gz newspipe-b244701ad7e4b2e27802d5c5b661db86f2549610.tar.bz2 newspipe-b244701ad7e4b2e27802d5c5b661db86f2549610.zip | |
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.
Diffstat (limited to 'feedgetter.py')
| -rw-r--r-- | feedgetter.py | 9 |
1 files changed, 4 insertions, 5 deletions
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'), \ |