Skip to content

armgit / alook

Public Imported from GitHub
0

Multi-Agent Collaboration for Team and Friends

3.6 KB
Raw Blame
import { describe, it, expect } from "vitest";
import { isUniqueConstraintError } from "../../src/utils/db-errors";

describe("isUniqueConstraintError", () => {
  it("returns true for error with SQLITE_CONSTRAINT_UNIQUE code", () => {
    const err = Object.assign(new Error("constraint failed"), {
      code: "SQLITE_CONSTRAINT_UNIQUE",
    });
    expect(isUniqueConstraintError(err)).toBe(true);
  });

  it("returns true for error with UNIQUE in message", () => {
    const err = new Error("UNIQUE constraint failed: table.column");
    expect(isUniqueConstraintError(err)).toBe(true);
  });

  it("returns true for DrizzleQueryError wrapping a UNIQUE error as cause", () => {
    const inner = Object.assign(new Error("constraint"), {
      code: "SQLITE_CONSTRAINT_UNIQUE",
    });
    const outer = Object.assign(new Error("Query failed"), { cause: inner });
    expect(isUniqueConstraintError(outer)).toBe(true);
  });

  it("returns true for nested cause chain", () => {
    const innermost = new Error("UNIQUE constraint failed");
    const middle = Object.assign(new Error("wrapped"), { cause: innermost });
    const outer = Object.assign(new Error("top level"), { cause: middle });
    expect(isUniqueConstraintError(outer)).toBe(true);
  });

  it("returns false for non-Error values", () => {
    expect(isUniqueConstraintError(null)).toBe(false);
    expect(isUniqueConstraintError(undefined)).toBe(false);
    expect(isUniqueConstraintError("some string")).toBe(false);
    expect(isUniqueConstraintError(42)).toBe(false);
  });

  it("returns false for unrelated errors", () => {
    expect(isUniqueConstraintError(new Error("connection timeout"))).toBe(false);
    expect(isUniqueConstraintError(new Error("FOREIGN KEY constraint"))).toBe(false);
  });

  it("matches only the complete expected native UNIQUE column signature", () => {
    const columns = ["community_server.name", "community_server.discriminator"];
    expect(isUniqueConstraintError(new Error("D1_ERROR: UNIQUE constraint failed: community_server.name, community_server.discriminator: SQLITE_CONSTRAINT"), columns)).toBe(true);
    expect(isUniqueConstraintError(new Error("UNIQUE constraint failed: community_category.server_id, community_category.name"), columns)).toBe(false);
    expect(isUniqueConstraintError(new Error("UNIQUE constraint failed: community_server.name, community_server.discriminator_extra"), columns)).toBe(false);
    expect(isUniqueConstraintError(new Error("UNIQUE constraint failed: community_server.name, community_server.discriminator, community_server.id"), columns)).toBe(false);
    expect(isUniqueConstraintError(Object.assign(new Error("constraint failed"), { code: "SQLITE_CONSTRAINT_UNIQUE" }), columns)).toBe(false);
    expect(isUniqueConstraintError(new Error("FOREIGN KEY constraint failed"), columns)).toBe(false);
    expect(isUniqueConstraintError(new Error("UNIQUE constraint failed: community_server.name"), [])).toBe(false);
  });

  it("uses the actual nested driver cause rather than an outer query's text", () => {
    const columns = ["community_server.name", "community_server.discriminator"];
    const match = new Error("UNIQUE constraint failed: community_server.name, community_server.discriminator");
    const other = new Error("UNIQUE constraint failed: community_category.server_id, community_category.name");
    expect(isUniqueConstraintError(new Error("Query failed", { cause: new Error("Wrapped", { cause: match }) }), columns)).toBe(true);
    expect(isUniqueConstraintError(new Error(match.message, { cause: other }), columns)).toBe(false);
    expect(isUniqueConstraintError(null, columns)).toBe(false);
  });

});