From 9df65bfdac97c55243fed52791dd5e68736b1773 Mon Sep 17 00:00:00 2001 From: Ansgar Burchardt Date: Fri, 14 Aug 2015 11:10:47 +0200 Subject: [PATCH] Use changes table to include historic data. Requested-by: Enrico Zini --- config/debian/contributor.source | 23 +++++++++++------------ 1 file changed, 11 insertions(+), 12 deletions(-) diff --git a/config/debian/contributor.source b/config/debian/contributor.source index c801d1fd..67982c21 100644 --- a/config/debian/contributor.source +++ b/config/debian/contributor.source @@ -2,21 +2,20 @@ contribution: upload method: postgres db: service=projectb query: - SELECT s.install_date as date, - u.uid as id, - u.name as desc - FROM source s - JOIN fingerprint f ON s.sig_fpr = f.id - JOIN uid u ON f.uid = u.id -url: https://qa.debian.org/developer.php?login={id}&comaint=yes + SELECT fingerprint AS id, + SUBSTRING(fingerprint FROM 40-7) AS key_id, + seen AS date + FROM changes + WHERE architecture LIKE '%source%' + ORDER BY seen DESC +url: https://qa.debian.org/developer.php?login={key_id}&comaint=yes contribution: maint method: postgres db: service=projectb query: - SELECT s.install_date as date, - c.name as id - FROM source s - JOIN maintainer c ON s.changedby = c.id + SELECT changedby AS id, + seen AS date + FROM changes + WHERE architecture LIKE '%source%' url: https://qa.debian.org/developer.php?login={id}&comaint=yes - -- 2.39.2