[UDD] Improved link between LP bug tasks watching Debian bugs and debbugs ids

[Olivier Berger <olivier.berger@it-sudparis.eu>]

Hi.

Working on the D2R RDF exporter for UDD [0], I noticed that it could be
practical to record a link between LP tasks ('ubuntu_bugs_tasks' table)
that correspond to Debian bugs and the Debian bugs counterparts (in
table 'bugs') : in the 'ubuntu_bugs_tasks.watch' column contains bugs
from their CGI URLs
(http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=xxxx).

I'd suggest to add a table like :

CREATE TABLE whatever AS
SELECT bug, int4(substring(watch from 'http://bugs.debian.org/cgi-bin/bugreport\\.cgi\\?bug=(\\d+)')) as debian_bugid
FROM ubuntu_bugs_tasks WHERE
watch LIKE 'http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=%';


It'd then look like :

bug debian_bugid 
3080 449983
3198 457997
3611 134346
3804 265443
4844 423748
5385 298691
5608 378454
6707 502927
...

Any comments ?

Best regards,

[0]: https://picoforge.int-evry.fr/cgi-bin/twiki/view/Helios_wp3/Web/UltimateDebianDatabaseToRDF
-- 
Olivier BERGER <olivier.berger@it-sudparis.eu>
http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 2048R/5819D7E8
Ingénieur Recherche - Dept INF
Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France)