camel-integration-test 0.45.0

//! boot_scenario delegation tests (scenario-shared-boot task 3.1).
//!
//! Unit-test module of the lib target, declared in `src/lib.rs` under
//! `#[cfg(test)]`. Every test is project-based: it writes a temporary
//! project (`Camel.toml`, an optional route file, a `.test.yaml`
//! document parsed through [`crate::parse_scenario_document`]) and
//! boots it through [`crate::boot_scenario`] with an empty
//! [`LayeredEnv`]. Every rejection path here fires before
//! `ctx.start()` (tier security gating, route-file pre-checks,
//! discovery), so no listener teardown is needed.

use std::collections::BTreeMap;

use camel_api::CamelError;

use crate::boot_scenario::boot_scenario;
use crate::env_layers::{LayeredEnv, ambient_std};
use crate::parse_scenario_document;
use crate::{RouteSource, ScenarioAction, ScenarioDocument};

/// A minimal route file: one `direct:` → `log:` route.
const ROUTE: &str = r#"
routes:
  - id: boot-route
    from: direct:start
    steps:
      - to: log:info
"#;

/// A minimal scenario document declaring the route file.
const DOC: &str = r#"
routeFiles: [routes.yaml]
scenario:
  - sleep:
      duration: 1s
"#;

/// Writes a temporary project: `Camel.toml` from `camel_toml`, an
/// optional route file `(name, text)`, and the scenario document
/// `doc`. Returns the project dir and the parsed document.
fn project(
    camel_toml: &str,
    route: Option<(&str, &str)>,
    doc: &str,
) -> (tempfile::TempDir, ScenarioDocument) {
    let dir = tempfile::tempdir().expect("temp dir");
    std::fs::write(dir.path().join("Camel.toml"), camel_toml).expect("write Camel.toml");
    if let Some((name, text)) = route {
        std::fs::write(dir.path().join(name), text).expect("write route file");
    }
    let doc_path = dir.path().join("case.test.yaml");
    std::fs::write(&doc_path, doc).expect("write document");
    let document = parse_scenario_document(&doc_path).expect("document parses");
    (dir, document)
}

/// An empty layered environment: no doc, harness, or passthrough
/// layer, so ambient values can never resolve through it.
fn empty_env() -> LayeredEnv {
    LayeredEnv::new(BTreeMap::new(), BTreeMap::new(), Vec::new(), ambient_std())
}

/// Extracts the error from a rejected boot; panics with `what` when
/// the boot unexpectedly succeeded.
fn expect_boot_error(
    result: Result<crate::boot_scenario::ScenarioRun, CamelError>,
    what: &str,
) -> CamelError {
    match result {
        Ok(_) => panic!("{what}"),
        Err(err) => err,
    }
}

#[tokio::test]
async fn boot_rejects_keycloak_offline() {
    // The keycloak fixture field set from camel-bundles'
    // security_boot tests; the fixture's `{{env:KC}}` secret marker is
    // rejected by the sealed config loader's legacy-brace gate before
    // the tier gate, so the secret is literal here — the gate keys on
    // the section's presence, never on the secret.
    let (dir, doc) = project(
        r#"
[security.keycloak]
server_url = "https://kc.example.com"
realm = "camel"
client_id = "camel-api"
client_secret = "kc-secret"
"#,
        Some(("routes.yaml", ROUTE)),
        DOC,
    );
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "keycloak security must be rejected in the offline tier",
    );
    assert!(
        matches!(err, CamelError::AuthProviderUnavailable(_)),
        "expected AuthProviderUnavailable, got: {err:?}"
    );
}

#[tokio::test]
async fn boot_rejects_oidc_offline() {
    // Minimal `[security.oidc]`: `issuer` is OidcSecurityConfig's only
    // required field.
    let (dir, doc) = project(
        r#"
[security.oidc]
issuer = "https://oidc.example.test"
"#,
        Some(("routes.yaml", ROUTE)),
        DOC,
    );
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "oidc security must be rejected in the offline tier",
    );
    assert!(
        matches!(err, CamelError::AuthProviderUnavailable(_)),
        "expected AuthProviderUnavailable, got: {err:?}"
    );
}

#[tokio::test]
async fn boot_rejects_wasm_security_policies() {
    // Minimal `[security.policies]` entry: the wrapper's only field is
    // the `wasm` map; one policy with its required `path`. The gate
    // fires before any builder call, so the .wasm file need not exist.
    let (dir, doc) = project(
        r#"
[security.policies.wasm.demo]
path = "policies/demo.wasm"
"#,
        Some(("routes.yaml", ROUTE)),
        DOC,
    );
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "wasm security policies must be rejected in the scenario tier",
    );
    assert!(
        matches!(err, CamelError::Config(_)),
        "expected Config, got: {err:?}"
    );
    assert!(
        err.to_string()
            .contains("not supported in the scenario tier"),
        "error must name the v1 tier limitation: {err}"
    );
}

#[tokio::test]
async fn boot_hermetic_env_not_resolved_from_process() {
    // The variable exists only in the process environment; the empty
    // layered environment must not resolve it (edition-2024 unsafe
    // env APIs, same wrapping as the camel-config properties tests).
    unsafe { std::env::set_var("RC_6BSF_HERMETIC", "leak") };
    let route = r#"
routes:
  - id: hermetic
    from: direct:${env:RC_6BSF_HERMETIC}
    steps:
      - to: log:info
"#;
    let (dir, doc) = project("# minimal\n", Some(("routes.yaml", route)), DOC);
    let result = boot_scenario(&doc, dir.path(), &empty_env()).await;
    unsafe { std::env::remove_var("RC_6BSF_HERMETIC") };
    let err = expect_boot_error(
        result,
        "the process environment must not resolve scenario placeholders",
    );
    assert!(
        matches!(err, CamelError::Config(_)),
        "expected the unresolved-placeholder Config error, got: {err:?}"
    );
    let display = err.to_string();
    assert!(
        display.contains("RC_6BSF_HERMETIC"),
        "error must name the variable: {display}"
    );
    assert!(
        display.contains("no layer of the scenario environment defines it"),
        "error must name the hermetic resolution failure: {display}"
    );
}

#[tokio::test]
async fn boot_missing_route_file_names_the_file() {
    let doc = r#"
routeFiles: [nope.yaml]
scenario:
  - sleep:
      duration: 1s
"#;
    let (dir, doc) = project("# minimal\n", None, doc);
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "a missing declared route file must fail the boot",
    );
    assert!(
        matches!(err, CamelError::Io(_)),
        "expected Io, got: {err:?}"
    );
    assert!(
        err.to_string().contains("nope.yaml"),
        "error must name the missing file: {err}"
    );
}

/// A nested scenario document declaring its route file relative to
/// itself: the file lives next to the document, not at the root.
const NESTED_DOC: &str = r#"
routeFiles: [local.yaml]
scenario:
  - sleep:
      duration: 1s
"#;

/// A nested scenario document declaring its route file against the
/// project root's route space (`rr/` under the `Camel.toml` dir).
const NESTED_FROM_ROOT_DOC: &str = r#"
routeFilesFromRoot: [rr/root-route.yaml]
scenario:
  - sleep:
      duration: 1s
"#;

#[tokio::test]
async fn boot_root_walks_to_ancestor() {
    // rc-jjzy5, nested tree: the sealed `Camel.toml` and the
    // `routeFilesFromRoot` file live at the ANCESTOR root; the
    // relative-routeFiles file lives only next to the document. One
    // document declares exactly one route source
    // (`RouteSourceConflict`), so the pair boots twice: each `Ok`
    // proves its declared file was found and parsed at its own anchor
    // — the document directory for `routeFiles`, the passed root for
    // `routeFilesFromRoot`. Anchoring `routeFiles` at the root (the
    // pre-fix behavior) misses `local.yaml` and fails the first boot.
    let root = tempfile::tempdir().expect("temp dir");
    let sub = root.path().join("sub");
    std::fs::create_dir(&sub).expect("mkdir sub");
    std::fs::create_dir_all(root.path().join("rr")).expect("mkdir rr");
    std::fs::write(root.path().join("Camel.toml"), "# minimal\n").expect("write Camel.toml");
    std::fs::write(root.path().join("rr/root-route.yaml"), ROUTE).expect("write root route");
    std::fs::write(sub.join("local.yaml"), ROUTE).expect("write local route");

    let files_path = sub.join("doc.test.yaml");
    std::fs::write(&files_path, NESTED_DOC).expect("write document");
    let files_doc = parse_scenario_document(&files_path).expect("document parses");

    let from_root_path = sub.join("from-root.test.yaml");
    std::fs::write(&from_root_path, NESTED_FROM_ROOT_DOC).expect("write document");
    let from_root_doc = parse_scenario_document(&from_root_path).expect("document parses");

    boot_scenario(&files_doc, root.path(), &empty_env())
        .await
        .expect("relative routeFiles must anchor at the document directory");
    boot_scenario(&from_root_doc, root.path(), &empty_env())
        .await
        .expect("routeFilesFromRoot must follow the resolved root");
}

#[tokio::test]
async fn route_files_anchor_to_doc_dir() {
    // rc-jjzy5: the route file exists ONLY next to the nested
    // document; resolving relative `routeFiles` against the boot root
    // would miss it and fail the boot.
    let root = tempfile::tempdir().expect("temp dir");
    let sub = root.path().join("sub");
    std::fs::create_dir(&sub).expect("mkdir sub");
    std::fs::write(root.path().join("Camel.toml"), "# minimal\n").expect("write Camel.toml");
    std::fs::write(sub.join("local.yaml"), ROUTE).expect("write local route");
    let doc_path = sub.join("case.test.yaml");
    std::fs::write(&doc_path, NESTED_DOC).expect("write document");
    let doc = parse_scenario_document(&doc_path).expect("document parses");

    boot_scenario(&doc, root.path(), &empty_env())
        .await
        .expect("the colocated route file must load from the document directory");
}

#[tokio::test]
async fn boot_inline_routes_still_rejected() {
    // The load-time doc gate (rc-9dpx) rejects inline route sources
    // inside `parse_scenario_document`, so the boot-level rejection is
    // reachable only through a directly-constructed document — exactly
    // the defense-in-depth path this test keeps covered.
    let routes = camel_dsl::parse_yaml(
        "routes:\n  - id: inline-route\n    from: direct:start\n    steps:\n      - to: log:info\n",
    )
    .expect("inline routes parse");
    let doc = ScenarioDocument {
        source_path: std::path::PathBuf::new(),
        route_source: RouteSource::Inline(routes),
        scenario: vec![ScenarioAction::Sleep {
            duration: std::time::Duration::from_secs(1),
        }],
        partners: None,
        env: None,
        env_passthrough: None,
        profile: None,
        send_deadline: None,
        inbound: None,
        logs: None,
    };
    let dir = tempfile::tempdir().expect("temp dir");
    std::fs::write(dir.path().join("Camel.toml"), "# minimal\n").expect("write Camel.toml");
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "inline route sources must not boot in v1",
    );
    assert!(
        matches!(err, CamelError::Config(_)),
        "expected Config, got: {err:?}"
    );
    assert!(
        err.to_string()
            .contains("inline route sources cannot boot in v1"),
        "error must keep the inline-routes message: {err}"
    );
}

/// The `inbound:` rejection without the `http` feature, mirroring the
/// inline-routes defense-in-depth path.
#[cfg(not(feature = "http"))]
#[tokio::test]
async fn boot_rejects_inbound_without_http_feature() {
    // The load-time doc gate rejects `inbound:` without the `http`
    // feature inside `parse_scenario_document`, so the boot-level
    // rejection is reachable only through a directly-constructed
    // document — the same defense-in-depth path
    // `boot_inline_routes_still_rejected` keeps covered.
    let doc = ScenarioDocument {
        source_path: std::path::PathBuf::new(),
        route_source: RouteSource::RouteFiles(vec!["routes.yaml".into()]),
        scenario: vec![ScenarioAction::Sleep {
            duration: std::time::Duration::from_secs(1),
        }],
        partners: None,
        env: None,
        env_passthrough: None,
        profile: None,
        send_deadline: None,
        inbound: Some(crate::InboundListener {
            bind_var: "INBOUND".to_string(),
        }),
        logs: None,
    };
    let dir = tempfile::tempdir().expect("temp dir");
    std::fs::write(dir.path().join("Camel.toml"), "# minimal\n").expect("write Camel.toml");
    std::fs::write(dir.path().join("routes.yaml"), ROUTE).expect("write route file");
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "an inbound document must not boot without the http feature",
    );
    assert!(
        matches!(err, CamelError::Config(_)),
        "expected Config, got: {err:?}"
    );
    assert!(
        err.to_string().contains("http` feature"),
        "error must name the missing feature: {err}"
    );
}

#[tokio::test]
async fn boot_rejects_test_suffix_route_file() {
    // Discovery's reserved-suffix gate silently skips `.test.yaml`/
    // `.test.yml` files (they name `camel test` documents, not
    // routes); a document that explicitly declares one must fail the
    // boot instead of starting zero routes.
    let doc = r#"
routeFiles: [routes.test.yaml]
scenario:
  - sleep:
      duration: 1s
"#;
    let (dir, doc) = project("# minimal\n", Some(("routes.test.yaml", ROUTE)), doc);
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "a reserved-suffix route file must fail the boot",
    );
    assert!(
        matches!(err, CamelError::Config(_)),
        "expected Config, got: {err:?}"
    );
    let display = err.to_string();
    assert!(
        display.contains("routes.test.yaml"),
        "error must name the declared file: {display}"
    );
    assert!(
        display.contains("`camel test`"),
        "error must carry the `camel test` guidance: {display}"
    );
}

#[tokio::test]
async fn boot_rejects_job_suffix_route_file() {
    // Twin of the test-suffix case for the job family: a declared
    // `.job.yaml` route file fails the boot with `camel job` guidance.
    let doc = r#"
routeFiles: [routes.job.yaml]
scenario:
  - sleep:
      duration: 1s
"#;
    let (dir, doc) = project("# minimal\n", Some(("routes.job.yaml", ROUTE)), doc);
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "a reserved-suffix route file must fail the boot",
    );
    assert!(
        matches!(err, CamelError::Config(_)),
        "expected Config, got: {err:?}"
    );
    let display = err.to_string();
    assert!(
        display.contains("routes.job.yaml"),
        "error must name the declared file: {display}"
    );
    assert!(
        display.contains("`camel job`"),
        "error must carry the `camel job` guidance: {display}"
    );
}

/// A scenario document with no `sql:` action: the boot-time sqlite
/// memory lint fires on the datasource config alone, before any action
/// or route is considered. The declared route file need not exist — the
/// lint runs before route discovery.
const NO_SQL_DOC: &str = r#"
routeFiles: [routes.yaml]
scenario:
  - sleep:
      duration: 1s
"#;

/// Asserts the boot error is NOT the sql-memory-not-shared lint,
/// panicking with `what` when it is.
fn assert_not_memory_lint(
    result: Result<crate::boot_scenario::ScenarioRun, CamelError>,
    what: &str,
) {
    if let Err(err) = result {
        let display = err.to_string();
        assert!(
            !display.contains(crate::SQL_MEMORY_NOT_SHARED),
            "{what}: unexpected sql-memory-not-shared lint: {display}"
        );
    }
}

#[tokio::test]
async fn bare_memory_sqlite_rejected() {
    // A bare `sqlite::memory:` URL gives every pooled connection its
    // own private in-memory database; the boot must reject it before
    // any context preparation, naming the datasource (never the URL).
    let (dir, doc) = project(
        r#"
[datasources.appdb]
db_url = "sqlite::memory:"
"#,
        None,
        NO_SQL_DOC,
    );
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "a bare sqlite :memory: datasource must fail the boot",
    );
    assert!(
        matches!(err, CamelError::Config(_)),
        "expected Config, got: {err:?}"
    );
    let display = err.to_string();
    assert!(
        display.contains(crate::SQL_MEMORY_NOT_SHARED),
        "error must carry the sql-memory-not-shared key: {display}"
    );
    assert!(
        display.contains("appdb"),
        "error must name the datasource: {display}"
    );
}

#[tokio::test]
async fn shared_cache_memory_sqlite_passes_lint() {
    // `?cache=shared` makes all connections in the process share one
    // in-memory database, so the lint must not fire. The boot may still
    // fail later for unrelated reasons, so only the absence of the lint
    // is asserted.
    let (dir, doc) = project(
        r#"
[datasources.appdb]
db_url = "sqlite::memory:?cache=shared"
"#,
        None,
        NO_SQL_DOC,
    );
    assert_not_memory_lint(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "a shared-cache sqlite :memory: datasource must pass the lint",
    );
}

#[tokio::test]
async fn file_backed_sqlite_unaffected() {
    // A file-backed sqlite URL is not an in-memory database at all; the
    // lint must not fire.
    let (dir, doc) = project(
        r#"
[datasources.appdb]
db_url = "sqlite:file:/tmp/x.db"
"#,
        None,
        NO_SQL_DOC,
    );
    assert_not_memory_lint(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "a file-backed sqlite datasource must pass the lint",
    );
}

/// The lint is a config-shape check, so it runs even in a build without
/// the `sql` feature.
#[cfg(not(feature = "sql"))]
#[tokio::test]
async fn lint_is_ungated() {
    let (dir, doc) = project(
        r#"
[datasources.appdb]
db_url = "sqlite::memory:"
"#,
        None,
        NO_SQL_DOC,
    );
    let err = expect_boot_error(
        boot_scenario(&doc, dir.path(), &empty_env()).await,
        "the sqlite memory lint must fire without the sql feature",
    );
    assert!(
        err.to_string().contains(crate::SQL_MEMORY_NOT_SHARED),
        "error must carry the sql-memory-not-shared key: {err}"
    );
}

/// Adversarial boot-freshness tests (bd rc-25lup.4). The "hermetic
/// sqlite is per-boot = safe" claim is verified, not assumed: the boot
/// teardown closes the datasource catalog's pools, a shared-cache
/// sqlite in-memory database dies with its boot, and a later document
/// booting the same alias in the same process starts empty. File-backed
/// state is pinned as the opposite contract — it persists, so the
/// author's clean-first prepare is the isolation mechanism there.
#[cfg(feature = "sql")]
mod boot_freshness {
    use std::sync::Arc;

    use camel_api::datasource::DatasourceCatalog;
    use sqlx::Row;

    use super::{DOC, ROUTE, boot_scenario, empty_env, project};
    use crate::sql_action::{SqlAction, execute_sql_prepare};

    // The landed family convention (camel-cli sql e2e precedent): with
    // the Any driver each pooled connection gets a private in-memory
    // database, so memory fixtures pin `max_connections = 1` to keep
    // CREATE/INSERT/count on one connection.
    const MEMORY_TOML: &str = r#"
[datasources.appdb]
db_url = "sqlite::memory:?cache=shared"
max_connections = 1
"#;

    /// Seeds exactly one row (`label = tag`) through the real prepare
    /// executor — the same path a `sql:` document action takes.
    async fn seed(catalog: &Arc<dyn DatasourceCatalog>, tag: &str) {
        execute_sql_prepare(
            catalog,
            &SqlAction {
                datasource: "appdb".into(),
                prepare: vec![
                    "CREATE TABLE IF NOT EXISTS seeded (id INTEGER PRIMARY KEY, label TEXT)".into(),
                    format!("INSERT INTO seeded (label) VALUES ('{tag}')"),
                ],
            },
        )
        .await
        .expect("seed prepare");
    }

    /// Counts the `seeded` rows through the catalog's pool.
    async fn count(catalog: &Arc<dyn DatasourceCatalog>) -> i64 {
        let handle = catalog.get_pool("appdb").await.expect("pool");
        let pool = handle.downcast::<sqlx::AnyPool>().expect("any pool");
        let row = sqlx::query("SELECT COUNT(*) FROM seeded")
            .fetch_one(&*pool)
            .await
            .expect("count query");
        row.try_get::<i64, usize>(0).expect("count as i64")
    }

    #[tokio::test]
    async fn second_boot_over_same_memory_alias_starts_empty() {
        let (dir, doc) = project(MEMORY_TOML, Some(("routes.yaml", ROUTE)), DOC);

        // Boot A seeds one row and tears down.
        let mut run_a = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot A");
        let catalog_a = run_a.boot.datasource_catalog();
        seed(&catalog_a, "a").await;
        assert_eq!(
            count(&catalog_a).await,
            1,
            "boot A must see its own seeded row"
        );
        run_a
            .boot
            .shutdown(&mut run_a.ctx)
            .await
            .expect("shutdown A");
        drop(run_a);

        // Boot B: same project, same alias, same process. The in-memory
        // database must have died with boot A's pools — only B's own
        // row may exist.
        let mut run_b = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot B");
        let catalog_b = run_b.boot.datasource_catalog();
        seed(&catalog_b, "b").await;
        let count_b = count(&catalog_b).await;
        assert_eq!(
            count_b, 1,
            "boot B must start from an empty database — boot A's rows leaked across boots"
        );
        run_b
            .boot
            .shutdown(&mut run_b.ctx)
            .await
            .expect("shutdown B");
    }

    /// Named shared-memory URIs (`file:memdb_x?mode=memory&cache=shared`)
    /// genuinely share across connections AND across parses — the only
    /// URL shape where a lingering boot-A connection leaks rows into a
    /// later boot over the same URI. The teardown close seam is
    /// load-bearing here: remove the `close_all` step and this test
    /// fails with boot B counting boot A's rows (bd rc-25lup.4).
    #[tokio::test]
    async fn named_shared_memory_uri_dies_with_its_boot() {
        // `sqlite:file:` matches no factory scheme prefix, so the
        // provider key pins the sqlx factory explicitly.
        const NAMED_TOML: &str = r#"
[datasources.appdb]
db_url = "sqlite:file:memdb_isolation_probe?mode=memory&cache=shared"
max_connections = 1
provider = "sqlx"
"#;
        let (dir, doc) = project(NAMED_TOML, Some(("routes.yaml", ROUTE)), DOC);

        let mut run_a = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot A");
        let catalog_a = run_a.boot.datasource_catalog();
        seed(&catalog_a, "a").await;
        assert_eq!(count(&catalog_a).await, 1);
        run_a
            .boot
            .shutdown(&mut run_a.ctx)
            .await
            .expect("shutdown A");
        drop(run_a);

        let mut run_b = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot B");
        let catalog_b = run_b.boot.datasource_catalog();
        seed(&catalog_b, "b").await;
        let count_b = count(&catalog_b).await;
        assert_eq!(
            count_b, 1,
            "the named shared memory database must die with boot A — B sees A's rows"
        );
        run_b
            .boot
            .shutdown(&mut run_b.ctx)
            .await
            .expect("shutdown B");
    }

    #[tokio::test]
    async fn shutdown_closes_the_datasource_pools() {
        let (dir, doc) = project(MEMORY_TOML, Some(("routes.yaml", ROUTE)), DOC);

        let mut run = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot");
        let catalog = run.boot.datasource_catalog();
        seed(&catalog, "x").await;
        let handle = catalog.get_pool("appdb").await.expect("pool");
        let pool = handle.downcast::<sqlx::AnyPool>().expect("any pool");

        run.boot.shutdown(&mut run.ctx).await.expect("shutdown");

        assert!(
            pool.is_closed(),
            "boot teardown must close the datasource pools (bd rc-25lup.4)"
        );
    }

    #[tokio::test]
    async fn file_backed_state_persists_across_boots() {
        let (dir, doc) = project("", Some(("routes.yaml", ROUTE)), DOC);
        // `sqlite://<abs path>?mode=rwc` matches the factory's
        // `sqlite://` prefix; `mode=rwc` lets the first boot create the
        // file in the project tempdir.
        let camel_toml = format!(
            "[datasources.appdb]\ndb_url = \"sqlite://{}/shared.db?mode=rwc\"\n",
            dir.path().display()
        );
        std::fs::write(dir.path().join("Camel.toml"), camel_toml).expect("rewrite Camel.toml");

        // Boot A seeds one row into the file and tears down.
        let mut run_a = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot A");
        let catalog_a = run_a.boot.datasource_catalog();
        seed(&catalog_a, "a").await;
        run_a
            .boot
            .shutdown(&mut run_a.ctx)
            .await
            .expect("shutdown A");
        drop(run_a);

        // Boot B over the same file: A's row IS visible — durable
        // datasources are outside the per-boot freshness guarantee, and
        // the document's clean-first prepare owns isolation.
        let mut run_b = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot B");
        let catalog_b = run_b.boot.datasource_catalog();
        let count_b = count(&catalog_b).await;
        assert_eq!(
            count_b, 1,
            "file-backed rows persist across boots — the clean-first idiom owns isolation"
        );
        run_b
            .boot
            .shutdown(&mut run_b.ctx)
            .await
            .expect("shutdown B");
    }

    /// The N-connection sharing contract behind the named-URI
    /// convention (bd rc-gcf9n): with
    /// `sqlite:file:memdb_x?mode=memory&cache=shared` every pooled
    /// connection shares one named in-memory database, so
    /// `max_connections` is selected for the workload instead of
    /// pinned at 1. Proved through the real scenario boot: a row
    /// written via one acquired connection is visible via a second,
    /// while the freshness close seam keeps a later boot empty.
    #[tokio::test]
    async fn named_memory_uri_shares_across_pool_connections() {
        // `sqlite:file:` matches no factory scheme prefix, so the
        // provider key pins the sqlx factory explicitly.
        const NAMED_TOML: &str = r#"
[datasources.appdb]
db_url = "sqlite:file:memdb_sharing_probe?mode=memory&cache=shared"
max_connections = 3
provider = "sqlx"
"#;
        let (dir, doc) = project(NAMED_TOML, Some(("routes.yaml", ROUTE)), DOC);

        let mut run_a = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot A");
        let catalog_a = run_a.boot.datasource_catalog();
        let handle_a = catalog_a.get_pool("appdb").await.expect("pool");
        let pool_a = handle_a.downcast::<sqlx::AnyPool>().expect("any pool");

        // Holding conn A forces the next acquire to hand out a
        // distinct pooled connection. The acquire is timeout-wrapped
        // so a broken pool fails fast instead of hanging the suite.
        let mut conn_a = pool_a.acquire().await.expect("conn A");
        let mut conn_b = tokio::time::timeout(std::time::Duration::from_secs(10), pool_a.acquire())
            .await
            .expect("conn B acquire must not hang")
            .expect("conn B");

        // Schema mirrors `seed`'s, but the writes go through conn A
        // itself: this test targets the pool, not the prepare executor.
        sqlx::query("CREATE TABLE IF NOT EXISTS seeded (id INTEGER PRIMARY KEY, label TEXT)")
            .execute(&mut *conn_a)
            .await
            .expect("create via conn A");
        sqlx::query("INSERT INTO seeded (label) VALUES ('a')")
            .execute(&mut *conn_a)
            .await
            .expect("insert via conn A");

        let row = sqlx::query("SELECT COUNT(*) FROM seeded")
            .fetch_one(&mut *conn_b)
            .await
            .expect("count via conn B");
        let count_via_b = row.try_get::<i64, usize>(0).expect("count as i64");
        assert_eq!(
            count_via_b, 1,
            "the row written via conn A must be visible via conn B — \
             the named shared-memory database must share across pool connections"
        );
        drop(conn_a);
        drop(conn_b);

        run_a
            .boot
            .shutdown(&mut run_a.ctx)
            .await
            .expect("shutdown A");
        drop(run_a);

        // Same document, same URI, same process: the close seam must
        // still hold — boot A's shared database dies with its pools,
        // so boot B counts only its own row.
        let mut run_b = boot_scenario(&doc, dir.path(), &empty_env())
            .await
            .expect("boot B");
        let catalog_b = run_b.boot.datasource_catalog();
        seed(&catalog_b, "b").await;
        let count_b = count(&catalog_b).await;
        assert_eq!(
            count_b, 1,
            "boot B must start from an empty database — boot A's shared rows leaked across boots"
        );
        run_b
            .boot
            .shutdown(&mut run_b.ctx)
            .await
            .expect("shutdown B");
    }
}