U 7hk @sJddlmZmZddlmZmZddlZddlmZddlm Z ee de Z ee Z ede Zedeed ZeZeD]\ZZed ed ed qed eedZeZeD]\ZZed ed ed qedeedZeZeD]&\ZZed ep,dd ed qereddZededeZeedeedZeZerDededeD]Z ede dede dede dre dddndded e d!pded"e d#d$ed%e d&ed'qnved(eed)d*Z!eed+ee!d,ZeZ"e"D]<\ZZZ#e#re#d-ndZ$ed.ed ed/e$d0d1q|ed2eed3Ze%dZ&ed4e&e&dkr4ed5eed6ZeD] \ZZed.ed ed qW5QRXed7dS)8) create_enginetext)datetime timedeltaN) load_dotenv)Config DATABASE_URLz.=== Activity Records Analysis (SQLAlchemy) ===z- 1. Unique developer_ids in activity_records:z SELECT DISTINCT developer_id, COUNT(*) as record_count FROM activity_records WHERE developer_id IS NOT NULL GROUP BY developer_id ORDER BY record_count DESC z z: z recordsz 2. Top 20 Application Names:z SELECT application_name, COUNT(*) as count FROM activity_records WHERE application_name IS NOT NULL GROUP BY application_name ORDER BY count DESC LIMIT 20 z$ 3. Current Categories Distribution:z SELECT category, COUNT(*) as count FROM activity_records GROUP BY category ORDER BY count DESC ZNULLz" 4. Sample records for developer 'z':ao SELECT id, application_name, window_title, category, duration, timestamp FROM activity_records WHERE developer_id = :dev_id AND DATE(timestamp) = :today ORDER BY timestamp DESC LIMIT 10 )dev_idtodayz Today's activities (z):z ID: z App: z Title: 2Nonez...z Category: z Duration: z secondsz Time: z ---z9 No activities found for today. Checking last 7 days...)Zdaysa SELECT DATE(timestamp) as date, COUNT(*) as activity_count, SUM(duration) as total_duration FROM activity_records WHERE developer_id = :dev_id AND DATE(timestamp) >= :week_ago GROUP BY DATE(timestamp) ORDER BY date DESC )r week_agoiz z activities, z.2fz hoursz 5. Uncategorized Records:zm SELECT COUNT(*) FROM activity_records WHERE category IS NULL OR category = '' z Total uncategorized: z Sample uncategorized apps:a( SELECT DISTINCT application_name, COUNT(*) as count FROM activity_records WHERE category IS NULL OR category = '' AND application_name IS NOT NULL GROUP BY application_name ORDER BY count DESC LIMIT 10 z Done!)'Z sqlalchemyrrrrosZdotenvrZconfigrgetenvZget_database_urlrZengineprintZconnectZconnZexecuteresultZfetchallZ developersr countZappsZapp categoriescatZ sample_dev_idZnowdater ZrecordsrecordrZ daily_statsZdurationZhoursZfetchoneZuncategorized_countrr./debug_activity_sqlalchemy.pysz           *  "   $