Function list_deployments

chirpstack/src/storage/fuota.rs:326–396

(
    user_id: Option<Uuid>,
    tenant_id: Option<Uuid>,
    application_id: Option<Uuid>,
    limit: i64,
    offset: i64,
)

}

pub async fn list_deployments(
    user_id: Option<Uuid>,
    tenant_id: Option<Uuid>,
    application_id: Option<Uuid>,
    limit: i64,
    offset: i64,
) -> Result<Vec<FuotaDeploymentListItem>, Error> {
    let mut q = fuota_deployment::dsl::fuota_deployment
        .inner_join(application::table)
        .select((
            fuota_deployment::id,
            fuota_deployment::created_at,
            fuota_deployment::updated_at,
            fuota_deployment::started_at,
            fuota_deployment::completed_at,
            fuota_deployment::name,
            application::id,
            application::name,
        ))
        .into_boxed();

    // filter by user permissions
    if let Some(user_id) = user_id {
        q = q.filter(dsl::exists(
            user::table
                .filter(
                    user::id
                        .eq(fields::Uuid::from(user_id))
                        .and(user::is_active.eq(true)),
                )
                .filter(
                    user::is_admin.eq(true).or(dsl::exists(
                        tenant_user::table
                            .filter(
                                tenant_user::user_id
                                    .eq(user::id)
                                    .and(tenant_user::tenant_id.eq(application::tenant_id)),
                            )
                            .filter(
                                tenant_user::is_admin
                                    .eq(true)
                                    .or(tenant_user::is_device_admin.eq(true))
                                    .or(dsl::exists(
                                        tenant_user_application::table.filter(
                                            tenant_user_application::user_id.eq(user::id).and(
                                                tenant_user_application::application_id
                                                    .eq(application::id),
                                            ),
                                        ),
                                    )),
                            ),
                    )),
                ),
        ));
    }

    if let Some(tenant_id) = tenant_id {
        q = q.filter(application::tenant_id.eq(fields::Uuid::from(tenant_id)));