U Shc @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 Cstdt}td|td}|}td|dtd|dtd|d td |d |d r|d nd}|d r|d nd}td|ddtd|ddtd|td}|}t|D]\}}td|ddtd|dtd|dtd|d dtd|d |d rzbt|d t rzt |d n|d }d|krtd|dd|krd|krtdWqYqXqtdt } |td d!| i}|} | rV| D]P\} } } }| r| nd}|r&|nd}td"| d#| d$|d%d&|d%d' qntd(td)|td*}|D]\}zt|t rt |n|}t|trPd+}d|krtd,|dd-}d.|kr t|d.tr d|d.kr td/|d.dd-}d|kr,d0|kr,td1d-}|sPtd2td3t|Wn YnXqxtd4|ddks|d dkrtd5td6ntd7td8W5QRXd9S):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. Sample records with duration data...ab SELECT developer_id, application_name, duration, timestamp, activity_data FROM activity_records WHERE developer_id IN ('ankita gholap', 'RiddhiDhakhara', 'ankita_gholap') ORDER BY timestamp DESC LIMIT 10 z Record rz Developer: z App: z Duration: z Timestamp: Zdurationz Duration in JSON: Z timestampZ start_timez. Timestamps in JSON - can calculate durationz 3. Checking today's data...a, SELECT developer_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 todayz z: z records, z.0fz total seconds, z avg secondsz No data for today!zD 4. Checking if duration needs to be extracted from activity_data...z SELECT activity_data FROM activity_records WHERE activity_data IS NOT NULL AND activity_data != '{}' LIMIT 5 Fz Found 'duration' in JSON: Tdataz$ Found 'duration' in nested data: Z end_timestampz2 Found timestamp fields - can calculate durationz' No duration info in this JSON recordz Keys available: z 5. SOLUTION:uA ✅ Need to extract/calculate duration from activity_data JSONz# Run: python fix_duration_data.pyu4 ❓ Duration data exists but may not be for todayz Check your data sync processN)printengineZconnectZexecuterZfetchoneZfetchall enumerate isinstancestrjsonloadsrrdictlistkeys)ZconnresultZstatsZavg_durZmax_durZrecordsirecordrrZ today_dataZdev_idcountZ total_durZtotal_sZavg_sZdata_strZduration_foundr&./debug_duration_issue.pydebug_duration_issues   &    ,   (  r(__main__)Z sqlalchemyrrrosZdotenvrrrgetenvrrr r r r rr(__name__r&r&r&r's$       "