Hi Ben,

On 21/08/24 at 00:40 +0200, Ben Tris wrote:
> Package: qa.debian.org
> Followup-For: Bug #1079070
> X-Debbugs-Cc: benatt...@gezapig.nl
> 
> Dear Maintainer,
> 
> No, I'm not a developer.
> 
> I just want to see all info like:
> 
> upstream-metadata (classification)
> data-tarball-compression-format (classification)
> mail-contact (classification)
> vcs-uri (classification)
> 
> 
> Of those I think mail-contact had the most rows, before changes were made.
> This was probably the one with the most rows: hardening-no-bindnow
> (information)
> There was no problem with those.
> 
> A limit after the number of rows of mail-contact is probably good enough for
> me.
> 
> At this moment this limit of 5000 rows affects at least 92 tags.

If you are trying to mass-process lintian results, you should probably
use the SQL interface instead, as documented on
https://udd-mirror.debian.net/

To get the results for the 'mail-contact' tag, you could use:
select source, version, package, package_version, architectures::text[] 
architectures, tag_type, tag, information, lintian_version, count
FROM lintian_results_agg
WHERE tag = 'mail-contact'
ORDER BY 1,2,3,4,6,7

Lucas

Reply via email to