test(infra): add unit tests for SQLite number normalization (#98009)

dwc1997 · web-flow · commit 3669280b9aec · 2026-06-30T18:15:38.000-07:00
* test(infra): add unit tests for SQLite number normalization

* fix: remove undefined param test, not in function signature
diff --git a/src/infra/sqlite-number.test.ts b/src/infra/sqlite-number.test.ts
@@ -0,0 +1,41 @@
+// Tests for SQLite number normalization.
+import { describe, expect, it } from "vitest";
+import { normalizeSqliteNumber } from "./sqlite-number.js";
+
+describe("normalizeSqliteNumber", () => {
+  it("returns number value unchanged", () => {
+    expect(normalizeSqliteNumber(5)).toBe(5);
+  });
+
+  it("converts bigint to number", () => {
+    expect(normalizeSqliteNumber(BigInt(5))).toBe(5);
+  });
+
+  it("returns undefined for null", () => {
+    expect(normalizeSqliteNumber(null)).toBeUndefined();
+  });
+
+  it("returns zero unchanged", () => {
+    expect(normalizeSqliteNumber(0)).toBe(0);
+  });
+
+  it("returns negative value unchanged", () => {
+    expect(normalizeSqliteNumber(-1)).toBe(-1);
+  });
+
+  it("returns NaN unchanged", () => {
+    expect(normalizeSqliteNumber(Number.NaN)).toBe(Number.NaN);
+  });
+
+  it("converts large bigint", () => {
+    expect(normalizeSqliteNumber(BigInt(Number.MAX_SAFE_INTEGER))).toBe(Number.MAX_SAFE_INTEGER);
+  });
+
+  it("converts zero bigint", () => {
+    expect(normalizeSqliteNumber(BigInt(0))).toBe(0);
+  });
+
+  it("converts negative bigint", () => {
+    expect(normalizeSqliteNumber(BigInt(-1))).toBe(-1);
+  });
+});
