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ed ed e D ](Zeed   ded  ded   qed ed ed e D ]"Zeded   ded   qed ed e D ]"Zeded   ded   qLe  e  dS )    N)load_dotenvDATABASE_URLzpostgresql:// @:   /Z5432)ZhostZportZdatabaseuserZpasswordz=== Column Types ===a  
    SELECT 
        'developers' as table_name,
        column_name,
        data_type
    FROM information_schema.columns
    WHERE table_name = 'developers' AND column_name = 'developer_id'
    UNION ALL
    SELECT 
        'activity_records' as table_name,
        column_name,
        data_type
    FROM information_schema.columns
    WHERE table_name = 'activity_records' AND column_name = 'developer_id'
.z:    z
=== Sample Data ===zDSELECT developer_id, pg_typeof(developer_id) FROM developers LIMIT 2zDevelopers table:z
  Value: 'z	', Type: ziSELECT developer_id, pg_typeof(developer_id) FROM activity_records WHERE developer_id IS NOT NULL LIMIT 2z
Activity_records table:)Zpsycopg2osZdotenvr   getenvr   replacesplitZ
conn_partsZ	user_passZhost_dbZ	host_portZconnectlenZconnZcursorZcurprintZexecuteZfetchallrowclose r   r   ./quick_type_check.py<module>   s>   

&
 
 