Skip to content

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.

911 B
Raw Blame
// 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 { mkdtempSync, writeFileSync } from "node:fs";
import { tmpdir } from "node:os";
import { join } from "node:path";
import { describe, expect, it } from "vitest";
import { loadSqlFiles } from "./migrations";

describe("loadSqlFiles", () => {
  it("loads .sql files sorted by name, ignoring non-sql", () => {
    const dir = mkdtempSync(join(tmpdir(), "core-"));
    writeFileSync(join(dir, "b.sql"), "SELECT 2;");
    writeFileSync(join(dir, "a.sql"), "SELECT 1;");
    writeFileSync(join(dir, "notes.txt"), "ignore me");
    const files = loadSqlFiles(dir);
    expect(files.map((f) => f.file)).toEqual(["a.sql", "b.sql"]);
    expect(files[0]?.contents).toBe("SELECT 1;");
  });
});