[Sqlgrey-users] Problem with count-subroutines

[Michael S. <Mic...@lr...>]

Hi Lionel and Dan,

since every record in connect and the AWLs has an (implizit)
expiration/purge-date, all routines, which check if a record is in one of
the tables, construct the select-statement in a way that expired records
are not found:

last_seen > $self->past_tstamp($self->{sqlgrey}{awl_age},'DAY')

However, this is not the case with all of the count subroutines, though
they are semantically and syntactically nearly identical.

Correct are:

- is_in_from_awl
- is_in_domain_awl
- in_connect
- recently_in_connect

Wrong are:

- count_from_awl
- count_src_domain_awl
- count_src_from_awl
- count_src_connect

Maybe correct, even without checking expiration ???:

- get_first_seen_in_from_awl
- get_reconnect_delay


Michael Storz
--
======================================================
Leibniz-Rechenzentrum      |    <mailto:St...@lr...>
Boltzmannstr. 1            |    Fax: +49 89 35831-9700
85748 Garching / Germany   |    Tel: +49 89 35831-8840
======================================================