import { describe, it, expect, vi, beforeEach } from "vitest";
import {
createMockMySQLAdapter,
createMockQueryResult,
createMockRequestContext,
} from "../../../../__tests__/mocks/index.js";
import { createHealthResource } from "../health.js";
import type { MySQLAdapter } from "../../MySQLAdapter.js";
describe("Health Resource", () => {
let mockAdapter: ReturnType<typeof createMockMySQLAdapter>;
let mockContext: ReturnType<typeof createMockRequestContext>;
beforeEach(() => {
vi.clearAllMocks();
mockAdapter = createMockMySQLAdapter();
mockContext = createMockRequestContext();
});
it("should return default values when status variables are missing", async () => {
// Empty status result
mockAdapter.executeQuery.mockResolvedValueOnce(createMockQueryResult([]));
// Missing max_connections (default 151)
mockAdapter.executeQuery.mockResolvedValueOnce(createMockQueryResult([]));
const resource = createHealthResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://health",
mockContext,
)) as any;
expect(result.status).toBe("healthy");
expect(result.uptime_seconds).toBe(0);
expect(result.connections.current).toBe(0);
expect(result.connections.max_allowed).toBe(151); // Default
expect(result.connections.usage_percent).toBe(0);
});
it("should handle zero buffer pool requests (avoid div by zero)", async () => {
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([
{ Variable_name: "Innodb_buffer_pool_read_requests", Value: "0" },
{ Variable_name: "Innodb_buffer_pool_reads", Value: "0" },
]),
);
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([{ Value: "100" }]),
);
const resource = createHealthResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://health",
mockContext,
)) as any;
expect(result.performance.buffer_pool_hit_ratio).toBe(100);
});
it("should handle zero table lock waits (avoid div by zero)", async () => {
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([
{ Variable_name: "Table_locks_waited", Value: "0" },
{ Variable_name: "Table_locks_immediate", Value: "0" },
]),
);
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([{ Value: "100" }]),
);
const resource = createHealthResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://health",
mockContext,
)) as any;
expect(result.performance.table_lock_contention_percent).toBe(0);
});
it("should calculate metrics correctly with values", async () => {
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([
{ Variable_name: "Uptime", Value: "3600" },
{ Variable_name: "Threads_connected", Value: "50" },
{ Variable_name: "Innodb_buffer_pool_read_requests", Value: "100" },
{ Variable_name: "Innodb_buffer_pool_reads", Value: "10" }, // 90% hit ratio
{ Variable_name: "Table_locks_waited", Value: "20" },
{ Variable_name: "Table_locks_immediate", Value: "80" }, // 20% contention
]),
);
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([{ Value: "100" }]),
); // Max connections
const resource = createHealthResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://health",
mockContext,
)) as any;
expect(result.uptime_seconds).toBe(3600);
expect(result.connections.usage_percent).toBe(50); // 50/100
expect(result.performance.buffer_pool_hit_ratio).toBe(90);
expect(result.performance.table_lock_contention_percent).toBe(20);
});
it("should include pool stats if available", async () => {
mockAdapter.executeQuery.mockResolvedValue(createMockQueryResult([]));
const mockPool = {
getStats: vi.fn().mockReturnValue({ total: 10, active: 5, idle: 5 }),
};
(mockAdapter.getPool as any).mockReturnValue(mockPool);
const resource = createHealthResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://health",
mockContext,
)) as any;
expect(result.pool).toEqual({ total: 10, active: 5, idle: 5 });
});
});
