U
    bhQ                  
   @   sn  d Z ddlZddlZddlmZ e  edZededd   ze	eZ
e
 Zed ed	 e D ] Zed
ed  ded   qved z&ed ede d  d W n\ ek
r" Z z<ede  ed ed ede d  d W 5 dZ[X Y nX e  e
  W n2 ek
rh Z zede  W 5 dZ[X Y nX dS )z-Test script to verify PostgreSQL column types    N)load_dotenvDATABASE_URLzConnecting to: @   z
1. Checking column types:z
        SELECT column_name, data_type 
        FROM information_schema.columns 
        WHERE table_name IN ('developers', 'activity_records') 
        AND column_name = 'developer_id'
        ORDER BY table_name
    z   z: z
2. Testing simple join:z
            SELECT COUNT(*) 
            FROM developers d 
            JOIN activity_records ar ON d.developer_id = ar.developer_id
        u      ✅ Simple join works: z recordsu      ❌ Simple join failed: z
3. Testing join with cast:z
            SELECT COUNT(*) 
            FROM developers d 
            JOIN activity_records ar ON d.developer_id::VARCHAR = ar.developer_id::VARCHAR
        u      ✅ Join with cast works: u   
❌ Database error: )__doc__Zpsycopg2osZdotenvr   getenvr   printsplitZconnectZconnZcursorZcurZexecuteZfetchallrowZfetchone	Exceptioneclose r   r   ./test_column_types.py<module>   s4   




*