U h @sddlmZmZddlmZddlZddlmZeede Z ee Z ddZ dd Z ed kred ze e Wn@ek rZz"ed eddlZeW5dZ[XYnXdS) ) create_enginetext)ConfigN) load_dotenv DATABASE_URLc Cstp}td|td}t|}|sDtdW5QRdStdt|d|D]\}}td|d|d q\td }|d krtd W5QRdStd z"|td| tdWn2t k r}ztd|W5d}~XYnXtdtd}||}| td|j dtd|td }|dkrftdntd|dW5QRXdS)z7Fix any integer developer_ids in activity_records tablez9Checking for integer developer_ids in activity_records...z SELECT DISTINCT developer_id, pg_typeof(developer_id) as type FROM activity_records WHERE developer_id IS NOT NULL AND developer_id ~ '^[0-9]+$' LIMIT 10 u8✅ No numeric developer_ids found. Database looks good!NzFound z( numeric developer_ids that need fixing: - 'z ' (type: )zD Do you want to fix these by converting to string format? (yes/no): Zyesz Cancelled.z' Creating backup of activity_records...z CREATE TABLE IF NOT EXISTS activity_records_backup AS SELECT * FROM activity_records u/✅ Backup created as 'activity_records_backup'u#⚠️ Backup might already exist: z Fixing developer_ids...z UPDATE activity_records SET developer_id = CONCAT('dev_', developer_id) WHERE developer_id ~ '^[0-9]+$' u ✅ Updated  recordsz Verifying fix...zs SELECT COUNT(*) FROM activity_records WHERE developer_id ~ '^[0-9]+$' ru1✅ All developer_ids are now properly formatted!u⚠️ Still found z numeric developer_ids) engineconnectprintexecuterlistleninputlowerZcommit ExceptionZrowcountZscalar)connresultZ numeric_idsdev_idZdtypeZresponseeZ update_queryr./fix_database_types.pyfix_developer_idss>        rc Cst}td|td}t|}|rftdt|d|D]\}}td|d|dqDntd|td }t|}|rtd t|d |D]\}}td |d |dqntdW5QRXdS)z%Check data consistency between tablesz" === Checking data consistency ===aE SELECT DISTINCT ar.developer_id, COUNT(*) as count FROM activity_records ar LEFT JOIN developers d ON ar.developer_id = d.developer_id WHERE ar.developer_id IS NOT NULL AND d.developer_id IS NULL GROUP BY ar.developer_id LIMIT 10 u# ⚠️ Found activity records for z non-existent developers:rz': r u2 ✅ All activity records have matching developersz SELECT d.developer_id, d.name FROM developers d LEFT JOIN activity_records ar ON d.developer_id = ar.developer_id WHERE d.active = true AND ar.id IS NULL LIMIT 10 u ⚠️ Found z( active developers without any activity:z - z (ID: ru0 ✅ All active developers have activity recordsN)r r r r rrr)rrZorphanedrcountZinactivenamerrrcheck_data_consistencyVs      r__main__z$=== Timesheet Database Fix Tool === u ❌ Error: )Z sqlalchemyrrZconfigrosZdotenvrgetenvZget_database_urlrr rr__name__r rr traceback print_excrrrrs"  G*