From 8db9929ca84f5d9aacb4159d48ef6baede5ede74 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Wed, 2 Jul 2025 14:29:34 +0000 Subject: [PATCH] keys: Resolve ambiguous relationships Signed-off-by: Michael Tremer --- src/buildservice/keys.py | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/src/buildservice/keys.py b/src/buildservice/keys.py index e831ca7d..8e47be7b 100644 --- a/src/buildservice/keys.py +++ b/src/buildservice/keys.py @@ -66,15 +66,19 @@ class Key(sqlmodel.SQLModel, database.BackendMixin, database.SoftDeleteMixin, ta # Created By - created_by: "User" = sqlmodel.Relationship() + created_by: "User" = sqlmodel.Relationship( + sa_relationship_kwargs={ "foreign_keys" : "[Key.created_by_id]" }, + ) # Deleted By ID - #deleted_by_id: int = sqlmodel.Field(foreign_key="users.id", exclude=True) + deleted_by_id: int = sqlmodel.Field(foreign_key="users.id", exclude=True) # Deleted By - #deleted_by: "User" = sqlmodel.Relationship() + deleted_by: "User" = sqlmodel.Relationship( + sa_relationship_kwargs={ "foreign_keys" : "[Key.deleted_by_id]" }, + ) # Public Key -- 2.47.2