U Sh @sddlmZmZddlZddlmZddlmZmZmZee 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 timedelta DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/c CsBtdt&}td|td}|}td|dtd|dtd|d td |td }|}|r|D]<\}}}}|r|nd}td |d |d|d|dd qntdt} td| ddD]} |td| | d}|}|ddkrx|dr4|dnd} td | d |dd| ddtd|d d|dqtd | dqtd|td}|D].} td | dd | dd!| d d"qtd#|r|r$|dd| kr$td$td%td&td'td(ntd)td*W5QRXd+S),z)Check if the issue is with date filteringz%=== Checking Date-Related Issues === z!1. Date range of activity data...a+ SELECT MIN(timestamp) as earliest, MAX(timestamp) as latest, COUNT(DISTINCT DATE(timestamp)) as unique_days FROM activity_records WHERE developer_id IN ('ankita gholap', 'RiddhiDhakhara', 'ankita_gholap') z Earliest: rz Latest: z Unique days: z% 2. Activity count by recent dates...a SELECT DATE(timestamp) as activity_date, COUNT(*) as record_count, COUNT(DISTINCT developer_id) as developers, SUM(duration) / 3600 as total_hours FROM activity_records WHERE timestamp >= CURRENT_DATE - INTERVAL '7 days' GROUP BY DATE(timestamp) ORDER BY activity_date DESC z z: z records, z developers, z.1fz hoursz No data in the last 7 days!z 3. Checking data for today (z)...)z ankita gholapZRiddhiDhakharaZ ankita_gholapak SELECT COUNT(*) as count, SUM(duration) as total_duration, MIN(timestamp) as first_activity, MAX(timestamp) as last_activity FROM activity_records WHERE developer_id = :dev_id AND DATE(timestamp) = :today )dev_idtodayz.0fz secondsz First: z, Last: z: No data for todayz 4. Sample timestamp values...a8 SELECT id, timestamp, DATE(timestamp) as date_part, activity_data FROM activity_records WHERE developer_id IN ('ankita gholap', 'RiddhiDhakhara') ORDER BY timestamp DESC LIMIT 5 z ID z (Date: )z 5. ANALYSIS:uI ⚠️ No data for today - the dashboard shows today's data by defaultz Solutions:z0 1. Click on a different date in the dashboardz 2. Sync today's activity dataz8 3. Modify dashboard to show the latest available dateu ✓ Data exists for todayz, Check if duration values are properly setN) printengineZconnectZexecuterZfetchoneZfetchallrr) ZconnresultrowZdatesZact_datecountZdevsZhoursZ hours_valrrZdurrecordr./check_date_issue.pycheck_date_issuessR    (  " , r __main__)Z sqlalchemyrrosZdotenvrrrrgetenvrr r r r r rr __name__rrrrs        "a