U !h @sdZddlmZmZddlmZddlZddlmZmZddl Z ede ddZ e d e d zfee Z e JZe d e d eed ZeZe deeeD]Ze dedde dede dede dede edr*deddddnde dede dede d ed!qe d"e d eed#ZeZe d$eeeD]bZe d%ede d&ede d'ede d(ede d)edd*qe d+e d eedd,Zeed-d.eiZeZereD].Ze edd/edd0edd*d1qPne d2e d3e d eed4ZeZere d5eD],Ze d6edd7edd8edqne d9e d:e d eed;ZeZeeD]\ZZ e de de d?e dd@e dr(zLe!e de"re #e dne dZ$e dAe j%e$ddBddCdWn,e dAe"e dddCdYnXq(e dDe d eedEZe dFeD]:Z&e d6e&dd7e&ddGe&ddHkr\dIndJq.eedKZe dLeD]:Z&e d6e&dd7e&ddGe&ddHkrdIndJqW5QRXWn@e'k r Z(z e dMe(e dNe W5dZ([(XYnXdS)Oz& Check developer data in the database ) create_enginetext) load_dotenvN)datetime timedeltaz.env DATABASE_URLz7postgresql://postgres:asdf1234@localhost:5432/timesheetu🔍 Checking Developer Data...z<============================================================u 📋 DEVELOPERS TABLE:z(----------------------------------------a& SELECT id, developer_id, name, email, api_token, active, created_at, last_sync FROM developers ORDER BY created_at DESC zTotal Developers: z Developer #:z ID: z Name: z Email: z Token: z...zNo tokenz Active: z Created: z Last Sync: u 📊 ACTIVITY RECORDS:a SELECT developer_id, COUNT(*) as record_count, MIN(timestamp) as first_activity, MAX(timestamp) as last_activity, SUM(duration) / 3600.0 as total_hours FROM activity_records WHERE developer_id IS NOT NULL GROUP BY developer_id ORDER BY last_activity DESC zDevelopers with Activities: z Developer: z Records: z First Activity: z Last Activity: z Total Hours: z.2fu& ⏰ RECENT ACTIVITY (Last 24 hours):)Zdaysa  SELECT developer_id, COUNT(*) as activities, SUM(duration) / 3600.0 as hours FROM activity_records WHERE timestamp > :yesterday GROUP BY developer_id ORDER BY hours DESC yesterdayz: z activities, z hoursz No activity in the last 24 hoursu 🔧 SYNC STATUS:z SELECT d.developer_id, d.name, d.created_at 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!Developers with NO activity data:z - z (z) - Registered: u,✅ All active developers have activity datau- 📝 SAMPLE ACTIVITY DATA (Last 5 records):z SELECT developer_id, timestamp, duration, activity_data FROM activity_records ORDER BY timestamp DESC LIMIT 5 z Record z Developer: z Time: z Duration: z secondsz Data: )indentu 🏗️ TABLE STRUCTURE:z SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = 'developers' ORDER BY ordinal_position zDEVELOPERS table columns:z) ZYESzNOT NULLz SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = 'activity_records' ORDER BY ordinal_position z ACTIVITY_RECORDS table columns:u ❌ Error: zDatabase URL: ))__doc__Z sqlalchemyrrZdotenvrosrrZjsongetenvrprintZengineZconnectZconnZexecuteresultZfetchallZ developerslenZdevZ activitiesZactZnowrZrecentrZ no_activityZsamples enumerateiZsample isinstancestrloadsdatadumpscol Exceptioner&r&./check_developer_data.pys   *   .,  &&*8F