diff options
| author | Santo Cariotti <santo@dcariotti.me> | 2022-09-24 17:37:38 +0000 |
|---|---|---|
| committer | Santo Cariotti <santo@dcariotti.me> | 2022-09-24 17:37:38 +0000 |
| commit | 159f5eda5e6937c4aaeae61cbca703761ee32003 (patch) | |
| tree | 24826397e4b051e2db2a6247e9b654c1cb67ab8f /src/models | |
| parent | 4319bceb894e87be5586ae662c7d7d57b02305ba (diff) | |
Fix `json_build_object` returning name too
Diffstat (limited to 'src/models')
| -rw-r--r-- | src/models/model.rs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/models/model.rs b/src/models/model.rs index 60a6814..98ee8d4 100644 --- a/src/models/model.rs +++ b/src/models/model.rs @@ -159,7 +159,7 @@ impl Model { r#" SELECT models.*, - json_build_object('id', users.id, 'email', users.email, 'username', users.username, 'is_staff', users.is_staff, 'avatar', users.avatar) as author, + json_build_object('id', users.id, 'name', users.name, '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 @@ -181,7 +181,7 @@ impl Model { r#" SELECT models.*, - json_build_object('id', users.id, 'email', users.email, 'username', users.username, 'is_staff', users.is_staff, 'avatar', users.avatar) as author, + json_build_object('id', users.id, 'name', users.name, '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 @@ -205,7 +205,7 @@ impl Model { r#" SELECT models.*, - json_build_object('id', users.id, 'email', users.email, 'username', users.username, 'is_staff', users.is_staff, 'avatar', users.avatar) as author, + json_build_object('id', users.id, 'name', users.name, '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 |