U hZ @sddlmZmZddlZddlZddlmZddlmZeedZ e seddZ edd Z ed d Z ed d Z eddZde dede de de Z ee ZddZedkredS)) create_enginetextN) load_dotenv)datetime DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/c Cstdtd}td|td}|}|ddkrTtdW5QRdStd|ddtd |d d td |d d|dtd|td}|}|D]\}}td|d|dqtd|td}|}td|dtd|d td|d |ddkrZ|d dkrZtdtdtd|td}|}|r|drzt|dtrt |dn|d}tt j |ddtdt|t rvtd t |d!}d"|ksd#|krd$}td%nVd&|krHt|d&t rHd"|d&krhd$}td'n d(|ks\d)|krhd$}td*|svtd+Wn2tk r} ztd,| W5d} ~ XYnXtd-t} |td.d/| i}|}|ddkr$td0|dtd1|d td2|d d3ntd4td5|ddkrb|d dkrbtd6td7ntd8td9W5QRXdS):z1Quick diagnosis of why dashboard shows empty dataz'=== Dashboard Empty Data Diagnosis === z&1. Checking if activity data exists...z SELECT COUNT(*) as total, COUNT(DISTINCT developer_id) as developers, MIN(timestamp) as earliest, MAX(timestamp) as latest FROM activity_records ru- ❌ No activity records found in database!Nu ✓ Found z recordsu ✓ z developersu ✓ Date range: z to z 2. Developers in database:z SELECT DISTINCT developer_id, COUNT(*) as records FROM activity_records WHERE developer_id IS NOT NULL GROUP BY developer_id ORDER BY developer_id z - z: z 3. Checking data format...aX SELECT COUNT(CASE WHEN activity_data IS NOT NULL AND activity_data != '{}' THEN 1 END) as has_json, COUNT(CASE WHEN application_name IS NOT NULL THEN 1 END) as has_app_name, COUNT(CASE WHEN window_title IS NOT NULL THEN 1 END) as has_title FROM activity_records z& Records with activity_data (JSON): z" Records with application_name: z Records with window_title: uN ⚠️ PROBLEM FOUND: Data is in JSON format but not extracted to columns!z4 The dashboard expects data in individual columns.z( 4. Sample activity_data JSON structure:z SELECT activity_data FROM activity_records WHERE activity_data IS NOT NULL AND activity_data != '{}' AND activity_data != '' LIMIT 1 )indentz 5. JSON Structure Analysis:z Top-level keys: FZappZ applicationTu$ ✓ Found app field at root leveldatau' ✓ Found app field in nested 'data'fileZprojectu) ✓ Found file/project based structureu- ❌ No recognizable app/file fields found!z Error parsing JSON: z 6. Checking today's data...z SELECT COUNT(*) as count, COUNT(DISTINCT developer_id) as devs, SUM(duration) / 3600 as hours FROM activity_records WHERE DATE(timestamp) = :today todayz Today's records: z Active developers: z Total hours: z.1f if row[2] else 0u ❌ No data for today!z 7. SOLUTION:uD ✅ Run the flexible_dashboard_fix.py script to extract JSON dataz< This will populate the required columns for the dashboardu. ❓ Check your data collection/sync processuE ❓ Verify the dashboard API is connecting to the correct database)printengineZconnectZexecuterZfetchoneZfetchall isinstancestrjsonloadsdumpsdictlistkeys ExceptionrZnowdate) ZconnresultrowZ developersZdev_idcountZstatsrZhas_apperr(./quick_dashboard_diagnosis.pydiagnose_dashboard_issues    &        r*__main__)Z sqlalchemyrrrosZdotenvrrgetenvrrrr r r rr*__name__r(r(r(r)s"        "