U —!ΨhUγ @sdZddlmZmZddlmZddlZedƒe dd‘Ze dƒe d ƒzJeeƒZ e   ‘.Z e   ed ƒ‘Ze ‘Ze d ƒe d ed›ƒe d ed›ƒe ded›ƒe   edƒ‘Ze ‘Ze dƒe ded›ƒe ded›ƒe ded›ded›ƒe   edƒ‘Ze ‘Ze dƒerreD]0Ze ded›ded›dedd›dƒq>ne dƒe   ed ƒ‘Ze ‘Ze d!ƒeD]VZedrΐeddd"…›d#nd$Ze d%ed›d&ed›d'e›d(ed›ƒqœe d)ƒe   ed*ƒ‘Ze ‘Zedkr,e d%e›d+ƒe   ed,ƒ‘Ze ‘Zedkr\e d-e›d.ƒe   ed/ƒ‘Ze ‘ZedkrŒe d0e›d1ƒW5QRXWnhek rZzHe d2ƒe de›ƒe d3ƒe d4ƒe d5ƒe d6ƒe d7e›ƒW5dZ[XYnXdS)8z6 Quick database check for developer and activity data ι)Ϊ create_engineΪtext)Ϊ load_dotenvNz.envΪ DATABASE_URLz7postgresql://postgres:asdf1234@localhost:5432/timesheetuπŸš€ Quick Database Checkz2==================================================a SELECT COUNT(*) as total_developers, COUNT(CASE WHEN active = true THEN 1 END) as active_developers, COUNT(CASE WHEN api_token IS NOT NULL THEN 1 END) as with_tokens FROM developers u πŸ‘₯ DEVELOPERS:z Total: z Active: ιz With Tokens: ιa@ SELECT COUNT(*) as total_records, COUNT(DISTINCT developer_id) as developers_with_data, MIN(timestamp) as oldest_activity, MAX(timestamp) as newest_activity FROM activity_records WHERE developer_id IS NOT NULL u πŸ“Š ACTIVITIES:z Total Records: z Developers with Data: z Date Range: z to ιa: SELECT developer_id, COUNT(*) as activities_today, SUM(duration) / 3600.0 as hours_today FROM activity_records WHERE DATE(timestamp) = CURRENT_DATE GROUP BY developer_id ORDER BY hours_today DESC u πŸ“… TODAY'S ACTIVITY:z z: z activities, z.2fz hoursz No activity recorded todayzέ SELECT developer_id, name, api_token, created_at FROM developers ORDER BY created_at DESC LIMIT 10 u! πŸ“‹ DEVELOPER LIST (Recent 10):ιz...zNo tokenz - z (ID: z ) - Token: z - Created: u ⚠️ POTENTIAL ISSUES:zΕ SELECT COUNT(*) FROM developers d LEFT JOIN activity_records ar ON d.developer_id = ar.developer_id WHERE ar.id IS NULL AND d.active = true z( active developers have NO activity dataz± SELECT COUNT(DISTINCT developer_id) FROM activity_records WHERE developer_id IN ('test', 'demo', 'example', 'john_doe', 'jane_doe') z - Found z test/demo developers with datazΞ SELECT COUNT(*) FROM information_schema.columns WHERE table_name = 'developers' AND column_name IN ('ip_address', 'activitywatch_port', 'last_sync') z* - Missing some tracking columns (found z/3)u ❌ Database Connection Error:z Please check:z1. PostgreSQL is runningz2. Database 'timesheet' existsz%3. .env file has correct DATABASE_URLz Current DATABASE_URL: )Ϊ__doc__Z sqlalchemyrrZdotenvrΪosΪgetenvrΪprintZengineZconnectZconnZexecuteΪresultZfetchoneZ dev_statsZ act_statsZfetchallZ today_dataZdevZ developersZ token_displayZscalarZno_activity_countZ test_dataZ column_countΪ ExceptionΪe©rrϊ./quick_db_check.pyΪsp     0 $0