From d6490fe2887d96651d25a16d773d8fbefee073a8 Mon Sep 17 00:00:00 2001 From: Santo Cariotti Date: Sun, 18 Sep 2022 18:32:13 +0200 Subject: Show users avatar on get models --- src/models/model.rs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/models/model.rs b/src/models/model.rs index f8e7057..828dfc2 100644 --- a/src/models/model.rs +++ b/src/models/model.rs @@ -129,7 +129,7 @@ impl Model { r#" SELECT models.*, - json_build_object('id', users.id, 'email', users.email, 'username', users.username, 'is_staff', users.is_staff) as author, + json_build_object('id', users.id, 'email', users.email, 'username', users.username, 'is_staff', users.is_staff, 'avatar', users.avatar) as author, json_agg(uploads.*) filter (where uploads.* is not null) as uploads FROM models JOIN users ON users.id = models.author_id @@ -151,7 +151,7 @@ impl Model { r#" SELECT models.*, - json_build_object('id', users.id, 'email', users.email, 'username', users.username, 'is_staff', users.is_staff) as author, + json_build_object('id', users.id, 'email', users.email, 'username', users.username, 'is_staff', users.is_staff, 'avatar', users.avatar) as author, json_agg(uploads.*) filter (where uploads.* is not null) as uploads FROM models JOIN users ON users.id = models.author_id -- cgit v1.2.3-71-g8e6c