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.
// The root `scripts/lib` helpers belong to no package. They are tested here
// because this package's tests never cache, so an edit under scripts/ is seen.
import { describe, expect, it } from "vitest";
import {
sortRelationships,
stripPerTenantTables,
validateDatabaseUrl
} from "../../../scripts/lib/generate-db-types";
import { readLocalScriptConfig } from "../../../scripts/lib/local-script-config";
import { normalizeSwaggerSchema } from "../../../scripts/lib/swagger-schema";
describe("validateDatabaseUrl", () => {
it.each(["localhost", "127.0.0.1", "[::1]"])(
"accepts a local PostgreSQL host %s",
(host) => {
const url = `postgresql://example:synthetic@${host}:5432/example`;
expect(validateDatabaseUrl(url)).toBe(url);
}
);
it.each([
undefined,
" ",
"not-a-database-url",
"postgresql://localhost:[email protected]/example",
"postgresql://example:[email protected]/example",
"postgresql://example:[email protected]/localhost",
"http://example:synthetic-secret@localhost/example",
"postgresql://example:synthetic-secret@localhost/example?host=example.com",
"postgresql://example:synthetic-secret@localhost/example?hostaddr=192.0.2.1"
])("refuses %s without echoing it", (url) => {
// The message lands in public run logs, so it must not carry the URL.
expect(() => validateDatabaseUrl(url)).toThrow(
expect.objectContaining({
message: expect.not.stringMatching(/synthetic-secret|example\.com/)
})
);
});
});
describe("stripPerTenantTables", () => {
const table = (name: string) =>
[` ${name}: {`, " Row: {}", " }"].join("\n");
it("drops per-company tables, quoted ids included, and keeps the static ones", () => {
const source = [
table("searchIndexRegistry"),
table("searchIndex_dal7910g60gg2egcfj40"),
table('"searchIndex_accttest-08e7f74786d6-company"'),
table('"auditLog_accttest-08e7f74786d6-company"'),
table("auditLogArchive")
].join("\n");
expect(stripPerTenantTables(source)).toBe(
[table("searchIndexRegistry"), table("auditLogArchive")].join("\n")
);
});
});
describe("sortRelationships", () => {
const block = (entries: string[]) =>
[
" x: {",
" Relationships: [",
...entries,
" ]",
" }"
].join("\n");
const entry = (column: string, last = false) =>
[
" {",
' foreignKeyName: "x_fkey"',
` columns: ["${column}"]`,
" isOneToOne: false",
' referencedRelation: "country"',
' referencedColumns: ["code"]',
last ? " }" : " },"
].join("\n");
it("orders a Relationships block the same whatever order Postgres listed it in", () => {
const sorted = block([
entry("customerCountryCode"),
entry("supplierCountryCode", true)
]);
const unsorted = block([
entry("supplierCountryCode"),
entry("customerCountryCode", true)
]);
// Every entry but the last keeps its trailing comma.
expect(sortRelationships(unsorted)).toBe(sorted);
expect(sortRelationships(sorted)).toBe(sorted);
});
it("leaves an empty block alone", () => {
const empty = " Relationships: []\n }";
expect(sortRelationships(empty)).toBe(empty);
});
});
describe("normalizeSwaggerSchema", () => {
const pk = "This is a Primary Key.<pk/>";
const fk =
"This is a Foreign Key to `supplierLocation.id`.<fk table='supplierLocation' column='id'/>";
// PostgREST puts the `partners` primary-key note on whichever alias of
// partner.id it meets first, which differs between databases.
const schema = (pkOn: "id" | "supplierLocationId") => ({
definitions: {
partners: {
properties: {
id: {
description: `Original id documentation.\n\nNote:\n${pkOn === "id" ? `${pk}\n` : ""}${fk}`
},
supplierLocationId: {
description: `Alias documentation.\n\nNote:\n${pkOn === "supplierLocationId" ? `${pk}\n` : ""}${fk}`
}
}
},
unrelated: { properties: { id: { description: `Leave: ${pk}` } } }
}
});
it("pins the primary-key note to id whichever alias carried it", () => {
expect(normalizeSwaggerSchema(schema("supplierLocationId"))).toEqual(
schema("id")
);
expect(normalizeSwaggerSchema(schema("id"))).toEqual(schema("id"));
});
it("keeps the note on the alias when id has no Note block to receive it", () => {
const input = schema("supplierLocationId");
input.definitions.partners.properties.id.description = "No note here.";
expect(normalizeSwaggerSchema(input)).toEqual(input);
});
it("does not modify its input", () => {
const input = schema("supplierLocationId");
normalizeSwaggerSchema(input);
expect(input).toEqual(schema("supplierLocationId"));
});
});
describe("readLocalScriptConfig", () => {
it("returns only the requested values", () => {
expect(
readLocalScriptConfig(["A_TEST_KEY", "B_TEST_KEY"], {
A_TEST_KEY: "a",
B_TEST_KEY: "b",
C_TEST_KEY: "ignored"
})
).toEqual({ A_TEST_KEY: "a", B_TEST_KEY: "b" });
});
it("names the missing and blank keys without disclosing configured values", () => {
let message = "";
try {
readLocalScriptConfig(["A_TEST_KEY", "B_TEST_KEY", "C_TEST_KEY"], {
A_TEST_KEY: "private-value-sentinel",
B_TEST_KEY: " "
});
} catch (error) {
message = (error as Error).message;
}
expect(message).toMatch(/: B_TEST_KEY, C_TEST_KEY\./);
expect(message).not.toContain("private-value-sentinel");
});
});