swadhinbiswas Add repository developer workload insights API · 2/19/2026
2552825
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
import { beforeEach, describe, expect, it, vi } from "vitest";
const {
canReadRepoMock,
getDeveloperWorkloadsMock,
fakeSchema,
} = vi.hoisted(() => ({
canReadRepoMock: vi.fn(async () => true),
getDeveloperWorkloadsMock: vi.fn(async () => ([
{
userId: "u1",
userName: "Dev 1",
openPRs: 3,
pendingReviews: 2,
assignedIssues: 1,
recentCommits: 0,
avgReviewTime: 0,
workloadScore: 85,
trend: "increasing",
},
{
userId: "u2",
userName: "Dev 2",
openPRs: 0,
pendingReviews: 0,
assignedIssues: 1,
recentCommits: 0,
avgReviewTime: 0,
workloadScore: 15,
trend: "decreasing",
},
])),
fakeSchema: {
users: { username: {} },
repositories: { ownerId: {}, name: {}, id: {} },
} as any,
}));
let mockDb: any;
vi.mock("@/db", () => ({
getDatabase: () => mockDb,
schema: fakeSchema,
}));
vi.mock("@/lib/permissions", () => ({
canReadRepo: canReadRepoMock,
}));
vi.mock("@/lib/analytics-advanced", () => ({
getDeveloperWorkloads: getDeveloperWorkloadsMock,
}));
import { GET as getWorkload } from "@/pages/api/repos/[owner]/[repo]/analytics/workload";
function makeDb() {
return {
query: {
users: {
findFirst: vi.fn(async () => ({ id: "owner-1" })),
},
repositories: {
findFirst: vi.fn(async () => ({ id: "repo-1", ownerId: "owner-1", name: "demo" })),
},
},
};
}
async function readJson(response: Response): Promise<any> {
return response.json();
}
describe("analytics workload route", () => {
beforeEach(() => {
mockDb = makeDb();
canReadRepoMock.mockResolvedValue(true);
});
it("returns repository workload summary", async () => {
const response = await getWorkload({
params: { owner: "owner-1", repo: "demo" },
url: new URL("http://localhost/api/repos/owner-1/demo/analytics/workload?days=14"),
locals: { user: { id: "user-1" } },
} as any);
const body = await readJson(response);
expect(response.status).toBe(200);
expect(body?.data?.summary?.overloadedCount).toBe(1);
expect(body?.data?.summary?.underutilizedCount).toBe(1);
expect(getDeveloperWorkloadsMock).toHaveBeenCalledWith({
repositoryId: "repo-1",
days: 14,
});
});
it("applies contributor limit", async () => {
const response = await getWorkload({
params: { owner: "owner-1", repo: "demo" },
url: new URL("http://localhost/api/repos/owner-1/demo/analytics/workload?limit=1"),
locals: { user: { id: "user-1" } },
} as any);
const body = await readJson(response);
expect(response.status).toBe(200);
expect(body?.data?.contributors).toHaveLength(1);
});
});