U Sh @sddlmZmZddlZddlZddlmZddlmZmZee dZ e se ddZ e dd Z e d d Z e d d Ze ddZdedede de de Z ee ZddZedkredS)) create_enginetextN) load_dotenv)datetimedate DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/c Cs2tdt}td|td}|}td|dtd|dtd|d td |d |d r|d nd}|d r|d nd}td|ddtd|ddtd|td}dd|D}td|td|r|dd D]}|tdd|i}|}|rtd|t|D]V\}} td|ddtd| dtd| d dtd | d qNqtd!t } |td"d#| i}|} | r<| D]X\}} } }| r| nd}|r|nd}|d$}td%|d&| d'|dd(|d)d* qntd+td,|td-}|}|rtd.|D]@\}}}}|r|nd}td%|d&|d/|d'|d0d1 qttd2|ddtd3td4td5| rtd6td7n(td8td9td:td;td<W5QRXdS)=z$Debug why durations are showing as 0z!=== Debugging Duration Issue === z*1. Checking duration values in database...a SELECT COUNT(*) as total_records, COUNT(CASE WHEN duration IS NULL THEN 1 END) as null_durations, COUNT(CASE WHEN duration = 0 THEN 1 END) as zero_durations, COUNT(CASE WHEN duration > 0 THEN 1 END) as positive_durations, AVG(duration) as avg_duration, MAX(duration) as max_duration FROM activity_records z Total records: rz NULL durations: z Zero durations: z Positive durations: z Average duration: z.2fz secondsz Max duration: z# 2. Finding actual developer IDs...z SELECT DISTINCT CAST(developer_id AS VARCHAR) as dev_id FROM activity_records WHERE developer_id IS NOT NULL ORDER BY 1 cSsg|] }|dqS)r).0rowrr./debug_duration_issue_fixed.py ?sz(debug_duration_issue..z Found developers: z( 3. Sample records with duration data...Na SELECT CAST(developer_id AS VARCHAR) as dev_id, application_name, duration, timestamp, activity_data FROM activity_records WHERE CAST(developer_id AS VARCHAR) = :dev_id ORDER BY timestamp DESC LIMIT 3 dev_idz Developer: z - Record rz App: z Duration: z Timestamp: z 4. Checking today's data...aG SELECT CAST(developer_id AS VARCHAR) as dev_id, COUNT(*) as count, SUM(duration) as total_duration, AVG(duration) as avg_duration FROM activity_records WHERE DATE(timestamp) = :today GROUP BY developer_id todayiz z: z records, z hours, z.0fz s averageu ❌ No data for today!z& 5. Checking latest dates with data...a SELECT DATE(timestamp) as activity_date, COUNT(DISTINCT CAST(developer_id AS VARCHAR)) as developers, COUNT(*) as records, SUM(duration) / 3600 as total_hours FROM activity_records GROUP BY DATE(timestamp) ORDER BY activity_date DESC LIMIT 7 z Recent activity dates:z developers, z.1fz hoursu ⚠️ Latest data is from z8 The dashboard is looking for today's data by default.z1 You need to select this date in the dashboard!z 6. SOLUTION:u4 ✓ Data exists for today with positive durationsz7 Check if the dashboard is properly querying the datauF ⚠️ No data for today - this is why the dashboard shows 0 hours!z Options:zD 1. Select a different date in the dashboard (use the date picker)z 2. Sync today's activity dataz< 3. Modify the dashboard to show the latest available date) printengineZconnectZexecuterZfetchoneZfetchall enumeraterr)ZconnresultZstatsZavg_durZmax_durZdev_idsrZrecordsirecordrZ today_datacountZ total_durZtotal_sZavg_sZhoursZdatesZact_dateZdevsZ hours_valrrrdebug_duration_issues      , ( r$__main__)Z sqlalchemyrrZjsonosZdotenvrrrgetenvrrr r r r rr$__name__rrrrs$       "