U 7h%=@sXddlmZmZddlZddlZddlmZddlZddlm Z e e de Z ee Z dddd d d d d ddddddddddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBg=dCdDdEdFdGdHdIdJdKdLdMdNdOdPdQgdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcddgdedfdgdhdidjdkdldmdndodpdqdrdsdtdudvgdwZdxdyZdzd{Zed|e Zed}eed~ZeZedededededededdkreddkredededeedZdZeD]\Zzeeer0eeneZed7Zedededejedddddee\Z Z!ede de!re!ddnddWn2e"k rZ#zede#W5dZ#[#XYnXqedeedZe$Z%zdZ&dZ'eD]\Z(Zee\Z)Z*e)r ee)Z+eede(e)dde*rTe*ddnde+de&d7Z&e'd7Z'e&ddkr ede&dq edeedZeD]0\Z(Z)ee)Z+eede(e+de'd7Z'qe%,edede&dede'dWn<e"k rLZ#ze%-ede#W5dZ#[#XYnXededeedZeD] \Z Z.ede de.dqpedeedZeD]&\Z/Z.ede/pdde.dqedeedZeD]:\Z Z/Z!ede/de de!re!ddnddqW5QRXededededdS)) create_enginetextN)Config) load_dotenv DATABASE_URLzcode.execodez cursor.exeZcursorz 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.exepython3ZnpmZyarnZpipZpip3zgnome-terminalZkonsoleZxterm terminatorZtilixZvscodezvisual studio codez chrome.exez firefox.exez msedge.exez opera.exez brave.exez vivaldi.exeZsafariz iexplore.exebrowserZchromiumz google-chromeZfirefoxzmicrosoft-edgeZchromeZedgez filezilla.exez winscp.exez putty.exez mobaxterm.exez mysql.exezpsql.exez pgadmin4.exeZ phpmyadminZapacheZnginxZhttpdZsshZsshdZ systemctlZdockerzdocker-composeZkubectlZmysqlZ postgresqlz spotify.exezvlc.exezmpv.exez wmplayer.exez steam.exezepicgameslauncher.exez whatsapp.exez telegram.exez signal.exez messenger.exeZspotifyZvlcZmpvZ rhythmboxztelegram-desktopZyoutubeZnetflixZdiscord)Z productivityr Zserverznon-workcsD|sdS|tD]&\}}tfdd|Dr|SqdS)z+Categorize an application based on its nameZ uncategorizedc3s|]}|kVqdS)N).0appZ app_lowerr ./fix_all_activities.py :sz!categorize_app..)lower CATEGORIESitemsany)app_namecategoryZappsr rrcategorize_app2s rc Cs z|s WdSt|tr"t|}n|}d}d}t|trd|krt|dtr|d}|dph|d}|dp||d}n2|dp|dp|d}|dp|d}|sd |kr|d }||fWStk r}ztd |WYdSd}~XYnXdS) zAExtract application name and window title from activity_data JSON)NNNdatar Z applicationtitle window_titleZapplication_nameZurlzError parsing JSON: ) isinstancestrjsonloadsdictget Exceptionprint)Z activity_datarrrZ event_dataer r rextract_app_info?s*     r$z.=== Comprehensive Fix for Activity Records ===z 1. Checking current state...z SELECT COUNT(*) as total, COUNT(CASE WHEN application_name IS NULL THEN 1 END) as null_app, COUNT(CASE WHEN category IS NULL OR category = '' THEN 1 END) as null_category FROM activity_records z Total records: z" Records with NULL application: z Records without category: u? ✅ All records already have application names and categories!z( 2. Examining activity_data structure...z SELECT activity_data FROM activity_records WHERE activity_data IS NOT NULL AND activity_data != '' AND activity_data != '{}' LIMIT 5 z Sample :z Structure: )indenti,z...z Extracted: app='z ', title='2'z Error: z, 3. Extracting application data from JSON...z SELECT id, activity_data FROM activity_records WHERE (application_name IS NULL OR application_name = '') AND activity_data IS NOT NULL AND activity_data != '{}' a UPDATE activity_records SET application_name = :app_name, window_title = COALESCE(:window_title, window_title), category = :category WHERE id = :id i)idrrrdz Processed z records...z% 4. Categorizing remaining records...z SELECT id, application_name FROM activity_records WHERE (category IS NULL OR category = '') AND application_name IS NOT NULL z} UPDATE activity_records SET category = :category WHERE id = :id )r-ru$ ✅ Successfully processed records:z - Extracted app data: z recordsz - Categorized: u ❌ Error during processing: z 5. Final Results:z Top Applications:z SELECT application_name, COUNT(*) as count FROM activity_records WHERE application_name IS NOT NULL GROUP BY application_name ORDER BY count DESC LIMIT 15 z z: z Category Distribution:z SELECT category, COUNT(*) as count FROM activity_records GROUP BY category ORDER BY count DESC ZNULLz" Sample Categorized Activities:z SELECT application_name, category, window_title FROM activity_records WHERE category IS NOT NULL AND application_name IS NOT NULL ORDER BY timestamp DESC LIMIT 10 z [z] <zNo titleuD ✅ Fix complete! Your dashboard should now show proper categories.uC 📝 Note: If some records still have NULL applications, it means:z; - The activity_data JSON doesn't contain app informationzF - The sync script needs to be updated to properly capture this data)0Z sqlalchemyrrrsysZconfigrosZdotenvrgetenvZget_database_urlrZenginerrr$r"ZconnectZconnZexecuteresultZfetchoneZstatsexitZ sample_countZdata_strrrrrdumpsr rr!r#ZbeginZtransZ updated_countZcategorized_countZ record_idrrrZcommitZrollbackcountcatr r r rs  # #    " ,$            <