On Wed, Jun 5, 2013 at 4:39 PM, Reinhard Tartler <[email protected]> wrote: > On Wed, Jun 5, 2013 at 7:28 PM, Felipe Sateler <[email protected]> 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 = '[email protected]' 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 _______________________________________________ pkg-multimedia-maintainers mailing list [email protected] http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-multimedia-maintainers
