From f8aeecaf8cd33d87315c5a50be9a762e142062a4 Mon Sep 17 00:00:00 2001 From: "travis%sedsystems.ca" <> Date: Wed, 9 Feb 2005 00:51:02 +0000 Subject: Bug 257315 : type of delta_ts in bugs table should not be timestamp Patch by Tomas Kopal r=mkanat, LpSolit a=justdave --- contrib/bug_email.pl | 6 +++--- contrib/jb2bz.py | 2 ++ 2 files changed, 5 insertions(+), 3 deletions(-) (limited to 'contrib') diff --git a/contrib/bug_email.pl b/contrib/bug_email.pl index 6589401e8..1f2f28421 100755 --- a/contrib/bug_email.pl +++ b/contrib/bug_email.pl @@ -38,7 +38,7 @@ # # You need to work with bug_email.pl the MIME::Parser installed. # -# $Id: bug_email.pl,v 1.22 2005/01/30 04:22:28 justdave%bugzilla.org Exp $ +# $Id: bug_email.pl,v 1.23 2005/02/08 16:51:03 travis%sedsystems.ca Exp $ ############################################################### # 02/12/2000 (SML) @@ -1085,7 +1085,7 @@ END my $reporter = ""; my $query = "insert into bugs (\n" . join(",\n", @used_fields ) . - ", bug_status, creation_ts, everconfirmed) values ( "; + ", bug_status, creation_ts, delta_ts, everconfirmed) values ( "; # 'Yuck'. Then again, this whole file should be rewritten anyway... $query =~ s/product/product_id/; @@ -1140,7 +1140,7 @@ END $state = SqlQuote("NEW"); } - $query .= $state . ", \'$bug_when\', $ever_confirmed)\n"; + $query .= $state . ", \'$bug_when\', \'$bug_when\', $ever_confirmed)\n"; # $query .= SqlQuote( "NEW" ) . ", now(), " . SqlQuote($comment) . " )\n"; SendSQL("SELECT userid FROM profiles WHERE login_name=\'$reporter\'"); diff --git a/contrib/jb2bz.py b/contrib/jb2bz.py index dbd47ea7a..ed8231dfc 100644 --- a/contrib/jb2bz.py +++ b/contrib/jb2bz.py @@ -208,6 +208,7 @@ def process_jitterbug(filename): "bug_severity='normal'," \ "bug_status=%s," \ "creation_ts=%s," \ + "delta_ts=%s," \ "short_desc=%s," \ "product=%s," \ "rep_platform='All'," \ @@ -219,6 +220,7 @@ def process_jitterbug(filename): [ current['number'], bug_status, time.strftime("%Y-%m-%d %H:%M:%S", current['date-reported'][:9]), + time.strftime("%Y-%m-%d %H:%M:%S", current['date-reported'][:9]), current['short-description'], product, reporter, -- cgit v1.2.3-24-g4f1b