Skip to content

Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.

858 B
Raw Blame
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.

import { describe, expect, it } from "vitest";
import { searchFilter } from "./supabase";

describe("searchFilter", () => {
  it("quotes the term so filter syntax in it stays text", () => {
    expect(searchFilter(["name", "readableId"], 'a,b.(c) "d"')).toBe(
      'name.ilike."%a,b.(c) \\"d\\"%",readableId.ilike."%a,b.(c) \\"d\\"%"'
    );
  });

  it("matches \\, % and _ as themselves, not as ILIKE escapes or wildcards", () => {
    // ILIKE sees `\\\\` (a backslash), `\\%` and `\\_`; PostgREST unquotes one layer.
    expect(searchFilter(["name"], "a\\b%c_d")).toBe(
      'name.ilike."%a\\\\\\\\b\\\\%c\\\\_d%"'
    );
  });
});