/**
* mysql-mcp - Variables Resource Unit Tests
*
* Tests for variables resource handler execution.
*/
import { describe, it, expect, vi, beforeEach } from "vitest";
import {
createMockMySQLAdapter,
createMockQueryResult,
createMockRequestContext,
} from "../../../../__tests__/mocks/index.js";
import type { MySQLAdapter } from "../../MySQLAdapter.js";
import { createVariablesResource } from "../variables.js";
describe("Variables Resource", () => {
let mockAdapter: ReturnType<typeof createMockMySQLAdapter>;
let mockContext: ReturnType<typeof createMockRequestContext>;
beforeEach(() => {
vi.clearAllMocks();
mockAdapter = createMockMySQLAdapter();
mockContext = createMockRequestContext();
});
it("should return all global variables", async () => {
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([
{ Variable_name: "max_connections", Value: "151" },
{ Variable_name: "innodb_buffer_pool_size", Value: "134217728" },
]),
);
const resource = createVariablesResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://variables",
mockContext,
)) as { variables: Record<string, string> };
expect(result.variables).toEqual({
max_connections: "151",
innodb_buffer_pool_size: "134217728",
});
expect(mockAdapter.executeQuery).toHaveBeenCalledWith(
"SHOW GLOBAL VARIABLES",
);
});
it("should handle empty result set", async () => {
mockAdapter.executeQuery.mockResolvedValueOnce(createMockQueryResult([]));
const resource = createVariablesResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://variables",
mockContext,
)) as { variables: Record<string, string> };
expect(result.variables).toEqual({});
});
it("should handle missing rows property in result", async () => {
mockAdapter.executeQuery.mockResolvedValueOnce({
columns: [],
rowsAffected: 0,
insertId: undefined,
start_time: 0,
executionTimeMs: 0,
});
const resource = createVariablesResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://variables",
mockContext,
)) as { variables: Record<string, string> };
expect(result.variables).toEqual({});
});
it("should handle database errors", async () => {
mockAdapter.executeQuery.mockRejectedValueOnce(
new Error("Connection failed"),
);
const resource = createVariablesResource(
mockAdapter as unknown as MySQLAdapter,
);
await expect(
resource.handler("mysql://variables", mockContext),
).rejects.toThrow("Connection failed");
});
});
