Re: [UDD] Enhances field in packages table should be text[] (array) rather than text

2011-01-23 Thread Lucas Nussbaum
On 13/01/11 at 11:41 +0100, Andreas Tille wrote: > Hi, > > for the Blends tasks pages I used to query UDD for packages which are > enhancing a given package pkgX by doing > >SELECT DISTINCT package, enhances FROM packages > WHERE enhances LIKE '%pkgX%' ; > > which worked so far. It has

Re: [UDD] Really strange missing homepage field for certain archs in package uisp

2011-01-23 Thread Lucas Nussbaum
On 17/01/11 at 10:37 +0100, Andreas Tille wrote: > [Marga as maintainer of the package in question in CC, because she > might or might not have an idea what might have happened.] > > Hi, > > when rewriting the code for the Blends tasks pages I stumbled upon a > really strange thing in UDD: > >

Re: [UDD] Fixing (most) email addresses in upload_history table

2011-01-23 Thread Lucas Nussbaum
On 23/01/11 at 00:41 +0100, Andreas Tille wrote: > Hi again, > > additional remark to the Duplicated Key problem: If I do a > TRUNCATE upload_history_closes > before I do a full import this works smoothly and the exception is not > triggered. So I commited the code without the try-exccept code

Re: [UDD] Enhances field in packages table should be text[] (array) rather than text

2011-01-23 Thread Andreas Tille
On Sun, Jan 23, 2011 at 02:17:49PM +0100, Lucas Nussbaum wrote: > It would be better to have both a array-ifed version of the field, and a > text version of the field, in the packages table. That way, > compatibility is preserved. Patch welcomed. Uhmm, that sounds a bit redundant. I just implemen

Re: [UDD] Fixing (most) email addresses in upload_history table

2011-01-23 Thread Andreas Tille
On Sun, Jan 23, 2011 at 02:14:14PM +0100, Lucas Nussbaum wrote: > On 23/01/11 at 00:41 +0100, Andreas Tille wrote: > > BTW, a > > > > udd=# SELECT maintainer, maintainer_email, changed_by, changed_by_email, > > signed_by FROM upload_history WHERE (maintainer_email not like '%@%' or > > changed_b

Re: [UDD] Fixing (most) email addresses in upload_history table

2011-01-23 Thread Lucas Nussbaum
On 23/01/11 at 14:40 +0100, Andreas Tille wrote: > On Sun, Jan 23, 2011 at 02:14:14PM +0100, Lucas Nussbaum wrote: > > On 23/01/11 at 00:41 +0100, Andreas Tille wrote: > > > BTW, a > > > > > > udd=# SELECT maintainer, maintainer_email, changed_by, changed_by_email, > > > signed_by FROM upload_his

Re: [UDD] Fixing (most) email addresses in upload_history table

2011-01-23 Thread Andreas Tille
On Sun, Jan 23, 2011 at 03:55:55PM +0100, Lucas Nussbaum wrote: > >1. Reimporting the whole upload_history* tables with the new importer > > script? > > -> I do not like it really because of the import problem I have > > faced on my side and I do not really understand the i