speed up members list, and only show latest builds less than a year old

[buildfarm-server.git] / cgi-bin / show_members.pl

diff --git a/cgi-bin/show_members.pl b/cgi-bin/show_members.pl
index d4b03b23b6456ee19c3ca40d119fbeb4e18b5ea2..31b61dc77c8668b3e6a6716c3ec96dbb410bdded 100755 (executable)
--- a/cgi-bin/show_members.pl
+++ b/cgi-bin/show_members.pl
@@ -35,15 +35,13 @@ my $statement = <<EOS;
 
   select name, operating_system, os_version, compiler, compiler_version, owner_email, 
     architecture as arch, ARRAY(
-                               select distinct on (branch <> 'HEAD', branch) 
-                                      branch || ':' || 
-                                      extract(days from now() - snapshot)
-                               from build_status 
-                               where name = sysname
-                               order by branch <> 'HEAD', branch desc, 
-                                        snapshot desc
+                               select branch || ':' || 
+                                      extract(days from now() - latest_snapshot)
+                               from build_status_latest l 
+                               where l.sysname = s.name
+                               order by branch <> 'HEAD', branch desc 
                                ) as branches 
-  from buildsystems 
+  from buildsystems s
   where status = 'approved'
   order by $sort_by
 
@@ -119,7 +117,15 @@ __DATA__
     <th>Branches reported on<br />(most recent report)</th>
     </tr>
 [% alt = true %]
-[% FOREACH row IN statrows %]    <tr [%- IF alt %]class="alt"[% END -%]>
+[% FOREACH row IN statrows ;
+    have_recent = 0;
+    FOREACH branch_days IN row.branches.split(',') ;
+       branch_fields = branch_days.split(':');
+       branch_day = branch_fields.1;
+       IF branch_day < 365 ; have_recent = 1; END;
+    END;
+ IF have_recent ;
+%]    <tr [%- IF alt %]class="alt"[% END -%]>
     [% alt = ! alt %]
     <td><input type="checkbox" name="member" value="[% row.name %]" /></td>
     <td>[% row.name %]<br />[% row.owner_email %]</td>
@@ -133,12 +139,13 @@ __DATA__
        branch_fields = branch_days.split(':');
        branch = branch_fields.0;
        branch_day = branch_fields.1;
+       IF branch_day < 365 ;
     %]<li><a 
     href="show_history.pl?nm=[% row.name %]&amp;br=[% branch %]"
     title="History"
-    >[% branch %]</a>&nbsp;([% branch_day %]&nbsp;days&nbsp;ago)</li>[% END %]</ul></td>
+    >[% branch %]</a>&nbsp;([% branch_day %]&nbsp;days&nbsp;ago)</li>[% END; END %]</ul></td>
     </tr>
-[% END %]
+[% END; END %]
     </table>
     <input type="submit" value="Make Filter" />
     </form>