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 { findDroppedFunctionChanges } from "./function-redefinition-keeps-changes";
const fn = (body: string[]) => `
CREATE OR REPLACE FUNCTION public.complete_job(p_job_id TEXT)
RETURNS VOID LANGUAGE plpgsql AS $$
BEGIN
${body.join("\n")}
END;
$$;`;
const ORIGINAL = [
" SELECT accountingEnabled INTO v_enabled FROM settings;",
" IF NOT v_enabled THEN RETURN; END IF;"
];
const ALWAYS_POST = [
" v_posting_status := journal_posting_status(p_company_id);",
" INSERT INTO journal (status) VALUES (v_posting_status);"
];
const SERIAL = [" AND te.status NOT IN ('Rejected', 'Scrapped')"];
const migrations = (third: string[], file = "20261020101010_third.sql") => [
{ file: "20261001101010_first.sql", contents: fn(ORIGINAL) },
{ file: "20261009101010_always-post.sql", contents: fn(ALWAYS_POST) },
{ file, contents: fn(third) }
];
describe("function-redefinition-keeps-changes", () => {
it("fails a redefinition forked from an older copy", () => {
const [finding] = findDroppedFunctionChanges(
migrations([...ORIGINAL, ...SERIAL])
);
expect(finding?.snippet).toBe(
"complete_job drops 20261009101010_always-post.sql"
);
});
it("passes a redefinition that starts from the newest definition", () => {
expect(
findDroppedFunctionChanges(migrations([...ALWAYS_POST, ...SERIAL]))
).toEqual([]);
});
it("tells an overload from the function it shares a name with", () => {
const overload = (args: string, body: string[]) =>
fn(body).replace("(p_job_id TEXT)", `(${args})`);
const SERIAL_OVERLOAD = [
" v_serials := array_agg(p_serial ORDER BY p_serial);",
" PERFORM receive_serials(p_job_id, v_serials);"
];
expect(
findDroppedFunctionChanges([
{ file: "20261001101010_first.sql", contents: fn(ORIGINAL) },
{
file: "20261009101010_overload.sql",
contents: overload(
"p_job_id TEXT, p_serial character varying(20) DEFAULT NULL",
SERIAL_OVERLOAD
)
},
{
file: "20261020101010_third.sql",
contents: overload("text", [...ORIGINAL, ...SERIAL])
}
])
).toEqual([]);
// The overload redefined from an older copy of itself is still caught.
const [finding] = findDroppedFunctionChanges([
{
file: "20261001101010_first.sql",
contents: overload("t TEXT, n int", ORIGINAL)
},
{
file: "20261009101010_always-post.sql",
contents: overload("t text, n INTEGER", ALWAYS_POST)
},
{
file: "20261020101010_third.sql",
contents: overload("IN t TEXT, n int4, OUT ok boolean", [
...ORIGINAL,
...SERIAL
])
}
]);
expect(finding?.message).toMatch(
/redefines public\.complete_job\(text, integer\)/
);
});
it("checks a function outside the public schema", () => {
const util = (body: string[]) =>
fn(body).replace("public.complete_job", "util.complete_job");
const [finding] = findDroppedFunctionChanges([
{ file: "20261001101010_first.sql", contents: util(ORIGINAL) },
{ file: "20261009101010_always-post.sql", contents: util(ALWAYS_POST) },
{
file: "20261020101010_third.sql",
contents: util([...ORIGINAL, ...SERIAL])
}
]);
expect(finding?.snippet).toBe(
"util.complete_job drops 20261009101010_always-post.sql"
);
});
it("leaves migrations from before it was added alone", () => {
expect(
findDroppedFunctionChanges(
migrations([...ORIGINAL, ...SERIAL], "20261012101010_third.sql")
)
).toEqual([]);
});
});