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.
TypeScript ai-agentsbill-of-materialserpinventory-managementleanmanufacturingmanufacturing-execution-systemmcp-servermesmrpopen-source-erppostgresqlproduction-planningqmsquality-management-systemreact-routerself-hostedsupabasetraceabilitytypescript
// 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%"'
);
});
});