Re: Interacting with cnfs

On Sun, 14 Jul 2024 09:17:31 +0200
Julien ÉLIE <iulius@nom-de-mon-site.com.invalid> wrote:

Hi Nigel,
 

I was thinking about a report I did for my older server, which used
the tradspool storage method, and that was to count how many
articles are in a group and list how many new articles have been
added since last run.
 
I can't see a way to make this happen using cnfs without pulling the
storage token using a similar method as 6.4 in the FAQ and then
manually parsing the newsgroups line from each article. 

 
You can use overview information to get the number of articles in a
newsgroup.
 
% getlist -R counts
news.software.nntp 17619 1 13223 y
 
gives you a list of newsgroups containing the information (13223
articles in news.software.nntp, between article numbers 1 and 17619).
For accurate results, see the groupexactcount setting in
readers.conf. You may want to set it to 0 for connections coming from
localhost or whichever server running your command.
 
How many articles have been added since the last run is not
straight-forward though...  You have to somehow record the latest
high water marks for each newsgroup, and see how many articles have a
greater article number than these recorded high water marks.
 
Use tdx-util or ovsqlite-util for that, assuming you have a
tradindexed or ovsqlite overview.
 
For instance, assuming I have recorded that the latest highest
article number for news.software.nntp was 17619, I get the number of
new articles with the following command:
 
% ovsqlite-util -g -n news.software.nntp -a 17620- | wc -l
0
 
 
Incidentally, you may also use tdx-util or ovsqlite-util instead of
"getlist -R counts" for the counts:
 
% ovsqlite-util -i -n news.software.nntp
news.software.nntp 17619 1 13223 y 1720923358 0
 
 
I hope this could help.
>

All good information, thank you. this is something that I would run
nightly so I would just need to subtract the previous nights values to
get the number of new articles per group. I'll give it a try tomorrow.
Thanks.

--
End Of The Line BBS - Plano, TX
telnet endofthelinebbs.com 23