Andreas Tille pushed to branch master at Debian Med / community / helper-scripts
Commits:
d8ae1d2f by Andreas Tille at 2020-03-29T11:19:51+02:00
Try adding Ubuntu popcon but these data are not sensibly updated. Votes are
way lower than in Debian
- - - - -
1 changed file:
- missing-autopkgtest
Changes:
=====================================
missing-autopkgtest
=====================================
@@ -92,14 +92,19 @@ echo >> "$output"
$RUNPSQL >>"$output" <<EOT
SELECT source AS "Source ",
- vote AS "Vote ",
- tasks AS "Tasks ",
+ vote AS "Vote ",
+-- vote AS "Ubuntu vote", -- These data are not sensibly updated.
Votes are way lower than in Debian
+ tasks AS "Tasks ",
tags AS "Tags"
FROM (
SELECT source, vote, MAX(testsuite) as testsuite, tasks, tags FROM (
SELECT source, vote, testsuite, tasks, tags, row_number() OVER (PARTITION
BY source ORDER BY vote DESC) FROM (
- SELECT DISTINCT p.source, p.package, CASE WHEN pop.vote IS NULL THEN -1
ELSE pop.vote END AS vote, s.testsuite, t.tasks, d.tags FROM packages p
+ SELECT DISTINCT p.source, p.package,
+ CASE WHEN pop.vote IS NULL THEN -1 ELSE pop.vote END AS vote,
+-- CASE WHEN upop.vote IS NULL THEN -1 ELSE upop.vote END AS uvote,
+ s.testsuite, t.tasks, d.tags FROM packages p
LEFT OUTER JOIN popcon pop ON p.package = pop.package
+-- LEFT OUTER JOIN ubuntu_popcon upop ON p.package = upop.package
LEFT OUTER JOIN (SELECT source, testsuite FROM sources WHERE release =
'sid' ) s ON p.source = s.source
LEFT OUTER JOIN (SELECT package, array_agg(tag) AS tags FROM debtags
WHERE tag LIKE 'uitoolkit::%' OR tag LIKE '%x11%' GROUP BY package) d ON
p.package = d.package
LEFT OUTER JOIN (SELECT package, array_agg(task) AS tasks FROM
blends_dependencies WHERE blend = '$1' GROUP BY package) t ON p.package =
t.package
View it on GitLab:
https://salsa.debian.org/med-team/community/helper-scripts/-/commit/d8ae1d2faf14ba36597ef9b0e233c86fbe96fed6
--
View it on GitLab:
https://salsa.debian.org/med-team/community/helper-scripts/-/commit/d8ae1d2faf14ba36597ef9b0e233c86fbe96fed6
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
