U h @s.ddlmZmZddlmZddlZddlmZeede Z ee ddZ ze ~Z eded e ed Zered ed d edde edZereded d eddede edZeD]4Zededded deddedqede edZeD],Zededded dedqDede edZeeZeredeedeD] \ZZed ed!ed"qned#W5QRXWnBek r(Zz"ed$eddlZeW5dZ[XYnXdS)%) create_enginetext)ConfigN) load_dotenv DATABASE_URLF)Zechou✅ Connected to databasez# === Checking column data types ===z SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name = 'developers' AND column_name = 'developer_id' zdevelopers.developer_id: z (max length: )z SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name = 'activity_records' AND column_name = 'developer_id' zactivity_records.developer_id: z$ === Sample data from developers ===z SELECT id, developer_id, name, pg_typeof(developer_id) as type FROM developers LIMIT 5 zID: z, developer_id: 'z ', name: z, type: z* === Sample data from activity_records ===z SELECT id, developer_id, pg_typeof(developer_id) as type FROM activity_records WHERE developer_id IS NOT NULL LIMIT 5 z ', type: z& === Checking for problematic data ===z SELECT COUNT(*), developer_id FROM activity_records WHERE developer_id ~ '^[0-9]+$' GROUP BY developer_id LIMIT 5 zFound z+ numeric developer_ids in activity_records:z developer_id 'z ' appears z timesz2No numeric developer_ids found in activity_recordsu ❌ Error: )Z sqlalchemyrrZconfigrosZdotenvrgetenvZget_database_urlrZengineZconnectZconnprintZexecuteZfetchoneresultrowlistZ numeric_idslencountZdev_id Exceptione traceback print_excrr./check_data_types.pysH    2*