U 7åhã3ã @sTddlmZmZddlZddlZddlZddlmZddlm Z eƒe  de   ¡¡Z ee ƒZ dd„Zdd „Zed ƒe  ¡¢Zed ƒe ed ƒ¡ZdZeD]Zed 7Zeedƒ\ZZesÄer ede›de›de›dƒed kr eedeƒre ed¡nedZedejedddd…›dƒq edƒe edƒ¡ZeeƒZede eƒ›dƒdZ!dZ"e#de eƒe!ƒD]ˆZ$ee$e$e!…Z%e%D]kròedd>…dnepúd?Z6ed@e2dA›dBedC›dDe6›ƒqÄW5QRXedEƒedFƒedGƒedHƒedIƒdS)Jé)Ú create_engineÚtextN)Ú load_dotenv)ÚConfigÚ DATABASE_URLc Cs<|sdSzðt|tƒr t |¡}n|}d}d}d|kr>|d}n4d|krP|d}n"d|krb|d}nd|krr|d}d|kr„|d}n"d|kr–|d}nd |kr¦|d }|sðd |krð|d }t|tƒrð| d¡pÖ| d¡}|pî| d¡pî| d ¡}||fWStjtfk r6}ztd |›ƒWY¢dSd}~XYnXdS) zK Extract application name and window title from activity JSON data )NNNÚappZ applicationZprogramZprocessÚtitleZwindowÚ window_titleÚdatazError parsing JSON: ) Ú isinstanceÚstrÚjsonÚloadsÚdictÚgetZJSONDecodeErrorÚ TypeErrorÚprint)Ú activity_datar Úapp_namer ÚnestedÚe©rú./categorized_from_json.pyÚextract_app_info_from_jsons>          rc NCsê|sdSt|ƒ ¡}|r$t|ƒ ¡nd}| dd¡}dddddd d d d d ddddddddddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPhM}||krÞdQSdRdSdTdUdVdWh}||krúdXSdYdZd[d\d]d^d_d`dadbh }||kr’dcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~dd€dd‚dƒd„d…d†d‡dˆd‰dŠd3d‹dŒddŽddd‘d’d“d”d•d–d—d˜d™dšd›dœddždŸd d¡d¢d£d¤gC}d¥d¦d§d¨d©dªd«d¬d­d®d¯d°d±d²d³d´dµd¶d·d¸d¹dºd»d¼d½d¾d¿dÀdÁdÂdÃdÄdÅdÆdÇdÈdÉdÊdËdÌdÍdÎdÏdÐdÑdÒdÓdÔdÕdÖd×dØdÙdÚdÛdÜdÝdÞdßdàdádâdãdädådædçdèdédêdëdìdídîdïdðdñdògN} |D]} t | |tj¡rJdóSqJ| D]} t | |tj¡rndôSqndõSdöd÷dødùdúd²d±h} || kr²dûSdüdýdþdÿddddddh } || krædSdS(z@ Categorize activity based on app name and window title ÚotherÚz.exeÚcodeZvscodezvisual studio codeZ visualstudioZdevenvZpycharmZ pycharm64ZideaZidea64ZintellijZeclipsez notepad++Z sublime_textZsublimeZatomZbracketsZwebstormZphpstormZrubymineZgolandZcursorZnotepadZvimZgvimZemacsZnanoZwindowsterminalZterminalÚcmdZ powershellZbashÚshZzshZterminusZitermZweztermZconemuZcmderZhyperZminttyZkonsoleZgitzgit-bashzgithub desktopZ sourcetreeZ gitkrakenZ tortoisegitZdockerzdocker desktopZpostmanZinsomniaZpawZsoapuizthunder clientZdbeaverZmysqlZmysqldzmysql workbenchZpgadminZpgadmin4zmongodb compassZmongodZredisz redis-serverZ tableplusz sequel proZheidisqlZnavicatZ filezillaZwinscpZputtyZvncZanydeskZ virtualboxZvmwareZvagrantZ parallelsÚ productivityZexplorerÚfinderZnautilusZthunarZdolphinÚfilesÚsystemZchromeZfirefoxZmsedgeZedgeZbraveZoperaZvivaldiZsafariZchromiumZwaterfoxz console\.awsz aws\.amazonZ amazonawsz\baws\bz\bec2\bz\bs3\bÚlambdaZ cloudfrontZelasticbeanstalkZcloudformationZroute53zrds\bZdynamodbzconsole\.cloud\.googlez cloud\.googlez\bgcp\bzcompute enginez app enginez cloud storageZfirebasez portal\.azurezazure\.microsoftz \bazure\bz azure devopszvisualstudio\.comZ digitaloceanZherokuZnetlifyZvercelz render\.comZ cloudflareZlinodeZvultrz railway\.appz github\.comZgitlabZ bitbucketZjenkinsZcircleciz travis-ciZ kuberneteszk8s\.ioZ localhostz 127\.0\.0\.1z 0\.0\.0\.0z 192\.168\.z :[0-9]{4}zlocalhost:[0-9]+Z stackoverflowz developer\.z developers\.zdocs\.Z documentationzapi\.z console\.zadmin\.Z dashboardz control panelZ phpmyadminZadminerz mongodb\.comz redis\.ioz elastic\.coZgrafanaZkibanaZ prometheusZfacebookZ instagramZtwitterz\bx\.comZtiktokz linkedin\.comZ pinterestZtumblrZsnapchatÚthreadsZmastodonz discord\.comZwhatsappZtelegramZyoutubez youtu\.beZnetflixz twitch\.tvZvimeoZ dailymotionZhuluZdisneyZ disneyplusZhbomaxZ primevideoz prime videoZhotstarZsonylivZzee5Z crunchyrollZ funimationZspotifyZ soundcloudZpandoraZdeezerz apple musicZjiosaavnZgaanaZwynkz amazon musicz amazon\.comz amazon\.inzamazon\.ZflipkartZebayZalibabaZ aliexpressZmyntraZajioZshopifyZetsyZwalmartZbestbuyz target\.comZredditZ9gagZimgurZbuzzfeedz medium\.comznews\.zcnn\.zbbc\.ZfoxnewsZndtvZ timesofindiaZsteamZ epicgamesÚoriginz battle\.netZrobloxZ minecraftZfortniteZvalorantZleagueoflegendsZtwitchZgamingzgames\.zign\.comÚserverÚ unproductiveÚbrowserZteamsZslackZzoomZskypeZdiscordZ communicationZwinwordZexcelZpowerpntZoutlookZonenoteZmsaccessZmspubZvisioZwordZ powerpointZoffice)r ÚlowerÚreplaceÚreÚsearchÚ IGNORECASE) rr Z app_lowerZ title_lowerZapp_baseZproductivity_appsZ system_appsZbrowsersZserver_patternsZunproductive_patternsÚpatternZ comm_appsZ office_appsrrrÚcategorize_activity?s   ð ÿ ß'ä     ÿ r/z.=== Categorizing Activities from JSON Data ===z 1. Analyzing JSON structure:zx SELECT activity_data FROM activity_records WHERE activity_data IS NOT NULL LIMIT 5 éz Sample z: app='z ', title='ú'z JSON structure: é)Úindentiôz...z9 2. Extracting app info from JSON and updating records...zÌ SELECT id, activity_data, application_name, window_title FROM activity_records WHERE activity_data IS NOT NULL AND (application_name IS NULL OR application_name = '') z Found z" records with JSON but no app namezã UPDATE activity_records SET application_name = :app_name, window_title = COALESCE(:window_title, window_title) WHERE id = :id )Úidrr z Updated ú/z recordsz( Total records updated with app info: z6 3. Categorizing all records based on app and title...z° SELECT id, application_name, window_title FROM activity_records WHERE application_name IS NOT NULL AND (category IS NULL OR category = '') z records to categorizez} UPDATE activity_records SET category = :category WHERE id = :id )r4Úcategoryz Categorized z 4. Final Results:z Category Distribution:z„ SELECT category, COUNT(*) as count FROM activity_records GROUP BY category ORDER BY count DESC z ZNULLz<15ú z>7z! Top Applications by Category:rr&r'r(r"z ú:zã SELECT application_name, COUNT(*) as count FROM activity_records WHERE category = :category GROUP BY application_name ORDER BY count DESC LIMIT 5 r6z z<25z>6z" 5. Sample Categorized Activities:z° SELECT application_name, window_title, category FROM activity_records WHERE category IS NOT NULL ORDER BY created_at DESC LIMIT 10 é<zNo titlez [z<12z] z<20z | u ✅ Categorization complete!z@ Note: If some records still lack categories, it may be because:z*- The JSON doesn't contain app informationz,- The app is not in our categorization rulesz/- The JSON structure is different than expected)7Z sqlalchemyrrr Úosr+ZdotenvrZconfigrÚgetenvZget_database_urlrZenginerr/rZconnectZconnZexecuteÚresultZ sample_countÚrowrrr r rr ÚdumpsÚlistZrecords_to_updateÚlenZ batch_sizeZ updated_countÚrangeÚiZbatchÚrecordrrr r4ZcommitÚminZrecords_to_categorizeZcategory_statsZapplication_namer6rÚcatÚcountÚ categoriesÚupperZ title_previewrrrrÚs¬  1 &$ ýû , þü , $ ù ".,