| 1 | //! `GET /{owner}` — a user or organization profile (spec §7). | |
| 2 | //! | |
| 3 | //! Users and organizations share one handle namespace (enforced by a trigger in | |
| 4 | //! the schema), so one route serves both and the lookup tries users first. | |
| 5 | //! | |
| 6 | //! The repository list is filtered by the same rule the repository pages use: | |
| 7 | //! public repos to everyone, private repos only where the viewer has a | |
| 8 | //! collaborator row, an org membership, ownership, or site admin. Getting this | |
| 9 | //! query wrong is the private-repo leak in its most direct form — a profile page | |
| 10 | //! that enumerates repositories the viewer cannot open. | |
| 11 | ||
| 12 | use axum::extract::{Path as UrlPath, State}; | |
| 13 | use axum::response::{IntoResponse, Response}; | |
| 14 | use serde::Deserialize; | |
| 15 | use uuid::Uuid; | |
| 16 | ||
| 17 | use crate::error::{AppError, AppResult}; | |
| 18 | use crate::state::{AppState, CsrfToken, CurrentUser, Nonce}; | |
| 19 | use crate::views::settings as v; | |
| 20 | use crate::views::{self, Chrome}; | |
| 21 | ||
| 22 | /// `GET /{owner}` | |
| 23 | pub async fn show( | |
| 24 | State(state): State<AppState>, | |
| 25 | UrlPath(handle): UrlPath<String>, | |
| 26 | CurrentUser(user): CurrentUser, | |
| 27 | CsrfToken(csrf): CsrfToken, | |
| 28 | Nonce(nonce): Nonce, | |
| 29 | ) -> AppResult<Response> { | |
| 30 | let viewer = user.as_ref().map(|u| u.id); | |
| 31 | let is_site_admin = user.as_ref().is_some_and(|u| u.is_admin); | |
| 32 | ||
| 33 | let owner = load_owner(&state, &handle).await?.ok_or(AppError::NotFound)?; | |
| 34 | ||
| 35 | let repos = load_repos(&state, &owner, viewer, is_site_admin).await?; | |
| 36 | ||
| 37 | let members = if owner.is_org { | |
| 38 | load_members(&state, owner.id).await? | |
| 39 | } else { | |
| 40 | Vec::new() | |
| 41 | }; | |
| 42 | ||
| 43 | Ok(views::page( | |
| 44 | Chrome { | |
| 45 | title: &owner.handle, | |
| 46 | user: user.as_deref(), | |
| 47 | csrf: &csrf, | |
| 48 | nonce: &nonce, | |
| 49 | }, | |
| 50 | v::profile(v::Profile { | |
| 51 | handle: &owner.handle, | |
| 52 | display_name: owner.display_name.as_deref(), | |
| 53 | description: owner.description.as_deref(), | |
| 54 | is_org: owner.is_org, | |
| 55 | repos: &repos, | |
| 56 | members: &members, | |
| 57 | joined: owner.created_at, | |
| 58 | }), | |
| 59 | ) | |
| 60 | .into_response()) | |
| 61 | } | |
| 62 | ||
| 63 | struct Owner { | |
| 64 | id: Uuid, | |
| 65 | handle: String, | |
| 66 | display_name: Option<String>, | |
| 67 | description: Option<String>, | |
| 68 | is_org: bool, | |
| 69 | created_at: chrono::DateTime<chrono::Utc>, | |
| 70 | } | |
| 71 | ||
| 72 | #[derive(sqlx::FromRow)] | |
| 73 | struct OwnerRow { | |
| 74 | id: Uuid, | |
| 75 | handle: String, | |
| 76 | display_name: Option<String>, | |
| 77 | description: Option<String>, | |
| 78 | is_org: bool, | |
| 79 | created_at: chrono::DateTime<chrono::Utc>, | |
| 80 | } | |
| 81 | ||
| 82 | async fn load_owner(state: &AppState, handle: &str) -> AppResult<Option<Owner>> { | |
| 83 | // One statement over both tables. The handle namespace is shared, so at most | |
| 84 | // one row can match — and doing it in one query means a user and an org can | |
| 85 | // never both be found and silently resolved in some arbitrary order. | |
| 86 | let row: Option<OwnerRow> = sqlx::query_as( | |
| 87 | r#" | |
| 88 | SELECT id, handle::text AS handle, display_name, NULL::text AS description, | |
| 89 | false AS is_org, created_at | |
| 90 | FROM users WHERE handle = $1 | |
| 91 | UNION ALL | |
| 92 | SELECT id, handle::text AS handle, display_name, description, | |
| 93 | true AS is_org, created_at | |
| 94 | FROM orgs WHERE handle = $1 | |
| 95 | "#, | |
| 96 | ) | |
| 97 | .bind(handle) | |
| 98 | .fetch_optional(&state.db) | |
| 99 | .await?; | |
| 100 | ||
| 101 | Ok(row.map(|r| Owner { | |
| 102 | id: r.id, | |
| 103 | handle: r.handle, | |
| 104 | display_name: r.display_name, | |
| 105 | description: r.description, | |
| 106 | is_org: r.is_org, | |
| 107 | created_at: r.created_at, | |
| 108 | })) | |
| 109 | } | |
| 110 | ||
| 111 | #[derive(Deserialize, sqlx::FromRow)] | |
| 112 | struct RepoRow { | |
| 113 | name: String, | |
| 114 | description: Option<String>, | |
| 115 | private: bool, | |
| 116 | pushed_at: Option<chrono::DateTime<chrono::Utc>>, | |
| 117 | } | |
| 118 | ||
| 119 | async fn load_repos( | |
| 120 | state: &AppState, | |
| 121 | owner: &Owner, | |
| 122 | viewer: Option<Uuid>, | |
| 123 | is_site_admin: bool, | |
| 124 | ) -> AppResult<Vec<v::ProfileRepo>> { | |
| 125 | // The visibility predicate is written out here rather than filtered in Rust | |
| 126 | // so a private repository is never loaded in the first place. Every branch | |
| 127 | // after the first requires `$2` (the viewer) to be non-null, so an anonymous | |
| 128 | // request can only ever match the public branch. | |
| 129 | let rows: Vec<RepoRow> = sqlx::query_as( | |
| 130 | r#" | |
| 131 | SELECT r.name::text AS name, | |
| 132 | r.description, | |
| 133 | (r.visibility = 'private') AS private, | |
| 134 | r.pushed_at | |
| 135 | FROM repos r | |
| 136 | WHERE (r.owner_user_id = $1 OR r.owner_org_id = $1) | |
| 137 | AND ( | |
| 138 | r.visibility = 'public' | |
| 139 | OR $3 | |
| 140 | OR r.owner_user_id = $2 | |
| 141 | OR EXISTS (SELECT 1 FROM repo_collaborators c | |
| 142 | WHERE c.repo_id = r.id AND c.user_id = $2) | |
| 143 | OR EXISTS (SELECT 1 FROM org_members m | |
| 144 | WHERE m.org_id = r.owner_org_id AND m.user_id = $2) | |
| 145 | ) | |
| 146 | ORDER BY r.pushed_at DESC NULLS LAST, r.name | |
| 147 | LIMIT 200 | |
| 148 | "#, | |
| 149 | ) | |
| 150 | .bind(owner.id) | |
| 151 | .bind(viewer) | |
| 152 | .bind(is_site_admin) | |
| 153 | .fetch_all(&state.db) | |
| 154 | .await?; | |
| 155 | ||
| 156 | Ok(rows | |
| 157 | .into_iter() | |
| 158 | .map(|r| v::ProfileRepo { | |
| 159 | name: r.name, | |
| 160 | description: r.description, | |
| 161 | private: r.private, | |
| 162 | pushed_at: r.pushed_at, | |
| 163 | }) | |
| 164 | .collect()) | |
| 165 | } | |
| 166 | ||
| 167 | async fn load_members( | |
| 168 | state: &AppState, | |
| 169 | org_id: Uuid, | |
| 170 | ) -> AppResult<Vec<(String, df_db::models::OrgRole)>> { | |
| 171 | Ok(sqlx::query_as( | |
| 172 | "SELECT u.handle::text, m.role | |
| 173 | FROM org_members m JOIN users u ON u.id = m.user_id | |
| 174 | WHERE m.org_id = $1 | |
| 175 | ORDER BY m.role DESC, u.handle", | |
| 176 | ) | |
| 177 | .bind(org_id) | |
| 178 | .fetch_all(&state.db) | |
| 179 | .await?) | |
| 180 | } |
180 lines · Rust