[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Savannah-hackers-public] Getting a full atom feed
From: |
Assaf Gordon |
Subject: |
Re: [Savannah-hackers-public] Getting a full atom feed |
Date: |
Wed, 26 Oct 2016 20:55:10 -0400 |
> On Oct 26, 2016, at 04:14, Ludovic Courtès <address@hidden> wrote:
>
> The Savane atom feed generator has a hard-coded limit of 20 items:
> [...]
> Could you run the above code without this 20 item limit and send me the
> result?
Sent off-list.
For future reference, the command was:
echo "select forum_id, user.realname, date as timestamp,
FROM_UNIXTIME(date, '%Y-%m-%d-%H%i%S' ) as date,
summary,details
from news_bytes,user
where is_approved<>4 and is_approved<5 and
group_id=11088 and news_bytes.submitted_by = user.user_id
order by date desc ;" | mysql savane \
| tr -d '\r' | iconv -f latin1 -t utf8 > guix-news.txt
-assaf