CAIRL Roadmap Phase 2 - Testing Script

Feature Branch: feature/roadmap-admin-interface Phase: 2 Complete (2A + 2B + 2C) Tester: HuggyCoder Date: **___**

Part 1: Automated Checks (Claude Code)

Run these commands. All must pass before UAT begins.

# ── Build & Type Safety ──────────────────────────────
echo "=== 1. Type Check ==="
npm run type-check
echo ""

echo "=== 2. Lint ==="
npm run lint
echo ""

echo "=== 3. Build ==="
npm run build
echo ""

# ── Database ─────────────────────────────────────────
echo "=== 4. Generate Migration ==="
npm run db:generate
echo ""

echo "=== 5. Apply Migrations ==="
npm run db:migrate
echo ""

echo "=== 6. Run Seed Script ==="
npx tsx scripts/seed-roadmap.ts
echo ""

# ── API Smoke Tests ──────────────────────────────────
# Start dev server first: npm run dev

echo "=== 7. API: List Initiatives ==="
curl -s http://localhost:3000/api/roadmap/initiatives | head -c 500
echo ""

echo "=== 8. API: List Sprints ==="
curl -s http://localhost:3000/api/roadmap/sprints | head -c 500
echo ""

echo "=== 9. API: List Tasks ==="
curl -s http://localhost:3000/api/roadmap/tasks | head -c 500
echo ""

echo "=== 10. API: List Dependencies ==="
curl -s http://localhost:3000/api/roadmap/dependencies | head -c 500
echo ""

echo "=== 11. API: List Changelog ==="
curl -s http://localhost:3000/api/roadmap/changelog | head -c 500
echo ""

echo "=== 12. API: Create Initiative ==="
curl -s -X POST http://localhost:3000/api/roadmap/initiatives \
  -H "Content-Type: application/json" \
  -d '{
    "title": "TEST: Smoke Test Initiative",
    "category": "tech_debt",
    "phase": "exploration",
    "priority": "low"
  }' | head -c 500
echo ""

echo "=== 13. API: Create Sprint ==="
curl -s -X POST http://localhost:3000/api/roadmap/sprints \
  -H "Content-Type: application/json" \
  -d '{
    "title": "TEST: Smoke Test Sprint",
    "category": "tech_debt",
    "phase": "exploration",
    "priority": "low"
  }' | head -c 500
echo ""

# Note: These curl tests may return 401/403 if auth is required.
# If so, that's correct behavior — confirms auth guard works.
# Test authenticated routes through the browser UI instead.

echo ""
echo "=== AUTOMATED CHECKS COMPLETE ==="
echo "If type-check, lint, and build passed: proceed to UAT"
echo "If API returns 401/403: auth guards working, test via browser"

Part 2: UAT Checklist

Prerequisites

1. Dev Server

• Dev server running (npm run dev)
• Browser dev tools open (Console tab for errors)

2. Database Setup

• Migrations applied (npm run db:migrate)
• Seed data loaded (npx tsx scripts/seed-roadmap.ts)
• Verify seed data: initiatives, sprints, tasks visible in database

3. Admin User Setup

REQUIRED: The seed script does NOT create admin users. You must have an admin user before starting UAT.

Option A: Use Existing Admin User

• Admin user already exists in database
• Skip to authentication step

Option B: Create Admin User via Registration

1. Navigate to registration page
2. Create user with email: admin@test.cairl.local
3. Manually update role in database:

# Connect to local database
psql "postgresql://localhost:5433/cairl_local"

# Update user role to admin
UPDATE users SET role = 'admin' WHERE email = 'admin@test.cairl.local';

# Verify
SELECT id, email, role FROM users WHERE role = 'admin';

# Exit
\q

Option C: Direct Database Insert

# Connect to local database
psql "postgresql://localhost:5433/cairl_local"

# Check users table schema
\d users

# Insert admin user (adjust fields based on your schema)
INSERT INTO users (email, role, email_verified)
VALUES ('admin@test.cairl.local', 'admin', true);

# Exit
\q

4. Authentication

• Logged in as admin user (super_admin or admin role)
• Verify admin access to /admin routes

2.1 Dashboard Overview (/admin/roadmap)

Notes: **___**

2.2 Initiative Management

List (/admin/roadmap/initiatives)

Create (/admin/roadmap/initiatives/new)

Edit (/admin/roadmap/initiatives/[id])

Notes: **___**

2.3 Sprint Management

List (/admin/roadmap/sprints)

Create (/admin/roadmap/sprints/new)

Edit (/admin/roadmap/sprints/[id])

Notes: **___**

2.4 Task Management

Inline Status Changes (on Sprint edit page)

Reordering (on Sprint edit page)

Task Edit Page (/admin/roadmap/tasks/[id])

Status Badge Colors

Notes: **___**

2.5 Dependencies

Notes: **___**

2.6 Changelog

Global Changelog (/admin/roadmap/changelog)

Inline Changelog (on edit pages)

Notes: **___**

2.7 Progress Rollup Accuracy

Notes: **___**

2.8 Auth & Permissions

Notes: **___**

2.9 Error Handling & Edge Cases

Notes: **___**

Part 3: Sign-Off

Results Summary

Blocking Issues (must fix before merge)

Non-Blocking Issues (can fix later)

Sign-Off

• All blocking issues resolved
• No console errors on any page
• Type check passes
• Lint passes
• Build passes
• Ready to merge to develop

Tester: **___** Date: **___** Branch Merge Approved: ☐ Yes ☐ No (list blockers)

Merge Checklist

After UAT passes:

# Ensure clean state
git checkout feature/roadmap-admin-interface
git pull origin feature/roadmap-admin-interface

# Final checks
npm run type-check
npm run lint
npm run build

# Merge to develop
git checkout develop
git pull origin develop
git merge feature/roadmap-admin-interface
git push origin develop

# Verify on staging
# Run seed on staging database
# Spot-check critical paths