End-to-end verification checklist for content processing, guided draft creation, assignment, practice completion, reporting, and cleanup
Use this checklist to verify the first guided-training slice end to end.
065_guided_training_foundation.sql.Create a small TXT file called battery-training.txt:
textPowerVault 3000 is a three-day home battery backup product.It costs $299 and is designed for households worried about power outages.Staff should acknowledge customer concern, ask what appliances matter most,and explain that the PowerVault can keep essential devices running during an outage.
battery-training.txt to a topic.Fuel Crisis Battery Backup.Customers are worried about fuel shortages and possible power outages. Staff need to pivot the conversation to battery backup options.Fuel Crisis Battery Backup.Delete the test assignment, scenario, and content item from the UI or API.
Expected result:
204 No Content.If a DELETE removes the item but reports an error, check the frontend backend-proxy no-body handling. A 204 response must be forwarded with a null body, not an empty string body.
Run these checks for extra confidence:
sqlSELECT id, filename, status, chunk_count FROM content_items ORDER BY id DESC LIMIT 5;SELECT content_item_id, count(*) FROM content_chunks GROUP BY content_item_id ORDER BY content_item_id DESC LIMIT 5;SELECT id, creation_source, delivery_mode, jsonb_array_length(learning_goals) AS goals, staff_brief <> '' AS has_brief FROM scenarios ORDER BY id DESC LIMIT 5;SELECT scenario_id, content_item_id FROM scenario_content_items ORDER BY created_at DESC LIMIT 5;SELECT id, scenario_id, status, attempt_count, completion_score, last_practice_session_id FROM assignments ORDER BY id DESC LIMIT 5;SELECT id, scenario_id, assignment_id, status, score FROM practice_sessions ORDER BY id DESC LIMIT 5;
Temporary smoke-data cleanup checks:
sqlSELECT count(*) FROM content_items WHERE filename LIKE 'codex-guided-training-%';SELECT count(*) FROM scenarios WHERE name LIKE 'Codex Smoke Guided Training%';SELECT count(*) FROM assignments WHERE scenario_name LIKE 'Codex Smoke Guided Training%';
If analytics is configured, the following events should appear during the test:
training_content_uploadedguided_training_builder_startedguided_training_draft_generatedguided_training_publishedassigned_practice_startedassigned_practice_completed