LiorCohen/sdd / plugin/fullstack-typescript/skills/components/integration-testing/integration-testing-standards
integration-testing-standards
VerifiedIntegration testing patterns - database setup/teardown, API testing, contract testing, and Testkube execution.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 4.1 KB |
| resources/api-testing.md | markdown | 4.4 KB |
| resources/authentication.md | markdown | 1.9 KB |
| resources/database-strategies.md | markdown | 3.2 KB |
| resources/testkube.md | markdown | 1.5 KB |
resources/database-strategies.md
View on GitHub# Database Strategies
Strategies for managing test database state: initialization, cleanup, and seeding.
---
## Test Database Initialization
```typescript
// components/<testing-component>/tests/integration/helpers/database.ts
import { Pool } from 'pg';
let pool: Pool | null = null;
export const getTestDatabase = (): Pool => {
if (!pool) {
pool = new Pool({
connectionString: process.env.TEST_DATABASE_URL,
max: 5,
});
}
return pool;
};
export const closeTestDatabase = async (): Promise<void> => {
if (pool) {
await pool.end();
pool = null;
}
};
```
## Cleanup Strategies
### Transaction Rollback (Fastest)
```typescript
import { describe, it, beforeEach, afterEach } from 'vitest';
import { getTestDatabase } from '../helpers/database';
describe('User API', () => {
let client: PoolClient;
beforeEach(async () => {
const pool = getTestDatabase();
client = await pool.connect();
await client.query('BEGIN');
});
afterEach(async () => {
await client.query('ROLLBACK');
client.release();
});
it('creates user', async () => {
// Test runs in transaction, rolled back after
});
});
```
### Truncate Tables (Clean State)
```typescript
// components/<testing-component>/tests/integration/helpers/cleanup.ts
const TABLES_TO_TRUNCATE = [
'plan_items',
'plans',
'users',
// Order matters - respect foreign keys
];
export const truncateTables = async (pool: Pool): Promise<void> => {
const client = await pool.connect();
try {
await client.query('BEGIN');
for (const table of TABLES_TO_TRUNCATE) {
await client.query(`TRUNCATE TABLE ${table} CASCADE`);
}
await client.query('COMMIT');
} finally {
client.release();
}
};
```
### Delete by Test Marker (Surgical)
```typescript
export const cleanupTestData = async (pool: Pool, testRunId: string): Promise<void> => {
const client = await pool.connect();
try {
// Delete only data created by this test run
await client.query(`DELETE FROM users WHERE metadata->>'testRunId' = $1`, [testRunId]);
} finally {
client.release();
}
};
```
---
## Seed Data
### SQL Seed Files
```sql
-- components/<testing-component>/fixtures/seed-data.sql
INSERT INTO users (id, email, name, role, client_id, password_hash, created_at)
VALUES
('seed-admin-1', 'admin@test.com', 'Test Admin', 'admin', 'test-client', '$2b$10$...', NOW()),
('seed-planner-1', 'planner@test.com', 'Test Planner', 'planner', 'test-client', '$2b$10$...', NOW());
INSERT INTO plans (id, name, owner_id, status, created_at)
VALUES
('seed-plan-1', 'Test Plan', 'seed-planner-1', 'draft', NOW());
```
### Programmatic Seeding
```typescript
// components/<testing-component>/tests/integration/helpers/seed.ts
import { Pool } from 'pg';
import { hashPassword } from './auth';
export const seedTestUsers = async (pool: Pool): Promise<void> => {
const passwordHash = await hashPassword('TestPass123!');
await pool.query(`
INSERT INTO users (id, email, name, role, client_id, password_hash, created_at)
VALUES
($1, $2, $3, $4, $5, $6, NOW())
ON CONFLICT (id) DO NOTHING
`, ['seed-user-1', 'test@example.com', 'Test User', 'planner', 'test-client', passwordHash]);
};
```
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |