U
    =Nh                  
   @   s   d dl Z d dlZe dZe Zed ed e Zed e Z	ed e	D ]"Z
ede
d  d	e
d
  d qZedee  ered eD ]Zede  qed zed e Zed e Z	ed e	D ]"Z
ede
d  d	e
d
  d qedee  erLed eD ]Zede  q6W n4 e jk
r Z zede  W 5 dZ[X Y nX ed ed e d  Zede  ed e Zedee  ered eD ],Zeded   ded  ded
   qe  dS )    Nztimesheet.dbz!=== CHECKING DEVELOPERS TABLE ===zSELECT * FROM developerszPRAGMA table_info(developers)z
Developers table columns:z  -    z (   )z)
Total developers in 'developers' table: z
Developers:z6
=== CHECKING DISCOVERED_DEVELOPERS_ENHANCED TABLE ===z,SELECT * FROM discovered_developers_enhancedz1PRAGMA table_info(discovered_developers_enhanced)z.
Discovered_developers_enhanced table columns:z2
Total in 'discovered_developers_enhanced' table: z
Discovered developers:z6Error accessing discovered_developers_enhanced table: z(
=== CHECKING ACTIVITY_RECORDS TABLE ===z%SELECT COUNT(*) FROM activity_recordsz
Total activity records: z
    SELECT DISTINCT 
        developer_id,
        developer_name,
        COUNT(*) as activity_count
    FROM activity_records 
    WHERE developer_id IS NOT NULL OR developer_name IS NOT NULL
    GROUP BY developer_id, developer_name
z(
Unique developers in activity_records: z
Developers with activities:z  - ID: z, Name: z, Activities: )Zsqlite3ZjsonZconnectZconnZcursorprintZexecuteZfetchallZ
developerscolumnscollenZdevZ
discoveredZOperationalErroreZfetchoneZtotal_activitiesZactivity_developersclose r   r   ./check_developers_table.py<module>   sX   


 

  

	*