backbone_bucket/presentation/http/

stored_file_handler.rs

//! StoredFile REST handlers
//!
//! Generated by metaphor-schema. Do not edit manually.
//!
//! Uses Axum and backbone-core's BackboneCrudHandler for all 12 CRUD endpoints.

use std::collections::HashMap;
use std::sync::Arc;

use axum::Router;
use serde::{Deserialize, Serialize};
use uuid::Uuid;
use chrono::{DateTime, Utc};

// Backbone framework imports
use backbone_core::http::{ApiResponse, BackboneCrudHandler};

// Auth integration (optional)
use backbone_auth::middleware::AuthContext;
#[cfg(feature = "auth")]
use backbone_auth::AuthMiddleware;

// Domain imports
use crate::domain::entity::*;
use crate::application::service::{StoredFileService, ServiceError};

// DTO imports
use crate::presentation::dto::{CreateStoredFileDto, UpdateStoredFileDto, PatchStoredFileDto, StoredFileResponseDto};

use crate::domain::state_machine::{StoredFileState, StoredFileStateMachine, StoredFileTransition};

/// Application error type
#[derive(Debug, thiserror::Error)]
pub enum StoredFileError {
    #[error("Not found: {0}")]
    NotFound(String),
    #[error("Validation error: {0}")]
    Validation(String),
    #[error("Database error: {0}")]
    Database(String),
    #[error("Internal error: {0}")]
    Internal(String),
    // Domain-specific errors from hook rules
    #[error("File path too long (max 1024 characters): {0}")]
    PathTooLong(String),
    #[error("Path traversal not allowed: {0}")]
    PathTraversal(String),
    #[error("File name too long (max 255 characters): {0}")]
    FilenameTooLong(String),
    #[error("Invalid MIME type format: {0}")]
    InvalidMimeType(String),
    #[error("Cannot update purged files: {0}")]
    FilePurged(String),
    #[error("Only admins can modify quarantined files: {0}")]
    QuarantineRestricted(String),
}

impl From<ServiceError> for StoredFileError {
    fn from(err: ServiceError) -> Self {
        match err {
            ServiceError::NotFound => Self::NotFound(err.to_string()),
            ServiceError::Validation(ref msg) => Self::Validation(msg.clone()),
            ServiceError::AlreadyExists(ref msg) => Self::Validation(msg.clone()),
            ServiceError::Repository(ref e) => Self::Database(e.to_string()),
            ServiceError::Internal(ref msg) => Self::Internal(msg.clone()),
            ServiceError::Violations(_) => Self::Validation(err.to_string()),
        }
    }
}

impl axum::response::IntoResponse for StoredFileError {
    fn into_response(self) -> axum::response::Response {
        use axum::http::StatusCode;
        use axum::Json;

        let (status, code) = match &self {
            Self::NotFound(_) => (StatusCode::NOT_FOUND, "STOREDFILE_NOT_FOUND"),
            Self::Validation(_) => (StatusCode::BAD_REQUEST, "STOREDFILE_VALIDATION_ERROR"),
            Self::Database(_) => (StatusCode::INTERNAL_SERVER_ERROR, "STOREDFILE_DATABASE_ERROR"),
            Self::Internal(_) => (StatusCode::INTERNAL_SERVER_ERROR, "STOREDFILE_INTERNAL_ERROR"),
            Self::PathTooLong(_) => (StatusCode::UNPROCESSABLE_ENTITY, "STOREDFILE_PATH_TOO_LONG"),
            Self::PathTraversal(_) => (StatusCode::UNPROCESSABLE_ENTITY, "STOREDFILE_PATH_TRAVERSAL"),
            Self::FilenameTooLong(_) => (StatusCode::UNPROCESSABLE_ENTITY, "STOREDFILE_FILENAME_TOO_LONG"),
            Self::InvalidMimeType(_) => (StatusCode::UNPROCESSABLE_ENTITY, "STOREDFILE_INVALID_MIME_TYPE"),
            Self::FilePurged(_) => (StatusCode::UNPROCESSABLE_ENTITY, "STOREDFILE_FILE_PURGED"),
            Self::QuarantineRestricted(_) => (StatusCode::UNPROCESSABLE_ENTITY, "STOREDFILE_QUARANTINE_RESTRICTED"),
        };

        let body = serde_json::json!({
            "success": false,
            "error": code,
            "message": self.to_string(),
        });

        (status, Json(body)).into_response()
    }
}

/// Domain-specific error codes for StoredFile
pub mod stored_file_errors {
    pub const PATH_TOO_LONG: &str = "STOREDFILE_PATH_TOO_LONG";
    pub const PATH_TRAVERSAL: &str = "STOREDFILE_PATH_TRAVERSAL";
    pub const FILENAME_TOO_LONG: &str = "STOREDFILE_FILENAME_TOO_LONG";
    pub const INVALID_MIME_TYPE: &str = "STOREDFILE_INVALID_MIME_TYPE";
    pub const FILE_PURGED: &str = "STOREDFILE_FILE_PURGED";
    pub const QUARANTINE_RESTRICTED: &str = "STOREDFILE_QUARANTINE_RESTRICTED";
}

// =============================================================================
// Route Configuration
// =============================================================================

/// Create Axum router with all 16 Backbone endpoints for StoredFile.
///
/// # Routes
///
/// | Method | Path | Description |
/// |--------|------|-------------|
/// | GET | /stored_files | List with pagination |
/// | POST | /stored_files | Create new |
/// | GET | /stored_files/:id | Get by ID |
/// | PUT | /stored_files/:id | Full update |
/// | PATCH | /stored_files/:id | Partial update |
/// | DELETE | /stored_files/:id | Soft delete |
/// | POST | /stored_files/bulk | Bulk create |
/// | POST | /stored_files/upsert | Upsert |
/// | GET | /stored_files/trash | List deleted |
/// | POST | /stored_files/:id/restore | Restore |
/// | DELETE | /stored_files/empty | Empty trash |
/// | GET | /stored_files/:id/deleted | Get deleted by ID |
/// | DELETE | /stored_files/trash/:id | Permanent delete from trash |
/// | GET | /stored_files/count | Count active entities |
/// | GET | /stored_files/trash/count | Count deleted entities |
///
/// # Example
///
/// ```text
/// let service = Arc::new(StoredFileService::with_repository(repository));
/// let router = create_stored_file_routes(service);
/// ```
pub fn create_stored_file_routes(service: Arc<StoredFileService>) -> Router {
    BackboneCrudHandler::<StoredFileService, StoredFile, CreateStoredFileDto, UpdateStoredFileDto, StoredFileResponseDto>::routes(
        service,
        "/stored_files",
    )
}

/// Create Axum router with only the read (GET) endpoints for StoredFile.
///
/// Safe for public, unauthenticated exposure (e.g., reference data).
/// Mutations must be served separately via `create_stored_file_write_routes`,
/// typically wrapped in an auth middleware layer.
pub fn create_stored_file_read_routes(service: Arc<StoredFileService>) -> Router {
    BackboneCrudHandler::<StoredFileService, StoredFile, CreateStoredFileDto, UpdateStoredFileDto, StoredFileResponseDto>::read_routes(
        service,
        "/stored_files",
    )
}

/// Create Axum router with only the write (mutation) endpoints for StoredFile.
///
/// These routes must NOT be publicly exposed. Wrap them with an auth
/// middleware before nesting into the application router.
///
/// # This is unguarded generic CRUD, not a validated write path
///
/// These are plain create/update/patch/delete mutations over the entity row —
/// they bypass all business invariants. If the module exposes a validated write
/// service (e.g. a command router over its domain engine), serve THAT instead
/// for any mutation that must respect domain rules.
pub fn create_stored_file_write_routes(service: Arc<StoredFileService>) -> Router {
    BackboneCrudHandler::<StoredFileService, StoredFile, CreateStoredFileDto, UpdateStoredFileDto, StoredFileResponseDto>::write_routes(
        service,
        "/stored_files",
    )
}

/// Create authenticated routes with auth middleware.
///
/// Requires the `auth` feature flag. The `AuthMiddleware` implementation
/// is responsible for extracting and validating tokens, then providing
/// an `AuthContext` via request extensions.
#[cfg(feature = "auth")]
pub fn create_protected_stored_file_routes<A: AuthMiddleware + Send + Sync + 'static>(
    service: Arc<StoredFileService>,
    auth: Arc<A>,
) -> Router {
    use axum::middleware;
    use axum::response::IntoResponse;

    let auth_layer = auth.clone();
    create_stored_file_routes(service)
        .layer(middleware::from_fn(move |mut req: axum::extract::Request, next: axum::middleware::Next| {
            let auth = auth_layer.clone();
            async move {
                let token = req.headers()
                    .get(axum::http::header::AUTHORIZATION)
                    .and_then(|h| h.to_str().ok())
                    .and_then(|raw| raw.strip_prefix("Bearer ").or_else(|| raw.strip_prefix("bearer ")))
                    .unwrap_or("");
                match auth.authenticate(token).await {
                    Ok(ctx) => {
                        req.extensions_mut().insert(ctx);
                        next.run(req).await
                    }
                    Err(_) => {
                        (axum::http::StatusCode::UNAUTHORIZED,
                         axum::Json(serde_json::json!({
                             "success": false,
                             "error": "unauthorized",
                             "message": "Authentication required"
                         }))
                        ).into_response()
                    }
                }
            }
        }))
}

// =============================================================================
// State Transition Handlers
// =============================================================================

/// Execute complete_upload transition on a StoredFile.
///
/// POST /stored_files/:id/transitions/complete_upload
pub async fn complete_upload_transition(
    axum::extract::State(service): axum::extract::State<Arc<StoredFileService>>,
    axum::extract::Path(id): axum::extract::Path<String>,
    auth: Option<axum::Extension<AuthContext>>,
) -> impl axum::response::IntoResponse {
    use axum::{http::StatusCode, Json};

    // Get current entity
    let entity = match service.get_by_id(&id).await {
        Ok(Some(e)) => e,
        Ok(None) => return (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => return (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    };

    // Check permission
    let Some(axum::Extension(auth)) = auth else {
        return (StatusCode::UNAUTHORIZED, Json(ApiResponse::<StoredFileResponseDto>::error("A transition needs an authenticated caller")));
    };
    {
        let allowed_roles = StoredFileTransition::CompleteUpload.allowed_roles();
        let granted = |required: &str| auth.permissions.iter().any(|p| {
            let (have, want): (Vec<&str>, Vec<&str>) = (p.split(':').collect(), required.split(':').collect());
            have.iter().enumerate().all(|(i, h)| *h == "*" || want.get(i) == Some(h))
                && (have.len() == want.len() || (have.len() < want.len() && have.last() == Some(&"*")))
        });
        let has_specific_perm = granted("stored_file:transition:complete_upload");
        let has_update_perm = granted("stored_file:update");
        let has_role = auth.roles.iter().any(|r| allowed_roles.contains(&r.as_str()));
        if !has_specific_perm && !has_role {
            if !has_update_perm {
                return (StatusCode::FORBIDDEN, Json(ApiResponse::<StoredFileResponseDto>::error("Insufficient permissions for complete_upload transition")));
            }
            tracing::warn!(target: "backbone::write_guard", entity = "StoredFile", verb = "complete_upload", code = "transition_by_update_permission", "a transition granted only by stored_file:update, running in shadow; it needs stored_file:transition:complete_upload or one of the roles system");
        }
    }

    // Create state machine from entity's actual status and validate transition
    let current_state: StoredFileState = match entity.status.to_string().parse() {
        Ok(s) => s,
        Err(_) => return (StatusCode::CONFLICT, Json(ApiResponse::<StoredFileResponseDto>::error("The stored state is not a state of this machine"))),
    };
    let sm = StoredFileStateMachine::from_state(current_state);
    if !sm.can_transition(StoredFileTransition::CompleteUpload) {
        return (StatusCode::BAD_REQUEST, Json(ApiResponse::<StoredFileResponseDto>::error("Transition not allowed from current state")));
    }

    {
        use backbone_core::row_rule as r;
        let row = &serde_json::to_value(&entity).unwrap_or_default();
        let state = row.get("status").and_then(|v| v.as_str()).unwrap_or_default();
        // Guard: size_bytes > 0
        if ["uploading"].contains(&state) && !r::holds(&r::gt(r::field(row, "size_bytes"), r::Val::Num(0.0_f64))) {
            return (StatusCode::UNPROCESSABLE_ENTITY, Json(ApiResponse::<StoredFileResponseDto>::error("The complete_upload transition's guard does not hold: size_bytes > 0")));
        }
    }

    // Apply transition via partial update
    let mut fields: HashMap<String, serde_json::Value> = HashMap::new();
    fields.insert("status".to_string(), serde_json::Value::String("processing".to_string()));

    match backbone_core::write_guard::as_transition("complete_upload", service.partial_update(&id, fields)).await {
        Ok(Some(updated)) => {
            let response: StoredFileResponseDto = updated.into();
            (StatusCode::OK, Json(ApiResponse::ok(response)))
        }
        Ok(None) => (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    }
}

/// Execute mark_safe transition on a StoredFile.
///
/// POST /stored_files/:id/transitions/mark_safe
pub async fn mark_safe_transition(
    axum::extract::State(service): axum::extract::State<Arc<StoredFileService>>,
    axum::extract::Path(id): axum::extract::Path<String>,
    auth: Option<axum::Extension<AuthContext>>,
) -> impl axum::response::IntoResponse {
    use axum::{http::StatusCode, Json};

    // Get current entity
    let entity = match service.get_by_id(&id).await {
        Ok(Some(e)) => e,
        Ok(None) => return (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => return (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    };

    // Check permission
    let Some(axum::Extension(auth)) = auth else {
        return (StatusCode::UNAUTHORIZED, Json(ApiResponse::<StoredFileResponseDto>::error("A transition needs an authenticated caller")));
    };
    {
        let allowed_roles = StoredFileTransition::MarkSafe.allowed_roles();
        let granted = |required: &str| auth.permissions.iter().any(|p| {
            let (have, want): (Vec<&str>, Vec<&str>) = (p.split(':').collect(), required.split(':').collect());
            have.iter().enumerate().all(|(i, h)| *h == "*" || want.get(i) == Some(h))
                && (have.len() == want.len() || (have.len() < want.len() && have.last() == Some(&"*")))
        });
        let has_specific_perm = granted("stored_file:transition:mark_safe");
        let has_update_perm = granted("stored_file:update");
        let has_role = auth.roles.iter().any(|r| allowed_roles.contains(&r.as_str()));
        if !has_specific_perm && !has_role {
            if !has_update_perm {
                return (StatusCode::FORBIDDEN, Json(ApiResponse::<StoredFileResponseDto>::error("Insufficient permissions for mark_safe transition")));
            }
            tracing::warn!(target: "backbone::write_guard", entity = "StoredFile", verb = "mark_safe", code = "transition_by_update_permission", "a transition granted only by stored_file:update, running in shadow; it needs stored_file:transition:mark_safe or one of the roles system");
        }
    }

    // Create state machine from entity's actual status and validate transition
    let current_state: StoredFileState = match entity.status.to_string().parse() {
        Ok(s) => s,
        Err(_) => return (StatusCode::CONFLICT, Json(ApiResponse::<StoredFileResponseDto>::error("The stored state is not a state of this machine"))),
    };
    let sm = StoredFileStateMachine::from_state(current_state);
    if !sm.can_transition(StoredFileTransition::MarkSafe) {
        return (StatusCode::BAD_REQUEST, Json(ApiResponse::<StoredFileResponseDto>::error("Transition not allowed from current state")));
    }

    {
        use backbone_core::row_rule as r;
        let row = &serde_json::to_value(&entity).unwrap_or_default();
        let state = row.get("status").and_then(|v| v.as_str()).unwrap_or_default();
        // Guard: is_scanned == true && (threat_level == null || threat_level == 'safe')
        if ["processing"].contains(&state) && !r::holds(&r::and(r::eq(r::field(row, "is_scanned"), r::Val::Bool(true)), r::or(r::is_null(r::field(row, "threat_level")), r::eq(r::field(row, "threat_level"), r::text("safe"))))) {
            return (StatusCode::UNPROCESSABLE_ENTITY, Json(ApiResponse::<StoredFileResponseDto>::error("The mark_safe transition's guard does not hold: is_scanned == true && (threat_level == null || threat_level == 'safe')")));
        }
    }

    // Apply transition via partial update
    let mut fields: HashMap<String, serde_json::Value> = HashMap::new();
    fields.insert("status".to_string(), serde_json::Value::String("active".to_string()));

    match backbone_core::write_guard::as_transition("mark_safe", service.partial_update(&id, fields)).await {
        Ok(Some(updated)) => {
            let response: StoredFileResponseDto = updated.into();
            (StatusCode::OK, Json(ApiResponse::ok(response)))
        }
        Ok(None) => (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    }
}

/// Execute quarantine transition on a StoredFile.
///
/// POST /stored_files/:id/transitions/quarantine
pub async fn quarantine_transition(
    axum::extract::State(service): axum::extract::State<Arc<StoredFileService>>,
    axum::extract::Path(id): axum::extract::Path<String>,
    auth: Option<axum::Extension<AuthContext>>,
) -> impl axum::response::IntoResponse {
    use axum::{http::StatusCode, Json};

    // Get current entity
    let entity = match service.get_by_id(&id).await {
        Ok(Some(e)) => e,
        Ok(None) => return (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => return (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    };

    // Check permission
    let Some(axum::Extension(auth)) = auth else {
        return (StatusCode::UNAUTHORIZED, Json(ApiResponse::<StoredFileResponseDto>::error("A transition needs an authenticated caller")));
    };
    {
        let allowed_roles = StoredFileTransition::Quarantine.allowed_roles();
        let granted = |required: &str| auth.permissions.iter().any(|p| {
            let (have, want): (Vec<&str>, Vec<&str>) = (p.split(':').collect(), required.split(':').collect());
            have.iter().enumerate().all(|(i, h)| *h == "*" || want.get(i) == Some(h))
                && (have.len() == want.len() || (have.len() < want.len() && have.last() == Some(&"*")))
        });
        let has_specific_perm = granted("stored_file:transition:quarantine");
        let has_update_perm = granted("stored_file:update");
        let has_role = auth.roles.iter().any(|r| allowed_roles.contains(&r.as_str()));
        if !has_specific_perm && !has_role {
            if !has_update_perm {
                return (StatusCode::FORBIDDEN, Json(ApiResponse::<StoredFileResponseDto>::error("Insufficient permissions for quarantine transition")));
            }
            tracing::warn!(target: "backbone::write_guard", entity = "StoredFile", verb = "quarantine", code = "transition_by_update_permission", "a transition granted only by stored_file:update, running in shadow; it needs stored_file:transition:quarantine or one of the roles system");
        }
    }

    // Create state machine from entity's actual status and validate transition
    let current_state: StoredFileState = match entity.status.to_string().parse() {
        Ok(s) => s,
        Err(_) => return (StatusCode::CONFLICT, Json(ApiResponse::<StoredFileResponseDto>::error("The stored state is not a state of this machine"))),
    };
    let sm = StoredFileStateMachine::from_state(current_state);
    if !sm.can_transition(StoredFileTransition::Quarantine) {
        return (StatusCode::BAD_REQUEST, Json(ApiResponse::<StoredFileResponseDto>::error("Transition not allowed from current state")));
    }

    {
        use backbone_core::row_rule as r;
        let row = &serde_json::to_value(&entity).unwrap_or_default();
        let state = row.get("status").and_then(|v| v.as_str()).unwrap_or_default();
        // Guard: threat_level != null && threat_level != 'safe'
        if ["processing"].contains(&state) && !r::holds(&r::and(r::is_not_null(r::field(row, "threat_level")), r::ne(r::field(row, "threat_level"), r::text("safe")))) {
            return (StatusCode::UNPROCESSABLE_ENTITY, Json(ApiResponse::<StoredFileResponseDto>::error("The quarantine transition's guard does not hold: threat_level != null && threat_level != 'safe'")));
        }
    }

    // Apply transition via partial update
    let mut fields: HashMap<String, serde_json::Value> = HashMap::new();
    fields.insert("status".to_string(), serde_json::Value::String("quarantined".to_string()));

    match backbone_core::write_guard::as_transition("quarantine", service.partial_update(&id, fields)).await {
        Ok(Some(updated)) => {
            let response: StoredFileResponseDto = updated.into();
            (StatusCode::OK, Json(ApiResponse::ok(response)))
        }
        Ok(None) => (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    }
}

/// Execute mark_safe_by_admin transition on a StoredFile.
///
/// POST /stored_files/:id/transitions/mark_safe_by_admin
pub async fn mark_safe_by_admin_transition(
    axum::extract::State(service): axum::extract::State<Arc<StoredFileService>>,
    axum::extract::Path(id): axum::extract::Path<String>,
    auth: Option<axum::Extension<AuthContext>>,
) -> impl axum::response::IntoResponse {
    use axum::{http::StatusCode, Json};

    // Get current entity
    let entity = match service.get_by_id(&id).await {
        Ok(Some(e)) => e,
        Ok(None) => return (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => return (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    };

    // Check permission
    let Some(axum::Extension(auth)) = auth else {
        return (StatusCode::UNAUTHORIZED, Json(ApiResponse::<StoredFileResponseDto>::error("A transition needs an authenticated caller")));
    };
    {
        let allowed_roles = StoredFileTransition::MarkSafeByAdmin.allowed_roles();
        let granted = |required: &str| auth.permissions.iter().any(|p| {
            let (have, want): (Vec<&str>, Vec<&str>) = (p.split(':').collect(), required.split(':').collect());
            have.iter().enumerate().all(|(i, h)| *h == "*" || want.get(i) == Some(h))
                && (have.len() == want.len() || (have.len() < want.len() && have.last() == Some(&"*")))
        });
        let has_specific_perm = granted("stored_file:transition:mark_safe_by_admin");
        let has_update_perm = granted("stored_file:update");
        let has_role = auth.roles.iter().any(|r| allowed_roles.contains(&r.as_str()));
        if !has_specific_perm && !has_role {
            if !has_update_perm {
                return (StatusCode::FORBIDDEN, Json(ApiResponse::<StoredFileResponseDto>::error("Insufficient permissions for mark_safe_by_admin transition")));
            }
            tracing::warn!(target: "backbone::write_guard", entity = "StoredFile", verb = "mark_safe_by_admin", code = "transition_by_update_permission", "a transition granted only by stored_file:update, running in shadow; it needs stored_file:transition:mark_safe_by_admin or one of the roles admin");
        }
    }

    // Create state machine from entity's actual status and validate transition
    let current_state: StoredFileState = match entity.status.to_string().parse() {
        Ok(s) => s,
        Err(_) => return (StatusCode::CONFLICT, Json(ApiResponse::<StoredFileResponseDto>::error("The stored state is not a state of this machine"))),
    };
    let sm = StoredFileStateMachine::from_state(current_state);
    if !sm.can_transition(StoredFileTransition::MarkSafeByAdmin) {
        return (StatusCode::BAD_REQUEST, Json(ApiResponse::<StoredFileResponseDto>::error("Transition not allowed from current state")));
    }

    // Apply transition via partial update
    let mut fields: HashMap<String, serde_json::Value> = HashMap::new();
    fields.insert("status".to_string(), serde_json::Value::String("active".to_string()));

    match backbone_core::write_guard::as_transition("mark_safe_by_admin", service.partial_update(&id, fields)).await {
        Ok(Some(updated)) => {
            let response: StoredFileResponseDto = updated.into();
            (StatusCode::OK, Json(ApiResponse::ok(response)))
        }
        Ok(None) => (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    }
}

/// Execute soft_delete transition on a StoredFile.
///
/// POST /stored_files/:id/transitions/soft_delete
pub async fn soft_delete_transition(
    axum::extract::State(service): axum::extract::State<Arc<StoredFileService>>,
    axum::extract::Path(id): axum::extract::Path<String>,
    auth: Option<axum::Extension<AuthContext>>,
) -> impl axum::response::IntoResponse {
    use axum::{http::StatusCode, Json};

    // Get current entity
    let entity = match service.get_by_id(&id).await {
        Ok(Some(e)) => e,
        Ok(None) => return (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => return (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    };

    // Check permission
    let Some(axum::Extension(auth)) = auth else {
        return (StatusCode::UNAUTHORIZED, Json(ApiResponse::<StoredFileResponseDto>::error("A transition needs an authenticated caller")));
    };
    {
        let allowed_roles = StoredFileTransition::SoftDelete.allowed_roles();
        let granted = |required: &str| auth.permissions.iter().any(|p| {
            let (have, want): (Vec<&str>, Vec<&str>) = (p.split(':').collect(), required.split(':').collect());
            have.iter().enumerate().all(|(i, h)| *h == "*" || want.get(i) == Some(h))
                && (have.len() == want.len() || (have.len() < want.len() && have.last() == Some(&"*")))
        });
        let has_specific_perm = granted("stored_file:transition:soft_delete");
        let has_update_perm = granted("stored_file:update");
        let has_role = auth.roles.iter().any(|r| allowed_roles.contains(&r.as_str()));
        if !has_specific_perm && !has_role {
            if !has_update_perm {
                return (StatusCode::FORBIDDEN, Json(ApiResponse::<StoredFileResponseDto>::error("Insufficient permissions for soft_delete transition")));
            }
            tracing::warn!(target: "backbone::write_guard", entity = "StoredFile", verb = "soft_delete", code = "transition_by_update_permission", "a transition granted only by stored_file:update, running in shadow; it needs stored_file:transition:soft_delete or one of the roles admin, owner");
        }
    }

    // Create state machine from entity's actual status and validate transition
    let current_state: StoredFileState = match entity.status.to_string().parse() {
        Ok(s) => s,
        Err(_) => return (StatusCode::CONFLICT, Json(ApiResponse::<StoredFileResponseDto>::error("The stored state is not a state of this machine"))),
    };
    let sm = StoredFileStateMachine::from_state(current_state);
    if !sm.can_transition(StoredFileTransition::SoftDelete) {
        return (StatusCode::BAD_REQUEST, Json(ApiResponse::<StoredFileResponseDto>::error("Transition not allowed from current state")));
    }

    // Guard `$actor.id == owner_id || $actor.has_role('admin')` not compiled (reads the writer, the time or the row before the write); the transition is not checked against it.
    // Apply transition via partial update
    let mut fields: HashMap<String, serde_json::Value> = HashMap::new();
    fields.insert("status".to_string(), serde_json::Value::String("deleted".to_string()));

    match backbone_core::write_guard::as_transition("soft_delete", service.partial_update(&id, fields)).await {
        Ok(Some(updated)) => {
            let response: StoredFileResponseDto = updated.into();
            (StatusCode::OK, Json(ApiResponse::ok(response)))
        }
        Ok(None) => (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    }
}

/// Execute restore transition on a StoredFile.
///
/// POST /stored_files/:id/transitions/restore
pub async fn restore_transition(
    axum::extract::State(service): axum::extract::State<Arc<StoredFileService>>,
    axum::extract::Path(id): axum::extract::Path<String>,
    auth: Option<axum::Extension<AuthContext>>,
) -> impl axum::response::IntoResponse {
    use axum::{http::StatusCode, Json};

    // Get current entity
    let entity = match service.get_by_id(&id).await {
        Ok(Some(e)) => e,
        Ok(None) => return (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => return (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    };

    // Check permission
    let Some(axum::Extension(auth)) = auth else {
        return (StatusCode::UNAUTHORIZED, Json(ApiResponse::<StoredFileResponseDto>::error("A transition needs an authenticated caller")));
    };
    {
        let allowed_roles = StoredFileTransition::Restore.allowed_roles();
        let granted = |required: &str| auth.permissions.iter().any(|p| {
            let (have, want): (Vec<&str>, Vec<&str>) = (p.split(':').collect(), required.split(':').collect());
            have.iter().enumerate().all(|(i, h)| *h == "*" || want.get(i) == Some(h))
                && (have.len() == want.len() || (have.len() < want.len() && have.last() == Some(&"*")))
        });
        let has_specific_perm = granted("stored_file:transition:restore");
        let has_update_perm = granted("stored_file:update");
        let has_role = auth.roles.iter().any(|r| allowed_roles.contains(&r.as_str()));
        if !has_specific_perm && !has_role {
            if !has_update_perm {
                return (StatusCode::FORBIDDEN, Json(ApiResponse::<StoredFileResponseDto>::error("Insufficient permissions for restore transition")));
            }
            tracing::warn!(target: "backbone::write_guard", entity = "StoredFile", verb = "restore", code = "transition_by_update_permission", "a transition granted only by stored_file:update, running in shadow; it needs stored_file:transition:restore or one of the roles admin, owner");
        }
    }

    // Create state machine from entity's actual status and validate transition
    let current_state: StoredFileState = match entity.status.to_string().parse() {
        Ok(s) => s,
        Err(_) => return (StatusCode::CONFLICT, Json(ApiResponse::<StoredFileResponseDto>::error("The stored state is not a state of this machine"))),
    };
    let sm = StoredFileStateMachine::from_state(current_state);
    if !sm.can_transition(StoredFileTransition::Restore) {
        return (StatusCode::BAD_REQUEST, Json(ApiResponse::<StoredFileResponseDto>::error("Transition not allowed from current state")));
    }

    // Guard `metadata.deleted_at != null && $actor.id == owner_id || $actor.has_role('admin')` not compiled (reads the writer, the time or the row before the write); the transition is not checked against it.
    // Apply transition via partial update
    let mut fields: HashMap<String, serde_json::Value> = HashMap::new();
    fields.insert("status".to_string(), serde_json::Value::String("active".to_string()));

    match backbone_core::write_guard::as_transition("restore", service.partial_update(&id, fields)).await {
        Ok(Some(updated)) => {
            let response: StoredFileResponseDto = updated.into();
            (StatusCode::OK, Json(ApiResponse::ok(response)))
        }
        Ok(None) => (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    }
}

/// Execute purge transition on a StoredFile.
///
/// POST /stored_files/:id/transitions/purge
pub async fn purge_transition(
    axum::extract::State(service): axum::extract::State<Arc<StoredFileService>>,
    axum::extract::Path(id): axum::extract::Path<String>,
    auth: Option<axum::Extension<AuthContext>>,
) -> impl axum::response::IntoResponse {
    use axum::{http::StatusCode, Json};

    // Get current entity
    let entity = match service.get_by_id(&id).await {
        Ok(Some(e)) => e,
        Ok(None) => return (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => return (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    };

    // Check permission
    let Some(axum::Extension(auth)) = auth else {
        return (StatusCode::UNAUTHORIZED, Json(ApiResponse::<StoredFileResponseDto>::error("A transition needs an authenticated caller")));
    };
    {
        let allowed_roles = StoredFileTransition::Purge.allowed_roles();
        let granted = |required: &str| auth.permissions.iter().any(|p| {
            let (have, want): (Vec<&str>, Vec<&str>) = (p.split(':').collect(), required.split(':').collect());
            have.iter().enumerate().all(|(i, h)| *h == "*" || want.get(i) == Some(h))
                && (have.len() == want.len() || (have.len() < want.len() && have.last() == Some(&"*")))
        });
        let has_specific_perm = granted("stored_file:transition:purge");
        let has_update_perm = granted("stored_file:update");
        let has_role = auth.roles.iter().any(|r| allowed_roles.contains(&r.as_str()));
        if !has_specific_perm && !has_role {
            if !has_update_perm {
                return (StatusCode::FORBIDDEN, Json(ApiResponse::<StoredFileResponseDto>::error("Insufficient permissions for purge transition")));
            }
            tracing::warn!(target: "backbone::write_guard", entity = "StoredFile", verb = "purge", code = "transition_by_update_permission", "a transition granted only by stored_file:update, running in shadow; it needs stored_file:transition:purge or one of the roles admin, system");
        }
    }

    // Create state machine from entity's actual status and validate transition
    let current_state: StoredFileState = match entity.status.to_string().parse() {
        Ok(s) => s,
        Err(_) => return (StatusCode::CONFLICT, Json(ApiResponse::<StoredFileResponseDto>::error("The stored state is not a state of this machine"))),
    };
    let sm = StoredFileStateMachine::from_state(current_state);
    if !sm.can_transition(StoredFileTransition::Purge) {
        return (StatusCode::BAD_REQUEST, Json(ApiResponse::<StoredFileResponseDto>::error("Transition not allowed from current state")));
    }

    // Guard `metadata.deleted_at != null && metadata.deleted_at < now() - 30.days` not compiled (`.days` reads a relation or a duration); the transition is not checked against it.
    // Apply transition via partial update
    let mut fields: HashMap<String, serde_json::Value> = HashMap::new();
    fields.insert("status".to_string(), serde_json::Value::String("purged".to_string()));

    match backbone_core::write_guard::as_transition("purge", service.partial_update(&id, fields)).await {
        Ok(Some(updated)) => {
            let response: StoredFileResponseDto = updated.into();
            (StatusCode::OK, Json(ApiResponse::ok(response)))
        }
        Ok(None) => (StatusCode::NOT_FOUND, Json(ApiResponse::<StoredFileResponseDto>::not_found("StoredFile", &id))),
        Err(e) => (StatusCode::INTERNAL_SERVER_ERROR, Json(ApiResponse::<StoredFileResponseDto>::error(e.to_string()))),
    }
}

/// Create routes for state transitions.
pub fn create_stored_file_transition_routes(service: Arc<StoredFileService>) -> Router {
    use axum::routing::post;

    Router::new()
        .route("/stored_files/:id/transitions/complete_upload", post(complete_upload_transition))
        .route("/stored_files/:id/transitions/mark_safe", post(mark_safe_transition))
        .route("/stored_files/:id/transitions/quarantine", post(quarantine_transition))
        .route("/stored_files/:id/transitions/mark_safe_by_admin", post(mark_safe_by_admin_transition))
        .route("/stored_files/:id/transitions/soft_delete", post(soft_delete_transition))
        .route("/stored_files/:id/transitions/restore", post(restore_transition))
        .route("/stored_files/:id/transitions/purge", post(purge_transition))
        .with_state(service)
}