mirror of https://github.com/czlonkowski/n8n-mcp.git synced 2026-03-28 21:23:07 +00:00

Files

Romuald Członkowski de2abaf89d refactor: streamline test suite — 33 fewer files, 11.9x faster (#670 )

* refactor: streamline test suite - cut 33 files, enable parallel execution (11.9x speedup)

Remove duplicate, low-value, and fragmented test files while preserving
all meaningful coverage. Enable parallel test execution and remove
the entire benchmark infrastructure.

Key changes:
- Consolidate workflow-validator tests (13 files -> 3)
- Consolidate config-validator tests (9 files -> 3)
- Consolidate telemetry tests (11 files -> 6)
- Merge AI validator tests (2 files -> 1)
- Remove example/demo test files, mock-testing files, and already-skipped tests
- Remove benchmark infrastructure (10 files, CI workflow, 4 npm scripts)
- Enable parallel test execution (remove singleThread: true)
- Remove retry:2 that was masking flaky tests
- Slim CI publish-results job

Results: 224 -> 191 test files, 4690 -> 4303 tests, 121K -> 106K lines
Local runtime: 319s -> 27s (11.9x speedup)

Conceived by Romuald Członkowski - www.aiadvisors.pl/en

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

* refactor: absorb config-validator satellite tests into consolidated file

The previous commit deleted 4 config-validator satellite files. This
properly merges their unique tests into the consolidated config-validator.test.ts,
recovering 89 tests that were dropped during the bulk deletion.

Deduplicates 5 tests that existed in both the satellite files and the
security test file.

Conceived by Romuald Członkowski - www.aiadvisors.pl/en

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

* fix: delete missed benchmark-pr.yml workflow, fix flaky session test

- Remove benchmark-pr.yml that referenced deleted benchmark:ci script
- Fix session-persistence round-trip test using timestamps closer to
  now to avoid edge cases exposed by removing retry:2

Conceived by Romuald Członkowski - www.aiadvisors.pl/en

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

* fix: rebuild FTS5 index after database rebuild to prevent stale rowid refs

The FTS5 content-synced index could retain phantom rowid references from
previous rebuild cycles, causing 'missing row N from content table'
errors on MATCH queries.

- Add explicit FTS5 rebuild command in rebuild script after all nodes saved
- Add FTS5 rebuild in test beforeAll as defense-in-depth
- Rebuild nodes.db with consistent FTS5 index

Conceived by Romuald Członkowski - www.aiadvisors.pl/en

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

* fix: use recent timestamps in all session persistence tests

Session round-trip tests used timestamps 5-10 minutes in the past which
could fail under CI load when combined with session timeout validation.
Use timestamps 30 seconds in the past for all valid-session test data.

Conceived by Romuald Członkowski - www.aiadvisors.pl/en

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

---------

Co-authored-by: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

2026-03-27 14:22:22 +01:00

__mocks__

fix: resolve TypeScript errors in test files

2025-07-28 20:28:45 +02:00

node-repository-ai-documentation.test.ts

feat: AI-powered documentation for community nodes (#530 )

2026-01-08 13:14:02 +01:00

node-repository-community.test.ts

chore: update n8n to 2.13.3 (#666 )

2026-03-26 22:21:56 +01:00

node-repository-core.test.ts

chore: update n8n to 2.13.3 (#666 )

2026-03-26 22:21:56 +01:00

node-repository-operations.test.ts

test: improve test coverage with comprehensive test suites

2025-09-25 09:17:02 +02:00

node-repository-outputs.test.ts

chore: update n8n to 2.13.3 (#666 )

2026-03-26 22:21:56 +01:00

README.md

test: add comprehensive unit tests for database, parsers, loaders, and MCP tools

2025-07-28 20:16:38 +02:00

shared-database.test.ts

fix: critical memory leak from per-session database connections (#554 )

2026-01-23 19:51:22 +01:00

template-repository-core.test.ts

fix: update tests for template compression, pagination, and quality filtering

2025-09-14 15:42:35 +02:00

README.md

Database Layer Unit Tests

This directory contains comprehensive unit tests for the database layer components of n8n-mcp.

Test Coverage

node-repository.ts - 100% Coverage ✅

saveNode method with JSON serialization
getNode method with JSON deserialization
getAITools method
safeJsonParse private method
Edge cases: large JSON, boolean conversion, invalid JSON handling

template-repository.ts - 80.31% Coverage ✅

FTS5 initialization and fallback
saveTemplate with sanitization
getTemplate and getTemplatesByNodes
searchTemplates with FTS5 and LIKE fallback
getTemplatesForTask with task mapping
Template statistics and maintenance operations
Uncovered: Some error paths in FTS5 operations

database-adapter.ts - Tested via Mocks

Interface compliance tests
PreparedStatement implementation
Transaction support
FTS5 detection logic
Error handling patterns

Test Strategy

The tests use a mock-based approach to:

Isolate database operations from actual database dependencies
Test business logic without requiring real SQLite/sql.js
Ensure consistent test execution across environments
Focus on behavior rather than implementation details

Key Test Files

node-repository-core.test.ts - Core NodeRepository functionality
template-repository-core.test.ts - Core TemplateRepository functionality
database-adapter-unit.test.ts - DatabaseAdapter interface and patterns

Running Tests

# Run all database tests
npm test -- tests/unit/database/

# Run with coverage
npm run test:coverage -- tests/unit/database/

# Run specific test file
npm test -- tests/unit/database/node-repository-core.test.ts

Mock Infrastructure

The tests use custom mock implementations:

MockDatabaseAdapter - Simulates database operations
MockPreparedStatement - Simulates SQL statement execution
Mock logger and template sanitizer for external dependencies

This approach ensures tests are fast, reliable, and maintainable.