On Mon, Mar 29, 2010 at 2:06 AM, Pierre Schmitz <pierre@archlinux.de> wrote:
Am Montag, 29. März 2010 00:01:03 schrieb Dan McGee:
Let me (and the list) know if you have any questions.
Thanks for your work! Just one suggestion: Would it be possible to chagne the pacakge list view on the dev site to just operate on pkgbase and ignore the different pkgnames and architectures? This would managing package assignments and orphans a lot easier.
Agreed, I'll keep that in mind as I work on the website in the coming weeks. Until then, here is that magic list. mysql> select count(*), r.name, p.pkgbase, username from packages p left join repos r on p.repo_id = r.id left join packages_packagerelation pr on p.pkgbase = pr.pkgbase left join auth_user u on pr.user_id = u.id where username is NULL and p.repo_id in (1,2) group by r.name, p.pkgbase, username order by r.name, p.pkgbase, count(*); +----------+-------+------------------------------------+----------+ | count(*) | name | pkgbase | username | +----------+-------+------------------------------------+----------+ | 2 | Core | bridge-utils | NULL | | 1 | Core | filesystem | NULL | | 1 | Core | ipw2100-fw | NULL | | 1 | Core | ipw2200-fw | NULL | | 1 | Core | iwlwifi-3945-ucode | NULL | | 1 | Core | iwlwifi-4965-ucode | NULL | | 1 | Core | iwlwifi-5000-ucode | NULL | | 1 | Core | iwlwifi-5150-ucode | NULL | | 2 | Core | libevent | NULL | | 2 | Core | libgssglue | NULL | | 2 | Core | libsasl | NULL | | 2 | Core | libtirpc | NULL | | 1 | Core | netcfg | NULL | | 2 | Core | rfkill | NULL | | 1 | Core | rt2x00-rt61-fw | NULL | | 1 | Core | rt2x00-rt71w-fw | NULL | | 1 | Core | tiacx-firmware | NULL | | 1 | Core | wireless-regdb | NULL | | 1 | Core | zd1211-firmware | NULL | | 2 | Extra | 3ddesktop | NULL | | 2 | Extra | aalib | NULL | | 2 | Extra | abuse | NULL | | 2 | Extra | acct | NULL | | 1 | Extra | acidrip | NULL | | 2 | Extra | afterstep | NULL | | 2 | Extra | agg | NULL | | 1 | Extra | aif | NULL | | 2 | Extra | alltray | NULL | | 2 | Extra | anthy | NULL | | 2 | Extra | apollon | NULL | | 2 | Extra | arch | NULL | | 1 | Extra | archlinux-artwork | NULL | | 2 | Extra | arj | NULL | | 2 | Extra | at | NULL | | 2 | Extra | aubio | NULL | | 2 | Extra | audacious | NULL | | 2 | Extra | audacious-plugins | NULL | | 2 | Extra | aufs2 | NULL | | 1 | Extra | autoconf2.13 | NULL | | 2 | Extra | autofs | NULL | | 2 | Extra | avahi | NULL | | 2 | Extra | bc | NULL | | 2 | Extra | beep | NULL | | 2 | Extra | bigloo | NULL | | 2 | Extra | biogrep | NULL | | 2 | Extra | biopython | NULL | | 2 | Extra | bitlbee | NULL | | 2 | Extra | bittorrent | NULL | | 2 | Extra | blassic | NULL | | 2 | Extra | bomberclone | NULL | | 2 | Extra | bonnie++ | NULL | | 1 | Extra | bootchart | NULL | | 2 | Extra | botan | NULL | | 2 | Extra | brltty | NULL | | 2 | Extra | btrfs-progs-unstable | NULL | | 2 | Extra | c-ares | NULL | | 2 | Extra | came | NULL | | 2 | Extra | ccrtp | NULL | | 2 | Extra | ccscript3 | NULL | | 2 | Extra | cdcd | NULL | | 1 | Extra | cddb_get | NULL | | 2 | Extra | cdlabelgen | NULL | | 4 | Extra | cdrdao | NULL | | 2 | Extra | cdrkit | NULL | | 2 | Extra | cdtool | NULL | | 2 | Extra | cegui | NULL | | 2 | Extra | centerim | NULL | | 2 | Extra | cfitsio | NULL | | 2 | Extra | clamav | NULL | | 2 | Extra | cmt | NULL | | 2 | Extra | colortail | NULL | | 2 | Extra | corewars | NULL | | 2 | Extra | cpudyn | NULL | | 2 | Extra | cpufreqd | NULL | | 2 | Extra | crimson | NULL | | 2 | Extra | cssed | NULL | | 1 | Extra | culmus | NULL | | 2 | Extra | cvs | NULL | | 2 | Extra | cvsps | NULL | | 2 | Extra | cx_freeze | NULL | | 2 | Extra | cyrus-sasl | NULL | | 2 | Extra | cyrus-sasl-plugins | NULL | | 2 | Extra | dbh | NULL | | 2 | Extra | devil | NULL | | 2 | Extra | dia | NULL | | 1 | Extra | ding | NULL | | 2 | Extra | distcc | NULL | | 2 | Extra | django | NULL | | 1 | Extra | docbook-xsl | NULL | | 2 | Extra | dssi | NULL | | 2 | Extra | dvdbackup | NULL | | 2 | Extra | eboard | NULL | | 2 | Extra | ed2k-gtk-gui | NULL | | 1 | Extra | eigen | NULL | | 2 | Extra | eject | NULL | | 2 | Extra | elinks | NULL | | 2 | Extra | enigma | NULL | | 2 | Extra | etherape | NULL | | 2 | Extra | ethstatus | NULL | | 2 | Extra | evms | NULL | | 2 | Extra | fastjar | NULL | | 2 | Extra | fcgi | NULL | | 2 | Extra | fcitx | NULL | | 2 | Extra | feh | NULL | | 2 | Extra | festival | NULL | | 1 | Extra | festival-awb-arctic | NULL | | 1 | Extra | festival-don | NULL | | 1 | Extra | festival-kallpc16k | NULL | | 1 | Extra | festival-rablpc16k | NULL | | 2 | Extra | fftw2 | NULL | | 2 | Extra | figlet | NULL | | 2 | Extra | flite | NULL | | 2 | Extra | fluidsynth | NULL | | 1 | Extra | font-bh-ttf | NULL | | 2 | Extra | fox | NULL | | 2 | Extra | fsarchiver | NULL | | 2 | Extra | gcal | NULL | | 2 | Extra | gcin | NULL | | 2 | Extra | gcombust | NULL | | 2 | Extra | gdeskcal | NULL | | 2 | Extra | gdesklets | NULL | | 2 | Extra | gdk-pixbuf | NULL | | 2 | Extra | gdome2 | NULL | | 2 | Extra | gift | NULL | | 2 | Extra | gift-fasttrack | NULL | | 2 | Extra | gift-gnutella | NULL | | 2 | Extra | gift-openft | NULL | | 2 | Extra | gimp-fourier | NULL | | 2 | Extra | glabels | NULL | | 2 | Extra | glade | NULL | | 2 | Extra | glew | NULL | | 2 | Extra | gmencoder | NULL | | 2 | Extra | gmpc | NULL | | 2 | Extra | gnash-common | NULL | | 2 | Extra | gnash-gtk | NULL | | 1 | Extra | gnome-blog | NULL | | 2 | Extra | gnomeicu | NULL | | 2 | Extra | gnugo | NULL | | 2 | Extra | gocr | NULL | | 2 | Extra | gpart | NULL | | 2 | Extra | gperf | NULL | | 2 | Extra | graveman | NULL | | 1 | Extra | gsfonts | NULL | | 2 | Extra | gtick | NULL | | 2 | Extra | gtk-smooth-engine | NULL | | 2 | Extra | gtk-vnc | NULL | | 2 | Extra | gtkam | NULL | | 2 | Extra | gtkglarea | NULL | | 2 | Extra | gtklp | NULL | | 2 | Extra | gtkterm | NULL | | 2 | Extra | gweled | NULL | | 2 | Extra | gxine | NULL | | 2 | Extra | haskell-mtl | NULL | | 2 | Extra | haskell-network | NULL | | 2 | Extra | haskell-packedstring | NULL | | 2 | Extra | haskell-regex-compat | NULL | | 2 | Extra | hdf5 | NULL | | 2 | Extra | hdup | NULL | | 2 | Extra | hexcurse | NULL | | 2 | Extra | hping | NULL | | 1 | Extra | hsqldb-java | NULL | | 1 | Extra | httplib2 | NULL | | 2 | Extra | httptunnel | NULL | | 2 | Extra | httrack | NULL | | 2 | Extra | hugs98 | NULL | | 2 | Extra | icmake | NULL | | 2 | Extra | id3lib | NULL | | 2 | Extra | ilmbase | NULL | | 2 | Extra | imap | NULL | | 2 | Extra | imwheel | NULL | | 2 | Extra | iptraf | NULL | | 2 | Extra | ipvsadm | NULL | | 2 | Extra | irda-utils | NULL | | 1 | Extra | itext | NULL | | 2 | Extra | jack | NULL | | 2 | Extra | jade | NULL | | 2 | Extra | jed | NULL | | 2 | Extra | joe | NULL | | 2 | Extra | john | NULL | | 2 | Extra | jpilot | NULL | | 2 | Extra | junit | NULL | | 2 | Extra | kdelibs3 | NULL | | 1 | Extra | koffice-l10n-fy | NULL | | 1 | Extra | koffice-l10n-hne | NULL | | 1 | Extra | koffice-l10n-wa | NULL | | 2 | Extra | ladspa | NULL | | 2 | Extra | lesstifextensions | NULL | | 2 | Extra | libchewing | NULL | | 2 | Extra | libdvdcss | NULL | | 2 | Extra | libdvdnav | NULL | | 2 | Extra | libdvdread | NULL | | 2 | Extra | libexif-gtk | NULL | | 2 | Extra | libffi | NULL | | 2 | Extra | libflashsupport | NULL | | 2 | Extra | libftdi | NULL | | 2 | Extra | libhangul | NULL | | 2 | Extra | libieee1284 | NULL | | 2 | Extra | libixp | NULL | | 2 | Extra | liblo | NULL | | 2 | Extra | liblqr | NULL | | 2 | Extra | libmad | NULL | | 2 | Extra | libmal | NULL | | 2 | Extra | libmcs | NULL | | 2 | Extra | libmodplug | NULL | | 2 | Extra | libmowgli | NULL | | 2 | Extra | libmp4v2 | NULL | | 2 | Extra | libmusepack | NULL | | 2 | Extra | libnet | NULL | | 2 | Extra | libnids | NULL | | 2 | Extra | libnjb | NULL | | 2 | Extra | libotf | NULL | | 2 | Extra | libots | NULL | | 2 | Extra | libpqxx | NULL | | 2 | Extra | libproxy | NULL | | 2 | Extra | libsexymm | NULL | | 2 | Extra | libticonv | NULL | | 1 | Extra | libui-sh | NULL | | 2 | Extra | libvisual-projectm | NULL | | 2 | Extra | libzip | NULL | | 2 | Extra | libzrtpcpp | NULL | | 2 | Extra | lincity | NULL | | 2 | Extra | linuxdcpp | NULL | | 2 | Extra | linux_logo | NULL | | 2 | Extra | lsof | NULL | | 2 | Extra | ltrace | NULL | | 2 | Extra | lua | NULL | | 2 | Extra | luola | NULL | | 2 | Extra | lxsplit | NULL | | 2 | Extra | lynx | NULL | | 2 | Extra | lzo | NULL | | 2 | Extra | m17n-db | NULL | | 2 | Extra | m17n-lib | NULL | | 2 | Extra | mailman | NULL | | 2 | Extra | mcrypt | NULL | | 1 | Extra | memtest86+ | NULL | | 2 | Extra | mhash | NULL | | 2 | Extra | mime-types | NULL | | 2 | Extra | mod_fastcgi | NULL | | 2 | Extra | mod_fcgid | NULL | | 2 | Extra | mod_python | NULL | | 2 | Extra | mod_wsgi | NULL | | 2 | Extra | monotone | NULL | | 2 | Extra | moon-buggy | NULL | | 2 | Extra | moon-lander | NULL | | 2 | Extra | most | NULL | | 2 | Extra | motion | NULL | | 2 | Extra | mp3blaster | NULL | | 2 | Extra | mrxvt | NULL | | 2 | Extra | mtr | NULL | | 2 | Extra | muse | NULL | | 1 | Extra | namcap | NULL | | 2 | Extra | ne | NULL | | 2 | Extra | netkit-bsd-finger | NULL | | 2 | Extra | netpbm | NULL | | 2 | Extra | netselect | NULL | | 2 | Extra | nilfs-utils | NULL | | 2 | Extra | nss-mdns | NULL | | 2 | Extra | nss_ldap | NULL | | 2 | Extra | ntop | NULL | | 2 | Extra | nvclock | NULL | | 2 | Extra | opencv | NULL | | 2 | Extra | opengtl | NULL | | 2 | Extra | opensp | NULL | | 2 | Extra | oxygen-icons | NULL | | 2 | Extra | pacbuild | NULL | | 2 | Extra | pal | NULL | | 2 | Extra | pam_ldap | NULL | | 2 | Extra | patchutils | NULL | | 2 | Extra | pebrot | NULL | | 1 | Extra | perl-appconfig | NULL | | 1 | Extra | perl-carp-clan | NULL | | 1 | Extra | perl-date-calc | NULL | | 1 | Extra | perl-file-desktopentry | NULL | | 1 | Extra | perl-file-tail | NULL | | 1 | Extra | perl-html-template | NULL | | 1 | Extra | perl-io-socket-ssl | NULL | | 1 | Extra | perl-libwww | NULL | | 1 | Extra | perl-log-log4perl | NULL | | 2 | Extra | perl-mail-spf | NULL | | 2 | Extra | perl-mail-spf-query | NULL | | 1 | Extra | perl-mime-lite | NULL | | 1 | Extra | perl-mime-types | NULL | | 2 | Extra | perl-net-dns-resolver-programmable | NULL | | 1 | Extra | perl-net-server | NULL | | 1 | Extra | perl-yaml | NULL | | 2 | Extra | pinball | NULL | | 1 | Extra | pkgstats | NULL | | 2 | Extra | planner | NULL | | 2 | Extra | potrace | NULL | | 2 | Extra | povray | NULL | | 2 | Extra | prelink | NULL | | 2 | Extra | privoxy | NULL | | 2 | Extra | projectm | NULL | | 2 | Extra | pure-ftpd | NULL | | 2 | Extra | putty | NULL | | 1 | Extra | pylint | NULL | | 2 | Extra | pyqt3 | NULL | | 2 | Extra | python-cheetah | NULL | | 2 | Extra | python-egenix-mx-base | NULL | | 2 | Extra | python-eyed3 | NULL | | 2 | Extra | python-formencode | NULL | | 1 | Extra | python-gdata | NULL | | 2 | Extra | python-geoip | NULL | | 1 | Extra | python-logilab-astng | NULL | | 1 | Extra | python-logilab-common | NULL | | 2 | Extra | python-m2crypto | NULL | | 2 | Extra | python-mpd | NULL | | 2 | Extra | python-nose | NULL | | 2 | Extra | python-notify | NULL | | 2 | Extra | python-numeric | NULL | | 2 | Extra | python-numpy | NULL | | 1 | Extra | python-opengl | NULL | | 2 | Extra | python-pygame | NULL | | 2 | Extra | python-pysqlite | NULL | | 2 | Extra | python-qscintilla | NULL | | 1 | Extra | python-sqlobject | NULL | | 2 | Extra | python-vpython | NULL | | 2 | Extra | pyvorbis | NULL | | 2 | Extra | pyxml | NULL | | 2 | Extra | qgit | NULL | | 2 | Extra | qjackctl | NULL | | 2 | Extra | qof | NULL | | 2 | Extra | qscintilla-qt3 | NULL | | 2 | Extra | qstat | NULL | | 2 | Extra | qsynth | NULL | | 2 | Extra | qt3 | NULL | | 2 | Extra | qt3-doc | NULL | | 2 | Extra | quilt | NULL | | 2 | Extra | razor | NULL | | 2 | Extra | rbldnsd | NULL | | 2 | Extra | rcs | NULL | | 2 | Extra | re2c | NULL | | 2 | Extra | recode | NULL | | 2 | Extra | rep-gtk | NULL | | 2 | Extra | revelation | NULL | | 2 | Extra | rockdodger | NULL | | 2 | Extra | root-tail | NULL | | 2 | Extra | rosegarden | NULL | | 2 | Extra | rpmunpack | NULL | | 2 | Extra | rssh | NULL | | 4 | Extra | ruby | NULL | | 2 | Extra | sawfish | NULL | | 2 | Extra | sbackup | NULL | | 2 | Extra | schedtool | NULL | | 2 | Extra | scim | NULL | | 2 | Extra | scim-anthy | NULL | | 2 | Extra | scim-chewing | NULL | | 2 | Extra | scim-hangul | NULL | | 2 | Extra | scim-m17n | NULL | | 2 | Extra | scim-pinyin | NULL | | 2 | Extra | scim-tables | NULL | | 2 | Extra | scim-uim | NULL | | 2 | Extra | scons | NULL | | 2 | Extra | screem | NULL | | 2 | Extra | setuptools | NULL | | 2 | Extra | sg3_utils | NULL | | 2 | Extra | sharutils | NULL | | 2 | Extra | slib | NULL | | 1 | Extra | slmodem | NULL | | 1 | Extra | slmodem-utils | NULL | | 2 | Extra | smc | NULL | | 2 | Extra | smtpprox | NULL | | 2 | Extra | snarf | NULL | | 2 | Extra | snd | NULL | | 2 | Extra | snes9x | NULL | | 2 | Extra | socat | NULL | | 2 | Extra | sox | NULL | | 2 | Extra | spamassassin-spamc | NULL | | 2 | Extra | spidermonkey | NULL | | 2 | Extra | squashfs-tools | NULL | | 2 | Extra | ssmtp | NULL | | 2 | Extra | stardict | NULL | | 2 | Extra | swatch | NULL | | 2 | Extra | sweep | NULL | | 2 | Extra | swh-plugins | NULL | | 2 | Extra | swi-prolog | NULL | | 2 | Extra | swig | NULL | | 2 | Extra | swt | NULL | | 2 | Extra | sylpheed | NULL | | 2 | Extra | synergy | NULL | | 2 | Extra | talloc | NULL | | 2 | Extra | tcdr | NULL | | 2 | Extra | tcptraceroute | NULL | | 2 | Extra | texi2html | NULL | | 2 | Extra | thttpd | NULL | | 2 | Extra | tin | NULL | | 2 | Extra | tomboy | NULL | | 2 | Extra | tomcat | NULL | | 2 | Extra | tor | NULL | | 2 | Extra | tpb | NULL | | 2 | Extra | transcode | NULL | | 2 | Extra | transset | NULL | | 2 | Extra | trayer | NULL | | 2 | Extra | tsocks | NULL | | 1 | Extra | ttf-arphic-ukai | NULL | | 2 | Extra | ttf-arphic-uming | NULL | | 2 | Extra | ttf-fireflysung | NULL | | 2 | Extra | ttf-freebanglafont | NULL | | 1 | Extra | ttf-freefont | NULL | | 2 | Extra | ttf-indic-otf | NULL | | 2 | Extra | ttf-isabella | NULL | | 1 | Extra | ttf-junicode | NULL | | 1 | Extra | ttf-khmer | NULL | | 2 | Extra | ttf-linux-libertine | NULL | | 2 | Extra | ttf-mph-2b-damase | NULL | | 1 | Extra | ttf-thai | NULL | | 2 | Extra | ttf-tibetan-machine | NULL | | 2 | Extra | ttf-ubraille | NULL | | 2 | Extra | twinkle | NULL | | 2 | Extra | uim | NULL | | 2 | Extra | uml_utilities | NULL | | 2 | Extra | unarj | NULL | | 2 | Extra | unixodbc | NULL | | 2 | Extra | v86d | NULL | | 2 | Extra | vacation | NULL | | 2 | Extra | valkyrie | NULL | | 2 | Extra | vconfig | NULL | | 2 | Extra | viewglob | NULL | | 1 | Extra | vim-buftabs | NULL | | 2 | Extra | virtuoso | NULL | | 2 | Extra | vnc | NULL | | 2 | Extra | w3m | NULL | | 2 | Extra | webalizer | NULL | | 1 | Extra | wine | NULL | | 2 | Extra | wipe | NULL | | 2 | Extra | wireshark | NULL | | 2 | Extra | wmii | NULL | | 2 | Extra | wmix | NULL | | 2 | Extra | words | NULL | | 2 | Extra | worker | NULL | | 2 | Extra | wpa_supplicant_gui | NULL | | 2 | Extra | wput | NULL | | 2 | Extra | wvdial | NULL | | 2 | Extra | wvstreams | NULL | | 2 | Extra | x11vnc | NULL | | 2 | Extra | x2vnc | NULL | | 2 | Extra | xarchiver | NULL | | 2 | Extra | xbill | NULL | | 2 | Extra | xbl | NULL | | 2 | Extra | xboard | NULL | | 2 | Extra | xclip | NULL | | 2 | Extra | xdialog | NULL | | 2 | Extra | xdrawchem | NULL | | 2 | Extra | xemacs | NULL | | 2 | Extra | xemacs-base | NULL | | 2 | Extra | xemacs-sumo | NULL | | 2 | Extra | xerces2-java | NULL | | 1 | Extra | xfce4-artwork | NULL | | 2 | Extra | xfsdump | NULL | | 2 | Extra | xmahjongg | NULL | | 1 | Extra | xorg-fonts-cyrillic | NULL | | 1 | Extra | xorg-fonts-misc | NULL | | 1 | Extra | xorg-fonts-type1 | NULL | | 2 | Extra | xosd | NULL | | 2 | Extra | xournal | NULL | | 1 | Extra | xpdf-arabic | NULL | | 1 | Extra | xpdf-chinese-simplified | NULL | | 1 | Extra | xpdf-chinese-traditional | NULL | | 1 | Extra | xpdf-cyrillic | NULL | | 1 | Extra | xpdf-greek | NULL | | 1 | Extra | xpdf-hebrew | NULL | | 1 | Extra | xpdf-japanese | NULL | | 1 | Extra | xpdf-korean | NULL | | 1 | Extra | xpdf-latin2 | NULL | | 1 | Extra | xpdf-thai | NULL | | 1 | Extra | xpdf-turkish | NULL | | 2 | Extra | xplc | NULL | | 2 | Extra | xqf | NULL | | 2 | Extra | xskat | NULL | | 2 | Extra | xtermcontrol | NULL | | 2 | Extra | xzgv | NULL | | 2 | Extra | yasm | NULL | | 2 | Extra | yodl | NULL | | 2 | Extra | yp-tools | NULL | | 2 | Extra | ypbind-mt | NULL | | 2 | Extra | ypserv | NULL | | 1 | Extra | zsnes | NULL | | 2 | Extra | zvbi | NULL | +----------+-------+------------------------------------+----------+ 478 rows in set (0.23 sec)