Method list_with_selector

crates/openshell-server/src/persistence/postgres.rs:398–429

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

    }

    pub async fn list_with_selector(
        &self,
        object_type: &str,
        label_selector: &str,
        limit: u32,
        offset: u32,
    ) -> PersistenceResult<Vec<ObjectRecord>> {
        use super::parse_label_selector;

        let required_labels = parse_label_selector(label_selector)?;
        let labels_jsonb = serde_json::to_value(&required_labels)
            .map_err(|e| PersistenceError::Encode(format!("failed to serialize labels: {e}")))?;

        let rows = sqlx::query(
            r"
SELECT object_type, id, name, payload, created_at_ms, updated_at_ms, labels, resource_version
FROM objects
WHERE object_type = $1 AND labels @> $2
ORDER BY created_at_ms ASC, name ASC
LIMIT $3 OFFSET $4
",
        )
        .bind(object_type)
        .bind(&labels_jsonb)
        .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 put_policy_revision(
        &self,