Bug#1016059: DDPO,Package Tracking System: move to UDD as a data source for lintian?

2022-07-26 Thread Mattia Rizzolo
On Tue, Jul 26, 2022 at 09:50:50PM +0200, Lucas Nussbaum wrote:
> On 26/07/22 at 17:24 +0200, Mattia Rizzolo wrote:
> > > https://udd.debian.org/lintian/?dpkg , which DDPO and PTS could use as a
> > > link target.
> > 
> > Probably, I'll keep it for the future for now.
> > However, may I suggest you make it use a proper querystring instead?
> > Like, ?pkg=dpkg, so that it'll be extensible in the future if one wants.
> 
> https://udd.debian.org/lintian/?packages=dpkg also works

Great, so I'll go with that!

> Regarding your comment on IRC:
> > btw, I consider udd.d.o/lintian/ slow, IMHO.  if you could see if some 
> > tuning could be done, that would likely be appreciated.
> 
> The postgresql optimizer was doing something strange with a temporary
> table. Fixed.

Much better, thank you!

> Also, this looks wrong:
> https://salsa.debian.org/qa/qa/-/commit/6eb803b9965a1d97b2dd5eed4da22fc69124d3f0#cbc3b83fa697117813ee1ea10081d209b6d42d4f_1080_1079
> (missing '?' before the source package name)

And thank you for spotting this as well… :|

I manually deployed the change, and it looks good to me now ;)

-- 
regards,
Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
More about me:  https://mapreri.org : :'  :
Launchpad user: https://launchpad.net/~mapreri  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-


signature.asc
Description: PGP signature


Bug#1016059: DDPO,Package Tracking System: move to UDD as a data source for lintian?

2022-07-26 Thread Lucas Nussbaum
On 26/07/22 at 17:24 +0200, Mattia Rizzolo wrote:
> > https://udd.debian.org/lintian/?dpkg , which DDPO and PTS could use as a
> > link target.
> 
> Probably, I'll keep it for the future for now.
> However, may I suggest you make it use a proper querystring instead?
> Like, ?pkg=dpkg, so that it'll be extensible in the future if one wants.

https://udd.debian.org/lintian/?packages=dpkg also works

Regarding your comment on IRC:
> btw, I consider udd.d.o/lintian/ slow, IMHO.  if you could see if some tuning 
> could be done, that would likely be appreciated.

The postgresql optimizer was doing something strange with a temporary
table. Fixed.

Also, this looks wrong:
https://salsa.debian.org/qa/qa/-/commit/6eb803b9965a1d97b2dd5eed4da22fc69124d3f0#cbc3b83fa697117813ee1ea10081d209b6d42d4f_1080_1079
(missing '?' before the source package name)

Lucas



Bug#1016059: DDPO,Package Tracking System: move to UDD as a data source for lintian?

2022-07-26 Thread Mattia Rizzolo
Control: clone -1 -2
Control: reassign -2 tracker.debian.org

On Tue, Jul 26, 2022 at 11:39:45AM +0200, Lucas Nussbaum wrote:
> Package: qa.debian.org

cloning a copy for tracker.  I'll do ddpo rsn!

> UDD now has its own importer for lintian data. It also provides a

Thank you for working on it!


> https://udd.debian.org/lintian/?dpkg , which DDPO and PTS could use as a
> link target.

Probably, I'll keep it for the future for now.
However, may I suggest you make it use a proper querystring instead?
Like, ?pkg=dpkg, so that it'll be extensible in the future if one wants.

> I suggest that DDPO and PTS move to using UDD as a data source for
> lintian.
> 
> https://udd.debian.org/lintian-qa-list.txt is refreshed on a regular
> basis while the importer is running. So DDPO/PTS can sync for example
> hourly.

Great.

> Minor caveat: the semantic for qa-list.txt was a bit poor:
> 1) for packages both in unstable and experimental, lintian-qa-list.txt
> show stats for packages in unstable.

That's fair.

> 3) it does not provide a column for tags of type 'information'.
> I suppose it is OK to keep it like that.

DDPO only uses errors and warning, so no interest in that.

-- 
regards,
Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
More about me:  https://mapreri.org : :'  :
Launchpad user: https://launchpad.net/~mapreri  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-


signature.asc
Description: PGP signature


Bug#1016059: DDPO,Package Tracking System: move to UDD as a data source for lintian?

2022-07-26 Thread Lucas Nussbaum
Package: qa.debian.org
Severity: normal

Hi,

lintian.debian.org has been out of date since end of 2021. The question
of its future has been raised with DSA:
https://lists.debian.org/debian-qa/2022/07/msg6.html

UDD now has its own importer for lintian data. It also provides a
drop-in replacement for https://lintian.debian.org/static/qa-list.txt as
https://udd.debian.org/lintian-qa-list.txt, and a web interface to view
detailed results per package at (e.g.)
https://udd.debian.org/lintian/?dpkg , which DDPO and PTS could use as a
link target.

I suggest that DDPO and PTS move to using UDD as a data source for
lintian.

https://udd.debian.org/lintian-qa-list.txt is refreshed on a regular
basis while the importer is running. So DDPO/PTS can sync for example
hourly.

Minor caveat: the semantic for qa-list.txt was a bit poor:
1) for packages both in unstable and experimental, lintian-qa-list.txt
show stats for packages in unstable.
2) packages not in unstable are not listed.
3) it does not provide a column for tags of type 'information'.
I suppose it is OK to keep it like that.

For reference, the UDD code the generate the data is
https://salsa.debian.org/qa/udd/-/blob/master/rimporters/lintian.rb#L380

Lucas