U ÿ äh8 ã@sZddlZddlmZddlZddlmZeƒe de ¡¡Ze  d¡r¾e  dd¡  d¡Z e d  d¡Z e d   d ¡Zed  d¡Ze dZe d ZedZeeƒd kr°ed nd Zed Zned ƒed ƒejeeeeed Ze ¡Zedƒe d¡e ¡D]:Zeed›ded ›dedr0ednd›dƒqedƒe d¡e ¡D]:Zeed›ded ›dedr†ednd›dƒqZedƒe d¡edƒe ¡D]"Zeded›ded ›ƒq¸e d¡edƒe ¡D]"Zeded›ded ›ƒqöedƒe d¡e ¡dZ ed e ›ƒe !¡e !¡dS)!éN)ÚConfig)Ú load_dotenvÚ DATABASE_URLz postgresql://Úú@ú:éú/Z5432zInvalid database URL)ÚhostÚportÚdatabaseÚuserÚpasswordz=== DEVELOPERS TABLE SCHEMA ===z£ SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name = 'developers' ORDER BY ordinal_position z: z (ézN/Aú)z& === ACTIVITY_RECORDS TABLE SCHEMA ===z© SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name = 'activity_records' ORDER BY ordinal_position z% === CHECKING DEVELOPER_ID VALUES ===zˆ SELECT DISTINCT developer_id, pg_typeof(developer_id) FROM activity_records WHERE developer_id IS NOT NULL LIMIT 10 z1Sample developer_id values from activity_records:z Value: 'z ', Type: z‚ SELECT DISTINCT developer_id, pg_typeof(developer_id) FROM developers WHERE developer_id IS NOT NULL LIMIT 10 z, Sample developer_id values from developers:z+ === CHECKING FOR NUMERIC DEVELOPER_IDS ===zw SELECT COUNT(*) FROM activity_records WHERE developer_id IS NOT NULL AND developer_id ~ '^[0-9]+$' z-Activity records with numeric developer_ids: )"Zpsycopg2ZconfigrÚosZdotenvrÚgetenvZget_database_urlrÚ startswithÚreplaceÚsplitÚpartsZ user_passZhost_dbZ host_portr rr Úlenr r ÚprintÚexitZconnectZconnZcursorZcurZexecuteZfetchallÚrowZfetchoneZ numeric_countÚclose©rrú./check_db_types.pyÚs`    û  8  8