/**
* mysql-mcp - Resources Unit Tests
*
* Tests for resource definitions using centralized mocks.
*/
import { describe, it, expect, vi, beforeEach } from 'vitest';
import { getMySQLResources } from '../index.js';
import type { MySQLAdapter } from '../../MySQLAdapter.js';
import { createMockMySQLAdapter, createMockRequestContext, createMockQueryResult } from '../../../../__tests__/mocks/index.js';
describe('getMySQLResources', () => {
let resources: ReturnType<typeof getMySQLResources>;
beforeEach(() => {
vi.clearAllMocks();
resources = getMySQLResources(createMockMySQLAdapter() as unknown as MySQLAdapter);
});
it('should return 18 resources', () => {
expect(resources).toHaveLength(18);
});
it('should have handler functions for all resources', () => {
for (const resource of resources) {
expect(typeof resource.handler).toBe('function');
}
});
it('should have descriptions for all resources', () => {
for (const resource of resources) {
expect(resource.description).toBeDefined();
expect(resource.description.length).toBeGreaterThan(0);
}
});
it('should have unique URIs for all resources', () => {
const uris = resources.map(r => r.uri);
const uniqueUris = new Set(uris);
expect(uniqueUris.size).toBe(uris.length);
});
it('should have URIs starting with mysql://', () => {
for (const resource of resources) {
expect(resource.uri.startsWith('mysql://')).toBe(true);
}
});
});
describe('Resource Handler Smoke Tests', () => {
let mockAdapter: ReturnType<typeof createMockMySQLAdapter>;
let mockContext: ReturnType<typeof createMockRequestContext>;
let resources: ReturnType<typeof getMySQLResources>;
beforeEach(() => {
vi.clearAllMocks();
mockAdapter = createMockMySQLAdapter();
mockContext = createMockRequestContext();
resources = getMySQLResources(mockAdapter as unknown as MySQLAdapter);
});
const findResource = (uri: string) => resources.find(r => r.uri === uri);
it('mysql://tables handler should call listTables', async () => {
const resource = findResource('mysql://tables');
expect(resource).toBeDefined();
const result = await resource!.handler('mysql://tables', mockContext);
expect(mockAdapter.listTables).toHaveBeenCalled();
expect(result).toHaveProperty('tables');
});
it('mysql://schema handler should call getSchema', async () => {
const resource = findResource('mysql://schema');
expect(resource).toBeDefined();
const result = await resource!.handler('mysql://schema', mockContext);
expect(mockAdapter.getSchema).toHaveBeenCalled();
expect(result).toHaveProperty('tables');
});
it('mysql://variables handler should execute query', async () => {
mockAdapter.executeQuery.mockResolvedValue(createMockQueryResult([
{ Variable_name: 'version', Value: '8.0.35' }
]));
const resource = findResource('mysql://variables');
expect(resource).toBeDefined();
await resource!.handler('mysql://variables', mockContext);
expect(mockAdapter.executeQuery).toHaveBeenCalledWith(expect.stringContaining('SHOW'));
});
it('mysql://status handler should execute query', async () => {
mockAdapter.executeQuery.mockResolvedValue(createMockQueryResult([
{ Variable_name: 'Uptime', Value: '86400' }
]));
const resource = findResource('mysql://status');
expect(resource).toBeDefined();
await resource!.handler('mysql://status', mockContext);
expect(mockAdapter.executeQuery).toHaveBeenCalledWith(expect.stringContaining('SHOW'));
});
it('mysql://processlist handler should execute processlist query', async () => {
mockAdapter.executeQuery.mockResolvedValue(createMockQueryResult([
{ Id: 1, User: 'root', Command: 'Query' }
]));
const resource = findResource('mysql://processlist');
expect(resource).toBeDefined();
await resource!.handler('mysql://processlist', mockContext);
expect(mockAdapter.executeQuery).toHaveBeenCalledWith(expect.stringContaining('PROCESSLIST'));
});
});
