Enforcing the 2nd maintainer rule, was: Bug#444368: ITP: dvd95 -- DVD9 to DVD5 converter

[Felipe Sateler]

On Wed, Jun 5, 2013 at 4:39 PM, Reinhard Tartler <siretart at gmail.com> wrote:
> On Wed, Jun 5, 2013 at 7:28 PM, Felipe Sateler <fsateler at debian.org> wrote:

>> Then, have a daily cron job scan the archive for packages maintained
>> by the team, and flag packages with less than 2 uploaders older than N
>> days. Send the resulting list to the team list.
>>
>> If nobody wants to help comaintain a package for M days, the package
>> should be moved to collab-maint or some other area.
>>
>> The principle is similar to the wnpp mails sent to -devel.
>
> I find this a very interesting idea and would welcome its
> implementation with or without enforcing the 2nd maintainer rule!

We seem to have 177 violations of the rule :s.

I've used udd to get the results (script below), I'll improve this so
we can get the date, and then we can use alioth to send the emails.

with
 duploaders AS (
  select distinct source, version, name
  from uploaders
 ),
 latest AS (
 select source, max(version) as version
 from sources
 where maintainer_email = 'pkg-multimedia-maintainers at lists.alioth.debian.org'
 group by source
 ),
 violators AS (
 select latest.source, latest.version
 from latest
 inner join duploaders
  on latest.source = duploaders.source AND latest.version = duploaders.version
 group by latest.source, latest.version
 having count(duploaders.name) < 2
 )

select violators.source, duploaders.name as uploader
from violators
inner join duploaders
 on violators.source = duploaders.source AND violators.version =
duploaders.version
 order by source
;


--

Saludos,
Felipe Sateler