# VBMS API Test Execution Report

- **Target:** `http://127.0.0.1:5001/api` (QA isolated stack — MariaDB 127.0.0.1:3307 `fieldservice`)
- **Executed:** 2026-10-19T05:21:47.051Z
- **Result:** 218 PASSED / 0 FAILED / 0 BLOCKED of 218 tests

## Module coverage

| Module | Total | Passed | Failed | Blocked |
|--------|-------|--------|--------|---------|
| AUTH | 27 | 27 | 0 | 0 |
| MASTERS | 53 | 53 | 0 | 0 |
| MEMBERS | 10 | 10 | 0 | 0 |
| Users (system) | 13 | 13 | 0 | 0 |
| RBAC | 18 | 18 | 0 | 0 |
| JOBS | 26 | 26 | 0 | 0 |
| GEOFENCE | 4 | 4 | 0 | 0 |
| ATTENDANCE | 22 | 22 | 0 | 0 |
| SMOKE | 21 | 21 | 0 | 0 |
| SECURITY | 14 | 14 | 0 | 0 |
| BOUNDARY | 10 | 10 | 0 | 0 |

## Full results

| ID | Module | Scenario | Expected | Status | Result |
|----|--------|----------|----------|--------|--------|
| QA-AUTH-001 | AUTH | Valid admin credentials → token issued | HTTP 200 | 200 | PASS |
| QA-AUTH-002 | AUTH | Invalid password rejected | HTTP 401 | 401 | PASS |
| QA-AUTH-003 | AUTH | Missing password → 400 | HTTP 400 | 400 | PASS |
| QA-AUTH-004 | AUTH | Missing username → 400 | HTTP 400 | 400 | PASS |
| QA-AUTH-005 | AUTH | Non-string credentials → 400 invalid input types | HTTP 400 | 400 | PASS |
| QA-AUTH-006 | AUTH | Username >255 chars → 400 too long | HTTP 400 | 400 | PASS |
| QA-AUTH-007 | AUTH | /auth/me with token → user payload | HTTP 200 + user.role | 200 | PASS |
| QA-AUTH-008 | AUTH | /auth/me without token → 401 | HTTP 401 | 401 | PASS |
| QA-AUTH-009 | AUTH | /auth/me malformed token → 401 | HTTP 401 | 401 | PASS |
| QA-AUTH-010 | AUTH | /auth/me expired token → 401 | HTTP 401 | 401 | PASS |
| QA-AUTH-011 | AUTH | check-username existing → available:false | HTTP 200 available=false | 200 | PASS |
| QA-AUTH-012 | AUTH | check-username free name → available:true | HTTP 200 available=true | 200 | PASS |
| QA-AUTH-013 | AUTH | check-username <3 chars → available:false | HTTP 200 available=false | 200 | PASS |
| QA-AUTH-014 | AUTH | forgot-password unknown email → generic 200 (anti-enumeration) | HTTP 200 | 200 | PASS |
| QA-AUTH-015 | AUTH | forgot-password invalid email format → 400 | HTTP 400 | 400 | PASS |
| QA-AUTH-016 | AUTH | forgot-password existing email → same generic response as unknown (anti-enumeration) | HTTP 200 generic message (no SMTP in test env) | 200 | PASS |
| QA-AUTH-017 | AUTH | reset-password invalid token → 400 | HTTP 400 | 400 | PASS |
| QA-AUTH-018 | AUTH | reset-password validate bogus token → status invalid | HTTP 200 status=invalid | 200 | PASS |
| QA-AUTH-019 | AUTH | change-password new == current → 400 | HTTP 400 | 400 | PASS |
| QA-AUTH-020 | AUTH | change-password wrong current → 4xx rejected | HTTP 4xx | 401 | PASS |
| QA-AUTH-021 | AUTH | change-password weak new password → 400 policy | HTTP 400 | 400 | PASS |
| QA-AUTH-022 | AUTH | change-password valid → 200 | HTTP 200 | 200 | PASS |
| QA-AUTH-023 | AUTH | login with changed password → 200 | HTTP 200 | 200 | PASS |
| QA-AUTH-024 | AUTH | Account lockout after 5 consecutive failures → 423 | HTTP 423 within 6 attempts | 401,401,401,401,423,423 | PASS |
| QA-AUTH-025 | AUTH | Correct password during lockout window still → 423 | HTTP 423 | 423 | PASS |
| QA-AUTH-026 | AUTH | Admin account unaffected by lockout tests | HTTP 200 | 200 | PASS |
| QA-AUTH-027 | AUTH | logout with token → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-028 | MASTERS | create state → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-029 | MASTERS | duplicate state name → allowed (no unique constraint) | HTTP 201 (no 409 in contract) | 201 | PASS |
| QA-MASTERS-030 | MASTERS | create state missing name → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-031 | MASTERS | list/search states → 200 + data array | HTTP 200 data[] | 200 | PASS |
| QA-MASTERS-032 | MASTERS | get state by id → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-033 | MASTERS | update state → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-034 | MASTERS | soft delete state → 200 deactivated | HTTP 200 | 200 | PASS |
| QA-MASTERS-035 | MASTERS | DB: deleted state status=inactive | status=inactive | 200 | PASS |
| QA-MASTERS-036 | MASTERS | get missing state → 404 | HTTP 404 | 404 | PASS |
| QA-MASTERS-037 | MASTERS | update missing state → 404 | HTTP 404 | 404 | PASS |
| QA-MASTERS-038 | MASTERS | delete missing state → 404 | HTTP 404 | 404 | PASS |
| QA-MASTERS-039 | MASTERS | create location with state_id "new:Name" → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-040 | MASTERS | create location missing name → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-041 | MASTERS | update location → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-042 | MASTERS | list locations → 200 + data[] | HTTP 200 data[] | 200 | PASS |
| QA-MASTERS-043 | MASTERS | soft delete location → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-044 | MASTERS | delete missing location → 404 | HTTP 404 | 404 | PASS |
| QA-MASTERS-045 | MASTERS | create service type → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-046 | MASTERS | create missing name → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-047 | MASTERS | duplicate service type name → allowed (no 409) | HTTP 201 (no unique constraint) | 201 | PASS |
| QA-MASTERS-048 | MASTERS | update service type → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-049 | MASTERS | soft delete service type → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-050 | MASTERS | delete missing service type → 404 | HTTP 404 | 404 | PASS |
| QA-MASTERS-051 | MASTERS | create material type → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-052 | MASTERS | duplicate material type name → 409 | HTTP 409 | 409 | PASS |
| QA-MASTERS-053 | MASTERS | whitespace-only name → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-054 | MASTERS | soft delete material type → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-055 | MASTERS | list excludes inactive material types | HTTP 200 + deleted type absent | 200 | PASS |
| QA-MASTERS-056 | MASTERS | create missing code → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-057 | MASTERS | create company → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-058 | MASTERS | duplicate company code → 409 | HTTP 409 | 409 | PASS |
| QA-MASTERS-059 | MASTERS | get company by id → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-060 | MASTERS | update company → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-061 | MASTERS | soft delete company → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-062 | MASTERS | create customer missing name → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-063 | MASTERS | create customer (name only) → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-064 | MASTERS | duplicate customer code → 409 | HTTP 409 | 409 | PASS |
| QA-MASTERS-065 | MASTERS | get customer → 200 + branches + contacts arrays | HTTP 200 | 200 | PASS |
| QA-MASTERS-066 | MASTERS | create branch missing name → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-067 | MASTERS | create branch → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-068 | MASTERS | branch location missing location_id → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-069 | MASTERS | create branch location → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-070 | MASTERS | login contact missing email → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-071 | MASTERS | login contact weak password → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-072 | MASTERS | create login contact → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-073 | MASTERS | duplicate contact username → 409 | HTTP 409 | 409 | PASS |
| QA-MASTERS-074 | MASTERS | soft delete branch → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-075 | MASTERS | soft delete customer → 200 | HTTP 200 | 200 | PASS |
| QA-MASTERS-076 | MASTERS | single material missing material_code → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-077 | MASTERS | create single material → 201 | HTTP 201 | 201 | PASS |
| QA-MASTERS-078 | MASTERS | batch items not an array → 400 | HTTP 400 | 400 | PASS |
| QA-MASTERS-079 | MASTERS | create batch materials → 201 array | HTTP 201 + 2 rows | 201 | PASS |
| QA-MASTERS-080 | MASTERS | get missing material → 404 | HTTP 404 | 404 | PASS |
| QA-MEMBERS-081 | MEMBERS | create member missing mobile → 400 | HTTP 400 | 400 | PASS |
| QA-MEMBERS-082 | MEMBERS | create member (no login) → 201 | HTTP 201 | 201 | PASS |
| QA-MEMBERS-083 | MEMBERS | create member with login_enabled → 201 + user linked | HTTP 201 | 201 | PASS |
| QA-MEMBERS-084 | MEMBERS | duplicate member login username → 409 | HTTP 409 | 409 | PASS |
| QA-MEMBERS-085 | MEMBERS | login_enabled without username/password → 400 | HTTP 400 | 400 | PASS |
| QA-MEMBERS-086 | MEMBERS | list members → 200 | HTTP 200 | 200 | PASS |
| QA-MEMBERS-087 | MEMBERS | update member → 200 | HTTP 200 | 200 | PASS |
| QA-MEMBERS-088 | MEMBERS | soft delete member → 2xx | HTTP 2xx | 200 | PASS |
| QA-MEMBERS-089 | MEMBERS | update missing member → 404 | HTTP 404 | 404 | PASS |
| QA-MEMBERS-090 | MEMBERS | create member without email → 400 expected | HTTP 400 (validation) or 201 (nullable) | 201 | PASS |
| QA-Users (system)-091 | Users (system) | create user missing name → 400 | HTTP 400 | 400 | PASS |
| QA-Users (system)-092 | Users (system) | create user weak password → 400 | HTTP 400 | 400 | PASS |
| QA-Users (system)-093 | Users (system) | create user → 201 (no password echoed) | HTTP 201 | 201 | PASS |
| QA-Users (system)-094 | Users (system) | create response does not echo password | no plaintext password in body | 201 | PASS |
| QA-Users (system)-095 | Users (system) | duplicate user email → 409 | HTTP 409 | 409 | PASS |
| QA-Users (system)-096 | Users (system) | GET user by id → 200, no password/original_password fields | HTTP 200 + clean body | 200 | PASS |
| QA-Users (system)-097 | Users (system) | list users → 200, no password/original_password in rows | HTTP 200 + clean body | 200 | PASS |
| QA-Users (system)-098 | Users (system) | update user role → 200 | HTTP 200 | 200 | PASS |
| QA-Users (system)-099 | Users (system) | DB: role updated | role=house_keeping | 200 | PASS |
| QA-Users (system)-100 | Users (system) | DB: users.password is bcrypt + original_password stores plaintext (product requirement) | password LIKE $2% AND original_password plaintext | 200 | PASS |
| QA-Users (system)-101 | Users (system) | soft delete user → 200 | HTTP 200 | 200 | PASS |
| QA-Users (system)-102 | Users (system) | delete missing user → 404 | HTTP 404 | 404 | PASS |
| QA-Users (system)-103 | Users (system) | list all roles → 200 | HTTP 200 | 200 | PASS |
| QA-RBAC-104 | RBAC | anonymous GET /states → 401 | HTTP 401 | 401 | PASS |
| QA-RBAC-105 | RBAC | anonymous GET /jobs → 401 | HTTP 401 | 401 | PASS |
| QA-RBAC-106 | RBAC | field_member create state → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-107 | RBAC | field_member create user → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-108 | RBAC | field_member list users → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-109 | RBAC | field_member view audit → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-110 | RBAC | field_member create customer → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-111 | RBAC | field_member create job → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-112 | RBAC | coordinator create user → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-113 | RBAC | coordinator view states → 200 | HTTP 200 | 200 | PASS |
| QA-RBAC-114 | RBAC | customer_viewer create job → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-115 | RBAC | customer_viewer view jobs → 200 | HTTP 200 | 200 | PASS |
| QA-RBAC-116 | RBAC | customer_viewer create state → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-117 | RBAC | house_keeping view settings → 200 | HTTP 200 | 200 | PASS |
| QA-RBAC-118 | RBAC | house_keeping edit settings → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-119 | RBAC | field_member edit settings → 403 | HTTP 403 | 403 | PASS |
| QA-RBAC-120 | RBAC | vbms_reviewer view pending reviews → 200 | HTTP 200 | 200 | PASS |
| QA-RBAC-121 | RBAC | field_member view vbms reviews → 403 | HTTP 403 | 403 | PASS |
| QA-JOBS-122 | JOBS | create job missing required fields → 400 | HTTP 400 | 400 | PASS |
| QA-JOBS-123 | JOBS | create job with members + coords → 201 status in_progress | HTTP 201 | 201 | PASS |
| QA-JOBS-124 | JOBS | created job status is in_progress | status=in_progress | 201 | PASS |
| QA-JOBS-125 | JOBS | assign without member → 400 | HTTP 400 | 400 | PASS |
| QA-JOBS-126 | JOBS | assign member (already assigned) → 2xx handled | HTTP 2xx | 201 | PASS |
| QA-JOBS-127 | JOBS | generate-daily-tasks → 200 + count | HTTP 200 count>=0 | 200 | PASS |
| QA-JOBS-128 | JOBS | job has >=1 daily task after generation/manual | daily_tasks.length >= 1 | 200 | PASS |
| QA-JOBS-129 | JOBS | manual ticket duplicate date → 400 | HTTP 400 | 400 | PASS |
| QA-JOBS-130 | JOBS | manual ticket missing task_date → 400 | HTTP 400 | 400 | PASS |
| QA-JOBS-131 | JOBS | ticket check-in within geofence → 200 status in_progress | HTTP 200 | 200 | PASS |
| QA-JOBS-132 | JOBS | ticket check-out → 200 status completed | HTTP 200 completed | 200 | PASS |
| QA-JOBS-133 | JOBS | DB: ticket status completed after checkout | status=completed | 200 | PASS |
| QA-JOBS-134 | JOBS | submit job for review → 200 | HTTP 200 | 200 | PASS |
| QA-JOBS-135 | JOBS | DB: job status submitted | status=submitted | 200 | PASS |
| QA-JOBS-136 | JOBS | vbms pending list → 200 | HTTP 200 | 200 | PASS |
| QA-JOBS-137 | JOBS | approve missing ticket → 404 | HTTP 404 | 404 | PASS |
| QA-JOBS-138 | JOBS | VBMS approve completed ticket → 200 | HTTP 200 | 200 | PASS |
| QA-JOBS-139 | JOBS | DB: job_reviews row created for VBMS approve | row exists decision=approved | 200 | PASS |
| QA-JOBS-140 | JOBS | rework without remarks → 400 | HTTP 400 | 400 | PASS |
| QA-JOBS-141 | JOBS | rework completed ticket → 200 + replacement generated | HTTP 200 | 200 | PASS |
| QA-JOBS-142 | JOBS | DB: ticket_redo_history row written | count >= 1 | 200 | PASS |
| QA-JOBS-143 | JOBS | DB: original ticket frozen as redo | status=redo | 200 | PASS |
| QA-JOBS-144 | JOBS | get missing job → 404 | HTTP 404 | 404 | PASS |
| QA-JOBS-145 | JOBS | list jobs → 200 + data/stats | HTTP 200 | 200 | PASS |
| QA-JOBS-146 | JOBS | sidebar-stats → 200 | HTTP 200 | 200 | PASS |
| QA-JOBS-147 | JOBS | daily-tasks list → 200 | HTTP 200 | 200 | PASS |
| QA-GEOFENCE-148 | GEOFENCE | check-in outside geofence (≈200km) → 403 + distance/radius | HTTP 403 + distance + radius | 403 | PASS |
| QA-GEOFENCE-149 | GEOFENCE | DB: out-of-fence check-in NOT recorded (reject-before-write) | checkin_time IS NULL | 200 | PASS |
| QA-GEOFENCE-150 | GEOFENCE | check-in within geofence → 200 | HTTP 200 | 200 | PASS |
| QA-GEOFENCE-151 | GEOFENCE | customer gps_enabled=0 → far check-in allowed (no fence) | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-152 | ATTENDANCE | checkin missing member_id → 400 | HTTP 400 | 400 | PASS |
| QA-ATTENDANCE-153 | ATTENDANCE | checkin valid → 201 | HTTP 201 | 201 | PASS |
| QA-ATTENDANCE-154 | ATTENDANCE | duplicate checkin same date → 409 | HTTP 409 | 409 | PASS |
| QA-ATTENDANCE-155 | ATTENDANCE | checkout without checkin → 404 | HTTP 404 | 404 | PASS |
| QA-ATTENDANCE-156 | ATTENDANCE | checkout valid → 200 + total_hours | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-157 | ATTENDANCE | double checkout → 409 | HTTP 409 | 409 | PASS |
| QA-ATTENDANCE-158 | ATTENDANCE | DB: attendance row has total_hours + status | total_hours present | 200 | PASS |
| QA-ATTENDANCE-159 | ATTENDANCE | list attendance → 200 data[] | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-160 | ATTENDANCE | daily-summary → 200 | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-161 | ATTENDANCE | update missing attendance → 404 | HTTP 404 | 404 | PASS |
| QA-ATTENDANCE-162 | ATTENDANCE | POST capacity missing member_id → 400 | HTTP 400 | 400 | PASS |
| QA-ATTENDANCE-163 | ATTENDANCE | GET capacity valid → 200 | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-164 | ATTENDANCE | PUT /attendance/cron-schedule → expected 200 "Schedule updated" | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-165 | ATTENDANCE | GET cron-status → 200 | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-166 | ATTENDANCE | create leave missing dates → 400 | HTTP 400 | 400 | PASS |
| QA-ATTENDANCE-167 | ATTENDANCE | from_date > to_date → 400 | HTTP 400 | 400 | PASS |
| QA-ATTENDANCE-168 | ATTENDANCE | create leave → 201 | HTTP 201 | 201 | PASS |
| QA-ATTENDANCE-169 | ATTENDANCE | list leaves → 200 | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-170 | ATTENDANCE | approve with invalid status → 400 | HTTP 400 | 400 | PASS |
| QA-ATTENDANCE-171 | ATTENDANCE | approve leave → 200 | HTTP 200 | 200 | PASS |
| QA-ATTENDANCE-172 | ATTENDANCE | approve missing leave → 404 | HTTP 404 | 404 | PASS |
| QA-ATTENDANCE-173 | ATTENDANCE | DB: leave status approved | status=approved | 200 | PASS |
| QA-SMOKE-174 | SMOKE | GET settings → 200 flat key map | HTTP 200 object | 200 | PASS |
| QA-SMOKE-175 | SMOKE | PUT empty body → 400 | HTTP 400 | 400 | PASS |
| QA-SMOKE-176 | SMOKE | PUT settings (super_admin) → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-177 | SMOKE | DB: setting persisted | setting_value=qa-probe-value | 200 | PASS |
| QA-SMOKE-178 | SMOKE | GET preferences → 200 {preferences, saved} | HTTP 200 | 200 | PASS |
| QA-SMOKE-179 | SMOKE | PUT preferences → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-180 | SMOKE | GET notifications → 200 {data,total,unread} | HTTP 200 | 200 | PASS |
| QA-SMOKE-181 | SMOKE | mark all read → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-182 | SMOKE | mark bogus id read → 200 graceful | HTTP 2xx (no 500) | 200 | PASS |
| QA-SMOKE-183 | SMOKE | GET dashboard stats → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-184 | SMOKE | search q=QA → 200 {results} | HTTP 200 | 200 | PASS |
| QA-SMOKE-185 | SMOKE | search q<2 chars → 200 empty results | HTTP 200 results=[] | 200 | PASS |
| QA-SMOKE-186 | SMOKE | GET audit logs → 200 data[] | HTTP 200 | 200 | PASS |
| QA-SMOKE-187 | SMOKE | GET missing audit id → 404 | HTTP 404 | 404 | PASS |
| QA-SMOKE-188 | SMOKE | DB: audit_logs contain state operations from this run | count > 0 | 200 | PASS |
| QA-SMOKE-189 | SMOKE | GET profile → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-190 | SMOKE | GET holidays → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-191 | SMOKE | create calendar missing name → 400 | HTTP 400 | 400 | PASS |
| QA-SMOKE-192 | SMOKE | GET mail formats → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-193 | SMOKE | public active templates → 200 | HTTP 200 | 200 | PASS |
| QA-SMOKE-194 | SMOKE | public feedback bogus token → 404 (no data leak) | HTTP 404 | 404 | PASS |
| QA-SECURITY-195 | SECURITY | SQLi probe in ?search= → 200 parameterized (no error, no dump) | HTTP 200 data[] | 200 | PASS |
| QA-SECURITY-196 | SECURITY | SQLi probe in login username → 401 rejected | HTTP 401 | 401 | PASS |
| QA-SECURITY-197 | SECURITY | store <script> state name → 201 (stored raw; frontend must escape) | HTTP 201 | 201 | PASS |
| QA-SECURITY-198 | SECURITY | stored XSS string round-trips unescaped in API JSON (expected; React escapes on render) | HTTP 200 contains payload | 200 | PASS |
| QA-SECURITY-199 | SECURITY | GET /api/uploads/<file> without auth → 401 expected | HTTP 401 | 401 | PASS |
| QA-SECURITY-200 | SECURITY | D-003 valid signed upload URL → 200 | HTTP 200 | 200 | PASS |
| QA-SECURITY-201 | SECURITY | D-003 tampered signature → 401 | HTTP 401 | 401 | PASS |
| QA-SECURITY-202 | SECURITY | D-003 expired signature → 401 | HTTP 401 | 401 | PASS |
| QA-SECURITY-203 | SECURITY | D-003 Bearer JWT upload access → 200 | HTTP 200 | 200 | PASS |
| QA-SECURITY-204 | SECURITY | GET /api/downloads/file/<file> → public APK mount, 404/200 by design | HTTP 404 or 200 | 404 | PASS |
| QA-SECURITY-205 | SECURITY | 200KB JSON body → 413 payload too large | HTTP 413 | 413 | PASS |
| QA-SECURITY-206 | SECURITY | malformed JSON body → 400 | HTTP 400 | 400 | PASS |
| QA-SECURITY-207 | SECURITY | unknown API route → 404 | HTTP 404 | 404 | PASS |
| QA-SECURITY-208 | SECURITY | DB: no lingering lockouts for qa_ users after cleanup | count=0 | 200 | PASS |
| QA-BOUNDARY-209 | BOUNDARY | page=0 → 200 clamped (or 400) | HTTP 200/400, no 500 | 200 | PASS |
| QA-BOUNDARY-210 | BOUNDARY | page=-5 → 200/400, no 500 | HTTP 200/400 | 200 | PASS |
| QA-BOUNDARY-211 | BOUNDARY | limit=100000 → 200 (server clamps to MAX_LIMIT=5000) | HTTP 200, rows ≤ 5000 | 200 | PASS |
| QA-BOUNDARY-212 | BOUNDARY | limit=abc (NaN) → 200/400, no 500 | HTTP 200/400 | 200 | PASS |
| QA-BOUNDARY-213 | BOUNDARY | 5000-char state name → 400/413/500 recorded | graceful 4xx preferred | 400 | PASS |
| QA-BOUNDARY-214 | BOUNDARY | empty JSON body create state → 400 | HTTP 400 | 400 | PASS |
| QA-BOUNDARY-215 | BOUNDARY | empty-string name → 400 | HTTP 400 | 400 | PASS |
| QA-BOUNDARY-216 | BOUNDARY | string-safe GET job by numeric id → 200 | HTTP 200 | 200 | PASS |
| QA-BOUNDARY-217 | BOUNDARY | GET job id=abc → 404/400, no 500 | HTTP 4xx | 404 | PASS |
| QA-BOUNDARY-218 | BOUNDARY | GET job id=-1 → 404/400, no 500 | HTTP 4xx | 404 | PASS |
