# One-off: backfill CRM routing for existing mail.sync.message records.
# Run: docker exec odoo_app odoo shell -d testing --no-http < /mnt/extra-addons/../work_scripts/...
# Or paste into odoo shell manually.

env['mail.sync.message'].action_route_all_unrouted()
leads = env['crm.lead'].search([])
msgs = env['mail.sync.message'].search([])
routed_leads = msgs.filtered(lambda m: m.is_routed_lead)
print('Total CRM leads:', len(leads))
print('Total inbox messages:', len(msgs))
print('Messages routed to CRM:', len(routed_leads))
for lead in leads[:15]:
    count = getattr(lead, 'mail_sync_message_count', None)
    print('  Lead:', lead.id, lead.name[:60], '- inbox msgs:', count)
env.cr.commit()