mirror of
https://github.com/MBombeck/HealthLog.git
synced 2026-11-09 04:50:59 +00:00
Marc-André Bombeck
79ac5670c7
A ratio (cholesterol/HDL, albumin/globulin) or an index such as INR has no unit, and every lab write path refuses a numeric value without one. That refusal stays: an empty unit usually means the extraction dropped it. Instead the value is stored as the UCUM unity "1", chosen on purpose. The unit field when a marker is defined, on a scanned report's row and in the document review edit now carries a "No unit" checkbox that sets "1". The CSV import takes 1 in the unit column, as the template and the import sheet say; an empty cell is still refused, and other spellings such as "ratio" or "-" stay the literal unit they always were. "1" compares as a unit of its own: it matches only itself, so it is refused under a marker kept in mg/dL and the other way round. Refs #1313
93 lines
2.8 KiB
TypeScript
93 lines
2.8 KiB
TypeScript
/**
|
|
* A lab value without a unit, through the CSV import against a real database.
|
|
*
|
|
* `1` in the unit column is the explicit "no unit" choice (the UCUM unity): it
|
|
* mints a marker kept in "1" and stores the reading under it. An empty unit
|
|
* cell is still refused, and "1" stays a unit of its own in both directions:
|
|
* it does not go under a marker kept in mg/dL, and mg/dL does not go under it.
|
|
*/
|
|
import { beforeAll, describe, expect, it } from "vitest";
|
|
|
|
import { getPrismaClient, truncateAllTables } from "./setup";
|
|
import { textToStream } from "@/lib/import/csv-stream";
|
|
import { importLabsCsv } from "@/lib/import/labs-csv";
|
|
import { labsCsvQuerySchema } from "@/lib/validations/record-import";
|
|
|
|
const prisma = getPrismaClient();
|
|
const USER = "unitless-lab-user";
|
|
const TZ = "Europe/Berlin";
|
|
|
|
const query = labsCsvQuerySchema.parse({
|
|
analyte: "0",
|
|
value: "1",
|
|
unit: "2",
|
|
date: "3",
|
|
referenceRange: "4",
|
|
decimal: "comma",
|
|
dateOrder: "dmy",
|
|
});
|
|
|
|
function run(csv: string) {
|
|
return importLabsCsv({
|
|
userId: USER,
|
|
tz: TZ,
|
|
stream: textToStream(csv),
|
|
maxBytes: 1_000_000,
|
|
query,
|
|
});
|
|
}
|
|
|
|
beforeAll(async () => {
|
|
await truncateAllTables(prisma);
|
|
await prisma.user.create({
|
|
data: { id: USER, username: USER, timezone: TZ },
|
|
});
|
|
await prisma.biomarker.create({
|
|
data: { userId: USER, name: "LDL", unit: "mg/dL" },
|
|
});
|
|
});
|
|
|
|
describe("lab CSV import of a value without a unit", () => {
|
|
it("mints a marker without a unit and refuses the rows that are not one", async () => {
|
|
const result = await run(
|
|
[
|
|
"Analyt;Wert;Einheit;Datum;Referenz",
|
|
"Cholesterin/HDL-Quotient;3,6;1;01.03.2025;0 - 5",
|
|
"INR;1,1;;01.03.2025;",
|
|
"LDL;2,1;1;01.03.2025;",
|
|
].join("\n"),
|
|
);
|
|
expect(result.errors).toEqual([
|
|
{ line: 3, reason: "missing_unit", field: "unit" },
|
|
{ line: 4, reason: "unit_mismatch", field: "unit" },
|
|
]);
|
|
expect(result.inserted).toBe(1);
|
|
|
|
const marker = await prisma.biomarker.findFirstOrThrow({
|
|
where: { userId: USER, name: "Cholesterin/HDL-Quotient" },
|
|
});
|
|
expect(marker.unit).toBe("1");
|
|
const reading = await prisma.labResult.findFirstOrThrow({
|
|
where: { userId: USER, biomarkerId: marker.id },
|
|
});
|
|
expect(reading.unit).toBe("1");
|
|
expect(reading.value).toBe(3.6);
|
|
expect(reading.sourceUnit).toBeNull();
|
|
expect(reading.sourceReferenceHigh).toBe(5);
|
|
});
|
|
|
|
it("refuses a real unit under the marker without one", async () => {
|
|
const result = await run(
|
|
[
|
|
"Analyt;Wert;Einheit;Datum",
|
|
"Cholesterin/HDL-Quotient;3,4;mg/dL;02.03.2025",
|
|
"Cholesterin/HDL-Quotient;3,2;1;03.03.2025",
|
|
].join("\n"),
|
|
);
|
|
expect(result.errors).toEqual([
|
|
{ line: 2, reason: "unit_mismatch", field: "unit" },
|
|
]);
|
|
expect(result.inserted).toBe(1);
|
|
});
|
|
});
|