From 4f87f68913a8261aa07cba6be2acc670fc9ca09e Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Wed, 24 May 2023 17:24:08 +0000 Subject: [PATCH] packages: Hide package names for packages which don't have any builds Signed-off-by: Michael Tremer --- src/buildservice/packages.py | 16 ++++++++++++---- 1 file changed, 12 insertions(+), 4 deletions(-) diff --git a/src/buildservice/packages.py b/src/buildservice/packages.py index c372ec25..61ec38ff 100644 --- a/src/buildservice/packages.py +++ b/src/buildservice/packages.py @@ -47,13 +47,17 @@ class Packages(base.Object): packages.created_at FROM packages + LEFT JOIN + builds ON packages.id = builds.pkg_id WHERE - deleted_at IS NULL + packages.deleted_at IS NULL + AND + builds.deleted_at IS NULL AND - arch = %s + packages.arch = %s ORDER BY - name, - created_at DESC + packages.name, + packages.created_at DESC """, "src", ) @@ -191,8 +195,12 @@ class Packages(base.Object): package_search_index search_index LEFT JOIN packages ON search_index.package_id = packages.id + LEFT JOIN + builds ON packages.id = builds.pkg_id WHERE packages.deleted_at IS NULL + AND + builds.deleted_at IS NULL AND search_index.document @@ websearch_to_tsquery('english', %s) ORDER BY -- 2.47.2