Function copy_to_query_form

nodedb/tests/sql_copy_to.rs:155–171

()

#[tokio::test]
async fn copy_to_query_form() {
    let srv = TestServer::start().await;

    seed_collection(&srv, "copy_to_query").await;

    let (_dir, out_path) = temp_output_path(".ndjson");
    // Export only rows where id < 3.
    srv.exec(&format!(
        "COPY (SELECT * FROM copy_to_query WHERE id < 3) TO '{out_path}'"
    ))
    .await
    .expect("COPY query-form TO NDJSON");

    let content = std::fs::read_to_string(&out_path).expect("read output file");
    let count = content.lines().filter(|l| !l.trim().is_empty()).count();
    assert_eq!(count, 2, "expected 2 rows matching id < 3");
}

// ── test 6: path traversal rejection ────────────────────────────────────────