U
    h                  
   @   s  d dl Z d dlZd dlmZ e  edZedddZed  dZ	ed d	Z
e
d  dZe jed  eedkred nd
e
d e	d  e	d dZe Zzzed ed e Zered dkreded  d ed ed e  ed ned ed e Zerred dkrreded  d ed e  ed ned ed W n: ek
r Z zede  e  W 5 dZ[X Y nX W 5 e  e  X dS )    N)load_dotenvDATABASE_URLzpostgresql:// @:   /Z5432)ZhostZportZdatabaseuserZpasswordz Checking current column types...z
        SELECT column_name, data_type
        FROM information_schema.columns
        WHERE table_name = 'activity_records' AND column_name = 'developer_id'
    zcharacter varyingz.Found issue: activity_records.developer_id is z, should be VARCHARz&
Converting developer_id to VARCHAR...z
            ALTER TABLE activity_records 
            ALTER COLUMN developer_id TYPE VARCHAR USING developer_id::VARCHAR
        u,   ✅ Fixed activity_records.developer_id typeu4   ✅ activity_records.developer_id is already VARCHARz
        SELECT column_name, data_type
        FROM information_schema.columns
        WHERE table_name = 'developers' AND column_name = 'developer_id'
    z)
Found issue: developers.developer_id is z|
            ALTER TABLE developers 
            ALTER COLUMN developer_id TYPE VARCHAR USING developer_id::VARCHAR
        u&   ✅ Fixed developers.developer_id typeu.   ✅ developers.developer_id is already VARCHARu3   
✅ All developer_id columns are now VARCHAR type!u   ❌ Error: )Zpsycopg2osZdotenvr   getenvr   replacesplitZ
conn_partsZ	user_passZhost_dbZ	host_portZconnectlenZconnZcursorZcurcloseprintZexecuteZfetchoneresultZcommit	ExceptioneZrollback r   r   ./fix_column_types.py<module>   sR   






