box-nestjs-monorepo/apps/box-mgnt-api/test/README.md

Video Cache E2E Test

Overview

This test validates the Redis cache contract for video caches:

• Category video lists contain ONLY video IDs (not Tag JSON)
• Tag-filtered video lists contain ONLY video IDs
• Tag metadata lists contain ONLY Tag JSON objects

Prerequisites

Before running the test, ensure:

1. MongoDB is running and accessible with valid credentials
2. Redis is running on localhost:6379 (or configure in .env file)
3. MongoDB has test data (channels, categories, videos, tags)

Environment Setup

The test uses .env.mgnt.test for configuration. Update the following variables if needed:

# MongoDB connection (ensure user exists and has correct permissions)
MONGO_URL="mongodb://boxuser:PASSWORD@localhost:27017/box_admin?authSource=admin"
MONGO_STATS_URL="mongodb://boxstatuser:PASSWORD@localhost:27017/box_stats?authSource=admin"

# Redis connection
REDIS_HOST=127.0.0.1
REDIS_PORT=6379
REDIS_DB=0

MongoDB Authentication Issues

If you see SCRAM failure: Authentication failed:

1. Option A: Create the MongoDB user:

   mongosh admin
   db.createUser({
    user: "boxuser",
    pwd: "YOUR_PASSWORD",
    roles: [{ role: "readWrite", db: "box_admin" }]
   })
   

2. Option B: Update .env.mgnt.test to use your existing MongoDB credentials

3. Option C: Use connection string without authentication:

   MONGO_URL="mongodb://localhost:27017/box_admin"
   

Running the Test

# From box-nestjs-monorepo directory
pnpm test:e2e:mgnt

Test Output

Successful test output includes:

✅ Redis connection verified
🗑️  Deleted cache keys: { ... }
🔨 Rebuilding video caches...
📋 Found X category video list keys
📋 Found X tag-filtered video list keys
📋 Found X tag metadata list keys
✅ All cache keys validated successfully!

Validation Logic

The test performs these validations:

Video List Keys

• Key type is list
• Each element is a 24-character hex string (MongoDB ObjectId)
• Fails if Tag JSON or Category JSON is detected

Tag Metadata Keys

• Key type is list
• Each element is valid JSON with required fields: id, name, seq, status, channelId, categoryId
• Fails if plain video IDs are detected

Troubleshooting

No Cache Keys Found

If test shows Found 0 category video list keys:

• MongoDB has no data - run seed scripts:

  pnpm prisma:seed:mongo:test
  

Test Timeout

If test exceeds 60 seconds:

• Check MongoDB query performance
• Ensure indexes exist on frequently queried fields
• Reduce test data volume

Redis Connection Failed

If expect(pong).toBe('PONG') fails:

• Verify Redis is running: redis-cli ping
• Check REDIS_HOST and REDIS_PORT in .env.mgnt.test