Method authenticate

backend/src/graphql/mod.rs:133–161

(&self, (user_id, session_id): (String, String))

    }

    pub async fn authenticate(&self, (user_id, session_id): (String, String)) -> Viewer {
        let result = sqlx::query_as::<_, SessionRow>(
            "select
                u.id user_id,
                u.selected_repository_id,
                $2 session_id,
                array_agg(ur.repository_id) write_repo_ids

            from sessions s
            join users u on s.user_id = u.id
            join users_repositories ur on u.id = ur.user_id
            where s.user_id = $1::uuid and s.session_id = decode($2, 'hex')
                and ur.can_write
            group by u.id",
        )
        .bind(&user_id)
        .bind(&session_id)
        .fetch_optional(&self.pool)
        .await;

        match result {
            Ok(row) => (user_id, row).into(),

            Err(err) => {
                log::warn!("failed to fetch session info, proceeding as guest: {}", err);
                Viewer::guest()
            }
        }
    }
}

#[Object]