Goal

Add integration tests for media handlers that interact with the database. These tests use in-memory SQLite with AppState { client: None, bucket: None } and do NOT require R2 storage.

File to edit

api/src/media.rs

Setup helper

use crate::AppState;

async fn setup_media_db() -> AppState {
    let db = sqlx::SqlitePool::connect("sqlite::memory:").await.unwrap();
    sqlx::migrate!("../migrations").run(&db).await.unwrap();
    AppState { db, client: None, bucket: None }
}

How to run

cd api && cargo test media

Sub-issues (pick one)

• test: list_media returns empty array when no media exists #86 test: list_media returns empty array when no media exists
• test: list_media filters by MIME type #87 test: list_media filters by MIME type
• test: get_media returns 404 for nonexistent ID #88 test: get_media returns 404 for nonexistent ID