U Zh@sdZddlmZmZddlmZddlmZddlZej ej de e Z eZedeeeZedded Zd d Zd d Ze dkreedS)zJ Script to check and optionally fix developer_id alignment between tables ) create_enginetext) sessionmaker)ConfigN)levelzConnecting to: F)Z autocommitZ autoflushZbindc st}td|td}td|D],}td|dd|dd|d d q0|td }td |D]\}td d|q|dd|D}dd|D}td||}|rtd|D]8tfdd|D}tdd|dtdq||}|r`td|D]2tfdd|D} tdd| dq,|st|sttdtd|td } td!| D](\} }td"| d#d$|d%qW5QRXdS)&Nz( === CHECKING DEVELOPER ID ALIGNMENT ===zi SELECT id, developer_id, name FROM developers ORDER BY id z" Developers in 'developers' table:z ID: rz, developer_id: 'z ', name: ''z SELECT DISTINCT developer_id, COUNT(*) as count FROM activity_records WHERE developer_id IS NOT NULL GROUP BY developer_id ORDER BY count DESC z2 Unique developer_ids in 'activity_records' table:z developer_id: 'z', activities: cSsh|] }|dqS)r.0devr r ./check_developer_alignment.py /sz,check_developer_alignment..cSsh|] }|dqS)rr r r r rr0sz === ALIGNMENT CHECK ===uG ⚠️ Developer IDs in activity_records but NOT in developers table:c3s|]\}}|kr|VqdS)Nr )r dcdev_idr r 9sz,check_developer_alignment..z - 'z' (z activities)zS Suggested fix: Check if this matches any developer name in the developers tableu' ⚠️ Developers with no activities:c3s"|]}|dkr|dVqdS)rrNr r rr rrDs z ' (name: 'z')u, ✅ All developer IDs are properly aligned!z === SAMPLE JOIN TEST ===a> SELECT d.developer_id, d.name, COUNT(ar.id) as activity_count FROM developers d LEFT JOIN activity_records ar ON d.developer_id = ar.developer_id WHERE d.active = true GROUP BY d.developer_id, d.name z Join results:z z (developer_id: z): z activities) SessionLocalprintexecuterfetchallnext) dbZ developersr Z activity_devscountZ dev_table_idsZactivity_table_idsZorphanedZ no_activitiesZdev_nameZ join_testnamer rrcheck_developer_alignmentsB *    rc Cst}|td}|rtdtdtd|D]B\}}td|d|dtdtd |d |d |d q:td td W5QRXdS)z,Suggest SQL commands to fix alignment issuesa3 SELECT DISTINCT ar.developer_id, COUNT(*) as count FROM activity_records ar LEFT JOIN developers d ON ar.developer_id = d.developer_id WHERE d.developer_id IS NULL AND ar.developer_id IS NOT NULL GROUP BY ar.developer_id z === SUGGESTED FIXES ===z1To fix orphaned activity records, you can either:z3 1. Add missing developers to the developers table:z -- For developer_id 'z' with z activities:zFINSERT INTO developers (developer_id, name, email, active, created_at)z VALUES ('z', 'z@company.com', true, NOW());zV 2. OR update activity_records to use existing developer_ids from the developers tablez) (only if you know the correct mapping)N)rrrrr)rresultrrr r r suggest_fixes[s  r__main__)__doc__Z sqlalchemyrrZsqlalchemy.ormrZconfigrZloggingZ basicConfigINFOZ getLogger__name__loggerZget_database_urlZ DATABASE_URLrZenginerrrr r r rs   I