[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Prototype script to determine last commit and last upload.



On Sat, Apr 10, 2010 at 10:45:37PM +0200, Niels Thykier wrote:
> Paul Wise wrote:
> > On Sat, Apr 10, 2010 at 1:29 AM, Mehdi Dogguy <mehdi@dogguy.org> wrote:
> >> Niels Thykier wrote:
> >>> The second script[3] we made was a script to determine the last upload
> >>> by  parsing the changelog of packages and look for an email in the
> >>> signature line.
> >> How is it different from who-uploads (from devscripts)?
> > 
> > who-uploads looks at GPG signatures, not changelog signature lines.
> > 
> 
> And that it answers the question "last-upload-by" $name, rather than
> "who-uploads" $package.
> 
> This information may be available on uploads by DD uploaders via the mia
> check scripts; but I am not aware of anything available to non-DDs and
> nothing that works on uploads by non-DDs.

I didn't look at the scripts at all but UDD might have a faster answer
to that question:

,----
| select date, source, version, changed_by
| from upload_history
| where changed_by_email = $email
| order by date desc limit 20;
`----

Maybe I'm wrong, I just remembered this query that I wrote a few weeks
ago.

Hauke

Attachment: signature.asc
Description: Digital signature


Reply to: