From 8d5e1ebab8938a7fd5e3d7d41f2bf847ca922154 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Sun, 26 Jan 2025 13:41:48 +0000 Subject: [PATCH] builders: Fix accidental join Signed-off-by: Michael Tremer --- src/buildservice/builders.py | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/src/buildservice/builders.py b/src/buildservice/builders.py index 7d587921..f23e5bfe 100644 --- a/src/buildservice/builders.py +++ b/src/buildservice/builders.py @@ -543,7 +543,7 @@ class Builder(database.Base, database.BackendMixin, database.SoftDeleteMixin): self.backend.jobs.running_jobs, ) .where( - jobs.Job.builder == self, + self.backend.jobs.running_jobs.c.builder_id == self.id, ) .cte("builder_running_jobs") ) @@ -568,9 +568,10 @@ class Builder(database.Base, database.BackendMixin, database.SoftDeleteMixin): stmt = ( sqlalchemy .select( - sqlalchemy.func.count( - self.running_jobs, - ).label("running_jobs"), + sqlalchemy.func.count().label("running_jobs"), + ) + .select_from( + self.running_jobs, ) ) -- 2.47.3