search

pudymody / pudymody.github.io

Personal page
https://federicoscodelaro.com/
0 stars 2 forks source link

QuiteRSS to FreshRSS #109

Open pudymody opened 1 year ago

pudymody commented 1 year ago

Comments for https://federicoscodelaro.com/blog/2023-04-14-quiterss-to-freshrss/

fzhem commented 3 months ago

Thank you very much for writing this article. I have been avoiding migrating from QuiteRSS but thanks to you I migrated to FreshRSS today 👍 .

The QuiteRSS database does not have the qr_* tables now. I have modified the query to also import favourites and fix the is_read logic. The is_read column can also have a value "2", idk what that means but 0 always means unread.

INSERT INTO entry (id,guid,title,author,content,link,date,lastSeen,is_read,is_favorite,id_feed) SELECT ROW_NUMBER() OVER (ORDER BY '') AS id, news.guid, news.title, news.author_name AS author, news.description AS content, news.link_href AS link, STRFTIME('%s', news.published) AS date, STRFTIME('%s', news.received) AS lastSeen, (news.read != 0) AS is_read, (news.starred == 1) AS is_favorite, f.id as id_feed FROM RSS.news LEFT JOIN RSS.feeds ON (feeds.id = news.feedId) LEFT JOIN feed as f ON (f.url = feeds.xmlUrl) WHERE news.deleted = 0 AND f.id not null;