Local onboarding walkthrough

docker compose -f infra/docker-compose.product.yml exec postgres \
  psql -U causeloop -d causeloop -c \
  "SELECT email, control_role, is_active FROM control.employees;"

SELECT id, slug, name, lifecycle_state, schema_name, storage_prefix
FROM control.tenants WHERE slug = 'acme';
-- lifecycle_state = 'draft', schema_name = 'tenant_acme'

docker compose -f infra/docker-compose.product.yml logs -f provisioner-worker

SELECT job_type, status, progress, steps_completed, error_detail
FROM control.platform_jobs
WHERE tenant_id = (SELECT id FROM control.tenants WHERE slug = 'acme')
  AND job_type = 'provision_tenant'
ORDER BY created_at DESC LIMIT 1;
-- status = 'succeeded', steps_completed has all 6 entries
SELECT lifecycle_state, schema_name FROM control.tenants WHERE slug = 'acme';
-- lifecycle_state = 'onboarding'

SET search_path TO tenant_acme;
SELECT version, row_count FROM datasets ORDER BY version DESC LIMIT 1;
SELECT count(*) FROM records;

SELECT job_type, status FROM control.platform_jobs
WHERE job_type = 'materialize_insights' ORDER BY created_at DESC LIMIT 1;

SET search_path TO tenant_acme;
SELECT key_values->'training_config' FROM settings;

SELECT status, progress, error_detail FROM control.platform_jobs
WHERE tenant_id = (SELECT id FROM control.tenants WHERE slug = 'acme')
  AND job_type = 'train_tenant_model' ORDER BY created_at DESC LIMIT 1;

SET search_path TO tenant_acme;
SELECT version, algorithm, is_active FROM model_checkpoints ORDER BY version DESC;

SELECT lifecycle_state, share_onboarding_outputs FROM control.tenants WHERE slug = 'acme';
-- lifecycle_state = 'review'

SELECT email, role_profile_key, status, expires_at
FROM control.tenant_invitations
WHERE tenant_id = (SELECT id FROM control.tenants WHERE slug = 'acme')
ORDER BY created_at DESC LIMIT 1;
-- status = 'pending'

SELECT status, accepted_at FROM control.tenant_invitations WHERE email = 'invited@client.com';

SET search_path TO tenant_acme;
SELECT email, is_active FROM users WHERE email = 'invited@client.com';

SELECT lifecycle_state FROM control.tenants WHERE slug = 'acme';
-- lifecycle_state = 'live'

SELECT action, resource_type, detail, created_at FROM control.audit_log
WHERE tenant_id = (SELECT id FROM control.tenants WHERE slug = 'acme')
ORDER BY created_at DESC LIMIT 5;