1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
|
sfeed
-----
RSS and Atom parser (and some format programs).
It converts RSS or Atom feeds from XML to a TAB-separated file. There are
formatting programs included to convert this TAB-separated format to various
other formats. There are also some programs and scripts included to import and
export OPML and to fetch, filter, merge and order feed items.
Build and install
-----------------
$ make
# make install
Usage
-----
Initial setup:
mkdir -p "$HOME/.sfeed/feeds"
cp sfeedrc.example "$HOME/.sfeed/sfeedrc"
Edit the sfeedrc(5) configuration file and change any RSS/Atom feeds. This file
is included and evaluated as a shellscript for sfeed_update, so it's functions
and behaviour can be overridden:
$EDITOR "$HOME/.sfeed/sfeedrc"
or you can import existing OPML subscriptions using sfeed_opml_import(1):
sfeed_opml_import < file.opml > "$HOME/.sfeed/sfeedrc"
an example to export from an other RSS/Atom reader called newsboat and import
for sfeed_update:
newsboat -e | sfeed_opml_import > "$HOME/.sfeed/sfeedrc"
an example to export from an other RSS/Atom reader called rss2email (3.x+) and
import for sfeed_update:
r2e opmlexport | sfeed_opml_import > "$HOME/.sfeed/sfeedrc"
Update feeds, this script merges the new items, see sfeed_update(1) for more
information what it can do:
sfeed_update
Format feeds:
Plain-text list:
sfeed_plain $HOME/.sfeed/feeds/* > "$HOME/.sfeed/feeds.txt"
HTML view (no frames), copy style.css for a default style:
cp style.css "$HOME/.sfeed/style.css"
sfeed_html $HOME/.sfeed/feeds/* > "$HOME/.sfeed/feeds.html"
HTML view with the menu as frames, copy style.css for a default style:
mkdir -p "$HOME/.sfeed/frames"
cd "$HOME/.sfeed/frames" && sfeed_frames $HOME/.sfeed/feeds/*
To automatically update your feeds periodically and format them in a way you
like you can make a wrapper script and add it as a cronjob.
Most protocols are supported because curl(1) is used by default and also proxy
settings from the environment (such as the $http_proxy environment variable)
are used.
The sfeed(1) program itself is just a parser that parses XML data from stdin
and is therefore network protocol-agnostic. It can be used with HTTP, HTTPS,
Gopher, SSH, etc.
See the section "Usage and examples" below and the man-pages for more
information how to use sfeed(1) and the additional tools.
A separate curses UI front-end called sfeed_curses is available at:
https://codemadness.org/sfeed_curses.html
Dependencies
------------
- C compiler (C99).
- libc (recommended: C99 and POSIX >= 200809).
Optional dependencies
---------------------
- POSIX make(1) for Makefile.
- POSIX sh(1),
used by sfeed_update(1) and sfeed_opml_export(1).
- POSIX utilities such as awk(1) and sort(1),
used by sfeed_update(1).
- curl(1) binary: https://curl.haxx.se/ ,
used by sfeed_update(1), but can be replaced with any tool like wget(1),
OpenBSD ftp(1) or hurl(1): https://git.codemadness.org/hurl/
- iconv(1) command-line utilities,
used by sfeed_update(1). If the text in your RSS/Atom feeds are already UTF-8
encoded then you don't need this. For a minimal iconv implementation:
https://git.etalabs.net/cgit/noxcuse/tree/src/iconv.c
- mandoc for documentation: https://mdocml.bsd.lv/
OS tested
---------
- Linux (compilers: clang, cproc, gcc, lacc, pcc, tcc, libc: glibc, musl).
- OpenBSD (clang, gcc).
- NetBSD
- FreeBSD
- DragonFlyBSD
- Windows (cygwin gcc, mingw).
- HaikuOS (using libbsd).
- FreeDOS (djgpp).
- FUZIX (sdcc -mz80).
Architectures tested
--------------------
amd64, ARM, aarch64, HPPA, i386, MIPS32-BE, SPARC64, Z80.
Files
-----
sfeed - Read XML RSS or Atom feed data from stdin. Write feed data
in TAB-separated format to stdout.
sfeed_atom - Format feed data (TSV) to an Atom feed.
sfeed_frames - Format feed data (TSV) to HTML file(s) with frames.
sfeed_gopher - Format feed data (TSV) to Gopher files.
sfeed_html - Format feed data (TSV) to HTML.
sfeed_opml_export - Generate an OPML XML file from a sfeedrc config file.
sfeed_opml_import - Generate a sfeedrc config file from an OPML XML file.
sfeed_mbox - Format feed data (TSV) to mbox.
sfeed_plain - Format feed data (TSV) to a plain-text list.
sfeed_twtxt - Format feed data (TSV) to a twtxt feed.
sfeed_update - Update feeds and merge items.
sfeed_web - Find URLs to RSS/Atom feed from a webpage.
sfeed_xmlenc - Detect character-set encoding from a XML stream.
sfeedrc.example - Example config file. Can be copied to $HOME/.sfeed/sfeedrc.
style.css - Example stylesheet to use with sfeed_html(1) and
sfeed_frames(1).
Files read at runtime by sfeed_update(1)
----------------------------------------
sfeedrc - Config file. This file is evaluated as a shellscript in
sfeed_update(1).
At least the following functions can be overridden per feed:
- fetch: to use wget(1), OpenBSD ftp(1) or an other download program.
- filter: to filter on fields.
- merge: to change the merge logic.
- order: to change the sort order.
See also the sfeedrc(5) man page documentation for more details.
The feeds() function is called to process the feeds. The default feed()
function is executed concurrently as a background job in your sfeedrc(5) config
file to make updating faster. The variable maxjobs can be changed to limit or
increase the amount of concurrent jobs (8 by default).
Files written at runtime by sfeed_update(1)
-------------------------------------------
feedname - TAB-separated format containing all items per feed. The
sfeed_update(1) script merges new items with this file.
The format is documented in sfeed(5).
File format
-----------
man 5 sfeed
man 5 sfeedrc
man 1 sfeed
Usage and examples
------------------
Find RSS/Atom feed URLs from a webpage:
url="https://codemadness.org"; curl -L -s "$url" | sfeed_web "$url"
output example:
https://codemadness.org/blog/rss.xml application/rss+xml
https://codemadness.org/blog/atom.xml application/atom+xml
- - -
Make sure your sfeedrc config file exists, see sfeedrc.example. To update your
feeds (configfile argument is optional):
sfeed_update "configfile"
Format the feeds files:
# Plain-text list.
sfeed_plain $HOME/.sfeed/feeds/* > $HOME/.sfeed/feeds.txt
# HTML view (no frames), copy style.css for a default style.
sfeed_html $HOME/.sfeed/feeds/* > $HOME/.sfeed/feeds.html
# HTML view with the menu as frames, copy style.css for a default style.
mkdir -p somedir && cd somedir && sfeed_frames $HOME/.sfeed/feeds/*
View formatted output in your browser:
$BROWSER "$HOME/.sfeed/feeds.html"
View formatted output in your editor:
$EDITOR "$HOME/.sfeed/feeds.txt"
- - -
Example script to view feed items in a vertical list/menu in dmenu(1). It opens
the selected URL in the browser set in $BROWSER:
#!/bin/sh
url=$(sfeed_plain "$HOME/.sfeed/feeds/"* | dmenu -l 35 -i | \
sed -n 's@^.* \([a-zA-Z]*://\)\(.*\)$@\1\2@p')
test -n "${url}" && $BROWSER "${url}"
dmenu can be found at: https://git.suckless.org/dmenu/
- - -
Generate a sfeedrc config file from your exported list of feeds in OPML
format:
sfeed_opml_import < opmlfile.xml > $HOME/.sfeed/sfeedrc
- - -
Export an OPML file of your feeds from a sfeedrc config file (configfile
argument is optional):
sfeed_opml_export configfile > myfeeds.opml
- - -
The filter function can be overridden in your sfeedrc file. This allows
filtering items per feed. It can be used to shorten URLs, filter away
advertisements, strip tracking parameters and more.
# filter fields.
# filter(name)
filter() {
case "$1" in
"tweakers")
awk -F '\t' 'BEGIN { OFS = "\t"; }
# skip ads.
$2 ~ /^ADV:/ {
next;
}
# shorten link.
{
if (match($3, /^https:\/\/tweakers\.net\/[a-z]+\/[0-9]+\//)) {
$3 = substr($3, RSTART, RLENGTH);
}
print $0;
}';;
"yt BSDNow")
# filter only BSD Now from channel.
awk -F '\t' '$2 ~ / \| BSD Now/';;
*)
cat;;
esac | \
# replace youtube links with embed links.
sed 's@www.youtube.com/watch?v=@www.youtube.com/embed/@g' | \
awk -F '\t' 'BEGIN { OFS = "\t"; }
function filterlink(s) {
# protocol must start with http, https or gopher.
if (match(s, /^(http|https|gopher):\/\//) == 0) {
return "";
}
# shorten feedburner links.
if (match(s, /^(http|https):\/\/[^\/]+\/~r\/.*\/~3\/[^\/]+\//)) {
s = substr($3, RSTART, RLENGTH);
}
# strip tracking parameters
# urchin, facebook, piwik, webtrekk and generic.
gsub(/\?(ad|campaign|fbclid|pk|tm|utm|wt)_([^&]+)/, "?", s);
gsub(/&(ad|campaign|fbclid|pk|tm|utm|wt)_([^&]+)/, "", s);
gsub(/\?&/, "?", s);
gsub(/[\?&]+$/, "", s);
return s
}
{
$3 = filterlink($3); # link
$8 = filterlink($8); # enclosure
# try to remove tracking pixels: <img/> tags with 1px width or height.
gsub("<img[^>]*(width|height)[\s]*=[\s]*[\"'"'"' ]?1[\"'"'"' ]?[^0-9>]+[^>]*>", "", $4);
print $0;
}'
}
- - -
Aggregate feeds. This filters new entries (maximum one day old) and sorts them
by newest first. Prefix the feed name in the title. Convert the TSV output data
to an Atom XML feed (again):
#!/bin/sh
cd ~/.sfeed/feeds/ || exit 1
awk -F '\t' -v "old=$(($(date +'%s') - 86400))" '
BEGIN { OFS = "\t"; }
int($1) >= old {
$2 = "[" FILENAME "] " $2;
print $0;
}' * | \
sort -k1,1rn | \
sfeed_atom
- - -
To have a "tail(1) -f"-like FIFO stream filtering for new unique feed items and
showing them as plain-text per line similar to sfeed_plain(1):
Create a FIFO:
fifo="/tmp/sfeed_fifo"
mkfifo "$fifo"
On the reading side:
# This keeps track of unique lines so might consume much memory.
# It tries to reopen the $fifo after 1 second if it fails.
while :; do cat "$fifo" || sleep 1; done | awk '!x[$0]++'
On the writing side:
feedsdir="$HOME/.sfeed/feeds/"
cd "$feedsdir" || exit 1
test -p "$fifo" || exit 1
# 1 day is old news, don't write older items.
awk -F '\t' -v "old=$(($(date +'%s') - 86400))" '
BEGIN { OFS = "\t"; }
int($1) >= old {
$2 = "[" FILENAME "] " $2;
print $0;
}' * | sort -k1,1n | sfeed_plain | cut -b 3- > "$fifo"
cut -b is used to trim the "N " prefix of sfeed_plain(1).
- - -
For some podcast feed the following code can be used to filter the latest
enclosure URL (probably some audio file):
awk -F '\t' 'BEGIN { latest = 0; }
length($8) {
ts = int($1);
if (ts > latest) {
url = $8;
latest = ts;
}
}
END { if (length(url)) { print url; } }'
- - -
Over time your feeds file might become quite big. You can archive items of a
feed from (roughly) the last week by doing for example:
awk -F '\t' -v "old=$(($(date +'%s') - 604800))" 'int($1) > old' < feed > feed.new
mv feed feed.bak
mv feed.new feed
This could also be run weekly in a crontab to archive the feeds. Like throwing
away old newspapers. It keeps the feeds list tidy and the formatted output
small.
- - -
Convert mbox to separate maildirs per feed and filter duplicate messages using the
fdm program.
fdm is available at: https://github.com/nicm/fdm
fdm config file (~/.sfeed/fdm.conf):
set unmatched-mail keep
account "sfeed" mbox "%[home]/.sfeed/mbox"
$cachepath = "%[home]/.sfeed/fdm.cache"
cache "${cachepath}"
$maildir = "%[home]/feeds/"
# Check if message is in in cache by Message-ID.
match case "^Message-ID: (.*)" in headers
action {
tag "msgid" value "%1"
}
continue
# If it is in the cache, stop.
match matched and in-cache "${cachepath}" key "%[msgid]"
action {
keep
}
# Not in the cache, process it and add to cache.
match case "^X-Feedname: (.*)" in headers
action {
# Store to local maildir.
maildir "${maildir}%1"
add-to-cache "${cachepath}" key "%[msgid]"
keep
}
Now run:
$ sfeed_mbox ~/.sfeed/feeds/* > ~/.sfeed/mbox
$ fdm -f ~/.sfeed/fdm.conf fetch
Now you can view feeds in mutt(1) for example.
- - -
Read from mbox and filter duplicate messages using the fdm program and deliver
it to a SMTP server. This works similar to the rss2email program.
fdm is available at: https://github.com/nicm/fdm
fdm config file (~/.sfeed/fdm.conf):
set unmatched-mail keep
account "sfeed" mbox "%[home]/.sfeed/mbox"
$cachepath = "%[home]/.sfeed/fdm.cache"
cache "${cachepath}"
# Check if message is in in cache by Message-ID.
match case "^Message-ID: (.*)" in headers
action {
tag "msgid" value "%1"
}
continue
# If it is in the cache, stop.
match matched and in-cache "${cachepath}" key "%[msgid]"
action {
keep
}
# Not in the cache, process it and add to cache.
match case "^X-Feedname: (.*)" in headers
action {
# Connect to a SMTP server and attempt to deliver the
# mail to it.
# Of course change the server and e-mail below.
smtp server "codemadness.org" to "hiltjo@codemadness.org"
add-to-cache "${cachepath}" key "%[msgid]"
keep
}
Now run:
$ sfeed_mbox ~/.sfeed/feeds/* > ~/.sfeed/mbox
$ fdm -f ~/.sfeed/fdm.conf fetch
Now you can view feeds in mutt(1) for example.
- - -
Convert mbox to separate maildirs per feed and filter duplicate messages using
procmail(1).
procmail_maildirs.sh file:
maildir="$HOME/feeds"
feedsdir="$HOME/.sfeed/feeds"
procmailconfig="$HOME/.sfeed/procmailrc"
# message-id cache to prevent duplicates.
mkdir -p "${maildir}/.cache"
if ! test -r "${procmailconfig}"; then
echo "Procmail configuration file \"${procmailconfig}\" does not exist or is not readable." >&2
echo "See procmailrc.example for an example." >&2
exit 1
fi
find "${feedsdir}" -type f -exec printf '%s\n' {} \; | while read -r d; do
name=$(basename "${d}")
mkdir -p "${maildir}/${name}/cur"
mkdir -p "${maildir}/${name}/new"
mkdir -p "${maildir}/${name}/tmp"
printf 'Mailbox %s\n' "${name}"
sfeed_mbox "${d}" | formail -s procmail "${procmailconfig}"
done
Procmailrc(5) file:
# Example for use with sfeed_mbox(1).
# The header X-Feedname is used to split into separate maildirs. It is
# assumed this name is sane.
MAILDIR="$HOME/feeds/"
:0
* ^X-Feedname: \/.*
{
FEED="$MATCH"
:0 Wh: "msgid_$FEED.lock"
| formail -D 1024000 ".cache/msgid_$FEED.cache"
:0
"$FEED"/
}
Now run:
$ procmail_maildirs.sh
Now you can view feeds in mutt(1) for example.
- - -
The fetch function can be overridden in your sfeedrc file. This allows to
replace the default curl(1) for sfeed_update with any other client to fetch the
RSS/Atom data or change the default curl options:
# fetch a feed via HTTP/HTTPS etc.
# fetch(name, url, feedfile)
fetch() {
hurl -m 1048576 -t 15 "$2" 2>/dev/null
}
- - -
Caching, incremental data updates and bandwidth-saving
For servers that support it some incremental updates and bandwidth-saving can
be done by using the "ETag" HTTP header.
Create a directory for storing the ETags per feed:
mkdir -p ~/.sfeed/etags/
The curl ETag options (--etag-save and --etag-compare) can be used to store and
send the previous ETag header value. curl version 7.73+ is recommended for it
to work properly.
The curl -z option can be used to send the modification date of a local file as
a HTTP "If-Modified-Since" request header. The server can then respond if the
data is modified or not or respond with only the incremental data.
The curl --compressed option can be used to indicate the client supports
decompression. Because RSS/Atom feeds are textual XML content this generally
compresses very well.
These options can be set by overriding the fetch() function in the sfeedrc
file:
# fetch(name, url, feedfile)
fetch() {
etag="$HOME/.sfeed/etags/$(basename "$3")"
curl \
-L --max-redirs 0 -H "User-Agent:" -f -s -m 15 \
--compressed \
--etag-save "${etag}" --etag-compare "${etag}" \
-z "${etag}" \
"$2" 2>/dev/null
}
These options can come at a cost of some privacy, because it exposes
additional metadata from the previous request.
- - -
CDNs blocking requests due to a missing HTTP User-Agent request header
sfeed_update will not send the "User-Agent" header by default for privacy
reasons. Some CDNs like Cloudflare don't like this and will block such HTTP
requests.
A custom User-Agent can be set by using the curl -H option, like so:
curl -H 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0'
The above example string pretends to be a Windows 10 (x86-64) machine running
Firefox 78.
- - -
Page redirects
For security and efficiency reasons by default redirects are not allowed and
are treated as an error.
For example to prevent hijacking an unencrypted http:// to https:// redirect or
to not add time of an unnecessary page redirect each time. It is encouraged to
use the final redirected URL in the sfeedrc config file.
If you want to ignore this advise you can override the fetch() function in the
sfeedrc file and change the curl options "-L --max-redirs 0".
- - -
Shellscript to update feeds in parallel more efficiently using xargs -P.
It creates a queue of the feeds with its settings, then uses xargs to process
them in parallel using the common, but non-POSIX -P option. This is more
efficient than the more portable solution in sfeed_update which can stall a
batch of $maxjobs in the queue if one item is slow.
sfeed_update_xargs shellscript:
#!/bin/sh
# update feeds, merge with old feeds using xargs in parallel mode (non-POSIX).
# include script and reuse its functions, but do not start main().
SFEED_UPDATE_INCLUDE="1" . sfeed_update
# load config file, sets $config.
loadconfig "$1"
# process a single feed.
# args are: config, tmpdir, name, feedurl, basesiteurl, encoding
if [ "${SFEED_UPDATE_CHILD}" = "1" ]; then
sfeedtmpdir="$2"
_feed "$3" "$4" "$5" "$6"
exit $?
fi
# ...else parent mode:
# feed(name, feedurl, basesiteurl, encoding)
feed() {
# workaround: *BSD xargs doesn't handle empty fields in the middle.
name="${1:-$$}"
feedurl="${2:-http://}"
basesiteurl="${3:-${feedurl}}"
encoding="$4"
printf '%s\0%s\0%s\0%s\0%s\0%s\0' "${config}" "${sfeedtmpdir}" \
"${name}" "${feedurl}" "${basesiteurl}" "${encoding}"
}
# fetch feeds and store in temporary directory.
sfeedtmpdir="$(mktemp -d '/tmp/sfeed_XXXXXX')"
# make sure path exists.
mkdir -p "${sfeedpath}"
# print feeds for parallel processing with xargs.
feeds | SFEED_UPDATE_CHILD="1" xargs -r -0 -P "${maxjobs}" -L 6 "$(readlink -f "$0")"
# cleanup temporary files etc.
cleanup
- - -
Shellscript to export existing newsboat cached items from sqlite3 to the sfeed
TSV format.
#!/bin/sh
# Export newsbeuter/newsboat cached items from sqlite3 to the sfeed TSV format.
# The data is split per file per feed with the name of the newsboat title/url.
# It writes the URLs of the read items line by line to a "urls" file.
#
# Dependencies: sqlite3, awk.
#
# Usage: create some directory to store the feeds, run this script.
#
# Assumes "html" for content-type (Newsboat only handles HTML content).
# Assumes feednames are unique and a feed title is set.
# newsboat cache.db file.
cachefile="$HOME/.newsboat/cache.db"
test -n "$1" && cachefile="$1"
# dump data.
# .mode ascii: Columns/rows delimited by 0x1F and 0x1E
# get the first fields in the order of the sfeed(5) format.
sqlite3 "$cachefile" <<!EOF |
.headers off
.mode ascii
.output
SELECT
i.pubDate, i.title, i.url, i.content, i.guid, i.author,
i.enclosure_url,
f.rssurl AS rssurl, f.title AS feedtitle, i.unread --,
-- i.id, i.enclosure_type, i.enqueued, i.flags, i.deleted,
-- i.base
FROM rss_feed f
INNER JOIN rss_item i ON i.feedurl = f.rssurl
ORDER BY
i.feedurl ASC, i.pubDate DESC;
.quit
!EOF
# convert to sfeed(5) TSV format.
awk '
BEGIN {
FS = "\x1f";
RS = "\x1e";
}
# normal non-content fields.
function field(s) {
gsub("^[[:space:]]*", "", s);
gsub("[[:space:]]*$", "", s);
gsub("[[:space:]]", " ", s);
gsub("[[:cntrl:]]", "", s);
return s;
}
# content field.
function content(s) {
gsub("^[[:space:]]*", "", s);
gsub("[[:space:]]*$", "", s);
# escape chars in content field.
gsub("\\\\", "\\\\", s);
gsub("\n", "\\n", s);
gsub("\t", "\\t", s);
return s;
}
function feedname(url, title) {
gsub("/", "_", title);
return title;
}
{
fname = feedname($8, $9);
if (!feed[fname]++) {
print "Writing file: \"" fname "\" (title: " $9 ", url: " $8 ")" > "/dev/stderr";
}
print $1 "\t" field($2) "\t" field($3) "\t" content($4) "\t" \
"html" "\t" field($5) "\t" field($6) "\t" field($7) \
> fname;
# write URLs of the read items to a file line by line.
if ($10 == "0") {
print $3 > "urls";
}
}'
License
-------
ISC, see LICENSE file.
Author
------
Hiltjo Posthuma <hiltjo@codemadness.org>
|