Re: Dealing with ci.d.n for package regressions

[Chris Lamb <lamby@debian.org>]

Chris Lamb wrote:

> I can hack together quick things like:

I just noticed that UDD has lintian results, so you can just write
this as:

(Spoilers: I'm not a SQL programmer)

   SELECT source, CASE (SELECT COUNT(*) FROM lintian
   WHERE package = source AND package_type = 'source' AND
   tag = 'testsuite-autopkgtest-missing') WHEN 0 THEN 'yes' ELSE
   'no' END AS has_autopkgtests FROM popcon_src ORDER BY insts DESC
   LIMIT 100;
   
         source         | has_autopkgtests
------------------------+------------------
 dpkg                   | no
 sed                    | no
 attr                   | no
 debianutils            | no
 bzip2                  | no
 pam                    | no
 tar                    | no
 coreutils              | no
 acl                    | no
 zlib                   | no
 util-linux             | yes
 ncurses                | no
 shadow                 | no
 base-passwd            | no
 grep                   | yes
 base-files             | no
 gzip                   | no
 findutils              | no
 hostname               | no
 debconf                | no
 e2fsprogs              | no
 apt                    | yes
 perl                   | no
 adduser                | yes
 readline               | no
 readline6              | yes
 lsb                    | no
 netbase                | no
 gnupg2                 | yes
 gnupg                  | yes
 gcc-4.4                | yes
 gcc-6                  | no
 gcc-4.9                | yes
 gcc-8                  | no
 gcc-4.7                | yes
 gcc-7                  | no
 sysvinit               | no
 libgpg-error           | yes
 bash                   | no
 libselinux             | no
 libsepol               | no
 eglibc                 | yes
 glibc                  | yes
 slang2                 | no
 procps                 | no
 popt                   | no
 tzdata                 | no
 debian-archive-keyring | no
 cpio                   | no
 ucf                    | no
 bsdmainutils           | no
 liblocale-gettext-perl | yes
 logrotate              | no
 libedit                | no
 libtext-iconv-perl     | no
 wget                   | no
 popularity-contest     | no
 pcre3                  | no
 mawk                   | no
 expat                  | no
 newt                   | no
 cron                   | no
 tcp-wrappers           | no
 iputils                | no
 libidn                 | no
 sqlite3                | no
 libtext-charwidth-perl | no
 systemd                | yes
 udev                   | yes
 libtext-wrapi18n-perl  | no
 openssh                | yes
 iptables               | yes
 ifupdown               | yes
 keyutils               | yes
 gettext                | no
 lvm2                   | no
 freetype               | no
 klibc                  | no
 cyrus-sasl2            | no
 pciutils               | no
 libcap2                | yes
 vim                    | yes
 libxml2                | yes
 libusb                 | no
 libxdmcp               | no
 libxau                 | no
 initramfs-tools        | no
 openssl                | no
 dmidecode              | no
 libx11                 | no
 file                   | no
 mime-support           | no
 openldap               | no
 libxcb                 | yes
 python-defaults        | no
 groff                  | no
 gdbm                   | no
 libxext                | no
 busybox                | no
 dash                   | yes
(100 rows)


Regards,

-- 
      ,''`.
     : :'  :     Chris Lamb
     `. `'`      lamby@debian.org / chris-lamb.co.uk
       `-