U Ch @sdZddlmZmZddlZddlZddlmZmZddlm Z ddl m Z e e de ZeeZdd Zed ed ed eZeed ZeeZedeeddZdZedeeeD]lZeeeeZeD]2Zeejej Z!eedej"e!ded7Zqe#ededeeqededW5QRXeded eZeedZe$Z%ede%j&ede%j'ede%jde%je%j&ddd ed!eed"ZeD]@\Z(Z)e)e%j&dZ*ed#e(pd$d%d&e)d'de*d(d qeW5QRXed)ed d*Z+e,Z-e-ed+d,Z.eZeed-e+e.e-d.Ze$Z/ed/e/j&ed0e/j0ed1e/j1ed2e/j2ed3e/j3ed4eed5d6e+iZeD]T\Z4Z(Z5Z6e5r4ee5d7kr4e5dd7d8ne5Z7ed9e(d:d;e4d<d&e7qW5QRXed=ed>ed?ed@edAedBedCedDedEedFedGedHedIedJedKedLedMedNedOedPedQedRdS)SzQ Run this script to fix all activity data issues Usage: python3 run_all_fixes.py ) create_enginetextN)datetime timedelta) load_dotenv)Config DATABASE_URLcs|sdSt|}|r$t|nd|dd}|dkr@dS|dkrLdS|dkrtfd d d Drnd Stfd d dDrdSdS|dkrdSdS)z*Categorize activity based on app and titleotherz.exe)codeZcursorZwindowsterminalZterminusZnotepadcmdZ powershellZgitpythonZnodeZnpmZpycharmZintellijZsublimeZatomZvimZ productivity)ZexplorerfinderZnautilussystem)ZchromeZfirefoxZedgeZmsedgeZbraveZoperac3s|]}|kVqdSN.0kwZ title_lowerr./run_all_fixes.py +sz&categorize_activity..)ZawsZazureZgcpZ localhostZgithubz:3000z:8000z:5000serverc3s|]}|kVqdSrrrrrrr/s)ZyoutubeZfacebookZ instagramZtwitterZredditZnetflixZ unproductivebrowser)ZteamsZslackZzoomZskypeZ communication)strlowerreplaceany)Zapp_name window_titleZ app_lowerZapp_baserrrcategorize_activitys$  rz(=== FIXING ALL ACTIVITY DATA ISSUES === z&STEP 1: Categorizing all activities...z2--------------------------------------------------z SELECT id, application_name, window_title FROM activity_records WHERE category IS NULL OR category = '' zFound z uncategorized recordsiz} UPDATE activity_records SET category = :category WHERE id = :id )idcategoryz Progress: /u✅ Categorized z records zSTEP 2: Verifying data...z SELECT COUNT(*) as total, COUNT(DISTINCT developer_id) as developers, COUNT(CASE WHEN category IS NOT NULL THEN 1 END) as categorized FROM activity_records zTotal records: zTotal developers: z Categorized: z (dz.1fz%)z Category breakdown:z SELECT category, COUNT(*) as count FROM activity_records GROUP BY category ORDER BY count DESC z ZNULLz<15 z>7z>5.1fz,STEP 3: Testing developer 'ankita_gholap'...Z ankita_gholap)Zdaysa SELECT COUNT(*) as total, COUNT(CASE WHEN category = 'productivity' THEN 1 END) as prod, COUNT(CASE WHEN category = 'server' THEN 1 END) as server, COUNT(CASE WHEN category = 'unproductive' THEN 1 END) as unprod, COUNT(CASE WHEN category = 'browser' THEN 1 END) as browser FROM activity_records WHERE developer_id = :dev_id AND timestamp >= :start_date AND timestamp <= :end_date )dev_id start_dateend_datezRecords in last 7 days: z Productivity: z Server: z Unproductive: z Browser: z Recent activities:z SELECT application_name, category, window_title, timestamp FROM activity_records WHERE developer_id = :dev_id ORDER BY timestamp DESC LIMIT 5 r'(z...z [z<12z] z<20z= ============================================================u✅ DATABASE FIXES COMPLETE!z<============================================================z NOW YOU NEED TO:z) 1. Add the API endpoint to your main.py:z1 - Copy the code from 'working_api_endpoint.py'z' - Add it to your FastAPI applicationz 2. Restart your backend server:z% cd /var/www/html/timesheet/backendz% # Kill existing process if runningz # Then start:z python3 main.pyz # orz7 uvicorn main:app --reload --host 0.0.0.0 --port 5000z 3. Test the API:z{ curl http://localhost:5000/api/activity-data/ankita_gholap?start_date=2025-09-30T00:00:00Z&end_date=2025-10-07T23:59:59Zz, 4. Clear browser cache and reload dashboardz$ If you still see the 'other' error:z,- The API endpoint code might not be updatedz@- Check if the endpoint is returning 'other' as an error messagez.- Look at the server logs for the actual erroru ✅ Script complete!)8__doc__Z sqlalchemyrrossysrrZdotenvrZconfigrgetenvZget_database_urlrZenginerprintZconnectZconnZexecuteresultlistZrecordslenZ batch_sizeZ categorizedrangeiZbatchrecordZapplication_namerr!r ZcommitfirstZstatstotalZ developerscatcountZpctZ developer_idZutcnowr)r(dataZprodrZunprodrZapptitletsZ title_shortrrrrs  '    & ,   (,