import { describe, it, expect, vi, beforeEach } from "vitest";
import { createInnodbResource } from "../innodb.js";
import type { MySQLAdapter } from "../../MySQLAdapter.js";
import {
createMockMySQLAdapter,
createMockRequestContext,
createMockQueryResult,
} from "../../../../__tests__/mocks/index.js";
describe("InnoDB Resource", () => {
let mockAdapter: ReturnType<typeof createMockMySQLAdapter>;
let mockContext: ReturnType<typeof createMockRequestContext>;
beforeEach(() => {
vi.clearAllMocks();
mockAdapter = createMockMySQLAdapter();
mockContext = createMockRequestContext();
});
it("should return buffer pool statistics", async () => {
// Mock buffer pool status
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([
{ Variable_name: "Innodb_buffer_pool_read_requests", Value: "10000" },
{ Variable_name: "Innodb_buffer_pool_reads", Value: "100" },
{ Variable_name: "Innodb_buffer_pool_pages_total", Value: "8192" },
{ Variable_name: "Innodb_buffer_pool_pages_free", Value: "1000" },
{ Variable_name: "Innodb_buffer_pool_pages_data", Value: "7000" },
{ Variable_name: "Innodb_buffer_pool_pages_dirty", Value: "50" },
{ Variable_name: "Innodb_buffer_pool_write_requests", Value: "5000" },
]),
);
// Mock config
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([
{ Variable_name: "innodb_buffer_pool_size", Value: "134217728" },
{ Variable_name: "innodb_buffer_pool_instances", Value: "1" },
]),
);
// Mock row operations
mockAdapter.executeQuery.mockResolvedValueOnce(
createMockQueryResult([
{ Variable_name: "Innodb_rows_read", Value: "50000" },
{ Variable_name: "Innodb_rows_inserted", Value: "1000" },
]),
);
const resource = createInnodbResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler("mysql://innodb", mockContext)) as {
buffer_pool: { hit_ratio_percent: number };
};
expect(result).toHaveProperty("io");
});
it("should handle missing buffer pool stats (division by zero protection)", async () => {
// Mock empty stats
mockAdapter.executeQuery.mockResolvedValue(createMockQueryResult([]));
const resource = createInnodbResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://innodb",
mockContext,
)) as any;
expect(result.buffer_pool.hit_ratio_percent).toBe(100); // Default when requests=0
expect(result.buffer_pool.pages.dirty_percent).toBe(0); // Default when total=0
expect(result.buffer_pool.size_bytes).toBe(0);
});
it("should parse configuration integers correctly", async () => {
mockAdapter.executeQuery
.mockResolvedValueOnce(createMockQueryResult([])) // buffer pool stats
.mockResolvedValueOnce(
createMockQueryResult([
// config
{ Variable_name: "innodb_buffer_pool_size", Value: "1024" },
{ Variable_name: "innodb_buffer_pool_instances", Value: "2" },
]),
)
.mockResolvedValueOnce(createMockQueryResult([])); // row ops
const resource = createInnodbResource(
mockAdapter as unknown as MySQLAdapter,
);
const result = (await resource.handler(
"mysql://innodb",
mockContext,
)) as any;
expect(result.buffer_pool.size_bytes).toBe(1024);
expect(result.buffer_pool.instances).toBe(2);
});
});
