developer-delphi-testing-integration

Validate Delphi module integration against a real SQLite database with BEGIN/ROLLBACK isolation.

Updated Jan 6, 2026

Search Tags:#sqlite #fixtures #integration-testing #smoke-tests #delphi #firedac #begin-rollback

Ready to run

npx skills add https://github.com/cslsoftwares/ParamentersORM --skill developer-delphi-testing-integration

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: developer-delphi-testing-integration
Source: https://github.com/cslsoftwares/ParamentersORM/tree/main/.cursor/skills/developer-delphi-testing-integration_V1.0.0
Command: npx skills add https://github.com/cslsoftwares/ParamentersORM --skill developer-delphi-testing-integration

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Integration testing in Delphi against real external resources (SQLite via FireDAC) with automatic BEGIN/ROLLBACK isolation, enabling reusable data fixtures, and smoke tests that exercise cross-layer rules across repository, service, and domain layers.

Core Features & Use Cases

Real-database integration tests across repository, service and domain layers using SQLite.
BEGIN/ROLLBACK isolation to ensure test isolation and repeatability.
Fixtures of data and smoke tests to verify module initialization and cross-layer business rules.
Clear guidance on scoping tests (integration over unit tests with mocks).

Quick Start

Configure a SQLite database and run the integration test suite to validate persistent state across layers.

Frequently Asked Questions about developer-delphi-testing-integration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run Delphi integration tests against a real SQLite database without polluting data?▼

You can run Delphi integration tests against a real SQLite database using BEGIN/ROLLBACK transaction isolation. This approach wraps each test in a transaction that is rolled back, ensuring persistent state is validated without permanently modifying the database.

What is the difference between unit tests with mocks and integration testing in Delphi?▼

Integration testing in Delphi validates cross-layer business rules across repository, service, and domain layers against a real database. Unit tests with mocks isolate individual modules, whereas integration tests verify that modules work together correctly with persistent state.

Can I use FireDAC with SQLite for cross-layer business rule verification?▼

Yes, you can use FireDAC with SQLite to verify cross-layer business rules. This setup allows you to execute smoke tests and validate module initialization across repository, service, and domain layers using real database interactions.

How do I set up reusable data fixtures for Delphi smoke tests?▼

You can set up reusable data fixtures for Delphi smoke tests by combining them with BEGIN/ROLLBACK isolation. This ensures test repeatability by resetting the SQLite database state after each test runs.

When should I use BEGIN and ROLLBACK for test isolation in Delphi database testing?▼

You should use BEGIN and ROLLBACK for test isolation when running integration tests that modify persistent state. This mechanism ensures each test runs in isolation and maintains repeatability across the SQLite database without leaving residual data.

Does this approach support testing domain logic and services together in Delphi?▼

Yes, this approach supports testing domain logic and services together in Delphi. It provides cross-layer coverage that includes repositories, services, and domain logic, ensuring that all layers integrate correctly against the SQLite database.