Multi-Agent Collaboration for Team and Friends
TypeScript agent-automationagent-orchestrationagent-workflowai-agentsai-collaborationai-memoryai-workforceautonomous-agentsclaude-codeclaude-code-skillscodexcoding-agentmulti-agentmultiple-agentone-person-businessone-person-companyone-person-teamopencodesolopreneur
import { describe, it, expect, vi } from "vitest";
import * as machineQueries from "../../src/db/queries/machine";
function createMockDb(rows: any[]) {
const chain: any = {};
chain.select = vi.fn(() => chain);
chain.from = vi.fn(() => chain);
chain.where = vi.fn(() => Promise.resolve(rows));
chain.insert = vi.fn(() => chain);
chain.values = vi.fn(() => chain);
chain.returning = vi.fn(() => Promise.resolve(rows));
chain.onConflictDoUpdate = vi.fn(() => chain);
chain.update = vi.fn(() => chain);
chain.set = vi.fn(() => chain);
chain.delete = vi.fn(() => chain);
return chain;
}
describe("upsertMachine", () => {
it("inserts and returns first row", async () => {
const m = { id: "m_1" };
const mockDb = createMockDb([m]);
const result = await machineQueries.upsertMachine(mockDb, { daemonId: "d_1", workspaceId: "ws_1", deviceInfo: "Mac" });
expect(mockDb.insert).toHaveBeenCalled();
expect(mockDb.onConflictDoUpdate).toHaveBeenCalled();
expect(result).toEqual(m);
});
it("uses null lastSeenAt when explicitly null", async () => {
const mockDb = createMockDb([{ id: "m_1" }]);
await machineQueries.upsertMachine(mockDb, { daemonId: "d_1", workspaceId: "ws_1", deviceInfo: "x", lastSeenAt: null });
expect(mockDb.values).toHaveBeenCalledWith(expect.objectContaining({ lastSeenAt: null }));
});
});
describe("getMachineByDaemon", () => {
it("returns null when not found", async () => {
const mockDb = createMockDb([]);
expect(await machineQueries.getMachineByDaemon(mockDb, "d_x", "ws_1")).toBeNull();
});
it("returns machine when found", async () => {
const m = { id: "m_1" };
const mockDb = createMockDb([m]);
expect(await machineQueries.getMachineByDaemon(mockDb, "d_1", "ws_1")).toEqual(m);
});
});
describe("updateMachineLastSeen", () => {
it("updates lastSeenAt", async () => {
const mockDb = createMockDb([]);
await machineQueries.updateMachineLastSeen(mockDb, "d_1", "ws_1");
expect(mockDb.set).toHaveBeenCalledWith(expect.objectContaining({ lastSeenAt: expect.any(String) }));
});
});
describe("setMachineLastSeenNull", () => {
it("sets lastSeenAt to null", async () => {
const mockDb = createMockDb([]);
await machineQueries.setMachineLastSeenNull(mockDb, "d_1", "ws_1");
expect(mockDb.set).toHaveBeenCalledWith(expect.objectContaining({ lastSeenAt: null }));
});
});
describe("deleteMachine", () => {
it("calls delete", async () => {
const mockDb = createMockDb([]);
await machineQueries.deleteMachine(mockDb, "d_1", "ws_1");
expect(mockDb.delete).toHaveBeenCalled();
});
});
describe("setPendingUpdateVersion", () => {
it("sets version", async () => {
const mockDb = createMockDb([]);
await machineQueries.setPendingUpdateVersion(mockDb, "d_1", "ws_1", "1.2.3");
expect(mockDb.set).toHaveBeenCalledWith(expect.objectContaining({ pendingUpdateVersion: "1.2.3" }));
});
});
describe("clearPendingUpdateVersion", () => {
it("clears to null", async () => {
const mockDb = createMockDb([]);
await machineQueries.clearPendingUpdateVersion(mockDb, "d_1", "ws_1");
expect(mockDb.set).toHaveBeenCalledWith(expect.objectContaining({ pendingUpdateVersion: null }));
});
});
describe("setPendingRescan", () => {
it("sets to true", async () => {
const mockDb = createMockDb([]);
await machineQueries.setPendingRescan(mockDb, "d_1", "ws_1");
expect(mockDb.set).toHaveBeenCalledWith(expect.objectContaining({ pendingRescan: true }));
});
});
describe("clearPendingRescan", () => {
it("sets to false", async () => {
const mockDb = createMockDb([]);
await machineQueries.clearPendingRescan(mockDb, "d_1", "ws_1");
expect(mockDb.set).toHaveBeenCalledWith(expect.objectContaining({ pendingRescan: false }));
});
});