From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 32402 invoked by alias); 25 Jul 2008 19:24:11 -0000 Received: (qmail 32384 invoked by uid 22791); 25 Jul 2008 19:24:09 -0000 X-Spam-Check-By: sourceware.org Received: from mx1.redhat.com (HELO mx1.redhat.com) (66.187.233.31) by sourceware.org (qpsmtpd/0.31) with ESMTP; Fri, 25 Jul 2008 19:23:32 +0000 Received: from int-mx1.corp.redhat.com (int-mx1.corp.redhat.com [172.16.52.254]) by mx1.redhat.com (8.13.8/8.13.8) with ESMTP id m6PJNUuI024408 for ; Fri, 25 Jul 2008 15:23:30 -0400 Received: from pobox.corp.redhat.com (pobox.corp.redhat.com [10.11.255.20]) by int-mx1.corp.redhat.com (8.13.1/8.13.1) with ESMTP id m6PJNU8I029099; Fri, 25 Jul 2008 15:23:30 -0400 Received: from opsy.redhat.com (vpn-10-118.bos.redhat.com [10.16.10.118]) by pobox.corp.redhat.com (8.13.1/8.13.1) with ESMTP id m6PJNTP0000662; Fri, 25 Jul 2008 15:23:30 -0400 Received: by opsy.redhat.com (Postfix, from userid 500) id 39E1F50824C; Fri, 25 Jul 2008 13:23:29 -0600 (MDT) To: "Daniel Berlin" Cc: "Gdb List" Subject: Re: Notes on conversion to bugzilla References: <4aca3dc20807232314t754a2286s27f7131a0d573444@mail.gmail.com> From: Tom Tromey Reply-To: Tom Tromey X-Attribution: Tom Date: Sat, 26 Jul 2008 05:54:00 -0000 In-Reply-To: <4aca3dc20807232314t754a2286s27f7131a0d573444@mail.gmail.com> (Daniel Berlin's message of "Wed\, 23 Jul 2008 23\:14\:49 -0700") Message-ID: User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Mailing-List: contact gdb-help@sourceware.org; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: gdb-owner@sourceware.org X-SW-Source: 2008-07/txt/msg00275.txt.bz2 >>>>> "Dan" == Daniel Berlin writes: Dan> Sorry, this got shoved into my gdb label, which i only read a Dan> small time. No problem. Dan> You will have to update the script to output something that is the Dan> same as the current schema. BTW there's a reference for various versions of bugzilla schema here: http://www.ravenbrook.com/project/p4dti/tool/cgi/bugzilla-schema/ I dumped the schema from the database, though, and updated the script, using my newly-acquired minimal knowledge of SQL. There were some field name changes, and I also changed some inserts to look up IDs in other tables. So, we end up with things like: insert into bugs( bug_id, assigned_to, bug_severity, priority, bug_status, creation_ts, delta_ts , short_desc, reporter, version, product_id, component_id, resolution, target_milestone, qa_contact, gccbuild, gcctarget, gcchost, keywords ) values ( 4, 10, 'critical', 'P2', 'CLOSED', '2000-11-01 18:08:00', '20020430091342', 'Attempt to initialize Variable Array', 17, '5.0', (select id from products where products.name = 'gdb'), (select id from components where components.name = 'gdb'), 'FIXED', '---', 0, '', '', '', 0 ); Dan> Once gnatsparse outputs things in the current schema, we just stop the Dan> sourceware bugzilla for a few minutes, tell gnatsparse to start Dan> numbering bugs at the last bug in the database (the bug number is Dan> unique across all products), let it run, and then import that into Dan> sql. Sounds good to me. Is there an easy way to test it first? I can send you the output, the script, the diff between the pristine script and what I came up with, ... whatever you like. I wasn't sure what to do about already existing entries in the 'profiles' table. I don't know enough SQL to know whether the inserts generated by this script will be a problem :-/ Tom> From a glance on sourceware it looks like perhaps just using Tom> log_accum_bugzillified is enough, but I have not tested this. Dan> Yes, this would work fine. Great. I've appended a patch to CVSROOT/loginfo. I only updated the gdb bits; I will do the rest later after pinging the various lists. Tom *** loginfo 26 Mar 2008 18:16:35 -0600 1.34 --- loginfo 25 Jul 2008 13:14:51 -0600 *************** *** 41,56 **** ^/?src/cgen (/usr/sourceware/bin/log_accum -T cgen -G cgen -C src -m cgen-cvs@sourceware.org -s %{sVv}) ^/?src/sid (/usr/sourceware/bin/log_accum -T sid -G sid -C src -m sid-cvs@sourceware.org -s %{sVv}) ! ^/?src/gdb (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/mmalloc (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/readline (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/sim (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/utils (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/tcl (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/itcl (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/libgui (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/tix (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/tk (/usr/sourceware/bin/log_accum -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ^/?src/winsup (QMAILHOST=cygwin.com /usr/sourceware/bin/log_accum -T cygwin -G cygwin -C src -m cygwin-cvs@cygwin.com -s %{sVv}) ^/?src/cygwin.* (QMAILHOST=cygwin.com /usr/sourceware/bin/log_accum -T cygwin -G cygwin -C src -m cygwin-cvs@cygwin.com -s %{sVv}) --- 41,56 ---- ^/?src/cgen (/usr/sourceware/bin/log_accum -T cgen -G cgen -C src -m cgen-cvs@sourceware.org -s %{sVv}) ^/?src/sid (/usr/sourceware/bin/log_accum -T sid -G sid -C src -m sid-cvs@sourceware.org -s %{sVv}) ! ^/?src/gdb (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/mmalloc (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/readline (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/sim (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/utils (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/tcl (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/itcl (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/libgui (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/tix (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ! ^/?src/tk (/usr/sourceware/bin/log_accum_bugzillified -T gdb -G gdb -C src -m gdb-cvs@sourceware.org -s %{sVv}) ^/?src/winsup (QMAILHOST=cygwin.com /usr/sourceware/bin/log_accum -T cygwin -G cygwin -C src -m cygwin-cvs@cygwin.com -s %{sVv}) ^/?src/cygwin.* (QMAILHOST=cygwin.com /usr/sourceware/bin/log_accum -T cygwin -G cygwin -C src -m cygwin-cvs@cygwin.com -s %{sVv})