U ؠh @sXddlmZmZddlZddlmZddlmZmZeedZ e seddZ edd Z ed d Z ed d Z eddZde dede de de Z ee ZeddZdZdZededeedee8ZedeeddeiZeZerNedeD]$\ZZeded ed!eZq&n:ed"ed#eed$ZeD]\Zed%eqped&eded'eed(eed)ZeZer ed*eD]8\ZZZ e re ndZ!ed+ed,ed-e!d.d/qn6ed0eed1Ze"\Z#Z$ed2e#de$er"ed3zeed4eeed5ZeZered6e%ed7e&edd8D]:\Z'Z(ed9e'd:d,e(d:d;e(d<dd=d'qned>Wn>e)k r Z*zed?e+e*ed@W5dZ*[*XYnXW5QRXedAedBedCedDedEdS)F) create_enginetextN) load_dotenv)datetimedate DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/z%=== Debugging Activity API Error === z 2025-09-30z 2025-10-08Zriddhidhakharaz Date range: z to z Developer: z$ 1. Checking developer variations...z SELECT DISTINCT CAST(developer_id AS VARCHAR) as dev_id, COUNT(*) as count FROM activity_records WHERE LOWER(CAST(developer_id AS VARCHAR)) = LOWER(:dev_id) GROUP BY developer_id dev_idz Found developer(s):z - 'z' (z records)u ❌ Developer not found!z All developers in database:z SELECT DISTINCT CAST(developer_id AS VARCHAR) as dev_id FROM activity_records ORDER BY 1 z - z 2. Checking data in date range z...a, SELECT DATE(timestamp) as activity_date, COUNT(*) as records, SUM(duration) / 3600 as hours FROM activity_records WHERE DATE(timestamp) BETWEEN :start_date AND :end_date GROUP BY DATE(timestamp) ORDER BY activity_date ) start_dateend_datez Data found:z z: z records, z.1fz hoursu" ❌ No data in this date range!zi SELECT MIN(DATE(timestamp)), MAX(DATE(timestamp)) FROM activity_records z Actual data range: z 3. Testing activity query...a. SELECT CAST(developer_id AS VARCHAR) as dev_id, application_name, window_title, duration, timestamp, category FROM activity_records WHERE LOWER(CAST(developer_id AS VARCHAR)) = LOWER(:dev_id) AND DATE(timestamp) BETWEEN :start_date AND :end_date AND application_name IS NOT NULL ORDER BY timestamp DESC LIMIT 10 )rrru ✓ Query successful, found z recordsz Sample z - 2u/ ⚠️ Query successful but no records foundu ❌ Query failed: z- This might be the cause of your 500 error!z 4. LIKELY ISSUES:zZ 1. Case sensitivity: Database might have 'RiddhiDhakhara' but API uses 'riddhidhakhara'zA 2. Date range: Your data might be outside Sep 30 - Oct 8, 2025zA 3. Missing columns: application_name or category might be NULLz. 4. Database connection issues in production),Z sqlalchemyrrosZdotenvrrrgetenvrrr r r r ZengineprintrrZ developer_idZconnectZconnZexecuteresultZfetchallZ developersZdevcountZ actual_dev_idZdatesZact_dateZrecordsZhoursZ hours_valZfetchoneZmin_dateZmax_datelen enumerateirecord Exceptionestrr$r$./debug_api_error.pys       "       $  6 $