[j6 dZddlZddlZddlZddlZddlmZddlmZidddddd ddddd dd d dd d d d dddd d dddd d dddd d dddd d ddd dddddddddddddddddddddddd ddddd!d"d#ddd$d%d#ddd&d%d#ddd%d#ddd'd(ddd'd(ddd)d*ddd)d*ddd+dddd%d,ddd-Zgd.Z d/Z d0Z d1Z d2Z d3Zd4Zed5k(reyy)6uAppend 🎬 Top 5 Video Opportunities to Reddit gaps reports. Scores each gap post by engagement + vertical relevance + visual potential, then appends a markdown table section matching the banger-x video opportunity format. N)datetime)Pathsleepg? NestraSleepweightverticalproductinsomniaposturezNeckLog+backpaingffffff?tmj? chronicpainmigraine333333? fibromyalgia hermesagentai-toolsz Hermes AgentstableDiffusionzAI video generativeAI vibecodingz AI codingfrugalg?ecomgeneral digitalnomad adhdwomen? lifestyle socialskillsg?decidingtobebetterg?travelgffffff?tech333333?fitness) confidenceroadtriponebag technology pcmasterrace askreddit xxfitness)zhow.*fixz how.*relievez how.*stopz how.*improvez any.*exercisstretchroutine techniqueguidetutorial demonstratzshow mezpain in.*sleepr alignmentz before.*after transformc0g}d}g}|jdD]c}tjd|}|r+|r|r|j||f|j d}g}G|sJtjd|}|r3|j|j d|j d|dtj d|}|rb|r`t |j djd d |d d <t |j djd d |d d <tjd|}|s)|s-d|d vs6d|vr"|jdd jnd |d d<f|r|r|j||f|S)z=Parse gaps report markdown, extract (subreddit, posts) pairs.N z ^## r/(\w+)z\*\*\[(.+?)\]\((.+?)\)\*\*)titleurllineu(⬆️\s*([\d,]+)\s*\|\s*💬\s*([\d,]+),upvotescommentsu¹\s*(Score|Patterns):patternsz Patterns:) splitrematchappendgroupsearchintreplacestrip) contentsections current_sub current_postsr;mpmempm2s :/home/kiro/trend-engine/trends/reddit/append_video_opps.pyextract_subreddit_postsrT8sHKM d#w HH^T * }m <=''!*KM  7>B$$XXa[88A; &FMBm/2288A;3F3FsB3O/P b!),03BHHQK4G4GR4P0Q b!*-((4d;C}]2%66[fjn[nDJJ{4KB4O4U4U4WtvM"%j1;w>}m45 Oc |jdd}|jdd}|jddj ||zdkDr|dz|dzzdznd}|j}tj|d d d d }|d }d}tD]} t j | sd}nd vrdnd} t fddDrdnd} ||z|z| z| z} t| d|fS)z5Score a post for video opportunity potential (0-100).r?rr@r9r=r8r$g?otherrrrr?rrc3&K|]}|v yw)N).0wr9s rS zscore_post..zsZ!1:Zs)zhow zwhat zwhy zany ztips r7)getlowerVERTICAL_WEIGHTSVISUAL_PATTERNSrCrGanyround)post subredditr?r@ engagementsub_key vert_info vert_bonus visual_scorepatquestion_bonus how_bonusscorer9s @rS score_postrpbshhy!$Gxx A&H HHWb ! ' ' )E:A89Kq8P'A+1 ,4VWJooG $$W'^g.hiI8$JL 99S% L   5LScNZ/YZZ`cI  #l 2^ Ci OE ?I %%rUcb|jdd}|jdd}|jdd}|j}d d}|dk(ry|d k(rd |vsd |vry d |vsd|vryd|vryy|dk(rd|vsd|vryd|vsd|vryy|r |dk7r|dS||jddd}d|dS)!z3Generate a punchy video hook based on post content.r9r=r rr cp|j}t||kr|Sdj|d|dzS)N ...)rBlenjoin)text max_wordswordss rStruncate_wordsz%generate_hook..truncate_wordss9  u: "Kxxjy)*U22rUruDYour sleep quality is wrecking your health — here's the fix in 60sr neckhumpu=That neck hump isn't permanent — here's what actually worksjawruCTMJ relief in under 60 seconds — the jaw trick nobody talks aboutpainu=Stop chasing pain relief — fix the root cause in your sleepuDYour posture is the problem nobody diagnoses — here's the real fixrhermesagentuFHermes Agent vs Claude Code — the honest comparison nobody's postingvideoanimeuBEveryone's making AI video wrong — here's the $0.05/gen pipelineu;The tool stack nobody's talking about — 10x your workflowz solves this in under 60 secondsrYzThe answer to "z" is simpler than you think) )r_r`rI) rerfrir9r r title_lowerrzcores rS generate_hookrs HHWb !E}}Z3HmmIr*G++-K3 7V Y  [ Fk$9 S k !Uk%9 Y { " SV Z  { "g&< \  #w+'= XM W ):;;emmC4a8!$'CDDrUcp|jdd}|jdd}|jdd}|jdd}g}|dkDr|jd|d n5|d kDr|jd |d n|dkDr|jd |d|dk\r|jd|dn,|dkDr|jd|dn|jd|dk7r|jd|d|dvr|jd|dk(r|jddj|S)z4Explain why this post is a strong video opportunity.r?rr@r rr 2u🔸 u upvotes — proven demandru📈 u upvotes — growing interest⬆️  upvotes💬 u0 comments — active thread, reply still visibleu1 replies — low competition for reply visibilityu2New thread — zero replies, first-mover advantageu 🎯 Direct z product fitrr u6📹 Visually demonstrable — perfect for short videoru/🛠️ Tool demo opportunity — show vs. tell · )r_rErv)rerfrir?r@r r reasonss rSgenerate_why_videors;hhy!$Gxx A&H}}Z3HmmIy1GG|wi'ABC 2wi'DEF 1 232~xj(XYZ Axj(YZ[KL)gYl;<''OP:HI ;;w rUc4 t|5}|j}ddddvsd|vr tdyt|}|s tdyg}|D]0\}}|D]&}t ||\}} |j |||| f(2|j dd |dd } | s td ytjjd } g} | j d | j d| j d| d| j d| j d| j dt| dD]\} \}}}} |jdd}|jdd}|jdd}|jdd}|jddjddj}t|d kDr|dd!d"z}d#|d$|}t||| }t!||| }| j d%| d&|d'|d(|d)|d*|d*|d+| j d,t#|d-d }|Dcgc]}|d.jdddkDs|}}|dd }|r-| j d/| j d| d| j d0| j d1| j d2t|dD]\} \}}}} |jdd}|jdd}|jdd}|jdd}|jddjddj}t|d kDr|dd!d"z}g}|d3k\r|j d4|d5n0|d6k\r|j d7|d8n|j d7|d9|d3kDr|j d#|d:n|d;kDr|j d#|d<| jd=d>}| jd?d>}|d>k7r|j d@|dA|dBvr|j dCdDj%|}t!||| }| j d%| d&|d'|d(|dE|d*|d*|d+| j d,dj%| }t|dF5}|j'|dddtdGt| dHy#1swYxYwcc}w#1swY4xYw)IzNProcess a single gaps report and append the Top 5 Video Opportunities section.Nu🎬 Top 5 Video Opportunitiesz Top 5 Videou> ⏭️ Already has video opportunities section — skippingFu% ⚠️ No subreddit sections foundc |dS)Nrr[xs rSzprocess_file..s adrUT)keyreverseu ⚠️ No posts to scorez%Y-%m-%d %H:%Mz --- u" ## 🎬 Top 5 Video Opportunitiesz **Auto-generated:** z ub**Source:** Gap post analysis — ranked by engagement × vertical relevance × visual potential zX | Rank | Subreddit | Post Title | Engagement | Why It's a Video Pick | Suggested Hook |zU|------|-----------|-----------|------------|----------------------|----------------|r7r9Untitledr?rr@r:#|z\|r6rsPMrtru | 💬 z| z | r/z | [z](z) | z | z |r=c,|djddS)Nr8r@r)r_rs rSrzprocess_file..sqtxx A/FrUr8u# ### 💬 Top 5 by Comment Activityua**Source:** Gap posts ranked by pure comment count — indicates active discussion & engagement zP | Rank | Subreddit | Post Title | Comments | Why It's Active | Suggested Hook |zN|------|-----------|-----------|----------|-----------------|----------------|ru💥 u comments — hot threadrru comments — active debateu comments — discussion growingu upvotes — high visibilityrrr rr u🎯 z opportunityru📹 Video-reply readyru ) | 💬 au ✅ Appended top z video opportunities)openreadprintrTrprEsortrnowstrftime enumerater_rIrJrurrsortedrvwrite)filepathfrKrLscoredrfpostsreroritop5 generatedlinesir9r?r@r: safe_titleengagement_strwhyhook by_commentsr top5_commentsrr r why_active section_texts rS process_filersi h1&&((72mw6N NP&w/H  57F$? 5 ?D)$ : E9 MM5)T9= > ??  KKNDK1 "1:D  +- ''(89I E LL7 LL68 LL))B78 LLuw LLln LLhj2;D!2Dm. .E9dI*-((9a(88J*hhuc"]]3.66tSAGGI z?R #CR50J"7)8H:> y)<T9i8 r!E)D Bse4GWWZ[^Z__bcgbhhjkl!m$ LL%FPTUK)IQqTXXj!-Dq-H1IKIOM ;= -i[;< xz hj eg6? q6Q" w 2A2y$ HHWj1Exx A.Hhhy!,G((5#&CsE2::4EKKMJ:#'_u4 G2~xj0HIJRxj0KLMxj0PQR| 1MNO2 :; }}Z;HmmIy9G)#wi|<=//78W-J y) ?@ q@Jhs#S<T 1T  T<TTcfttjdkDrtjddng}|s tdtjd|D]Y}t |}|j std|-td|jdtt|[y)Nr7zMUsage: python3 append_video_opps.py [gaps_report_2.md ...]u ❌ Not found: u📄 rt) rusysargvrexitrexistsnamerstr)filesfppaths rSmainrAsMA-CHHQRL2E  ]^   Bx{{} %bT* +  dii[$%SY  rU__main__)__doc__rCjsonosrrpathlibrrarbrTrprrrr__name__r[rUrSrs   sMRsMR s jQ  s jQ  s jQs jQs jQs jQs ~V#:*Us zRs {S  s9M!"s9M#&s R'(s R)*SkiX+, # R"YO"YO"9M"9M" iP" iP9@(T&:$EL @zx   zFrU