Attachment 312768 Details for Bug 456681 – v2 for fixing sql queries

[patch] v2 for fixing sql queries

update_cf_queries.patch (text/plain), 1.63 KB, created by Noura El hawary on 2008-07-28 13:10:18 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Noura El hawary

Created: 2008-07-28 13:10:18 UTC

Size: 1.63 KB

patch

obsolete

>Index: update_cf_queries.pl
>===================================================================
>RCS file: /cvs/qa/rh_bugzilla_3/redhat/update_cf_queries.pl,v
>retrieving revision 1.1
>diff -p -u -r1.1 update_cf_queries.pl
>--- update_cf_queries.pl	2 May 2008 15:33:29 -0000	1.1
>+++ update_cf_queries.pl	28 Jul 2008 13:07:21 -0000
>@@ -32,7 +32,7 @@ else {
>         or die "Couldn't connect database: " . DBI->errstr;
> 
>     my @custom_fields
>-        = qw/'%devel_whiteboard%' '%qa_whiteboard%' '%internal_whiteboard%' '%fixed_in%' '%cust_facing%' '%issuetracker%'/;
>+        = qw/'%devel_whiteboard%' '%qa_whiteboard%' '%internal_whiteboard%' '%fixed_in%' '%cust_facing%' '%issuetracker%' '%Ascending%' '%Descending%' '%format=ft%' '%query_format=ft%'/;
> 
>     my $condition = join( " OR query LIKE ", @custom_fields );
> 
>@@ -54,7 +54,7 @@ else {
>             "UPDATE namedqueries SET query = ? WHERE userid = ? AND name = ?"
>         );
>         $update_query_sth->execute( $new_query, $userid, $name );
>-
>+        print "$userid, $name\n\n";
>         $count++;
>     }
> 
>@@ -115,6 +115,16 @@ sub convert_query {
>     my $new_query = canonicalise_query($cgi);
>     $new_query =~ s/=$_/=cf_$_/g foreach @custom_fields;
> 
>+    # remove format "&format=ft" from the query string
>+    $new_query =~ s/&format=ft//g;
>+    $new_query =~ s/&query_format=ft//g;
>+    
>+    # change Bug Number Ascending to just Bug Number 
>+    $new_query =~ s/Bug%20Number%20Ascending/Bug%20Number/g;
>+
>+    # change Bug Number Descending to bugs.bug_id+desc
>+    $new_query =~ s/Bug%20Number%20Descending/bugs\.bug_id%20desc/g;
>+    
>     print "New Query: $new_query\n\n";
> 
>     return $new_query;

Flags:

dkl: review-

Actions: View | Diff

Attachments on bug 456681: 312751 | 312768