Page 1 of 1

Link between feeds and entries

Posted: 30 May 2013, 14:38
by Cyanatide
Hi!
I try to develop a webservice which returns all rss item of a category. So, I create a SQL request with category name in parameter, I get all feed saved under this category. But I can't find a link between table ttrss_feeds and ttrss_entries, so I can't get items corresponding to a specific feed. How does it works on the GUI?
Thanks!

Re: Link between feeds and entries

Posted: 30 May 2013, 14:51
by fox
Image

see ttrss_user_entries

Re: Link between feeds and entries

Posted: 30 May 2013, 15:25
by jdelamater99
Cyanatide wrote:Hi!
I try to develop a webservice which returns all rss item of a category. So, I create a SQL request with category name in parameter, I get all feed saved under this category. But I can't find a link between table ttrss_feeds and ttrss_entries, so I can't get items corresponding to a specific feed. How does it works on the GUI?
Thanks!


Maybe I'm misunderstanding what you are trying to do, but it sounds like you are trying to recreate the wheel. Why not just use the "View as RSS feed" button?
Captured at 2013-05-30 at 7.21.34 AM.JPEG
Captured at 2013-05-30 at 7.21.34 AM.JPEG (11.11 KiB) Viewed 944 times


I'm probably missing something. I haven't gotten much sleep this week. I think I'm averaging 4hrs a night, so I'm kind of tired.

Re: Link between feeds and entries

Posted: 30 May 2013, 17:45
by Cyanatide
Thanks fox!
jdelamater99, in fact I want keep a RSS stream parsed to ré-insert him in another database.

Re: Link between feeds and entries

Posted: 30 May 2013, 17:59
by fox
You can even output feed in JSON instead of RSS which might be easier to parse depending on your service. See the wiki for details.