TC_ADMIN_005: Seed Data Verification

Test Case Information

Objective

Verify all test data (events, invoices, membership types) exists and is correctly configured.

Seed Script Reference

# Run seed (safe upserts)
docker exec membervu-backend npm run seed:rcme

Reset and reseed (destructive)
docker exec membervu-backend npm run seed:rcme -- --reset

Test Steps

Step 1: Verify Membership Types

Query:

SELECT name, "amountCents", currency, period, "isActive"
FROM "MembershipType"
WHERE "tenantId" = (SELECT id FROM "Tenant" WHERE slug = 'rcme');

Expected Data:

Step 2: Verify Test Events

Query:

SELECT slug, title, status, visibility, "priceCents", capacity
FROM "Event"
WHERE "tenantId" = (SELECT id FROM "Tenant" WHERE slug = 'rcme')
ORDER BY slug;

Expected Data:

Via UI:

1. Login as admin
2. Navigate to /admin/events
3. Verify all 3 events appear
4. Verify status badges correct

Step 3: Verify Test Invoices

Query:

SELECT
  i."invoiceNumber",
  m.email as "memberEmail",
  i.status,
  i."amountCents",
  i.description
FROM "Invoice" i
JOIN "Member" m ON i."memberId" = m.id
WHERE i."tenantId" = (SELECT id FROM "Tenant" WHERE slug = 'rcme')
ORDER BY i."invoiceNumber";

Expected Data:

Via UI:

1. Login as treasurer
2. Navigate to /admin/invoices
3. Verify all 5 invoices appear
4. Use status filter to verify each status

Step 4: Verify Member Records

Query:

SELECT
  email,
  "firstName",
  "lastName",
  status,
  "membershipApplicationStatus",
  roles
FROM "Member"
WHERE "tenantId" = (SELECT id FROM "Tenant" WHERE slug = 'rcme')
ORDER BY email;

Expected Data (12 members):

Step 5: Verify User-Member Linking

Query:

SELECT
  u.email,
  u.roles as "userRoles",
  u."platformRoles",
  m.roles as "memberRoles",
  m.status as "memberStatus"
FROM "User" u
JOIN "Member" m ON u."memberId" = m.id
WHERE u."tenantId" = (SELECT id FROM "Tenant" WHERE slug = 'rcme')
ORDER BY u.email;

Step 6: Verify Event Dates

Query:

SELECT slug, "startsAt", "endsAt",
  CASE
    WHEN "startsAt" > NOW() THEN 'FUTURE'
    WHEN "endsAt" < NOW() THEN 'PAST'
    ELSE 'CURRENT'
  END as timing
FROM "Event"
WHERE "tenantId" = (SELECT id FROM "Tenant" WHERE slug = 'rcme');

Step 7: Verify Invoice Dates

Query:

SELECT
  "invoiceNumber",
  "issuedAt",
  "dueAt",
  "paidAt",
  CASE
    WHEN "dueAt" < NOW() AND status != 'PAID' THEN 'OVERDUE'
    ELSE 'OK'
  END as "dueStatus"
FROM "Invoice"
WHERE "tenantId" = (SELECT id FROM "Tenant" WHERE slug = 'rcme');

Pass/Fail Criteria

Troubleshooting

Missing Data

# Reseed completely
docker exec membervu-backend npm run seed:rcme -- --reset

Wrong Tenant

# Verify tenant ID
docker exec membervu-backend npx prisma db execute --stdin <<< \
  "SELECT id, slug FROM \"Tenant\" WHERE slug = 'rcme';"

Stale Dates

Seed script uses relative dates (daysFromNow, daysAgo). Reseed if dates have drifted.

Result Summary

Tester: _________________

Date: _________________