U Sh @sddlmZmZddlZddlmZddlmZeedZ e seddZ edd Z ed d Z ed d Z eddZde dede de de Z ee ZedeZeedZeZerededededeD]>\ZZZZerendZeededdeddedqeddZeZededeed eeekreejZed!ed"ed#ed$ed%eed&ned'ned(W5QRXdS))) create_enginetextN) load_dotenv)date DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/z)=== Finding Dates with Activity Data === aP SELECT DATE(timestamp) as activity_date, COUNT(DISTINCT developer_id) as developers, COUNT(*) as total_records, SUM(duration) / 3600 as total_hours FROM activity_records WHERE duration > 0 GROUP BY DATE(timestamp) ORDER BY activity_date DESC zDates with activity data:z2==================================================z/Date | Developers | Records | Total Hoursz2--------------------------------------------------z | Z107z10.1fz3 ==================================================u📅 Today's date: u📊 Latest data: u ⚠️ Your data is z days old!u 🔧 TO FIX THE DASHBOARD:z01. Click the date picker in the top-right cornerz 2. Select: z&3. Your hours will appear immediately!u ✅ You have data for today!u+❌ No activity data found in the database!) Z sqlalchemyrrosZdotenvrZdatetimergetenvrrrr r r ZengineprintZconnectZconnZexecuteresultZfetchallZdatesZact_dateZdevsZrecordsZhoursZ hours_valZ latest_dateZtodayZdaysZ days_diffrr./find_data_dates.pysN        "  &