U Sh @sFddlmZmZddlZddlmZddlmZmZeedZ e seddZ edd Z ed d Z ed d Z eddZde dede de de Z ee Zede|ZeedZedededdZeD]bZe\ZZZZZereendZerendZdZeeddededdedded  qesded!n ed"ed#ed$ed%ed&ed'eZeed(d)eiZe Z!e!r ed*ed+e!D]J\ZZZereendZerendZed,ed-ed.ed/d0qned1ed2ed3W5QRXdS)4) create_enginetextN) load_dotenv)datetimedate DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/z=== Quick Dashboard Test === a SELECT CAST(developer_id AS VARCHAR) as dev_id, DATE(timestamp) as activity_date, COUNT(*) as records, SUM(duration) / 3600 as hours, COUNT(DISTINCT application_name) as apps FROM activity_records WHERE duration > 0 AND application_name IS NOT NULL GROUP BY developer_id, DATE(timestamp) ORDER BY activity_date DESC, dev_id LIMIT 20 zDeveloper Activity Summary:z:Developer ID | Date | Records | Hours | Appsz<------------------------------------------------------------FZUnknownTz<20z | 7z5.1f4zNo data found!u ⚠️ KEY INSIGHT:zIThe dashboard is showing '0h worked' because it's looking at TODAY's datez,but your data is from the dates shown above.uM ✅ SOLUTION: Select one of the dates above in your dashboard's date picker!z= ============================================================z%Checking today's data specifically...a SELECT CAST(developer_id AS VARCHAR) as dev_id, COUNT(*) as records, SUM(duration) / 3600 as hours FROM activity_records WHERE DATE(timestamp) = :today AND duration > 0 GROUP BY developer_id todayz Data for today (z):z z: z records, z.1fz hoursu ❌ No data for today ()z(This is why the dashboard shows 0 hours!)"Z sqlalchemyrrosZdotenvrrrgetenvrrr r r r ZengineprintZconnectZconnZexecuteresultZ data_foundrowZdev_idZact_dateZrecordsZhoursZappsstrZ dev_id_strZ hours_valrZfetchallZ today_datarr./quick_dashboard_test.pys^       " .   $