Path: ...!news.misty.com!weretis.net!feeder9.news.weretis.net!newsfeed.endofthelinebbs.com!.POSTED.47.186.0.68!not-for-mail
From: Nigel Reed <sysop@endofthelinebbs.com>
Newsgroups: news.software.nntp
Subject: Re: Interacting with cnfs
Date: Sun, 14 Jul 2024 23:44:02 -0500
Organization: End Of The Line BBS
Message-ID: <20240714234402.7af1802d@wibble.sysadmininc.com>
References: <20240705023621.62cd4083@wibble.sysadmininc.com>
	<v6vu2b$nssu$1@news.trigofacile.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Injection-Info: newsfeed.endofthelinebbs.com; posting-host="47.186.0.68";
	logging-data="290807"; mail-complaints-to="abuse@endofthelinebbs.com"
X-Newsreader: Claws Mail 4.2.0git6 (GTK 3.24.33; x86_64-pc-linux-gnu)
Bytes: 3126
Lines: 60

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

> Hi Nigel,
>=20
> > 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.
> >=20
> > 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. =20
>=20
> You can use overview information to get the number of articles in a=20
> newsgroup.
>=20
> % getlist -R counts
> news.software.nntp 17619 1 13223 y
>=20
> gives you a list of newsgroups containing the information (13223=20
> 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.
>=20
> How many articles have been added since the last run is not=20
> 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.
>=20
> Use tdx-util or ovsqlite-util for that, assuming you have a
> tradindexed or ovsqlite overview.
>=20
> 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:
>=20
> % ovsqlite-util -g -n news.software.nntp -a 17620- | wc -l
> 0
>=20
>=20
> Incidentally, you may also use tdx-util or ovsqlite-util instead of=20
> "getlist -R counts" for the counts:
>=20
> % ovsqlite-util -i -n news.software.nntp
> news.software.nntp 17619 1 13223 y 1720923358 0
>=20
>=20
> 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.

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