U h @sddlmZmZddlmZddlmZddlmZddl m Z m Z ddl Z e e ZeZedeefeedd d ZdS) ) APIRouterDepends)Session)text)get_db)datetimetimezoneNz(/api/debug/activity-check/{developer_id}) developer_iddbc s2z|tdd|i}|s@d|d|tddWS|tdd|i}|tdd|i}|td d|i}|d |r|d nd |d r|d nd |dr|dnd ddd|Ddd|DdWStk r,}z$td|dt|iWYSd }~XYnXd S)z5Debug endpoint to check activity data for a developerzKSELECT * FROM developers WHERE developer_id = :dev_id OR id::text = :dev_iddev_idz Developer 'z ' not foundz)SELECT developer_id, name FROM developers)errorZavailable_developersz SELECT COUNT(*), MIN(timestamp) as first_activity, MAX(timestamp) as last_activity FROM activity_records WHERE developer_id = :dev_id a8 SELECT category, COUNT(*) as count, SUM(duration) as total_duration FROM activity_records WHERE developer_id = :dev_id AND timestamp >= NOW() - INTERVAL '7 days' GROUP BY category ORDER BY count DESC z SELECT application_name, category, duration, timestamp FROM activity_records WHERE developer_id = :dev_id ORDER BY timestamp DESC LIMIT 10 TrN)first_activity last_activityc SsHg|]@}|dpd|dt|dp$dtt|dp4ddddqS)r uncategorizedr ri)categorycountduration_secondsduration_hours)floatround).0catr:/var/www/html/timesheet/backend/debug_activity_endpoint.py Ns  z(debug_activity_check..cSs:g|]2}|d|d|d|dr.|dnddqS)rr rN)apprduration timestamp) isoformat)rsamplerrrrWs )r Zdeveloper_existstotal_activities date_rangeZlast_7_days_categoriesrecent_activitieszDebug check error: r ) executerfetchonefetchallr! Exceptionloggerr str)r r Z dev_checkactivity_count categoriesZsampleserrrdebug_activity_check sN     r/)fastapirrsqlalchemy.ormr sqlalchemyrdatabaserrrlogging getLogger__name__r*routergetr+r/rrrrs