Method list_by_scope

crates/openshell-server/src/persistence/postgres.rs:371–396

(
        &self,
        object_type: &str,
        scope: &str,
        limit: u32,
        offset: u32,
    )

    }

    pub async fn list_by_scope(
        &self,
        object_type: &str,
        scope: &str,
        limit: u32,
        offset: u32,
    ) -> PersistenceResult<Vec<ObjectRecord>> {
        let rows = sqlx::query(
            r"
SELECT object_type, id, name, payload, created_at_ms, updated_at_ms, labels
FROM objects
WHERE object_type = $1 AND scope = $2
ORDER BY created_at_ms ASC, name ASC
LIMIT $3 OFFSET $4
",
        )
        .bind(object_type)
        .bind(scope)
        .bind(i64::from(limit))
        .bind(i64::from(offset))
        .fetch_all(&self.pool)
        .await
        .map_err(|e| map_db_error(&e))?;

        Ok(rows.into_iter().map(row_to_object_record).collect())
    }

    pub async fn list_with_selector(
        &self,