testing-workflow

全面的 E2E、集成和单元测试工作流。适用于逐层测试应用、验证用户旅程或运行测试套件时使用。

SKILL.md

--- frontmatter

name: testing-workflow
description: Comprehensive testing workflow for E2E, integration, and unit tests. Use when testing applications layer-by-layer, validating user journeys, or running test suites.
version: 1.0.0

Testing Workflow Skill

Purpose

Guide comprehensive testing following the layer-by-layer approach. Test systematically from database → backend → frontend → E2E.

Testing Philosophy

DON'T: Test entire system at once DO: Test each layer independently, bottom-up

code

Layer 1: Database ✅ → SQL queries
Layer 2: Backend ✅ → API/Edge Functions
Layer 3: Frontend 🟡 → Component testing
Layer 4: E2E 🔴 → Complete user journeys

Quick Navigation

🗄️ Layer 1: Database

Test SQL, RLS policies, migrations

•See DATABASE.md
•Quick SQL tests, RLS verification, policy checks

⚙️ Layer 2: Backend

Test Edge Functions, APIs

•See BACKEND.md
•Function deployment, secrets, logs

🎨 Layer 3: Frontend

Test components, UI

•See FRONTEND.md
•Component rendering, TypeScript, build

🚀 Layer 4: E2E

Test complete user journeys

•See E2E.md
•Playwright tests, full workflows

Quick Test Commands

Pre-Commit Check (30 sec)

bash

pnpm tsc && pnpm build

Full Test Suite (5 min)

bash

pnpm tsc && pnpm build && npx playwright test

Watch Mode

bash

npx playwright test --ui

Testing Layers

Layer	What	Tools	Time
1. Database	SQL, RLS	Supabase, psql	2 min
2. Backend	Edge Functions	curl, Supabase CLI	3 min
3. Frontend	Components	TypeScript, Build	2 min
4. E2E	User journeys	Playwright	5 min

Pre-Deployment Testing

Complete Test Run (15 min)

bash

# 1. Type check
pnpm tsc --noEmit

# 2. Build
pnpm build

# 3. Start dev server (background)
pnpm dev &

# 4. Manual smoke test
# - Visit /pitch-deck-wizard
# - Send message
# - Verify response

# 5. Run E2E tests
npx playwright test

# 6. Check production build
pnpm preview

Production Readiness Checklist

Code Quality

• pnpm tsc --noEmit → 0 errors
• pnpm lint → 0 warnings
• pnpm build → succeeds
• No console.log in production code

Functionality

• Wizard works (AI responds)
• Progress tracking (0-100%)
• Deck generation works
• All slides render

Backend

• Edge Functions deployed
• Secrets configured
• Database migrations applied
• RLS enabled

Testing

• Manual tests pass
• E2E tests pass
• No console errors
• No network errors

Common Issues

Tests Fail Due to RLS

sql

-- Set test presentation public
UPDATE presentations
SET is_public = true
WHERE id = 'd4a27c1c-8b2d-48a9-99c9-2298037e9e81';

Playwright Timeout

typescript

// Increase timeout
await page.waitForSelector('element', { timeout: 30000 });

TypeScript Errors

bash

# Find all errors
pnpm tsc --noEmit | grep "error TS"

Resources

•Daily Checklist: lovable-plan/management/903-DAILY-TESTING-CHECKLIST.md
•Full Strategy: lovable-plan/docs/004-TESTING-STRATEGY-AND-IMPROVEMENTS.md
•Playwright Docs: https://playwright.dev

Start testing: Begin with DATABASE.md for Layer 1