U h|1@sddlZddlZddlmZeedZedddZeddZ edd Z e ddZ ej e de e dkre dnd e de de dd ZeZd d ddddddddddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEg dFdGdHdIdJdKdLdMdNdOdPg dQdRdSdTdUdVdWdXdYdZg d[Zd\d]Zed^ed_ed`eD] \ZZedaedbedcq~eddedeeZdZeD]T\ZeeZedfeefejZee7ZedkredaedgedhediqeedjeedkedleD] \ZZedaedbedcqHedmdnD]fZedoededpefeZ e re D] \Z!Zedqe!dbedcqnedrqve"e"edsdS)tN) load_dotenv DATABASE_URLz postgresql://@:/Z5432)ZhostZportZdatabaseuserZpasswordzcode.execodez cursor.execursorz devenv.exez notepad++.exezsublime_text.exezatom.exez brackets.exeZvimZemacsz pycharm.exez pycharm64.exezidea.exez idea64.exez webstorm.exez phpstorm.exez rubymine.exez goland.exez clion.exez rider.exez datagrip.exez studio64.exez eclipse.exez netbeans.exezword.exez winword.exez excel.exez powerpnt.exez outlook.exez teams.exez slack.exez discord.exezzoom.exez skype.exez notion.exez obsidian.exez onenote.exez evernote.exeZterminalzcmd.exezpowershell.exeZbashz git-bash.exez postman.exez insomnia.exezgit.exez python.exeznode.exez chrome.exez firefox.exez msedge.exez opera.exez brave.exez vivaldi.exeZsafariz iexplore.exebrowserz filezilla.exez winscp.exez putty.exez mobaxterm.exez mysql.exezpsql.exez pgadmin4.exeZ phpmyadminZapacheZnginxZhttpdz spotify.exezvlc.exezmpv.exez wmplayer.exez steam.exezepicgameslauncher.exez whatsapp.exez telegram.exez signal.exez messenger.exe) productivityr servernon-workcsD|sdS|tD]&\}}tfdd|Dr|SqdS)z+Categorize an application based on its name uncategorizedc3s|]}|kVqdS)N).0appZ app_lowerr./categorize_all_activities.py >sz!categorize_app..)lower CATEGORIESitemsany)app_namecategoryappsrrrcategorize_app6s rz)=== Categorizing All Activity Records ===z" 1. Current category distribution:z SELECT CASE WHEN category IS NULL OR category = '' THEN 'NULL/Empty' ELSE category END as cat, COUNT(*) as count FROM activity_records GROUP BY cat ORDER BY count DESC z z: z recordsz5 2. Updating categories based on application names...zg SELECT DISTINCT application_name FROM activity_records WHERE application_name IS NOT NULL zc UPDATE activity_records SET category = %s WHERE application_name = %s z -> z (z records)u ✅ Total records updated: z 3. New category distribution:zp SELECT category, COUNT(*) as count FROM activity_records GROUP BY category ORDER BY count DESC z$ 4. Sample categorized applications:)r r rrrz z SELECT DISTINCT application_name, COUNT(*) as count FROM activity_records WHERE category = %s GROUP BY application_name ORDER BY count DESC LIMIT 5 z - z (no applications)uO ✅ Categorization complete! Your dashboard should now show proper categories.)#Zpsycopg2osZdotenvrgetenvrreplacesplitZ conn_partsZ user_passZhost_dbZ host_portZconnectlenZconnr ZcurrrprintZexecuteZfetchallcatcountZ app_namesZ total_updatedrrZrowcountupdatedZcommitupperrrcloserrrrs