Method load

backend/src/psql/organization.rs:54–73

(&self, ids: &[String])

    type Error = Error;

    async fn load(&self, ids: &[String]) -> Result<HashMap<String, Self::Value>> {
        log::debug!("batch load organizations: {:?}", ids);

        let rows = sqlx::query_as::<_, Row>(
            "select
                o.id,
                o.name,
                o.login

            from organizations o
            where o.id = any($1::uuid[]) and (o.owner_id = $2::uuid or o.public)",
        )
        .bind(ids)
        .bind(&self.viewer.user_id)
        .fetch_all(&self.pool)
        .await
        .map_err(Error::from)?;

        try_convert(rows)
    }
}