Rebasely Beta: data may be purged

justintypescript-ultra-strict Public

JavaScript · 88 lines · 3.6 KiB · at 503e839

import { test } from "node:test";import assert from "node:assert/strict";import { h, load } from "../../lib/harness.mjs";const { parseCsv } = await load();const parse = (text, required = []) => h.res(() => parseCsv(text, required));const ok = (value) => ({ ok: true, value });const errOf = (r, keys = []) => {  if (r.ok !== false || !r.error) return r;  const out = { kind: r.error.kind };  for (const k of keys) out[k] = r.error[k];  return out;};test("simple rows", () => {  assert.deepEqual(    parse("name,age\nann,30\nbob,41", ["name"]),    ok([{ name: "ann", age: "30" }, { name: "bob", age: "41" }]),  );});test("trailing line break and CRLF", () => {  assert.deepEqual(parse("a,b\n1,2\n"), ok([{ a: "1", b: "2" }]));  assert.deepEqual(parse("a,b\r\n1,2\r\n3,4\r\n"), ok([{ a: "1", b: "2" }, { a: "3", b: "4" }]));});test("quoted fields with commas, escaped quotes and line breaks", () => {  assert.deepEqual(    parse('id,note\n1,"hello, world"\n2,"say ""hi"""\n3,"two\nlines"\n'),    ok([      { id: "1", note: "hello, world" },      { id: "2", note: 'say "hi"' },      { id: "3", note: "two\nlines" },    ]),  );  assert.deepEqual(parse('a\r\n"x\r\ny"\r\n'), ok([{ a: "x\r\ny" }]));});test("quoted header fields", () => {  assert.deepEqual(parse('"first name","a,b"\nann,x\n', ["first name", "a,b"]), ok([{ "first name": "ann", "a,b": "x" }]));});test("blank lines are skipped", () => {  assert.deepEqual(parse("a,b\n\n1,2\n\n\n3,4\n\n"), ok([{ a: "1", b: "2" }, { a: "3", b: "4" }]));  assert.deepEqual(parse("\n\na\n1\n"), ok([{ a: "1" }]));});test("empty fields are kept as empty strings", () => {  assert.deepEqual(parse("a,b,c\n,,\n1,,3\n"), ok([{ a: "", b: "", c: "" }, { a: "1", b: "", c: "3" }]));  assert.deepEqual(parse('a\n""\n'), ok([{ a: "" }]));  assert.deepEqual(parse("a,b\n0,\n"), ok([{ a: "0", b: "" }]));});test("header only gives no records", () => {  assert.deepEqual(parse("a,b"), ok([]));  assert.deepEqual(parse("a,b\n\n"), ok([]));});test("missing header", () => {  assert.deepEqual(errOf(parse("")), { kind: "missing_header" });  assert.deepEqual(errOf(parse("\n\n")), { kind: "missing_header" });  assert.deepEqual(errOf(parse("\r\n", ["a"])), { kind: "missing_header" });});test("missing required column, first in requiredColumns order", () => {  assert.deepEqual(errOf(parse("id,name\n1,x\n", ["id", "email", "phone"]), ["column"]), { kind: "missing_column", column: "email" });  assert.deepEqual(errOf(parse("id,name\n1,x\n", ["Name"]), ["column"]), { kind: "missing_column", column: "Name" });});test("column count error uses the physical line", () => {  assert.deepEqual(errOf(parse("a,b\n1,2\n1,2,3\n"), ["line"]), { kind: "column_count", line: 3 });  assert.deepEqual(errOf(parse("a,b\n\n\n1\n"), ["line"]), { kind: "column_count", line: 4 });  assert.deepEqual(errOf(parse('a,b\n1,"x\ny\nz"\n5\n'), ["line"]), { kind: "column_count", line: 5 });  assert.deepEqual(errOf(parse("a,b\r\n1,2\r\n\r\n9\r\n"), ["line"]), { kind: "column_count", line: 4 });});test("unterminated quote reports the line where its row starts", () => {  assert.deepEqual(errOf(parse('a,b\n1,"oops\n2,3\n'), ["line"]), { kind: "unterminated_quote", line: 2 });  assert.deepEqual(errOf(parse('a,b\n\n1,2\n\n3,"x'), ["line"]), { kind: "unterminated_quote", line: 5 });});test("missing column is reported before row errors", () => {  assert.deepEqual(errOf(parse("a,b\n1,2,3\n", ["c"]), ["column"]), { kind: "missing_column", column: "c" });});test("the first bad row wins", () => {  assert.deepEqual(errOf(parse("a,b\n1\n1,2,3\n"), ["line"]), { kind: "column_count", line: 2 });});