Andreas Tille pushed to branch master at Debian Med / community / helper-scripts
Commits:
fe572356 by Andreas Tille at 2020-05-02T10:09:39+02:00
Adapt to the fixed table ci, duplicated table autopkgtest was removed
- - - - -
1 changed file:
- seek_outdated_med-packages
Changes:
=====================================
seek_outdated_med-packages
=====================================
@@ -51,8 +51,8 @@ CREATE TEMPORARY VIEW autopkgtest_fail ( source, suite_arch,
messages ) AS
SELECT source, suite_arch, messages FROM (
SELECT source, string_agg(suite_arch, ', ') AS suite_arch ,
array_agg(message) AS messages
FROM (
- SELECT source, string_agg(suite || '_' || architecture, ', ') AS
suite_arch , message
- FROM autopkgtest
+ SELECT source, string_agg(suite || '_' || arch, ', ') AS suite_arch ,
message
+ FROM ci
WHERE status = 'fail'
GROUP BY source, message
) tmp1 GROUP BY source
@@ -63,8 +63,8 @@ CREATE TEMPORARY VIEW autopkgtest_neutral ( source,
suite_arch, messages ) AS
SELECT source, suite_arch, messages FROM (
SELECT source, string_agg(suite_arch, ', ') AS suite_arch ,
array_agg(message) AS messages
FROM (
- SELECT source, string_agg(suite || '_' || architecture, ', ') AS
suite_arch , message
- FROM autopkgtest
+ SELECT source, string_agg(suite || '_' || arch, ', ') AS suite_arch ,
message
+ FROM ci
WHERE status = 'neutral'
GROUP BY source, message
) tmp1 GROUP BY source
@@ -93,7 +93,7 @@ CREATE TEMPORARY VIEW autopkgtest_neutral ( source,
suite_arch, messages ) AS
FROM packages p
-- begin tests
LEFT OUTER JOIN (SELECT source, array_agg(status) AS status_agg FROM (
- SELECT DISTINCT source, status FROM autopkgtest
WHERE status != 'pass' AND suite IN ('testing', 'unstable')
+ SELECT DISTINCT source, status FROM ci WHERE
status != 'pass' AND suite IN ('testing', 'unstable')
) tmp GROUP BY source) ci ON p.source = ci.source
LEFT OUTER JOIN autopkgtest_fail failci ON p.source = failci.source
LEFT OUTER JOIN autopkgtest_neutral neutralci ON p.source =
neutralci.source
View it on GitLab:
https://salsa.debian.org/med-team/community/helper-scripts/-/commit/fe5723562fb0812229610641c9e213e26b9c768f
--
View it on GitLab:
https://salsa.debian.org/med-team/community/helper-scripts/-/commit/fe5723562fb0812229610641c9e213e26b9c768f
You're receiving this email because of your account on salsa.debian.org.
_______________________________________________
debian-med-commit mailing list
[email protected]
https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/debian-med-commit
