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 { Client } from "pg";
import { afterAll, beforeAll, describe, expect, test } from "vitest";
import { attachments } from "./attachments";
import {
liveAttachments,
renderAttachment,
renderDetachment,
renderFor,
syncAttachments
} from "./attachments-sync";
describe("rendering an attachment", () => {
test("is one set_event_triggers call with every list spelled out", () => {
expect(
renderAttachment("customer", {
before: ["a"],
after: ["b", "c"],
events: true,
statement: ["z", "y"]
})
).toBe(
"SELECT set_event_triggers('customer', ARRAY['a']::text[], ARRAY['b', 'c']::text[], true, ARRAY['y', 'z']::text[]);"
);
});
test("a table without an entry is detached", () => {
expect(renderFor({}, "customer")).toBe(renderDetachment("customer"));
expect(renderDetachment("customer")).toBe(
"SELECT set_event_triggers('customer');"
);
});
});
// Runs against the local database: SUPABASE_DB_URL=… pnpm vitest run src/event-system
const url = process.env.SUPABASE_DB_URL;
describe.skipIf(!url)("attachments against a migrated database", () => {
const db = new Client({ connectionString: url });
// Each event trigger with its oid: a trigger that was dropped and created
// again has the same definition and a new oid.
const triggers = async () =>
(
await db.query<{ oid: number; definition: string }>(
`SELECT t.oid::int AS oid, pg_get_triggerdef(t.oid) AS definition
FROM pg_trigger t JOIN pg_class c ON c.oid = t.tgrelid
WHERE NOT t.tgisinternal AND t.tgname LIKE 'trg\\_event\\_%'
ORDER BY c.relname, t.tgname`
)
).rows;
beforeAll(async () => {
await db.connect();
await db.query("BEGIN");
});
afterAll(async () => {
await db.query("ROLLBACK");
await db.end();
});
test("the database already has exactly what attachments.ts declares", async () => {
expect(await syncAttachments(db, attachments, { dryRun: true })).toEqual(
[]
);
});
test("re-applying every entry touches no trigger", async () => {
// Creating a trigger locks its table, so a migration that restates every
// table must leave the ones that have not changed alone.
const before = await triggers();
for (const table of Object.keys(attachments)) {
await db.query(renderFor(attachments, table));
}
expect(await triggers()).toEqual(before);
});
test("sync detaches a table that has no entry, and heals a missing trigger", async () => {
const { customer: _, ...rest } = attachments;
expect(await syncAttachments(db, rest, { dryRun: false })).toEqual([
"customer"
]);
expect((await liveAttachments(db)).has("customer")).toBe(false);
expect(await syncAttachments(db, attachments, { dryRun: false })).toEqual([
"customer"
]);
await db.query(
`DROP TRIGGER "trg_event_statement_broadcast_table_changes_upd" ON "customer"`
);
const broken = await triggers();
await db.query(renderFor(attachments, "customer"));
const healed = (await triggers()).map((trigger) => trigger.definition);
expect(healed).toHaveLength(broken.length + 1);
expect(
healed.some(
(definition) =>
definition.includes(
"trg_event_statement_broadcast_table_changes_upd"
) && definition.includes("ON public.customer")
)
).toBe(true);
});
});