summaryrefslogtreecommitdiffstats
path: root/src/models
diff options
context:
space:
mode:
Diffstat (limited to 'src/models')
-rw-r--r--src/models/model.rs4
1 files 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