Does this skill require a specific test runner?

The patterns are optimized for Jest but the logic for environment setup and Prisma transactions can be adapted for other runners like Vitest or Mocha.

How does it manage test data between runs?

It implements a global setup that resets migrations and an after-each hook that uses TRUNCATE to clear tables, ensuring total isolation between individual tests.

Can I test complex database transactions?

Yes, it includes specific patterns for testing atomic operations, including verifying that data rolls back correctly when a step in a transaction fails.

Is this suitable for testing large schemas?

Absolutely. The TRUNCATE strategy is designed to be much faster than re-running migrations between every test, making it ideal for large PostgreSQL schemas.

Database Testing for Prisma & PostgreSQL

Name: Database Testing for Prisma & PostgreSQL
Author: karchtho

bykarchtho

安全与测试

Implements standardized patterns for testing database operations, repositories, and transactions using Prisma ORM and Jest.

关于

This skill provides a comprehensive framework for developers looking to implement robust database testing in Node.js applications. It covers everything from global environment configuration and automated migration resets to advanced transaction rollback verification and repository-level unit testing. By utilizing these standardized patterns, you can ensure that your database interactions, complex queries, and data isolation strategies are reliable, performant, and ready for production-grade environments.

主要功能

0 GitHub stars
Automated test database setup and global Jest configuration
Comprehensive transaction testing to verify atomic rollbacks
Efficient test data isolation using SQL TRUNCATE strategies
Advanced query testing for complex filtering and search logic
Standardized repository testing patterns for CRUD and relations

使用场景

Configuring isolated PostgreSQL environments for local and CI/CD testing
Verifying business logic integrity through complex Prisma transactions
Validating repository methods that involve intricate joins and dynamic filters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add karchtho/my-claude-marketplace database-testing

For use in Claude.ai and ChatGPT

Download Skill

GitHub

关于