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 { findUnsyncedDocumentSequences } from "./document-sequence-synced";
const seedData = (...tables: string[]) => ({
file: "seed-data.ts",
contents: `export const sequences = [\n${tables
.map((t) => ` {\n table: "${t}",\n prefix: "X"\n },`)
.join("\n")}\n] as const;\n`
});
const attachments = (...tables: string[]) => ({
file: "attachments.ts",
contents: `export const attachments = {\n${tables
.map(
(t) =>
` ${t}: { after: ["sync_advance_document_sequence"], events: true },`
)
.join("\n")}\n other: { events: true }\n} as const;\n`
});
const interceptor = (...tables: string[]) => ({
file: "sync_advance_document_sequence.sql",
contents: `v_column := CASE p_table\n${tables
.map((t) => ` WHEN '${t}' THEN '${t}Id'`)
.join("\n")}\n END;\n`
});
const messages = (
sources: Parameters<typeof findUnsyncedDocumentSequences>[0]
) =>
findUnsyncedDocumentSequences(sources).map((v) => `${v.file}: ${v.snippet}`);
describe("findUnsyncedDocumentSequences", () => {
it("accepts a counter whose table is attached and in the CASE", () => {
expect(
messages({
seedData: seedData("salesOrder"),
attachments: attachments("salesOrder"),
interceptor: interceptor("salesOrder")
})
).toEqual([]);
});
it("flags a new counter that is neither covered nor exempt", () => {
expect(
messages({
seedData: seedData("salesOrder", "serviceOrder"),
attachments: attachments("salesOrder"),
interceptor: interceptor("salesOrder")
})
).toEqual(['seed-data.ts: table: "serviceOrder"']);
});
it("accepts an exempt counter, and flags one that is also covered", () => {
expect(
messages({
seedData: seedData("inspection"),
attachments: attachments(),
interceptor: interceptor()
})
).toEqual([]);
expect(
messages({
seedData: seedData("inspection"),
attachments: attachments("inspection"),
interceptor: interceptor("inspection")
})
).toEqual(['seed-data.ts: table: "inspection"']);
});
it("maps counters named differently from their table", () => {
expect(
messages({
seedData: seedData("journalEntry", "creditMemo", "debitMemo"),
attachments: attachments("journal", "memo"),
interceptor: interceptor("journal", "memo")
})
).toEqual([]);
});
it("flags a table attached but missing from the CASE, and the reverse", () => {
expect(
messages({
seedData: seedData(),
attachments: attachments("quote"),
interceptor: interceptor("job")
})
).toEqual([
"attachments.ts: quote",
"sync_advance_document_sequence.sql: WHEN 'job'"
]);
});
});