homeio

1import { beforeEach, describe, expect, it, vi } from "vitest";
2
3vi.mock("@/lib/server/db/drizzle", () => ({
4  db: {
5    execute: vi.fn(),
6    select: vi.fn(),
7  },
8}));
9
10import { db } from "@/lib/server/db/drizzle";
11import { listInstalledAppsFromDb } from "@/lib/server/modules/apps/repository";
12
13function makeSelectChain(rows: unknown[]) {
14  const chain: Record<string, unknown> = {};
15  for (const method of ["from", "where", "orderBy", "limit", "innerJoin"]) {
16    chain[method] = vi.fn().mockReturnValue(chain);
17  }
18  chain.then = (resolve: (v: unknown) => unknown) =>
19    Promise.resolve(rows).then(resolve);
20  chain.catch = (reject: (r: unknown) => unknown) =>
21    Promise.resolve(rows).catch(reject);
22  chain.finally = (cb: () => void) => Promise.resolve(rows).finally(cb);
23  return chain;
24}
25
26describe("apps repository", () => {
27  beforeEach(() => {
28    vi.mocked(db.execute).mockReset();
29    vi.mocked(db.select).mockReset();
30  });
31
32  it("returns empty list when app_stacks table is not present", async () => {
33    vi.mocked(db.execute).mockResolvedValueOnce({
34      rows: [{ table_exists: null }],
35    } as never);
36
37    const result = await listInstalledAppsFromDb();
38
39    expect(result).toEqual([]);
40    expect(db.execute).toHaveBeenCalledTimes(1);
41  });
42
43  it("maps db rows to installed apps contract", async () => {
44    vi.mocked(db.execute).mockResolvedValueOnce({
45      rows: [{ table_exists: "app_stacks" }],
46    } as never);
47
48    vi.mocked(db.select).mockReturnValue(
49      makeSelectChain([
50        {
51          appId: "plex",
52          templateName: "plex",
53          stackName: "plex-stack",
54          composePath: "/DATA/AppData/plex/docker-compose.yml",
55          displayName: "Plex Media Server",
56          updatedAt: new Date("2026-02-22T12:00:00.000Z"),
57        },
58        {
59          appId: "home-assistant",
60          templateName: "home-assistant",
61          stackName: "home-assistant",
62          composePath: "/DATA/AppData/home-assistant/docker-compose.yml",
63          displayName: null,
64          updatedAt: "2026-02-22T12:10:00.000Z",
65        },
66      ]) as never,
67    );
68
69    const result = await listInstalledAppsFromDb();
70
71    expect(result).toEqual([
72      {
73        id: "plex",
74        name: "Plex Media Server",
75        stackName: "plex-stack",
76        composePath: "/DATA/AppData/plex/docker-compose.yml",
77        status: "unknown",
78        updatedAt: "2026-02-22T12:00:00.000Z",
79        webUiPort: undefined,
80        webUiUrl: null,
81        activeOperation: null,
82      },
83      {
84        id: "home-assistant",
85        name: "home-assistant",
86        stackName: "home-assistant",
87        composePath: "/DATA/AppData/home-assistant/docker-compose.yml",
88        status: "unknown",
89        updatedAt: "2026-02-22T12:10:00.000Z",
90        webUiPort: undefined,
91        webUiUrl: null,
92        activeOperation: null,
93      },
94    ]);
95  });
96});
97