Method delete_if

crates/openshell-server/src/persistence/sqlite.rs:231–262

(
        &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 {
                return Err(PersistenceError::Conflict {
                    current_resource_version: Some(record.resource_version),
                });
            }
            Ok(false)
        }
    }

    pub async fn put_scoped(
        &self,