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.
export function sanitize<T extends Record<string, any>>(
input: T
): {
[K in keyof T]: T[K] extends undefined ? null : T[K];
} {
const output = { ...input } as {
[K in keyof T]: T[K] extends undefined ? null : T[K];
};
Object.keys(output).forEach((key) => {
if (output[key as keyof T] === undefined && key !== "id") {
output[key as keyof T] = null as any;
}
});
return output;
}
/**
* A PostgREST `.or()` filter matching `term`, as typed, anywhere in any of
* `columns`. Two layers of escaping: `\`, `%` and `_` for ILIKE, so they
* match themselves, then the value is quoted for PostgREST, so a comma, dot
* or parenthesis is text, not filter syntax. Interpolated bare, "a,b" ended
* the filter early and the request failed.
*/
export function searchFilter(columns: string[], term: string): string {
const quoted = quoteFilterValue(`%${escapeLike(term)}%`);
return columns.map((column) => `${column}.ilike.${quoted}`).join(",");
}
/**
* A value quoted for a PostgREST logic tree (`or=(...)`, `and(...)`): the
* quotes keep `,`, `(`, `)`, `.` and `:` from changing the filter's shape,
* and a `"` or `\` inside is escaped.
*/
export function quoteFilterValue(value: string): string {
return `"${value.replace(/["\\]/g, (char) => `\\${char}`)}"`;
}
/** `term` for a LIKE / ILIKE pattern: `\\`, `%` and `_` match themselves. */
export function escapeLike(term: string): string {
return term.replace(/[\\%_]/g, (char) => `\\${char}`);
}