my $statement =<<EOS;
- select timezone('GMT'::text, now())::timestamp(0) without time zone - b.snapshot AS when_ago, b.*
- from dashboard_mat b
- order by branch = 'master' desc,
- branch desc, $sort_clause
- snapshot desc
+ SELECT timezone('GMT'::text, now())::timestamp(0) without time zone - b.snapshot AS when_ago,
+ b.*,
+ s.log_text
+ FROM dashboard_mat b LEFT JOIN build_status_log s
+ ON b.snapshot = s.snapshot AND s.log_stage = 'test-results.log'
+ ORDER BY b.branch = 'master' desc,
+ b.branch desc, $sort_clause
+ b.snapshot desc
EOS
;
$row->{build_flags} =~ s/,/ /g;
$row->{build_flags} =~ s/_PC\b//g;
$row->{build_flags} = lc($row->{build_flags});
+ if (defined($row->{log_text}))
+ { # convert to a hash
+ $row->{log_text} = { split /\s+/, $row->{log_text} };
+ }
push(@$statrows,$row);
}
$sth->finish;