Function copy_to_csv_with_header

nodedb/tests/sql_copy_to.rs:111–129

()

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

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

    let (_dir, out_path) = temp_output_path(".csv");
    srv.exec(&format!(
        "COPY copy_to_csv_hdr TO '{out_path}' WITH (FORMAT csv, HEADER true)"
    ))
    .await
    .expect("COPY TO CSV with header");

    let content = std::fs::read_to_string(&out_path).expect("read output file");
    let lines: Vec<&str> = content.lines().collect();
    // First line is the header.
    assert!(!lines.is_empty(), "expected at least a header line");
    // Should have header + 3 data rows.
    assert_eq!(lines.len(), 4, "expected header + 3 rows");
}

// ── test 4: CSV without header ───────────────────────────────────────────────