Attachment 294729 Details for Bug 406371 – Patch to add methods to db modules to access stored db functions (v1)

[patch] Patch to add methods to db modules to access stored db functions (v1)

db_function_methods.patch (text/plain), 2.49 KB, created by David Lawrence on 2008-02-13 04:37:20 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Lawrence

Created: 2008-02-13 04:37:20 UTC

Size: 2.49 KB

patch

obsolete

>Index: Bugzilla/DB/Mysql.pm
>===================================================================
>RCS file: /cvs/qa/rh_bugzilla_3/Bugzilla/DB/Mysql.pm,v
>retrieving revision 1.3
>diff -u -r1.3 Mysql.pm
>--- Bugzilla/DB/Mysql.pm	28 Jan 2008 04:46:17 -0000	1.3
>+++ Bugzilla/DB/Mysql.pm	13 Feb 2008 04:28:21 -0000
>@@ -205,6 +205,28 @@
>     return $self->_bz_build_schema_from_disk();
> }
> 
>+# REDHAT EXTENSION START 406371
>+sub sql_issue_tracker_list {
>+    my ($self) = @_;
>+    return "IssueTrackerList(bugs.bug_id)";
>+}
>+
>+sub sql_flag_list {
>+    my ($self, @group_ids) = @_;
>+    return "FLagList(bugs.bug_id,'" . join(',', @group_ids). "')";
>+}
>+
>+sub sql_dependson_list {
>+    my ($self) = @_;
>+    return "DependsOnList(bugs.bug_id)";
>+}
>+
>+sub sql_blockedby_list {
>+    my ($self) = @_;
>+    return "BlockedByList(bugs.bug_id)";
>+}
>+# REDHAT EXTENSION END 406371
>+
> #####################################################################
> # Database Setup
> #####################################################################
>Index: Bugzilla/DB/Pg.pm
>===================================================================
>RCS file: /cvs/qa/rh_bugzilla_3/Bugzilla/DB/Pg.pm,v
>retrieving revision 1.3
>diff -u -r1.3 Pg.pm
>--- Bugzilla/DB/Pg.pm	19 Dec 2007 16:20:04 -0000	1.3
>+++ Bugzilla/DB/Pg.pm	13 Feb 2008 04:28:21 -0000
>@@ -167,6 +167,35 @@
>     return $exists || 0;
> }
> 
>+# REDHAT EXTENSION START 406371
>+sub sql_issue_tracker_list {
>+    my ($self) = @_;
>+    return "ARRAY(SELECT it_id FROM bz_it_map WHERE bz_id = bugs.bug_id AND it_id IS NOT NULL)";
>+}
>+
>+sub sql_flag_list {
>+    my ($self, @group_ids) = @_;
>+    my $flag_select = "ARRAY(SELECT flagtypes.name || flags.status FROM flags 
>+                       LEFT JOIN flagtypes ON flags.type_id = flagtypes.id 
>+                       WHERE flags.is_active = 1 AND (flagtypes.view_group_id IS NULL";
>+    if ( $group_ids_string ) {
>+        $flag_select .= " OR flagtypes.view_group_id IN (" . join(',', @group_ids) . ")";
>+    }
>+    $flag_select .= ") AND flags.bug_id = bugs.bug_id)";
>+    return $flag_select;
>+}
>+
>+sub sql_dependson_list {
>+    my ($self) = @_;
>+    return "ARRAY(SELECT dependson FROM dependencies WHERE blocked = bugs.bug_id)";
>+}
>+
>+sub sql_blockedby_list {
>+    my ($self) = @_;
>+    return "ARRAY(SELECT blocked FROM dependencies WHERE dependson = bugs.bug_id)";
>+}
>+# REDHAT EXTENSION END 406371
>+
> #####################################################################
> # Custom Database Setup
> #####################################################################

Actions: View | Diff

Attachments on bug 406371: 294729 | 294756 | 294892