Skip to content

armgit / alook

Public Imported from GitHub
0

Multi-Agent Collaboration for Team and Friends

3.2 KB
Raw Blame
import { describe, it, expect, vi } from "vitest";
import * as conversationQueries from "../../src/db/queries/conversation";

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.orderBy = vi.fn(() => chain);
  chain.limit = vi.fn(() => Promise.resolve(rows));
  chain.insert = vi.fn(() => chain);
  chain.values = vi.fn(() => chain);
  chain.returning = vi.fn(() => Promise.resolve(rows));
  chain.update = vi.fn(() => chain);
  chain.set = vi.fn(() => chain);
  chain.delete = vi.fn(() => chain);
  chain.leftJoin = vi.fn(() => chain);
  chain.groupBy = vi.fn(() => chain);
  return chain;
}



describe("getConversationsByIds", () => {
  it("returns empty array for empty ids without querying DB", async () => {
    const result = await conversationQueries.getConversationsByIds(null as any, [], "ws_1");
    expect(result).toEqual([]);
  });
});

describe("getConversation", () => {
  it("returns null when not found", async () => {
    const mockDb = createMockDb([]);
    const result = await conversationQueries.getConversation(mockDb, "conv_missing", "ws_1");
    expect(result).toBeNull();
  });

  it("returns conversation when found", async () => {
    const conv = { id: "conv_1", title: "Test" };
    const mockDb = createMockDb([conv]);
    const result = await conversationQueries.getConversation(mockDb, "conv_1", "ws_1");
    expect(result).toEqual(conv);
  });
});

describe("updateConversationTitle", () => {
  it("returns null when no row updated", async () => {
    const chain: any = {};
    chain.update = vi.fn(() => chain);
    chain.set = vi.fn(() => chain);
    chain.where = vi.fn(() => chain);
    chain.returning = vi.fn(() => Promise.resolve([]));
    const result = await conversationQueries.updateConversationTitle(chain, "conv_1", "New Title");
    expect(result).toBeNull();
  });
});

describe("deleteConversation", () => {
  it("returns null when conversation does not exist", async () => {
    const chain: any = {};
    chain.delete = vi.fn(() => chain);
    chain.where = vi.fn(() => chain);
    chain.returning = vi.fn(() => Promise.resolve([]));
    const result = await conversationQueries.deleteConversation(chain, "conv_missing", "ws_1");
    expect(result).toBeNull();
  });
});

describe("hasPreviousConversations", () => {
  it("returns true when previous conversations exist", async () => {
    const chain: any = {};
    chain.select = vi.fn(() => chain);
    chain.from = vi.fn(() => chain);
    chain.where = vi.fn(() => chain);
    chain.limit = vi.fn(() => Promise.resolve([{ exists: 1 }]));
    const result = await conversationQueries.hasPreviousConversations(chain, "ws_1", "usr_1", "ag_1", "conv_current");
    expect(result).toBe(true);
  });

  it("returns false when no previous conversations exist", async () => {
    const chain: any = {};
    chain.select = vi.fn(() => chain);
    chain.from = vi.fn(() => chain);
    chain.where = vi.fn(() => chain);
    chain.limit = vi.fn(() => Promise.resolve([]));
    const result = await conversationQueries.hasPreviousConversations(chain, "ws_1", "usr_1", "ag_1", "conv_current");
    expect(result).toBe(false);
  });
});