diff options
| author |   Arthur Zamarin <arthurzam@gentoo.org> | 2024-08-02 15:27:46 +0300 |
|---|---|---|
| committer | Arthur Zamarin <arthurzam@gentoo.org> | 2024-08-02 15:27:46 +0300 |
| commit | 1945a73ede133ed72b89625dcc4685e18346d01e (patch) | |
| tree | db10212603b4a7660116292098cac25faca54d79 | |
| parent | add SPDX license info (diff) | |
| download | soko-1945a73ede133ed72b89625dcc4685e18346d01e.tar.gz soko-1945a73ede133ed72b89625dcc4685e18346d01e.tar.bz2 soko-1945a73ede133ed72b89625dcc4685e18346d01e.zip | |
eapi cleanup: exclude blockers with rev deps count
Signed-off-by: Arthur Zamarin <arthurzam@gentoo.org>
| -rw-r--r-- | pkg/app/handler/packages/eapi.templ | 2 |
1 files changed, 1 insertions, 1 deletions
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", |