Method delete_if

crates/openshell-server/src/persistence/postgres.rs:210–242

(
        &self,
        object_type: &str,
        id: &str,
        expected_resource_version: u64,
    )

    }

    pub async fn delete_if(
        &self,
        object_type: &str,
        id: &str,
        expected_resource_version: u64,
    ) -> PersistenceResult<bool> {
        let result = sqlx::query(
            r"
DELETE FROM objects
WHERE object_type = $1 AND id = $2 AND resource_version = $3
",
        )
        .bind(object_type)
        .bind(id)
        .bind(i64::try_from(expected_resource_version).unwrap_or(i64::MAX))
        .execute(&self.pool)
        .await
        .map_err(|e| map_db_error(&e))?;

        if result.rows_affected() > 0 {
            Ok(true)
        } else {
            // Check if object exists to distinguish NotFound from Conflict
            let existing = self.get(object_type, id).await?;
            if let Some(record) = existing {
                Err(PersistenceError::Conflict {
                    current_resource_version: Some(record.resource_version),
                })
            } else {
                Ok(false)
            }
        }
    }

    pub async fn put_scoped(
        &self,