U 7åhã6@s0ddlmZmZddlmZddlZddlmZeƒe de ¡¡Z ee ƒZdddd d ddd ddddddddddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;g6dd?d@dAdBdCdDdEdFdGdHg dIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYgdZd[d\d]d^d_d`dadbdcdddedfdgdhgdiœZdjdk„Z edlƒe ¡âZedmƒe ednƒ¡ZeD]$Zedoed›dpedq›drƒqXedsƒe edtƒ¡Ze ¡ZdZe ¡ZzzeD]Z\Ze eƒZe eduƒeedvœ¡ZejZee7Zedkr®edoe›dwe›dxe›dyƒq®e ¡edze›ƒWn<ek r^Zze ¡ed{e›ƒ‚W5dZ[XYnXed|ƒe ed}ƒ¡ZeD]$Zedoed›dpedq›drƒqzed~ƒdD]lZed€e !¡›dƒe ed‚ƒdƒei¡Ze ¡Z"e"re"D] \Z#Z$ed„e#›dpe$›drƒqêned…ƒq¬W5QRXed†ƒdS)‡é)Ú create_engineÚtext)ÚConfigN)Úload_dotenvÚDATABASE_URLzcode.exeÚcodez cursor.exeZcursorz devenv.exez notepad++.exezsublime_text.exezatom.exezbrackets.exeZvimZemacszpycharm.exez pycharm64.exezidea.exez idea64.exezwebstorm.exezphpstorm.exezrubymine.exez goland.exez clion.exez rider.exezdatagrip.exezstudio64.exezeclipse.exeznetbeans.exezword.exezwinword.exez excel.exezpowerpnt.exezoutlook.exez teams.exez slack.exezdiscord.exezzoom.exez skype.exez notion.exezobsidian.exezonenote.exezevernote.exeZterminalzcmd.exezpowershell.exeZbashzgit-bash.exezpostman.exezinsomnia.exezgit.exez python.exeznode.exeÚpython3ZnpmZyarnZpipZpip3z chrome.exezfirefox.exez msedge.exez opera.exez brave.exezvivaldi.exeZsafariziexplore.exeÚbrowserZchromiumz google-chromeZfirefoxzmicrosoft-edgez filezilla.exez winscp.exez putty.exez mobaxterm.exez mysql.exezpsql.exezpgadmin4.exeZ phpmyadminZapacheZnginxZhttpdZsshZsshdZ systemctlZdockerzdocker-composeZkubectlzspotify.exezvlc.exezmpv.exezwmplayer.exez steam.exezepicgameslauncher.exezwhatsapp.exeztelegram.exez signal.exez messenger.exeZspotifyZvlcZmpvZ rhythmboxztelegram-desktop)Úproductivityr Úserverúnon-workcsD|sdS| ¡‰t ¡D]&\}}t‡fdd„|Dƒƒr|SqdS)z+Categorize an application based on its nameÚ uncategorizedc3s|]}|ˆkVqdS)N©)Ú.0Úapp©Z app_lowerrú./categorize_sqlalchemy.pyÚ 6sz!categorize_app..)ÚlowerÚ CATEGORIESÚitemsÚany)Úapp_nameÚcategoryÚappsrrrÚcategorize_app.s rz)=== Categorizing All Activity Records ===z" 1. Current category distribution:a 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...zw SELECT DISTINCT application_name FROM activity_records WHERE application_name IS NOT NULL z‘ UPDATE activity_records SET category = :category WHERE application_name = :app_name )rrz -> z (z records)u âœ… Total records updated: u âŒ Error during update: z 3. New category distribution:z„ SELECT category, COUNT(*) as count FROM activity_records GROUP BY category ORDER BY count DESC z$ 4. Sample categorized applications:)r r rrr z ú:zì SELECT DISTINCT application_name, COUNT(*) as count FROM activity_records WHERE category = :category GROUP BY application_name ORDER BY count DESC LIMIT 5 rz - z (no applications)uO âœ… Categorization complete! Your dashboard should now show proper categories.)%Z sqlalchemyrrZconfigrÚosZdotenvrÚgetenvZget_database_urlrZenginerrÚprintZconnectZconnZexecuteÚresultÚrowZfetchallZ app_namesZ total_updatedZbeginZtransrrZrowcountÚupdatedZcommitÚ ExceptionÚeZrollbackÚupperrrÚcountrrrrÚs4õýüüç! " ü " ù