U
    bh                     @   s  d dl Z 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 e D ] Zeded   ded   qed ed e D ]Zeded    eded   eded   eded   eded   eded   ed rzLeed ereed ned Zedejedddd   d! W n   eded   Y nX qe  e  dS )"    N)load_dotenvDATABASE_URLzpostgresql:// @:   /Z5432)ZhostZportZdatabaseuserZpasswordz+=== Checking activity_records structure ===z
    SELECT column_name, data_type 
    FROM information_schema.columns 
    WHERE table_name = 'activity_records'
    ORDER BY ordinal_position
z
Columns in activity_records:z  z: z
=== Sample activity data ===z
    SELECT 
        id,
        developer_id,
        application_name,
        window_title,
        category,
        activity_data,
        duration,
        timestamp
    FROM activity_records 
    WHERE developer_id IS NOT NULL
    LIMIT 5
z
Record ID: z  Developer: z  App:    z	  Title:    z  Category:    z  Duration:       z  Activity Data: )indent   z...)Zpsycopg2ZjsonosZdotenvr   getenvr   replacesplitZ
conn_partsZ	user_passZhost_dbZ	host_portZconnectlenZconnZcursorZcurprintZexecuteZfetchallcolrow
isinstancestrloadsdatadumpsclose r   r   ./check_activity_data.py<module>   sN   



&&