On 03/30/10 at 12:15am, K. Piche wrote:
On Mon, 2010-03-29 at 20:00 -0500, Dan McGee wrote:
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 | Extra | gift | NULL | | 2 | Extra | gift-fasttrack | NULL | | 2 | Extra | gift-gnutella | NULL | | 2 | Extra | gift-openft | NULL |
I think we can safely throw these out along with bmp/bmpx if there are no objections.
+----------+-------+------------------------------------+----------+ 478 rows in set (0.23 sec)
-- K. Piche <kpiche@rogers.com>
No objections here --