From 1945a73ede133ed72b89625dcc4685e18346d01e Mon Sep 17 00:00:00 2001 From: Arthur Zamarin Date: Fri, 2 Aug 2024 15:27:46 +0300 Subject: eapi cleanup: exclude blockers with rev deps count Signed-off-by: Arthur Zamarin --- pkg/app/handler/packages/eapi.templ | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/pkg/app/handler/packages/eapi.templ b/pkg/app/handler/packages/eapi.templ index e01322d..3790d40 100644 --- a/pkg/app/handler/packages/eapi.templ +++ b/pkg/app/handler/packages/eapi.templ @@ -89,7 +89,7 @@ func Eapi(w http.ResponseWriter, r *http.Request) { Where("atom = version.atom"). Limit(1)). Join("LEFT JOIN reverse_dependencies").JoinOn("version.atom = reverse_dependencies.atom"). - ColumnExpr("COALESCE(COUNT(DISTINCT reverse_dependencies.reverse_dependency_atom),0) AS reverse_dependencies"). + ColumnExpr("COALESCE(COUNT(DISTINCT reverse_dependencies.reverse_dependency_atom) FILTER(WHERE reverse_dependency_atom NOT LIKE '[B]%'),0) AS reverse_dependencies"). Join("LEFT JOIN package_to_bugs").JoinOn("version.atom = package_to_bugs.package_atom"). ColumnExpr("COALESCE(COUNT(DISTINCT package_to_bugs.id),0) AS bugs"). ColumnExpr("EXISTS(?) AS is_masked", -- cgit v1.2.3-65-gdbad