Ë
    ¼vëjn  ã                  óÌ   — d Z ddlmZ ddlmZmZ ddlmZmZm	Z	m
Z
 h d£ZdZe G d„ d«      «       Ze G d	„ d
«      «       ZdZdd„Zdd„Zdd„Zdd„Zdd„Zddd„Zddd„Zdd„Zy)aJ  One view of an organisation's brand for every product: the BrandForge analysis in the tenant's schema (logo,
colours, fonts, voice) and the products the account holds. Each fact says where it came from. Nothing is guessed:
an account that never ran BrandForge gets an empty brand, and a renderer draws its no-logo, no-accent form.é    )Úannotations)Ú	dataclassÚfield)ÚAnyÚDictÚListÚOptional>   úui-serifú	system-uiú
sans-serifúui-sans-serifÚserifÚcursiveÚfantasyÚ	monospace)ÚheadingÚtextÚbuttonc                  ól   — e Zd ZU ded<   dZded<   dZded<   dZded<   dZded<   dZded	<   d
Z	ded<   y)ÚProductÚstrÚnameNúOptional[str]ÚurlÚimageÚpriceÚcurrencyÚdescriptionÚ	catalogueÚsource)
Ú__name__Ú
__module__Ú__qualname__Ú__annotations__r   r   r   r   r   r    © ó    ú^/var/www/html/strategist-ai/venv/lib/python3.12/site-packages/galaxiq_utils/templates/brand.pyr   r      sC   … à
ƒIØ€CˆÓØ€Eˆ=ÓØ€Eˆ=ÓØ"€HˆmÓ"Ø!%€K�Ó%Ø€FˆCÔr&   r   c                  ó  — e Zd ZU dZded<   dZded<   dZded<   dZded<    ee	¬«      Z
ded	<    ee¬«      Zd
ed<   dZded<    ee	¬«      Zded<    ee	¬«      Zded<    ee	¬«      Zded<   dZded<    ee¬«      Zd
ed<   dd„Zy)ÚBrandNr   r   ÚlogoÚprimaryÚaccent)Údefault_factoryz	List[str]ÚpaletteúDict[str, str]ÚfontsÚsummaryÚtoneúList[Product]ÚproductsúList[Dict[str, str]]ÚsocialÚaddressÚsourcesc                ó  — | j                   | j                  | j                  | j                  | j                  xs d| j
                  xs d| j                  dœ}|j                  «       D ��ci c]  \  }}|sŒ	||“Œ c}}S c c}}w )zThe brand as template values.N)z
brand.namez
brand.logozbrand.primaryzbrand.accentzbrand.fontszbrand.socialzbrand.address)r   r*   r+   r,   r0   r6   r7   Úitems)ÚselfÚoutÚkÚvs       r'   ÚvalueszBrand.values'   sm   € à!ŸY™Y°d·i±iÐRV×R^ÑR^Ø#Ÿ{™{¸4¿:¹:Ò;MÈÐ_c×_jÑ_jÒ_rÐnrØ $§¡ñ.ˆð "%§¡£×2™˜˜A²��1‘Ó2Ð2ùÓ2s   Á,
B Á7B )ÚreturnzDict[str, Any])r!   r"   r#   r   r$   r*   r+   r,   r   Úlistr.   Údictr0   r1   r2   r4   r6   r7   r8   r?   r%   r&   r'   r)   r)      sž   … à€Dˆ-ÓØ€Dˆ-ÓØ!€Gˆ]Ó!Ø €FˆMÓ Ù¨tÔ4€GˆYÓ4Ù!°$Ô7€Eˆ>Ó7Ø!€Gˆ]Ó!Ù¨DÔ1€Dˆ)Ó1Ù#°DÔ9€HˆmÓ9Ù#(¸Ô#>€FÐ Ó>Ø!€Gˆ]Ó!Ù#°DÔ9€Gˆ^Ó9ô3r&   r)   )zinstagram.comzfacebook.comzlinkedin.comzx.comztwitter.comzyoutube.comz
tiktok.comzpinterest.comc                ó  ‡— i }| j                  d«      xs g D ]Å  }t        |t        «      r|j                  d«      n|}t        |t        «      sŒ7|j	                  dd«      d   j	                  dd«      d   j                  «       j                  d«      Št        ˆfd	„t        D «       d
«      }|sŒ˜||vsŒ�|j                  d«      j                  d«      dk\  sŒÁ|||<   ŒÇ |j                  «       D ��cg c]
  \  }}||dœ‘Œ c}}S c c}}w )zPThe site's own social links, one per network, from the links BrandForge crawled.Úlinksr   z//é   éÿÿÿÿú/r   zwww.c              3  óz   •K  — | ]2  }‰|k(  s‰j                  d |z   «      sŒ|j                  d «      d   –— Œ4 y­w)ú.r   N)ÚendswithÚsplit)Ú.0ÚhÚhosts     €r'   ú	<genexpr>zsocial_from.<locals>.<genexpr>:   s5   øè ø€ Òe¨AÀÈÂÈdÏmÉmÐ\_ÐbcÑ\cÕNd˜Ÿ™ › Q�Ñeùs   ƒ;¢;Né   )r   r   )ÚgetÚ
isinstancerB   r   rK   ÚlowerÚremoveprefixÚnextÚSOCIAL_HOSTSÚrstripÚcountr:   )ÚrawÚfoundÚlinkr   ÚnetworkÚnÚurN   s          @r'   Úsocial_fromr_   2   sê   ø€ à€EØ—‘˜Ó Ò& Bò !ˆÜ!+¨D´$Ô!7ˆd�h‰h�uŒo¸TˆÜ˜#œsÔ#ØØ�y‰y˜˜qÓ! "Ñ%×+Ñ+¨C°Ó3°AÑ6×<Ñ<Ó>×KÑKÈFÓSˆÜÓe´ÔeÐgkÓlˆÚ�w eÒ+°·
±
¸3³×0EÑ0EÀcÓ0JÈaÓ0OØ ˆE�'ŠNð!ð /4¯k©k«m×<¡d a¨�Q˜qÓ!Ó<Ð<ùÓ<s   Ã4Dc                ób   — | j                  «       t        v r| S d| j                  dd«      z   dz   S )Nú"Ú )rS   ÚGENERICÚreplace)Úfamilys    r'   Ú_quotedrf   @   s0   € Ø—\‘\“^¤wÑ.ˆ6ÐW°C¸&¿.¹.ÈÈbÓ:QÑ4QÐTWÑ4WÐWr&   c                ó*  — t        | xs i j                  d«      xs d«      j                  «       }|sy|g| j                  d«      xs g D �cg c]R  }t        |«      j                  «       sŒt        |«      j                  «       |k7  sŒ:t        |«      j                  «       ‘ŒT c}z   }t        d„ |D «       «      s=| j                  d«      xs t	        d„ |xs g D «       d«      }|r|j                  |«       dj                  d	„ |D «       «      S c c}w )
zÍThe CSS stack for one measured role: the family really drawn, the site's own fallbacks, the generic keyword
    the site ends its stacks with. A monospace on the page (code blocks) never ends a text stack.re   rb   NÚstackc              3  óH   K  — | ]  }|j                  «       t        v –— Œ y ­w©N)rS   rc   ©rL   r]   s     r'   rO   zstack_for.<locals>.<genexpr>K   s   è ø€ Ò3¨ˆq�w‰w‹yœGÔ#Ñ3ùs   ‚ "Úfallbackc              3  óü   K  — | ]t  }t        |«      j                  «       j                  «       t        v rEt        |«      j                  «       j                  «       d k7  rt        |«      j                  «       –— Œv y­w)r   N)r   ÚstriprS   rc   )rL   Úfs     r'   rO   zstack_for.<locals>.<genexpr>L   sh   è ø€ ò 3CÀaÜ69¸!³f·l±l³n×6JÑ6JÓ6LÔPWÑ6WÔ\_Ð`aÓ\b×\hÑ\hÓ\j×\pÑ\pÓ\rð  wBò  ]Bô 47°q³6·<±<·>ñ 3Cùs   ‚A:A<z, c              3  ó2   K  — | ]  }t        |«      –— Œ y ­wrj   )rf   rk   s     r'   rO   zstack_for.<locals>.<genexpr>P   s   è ø€ Ò/ A”W˜Q—ZÑ/ùs   ‚)r   rQ   rn   ÚanyrU   ÚappendÚjoin)ÚmeasuredÚ
site_fontsre   ro   ÚnamesÚendings         r'   Ú	stack_forrx   D   sù   € ô �(’.˜b×%Ñ% hÓ/Ò5°2Ó6×<Ñ<Ó>€FÙØØˆH°·±¸gÓ1FÒ1LÈ"Ö}¨1ÔQTÐUVÓQW×Q]ÑQ]ÕQ_ÔdgÐhiÓdj×dpÑdpÓdrÐv|Ód|œ˜A›Ÿ™�Ò}Ñ}€EÜÑ3¨UÔ3Ô3Ø—‘˜jÓ)ò J¬Tñ 3CÈ:ÒK[ÐY[ô 3Cð EIó.JˆáØ�L‰L˜Ô Ø�9‰9Ñ/¨Ô/Ó/Ð/ùò ~s   ÁDÁ,DÂ	Dc                óx  — | xs i j                  d«      xs i }| xs i j                  d«      xs i }|j                  d«      xs( |j                  d«      xs i j                  d«      xs i }|j                  d«      xs i j                  d«      xsC |j                  d«      xs g D �cg c]$  }t        |t        «      sŒ|j                  d«      ‘Œ& c}}t        D �ci c]#  }t	        |j                  |«      |«      x}sŒ!||“Œ% }}|si S t        D ]6  }|j                  ||j                  d«      xs |j                  d«      «       Œ8 d	D ]_  }t        |j                  |«      xs |j                  d«      xs i j                  d
«      xs d«      }	|	j                  «       sŒX|	||› d�<   Œa |S c c}w c c}w )NÚfull_resultÚraw_extractionÚ
typographyÚcomputed_stylesr0   re   r   r   )r   r   Úweightrb   Ú_weight)rQ   rR   rB   ÚROLESrx   Ú
setdefaultr   Úisdigit)
ÚrowÚfullrY   r|   ro   ru   Úrolerh   r0   r~   s
             r'   Ú
fonts_fromr†   S   s½  € ØŠI�2�?‰?˜=Ó)Ò/¨R€DØŠ9�"�/‰/Ð*Ó
+Ò
1¨r€CØ—‘˜,Ó'Òg¨S¯W©WÐ5FÓ-GÒ-MÈ2×,RÑ,RÐS_Ó,`ÒgÐeg€JØ—7‘7Ð,Ó-Ò3°×8Ñ8¸ÓAò  PÐ`d×`hÑ`hÐipÓ`qÒ`wÐuwö  GPÐ[\ô  |Fð  GHô  JNõ  |OÀqÇuÁuÈXÅò  GP€JÜ%*Öe˜T¼	À*Ç.Á.ÐQUÓBVÐXbÓ8cÐ/c¨uÑ/cˆT�5‰[Ðe€EÐeÙØˆ	Üò JˆØ×Ñ˜˜uŸy™y¨Ó0ÒH°E·I±I¸iÓ4HÕIðJà%ò -ˆÜ�j—n‘n TÓ*ÒJ¨j¯n©n¸VÓ.DÒJÈ×OÑOÐPXÓYÒ_Ð]_Ó`ˆØ�>‰>ÕØ&,ˆE�T�F˜'Ð"Ò#ð-ð €Lùò GPùÚes   Â+F2ÃF2Ã"F7ÄF7c                ó  ‡— | s
t        «       S | j                  d«      xs i }| j                  d«      xs i }|j                  d«      xs i j                  d«      xs g Šˆfd„}|j                  d«      xs g D �cg c]  }t        |«      ‘Œ }} |d«      xs i j                  d«      xs	 |r|d	   nd
} |d«      xs i j                  d«      xs t        |«      dkD  r|d   nd
}|j                  d«      xs g }t	        d„ |D «       d
«      xs |r|d	   j                  d«      nd
}	|j                  d«      }
t        |
t        «      r|
j                  d«      n|
}
| j                  d«      }|s3t        |j                  d«      t        «      r|d   j                  d«      }|j                  d«      }t        |t        «      r|n3t        |t        «      r"t        |xs i j                  d«      xs g «      ng }t        ||	|||t        | «      |
|D �cg c]  }t        |«      ‘Œ c}t        |«      ¬«	      }|j                  «       j                  «       D ��ci c]  \  }}|sŒ	|d“Œ c}}|_        |S c c}w c c}w c c}}w )zkA Brand from a BrandForge analysis row (brand_name, full_result, raw_extraction). Empty when there is none.rz   r{   Úcolorsr.   c                ó6   •‡ — t        ˆ fd„‰D «       d„ d ¬«      S )Nc              3  óL   •K  — | ]  }|j                  d «      ‰k(  sŒ|–— Œ y­w)r…   N©rQ   )rL   Úpr…   s     €r'   rO   z/brand_from.<locals>.<lambda>.<locals>.<genexpr>k   s    øè ø€ ÒI 1°1·5±5¸³=ÀDÓ3HœQÑIùs   ƒ$�$c                ó&   — | j                  dd«      S )NÚscorer   r‹   )rŒ   s    r'   ú<lambda>z.brand_from.<locals>.<lambda>.<locals>.<lambda>k   s   € ÐYZ×Y^ÑY^Ð_fÐhiÓYj€ r&   )ÚkeyÚdefault)Úmax)r…   r.   s   `€r'   r�   zbrand_from.<locals>.<lambda>k   s   ù€ œÓI¨ÔIÑOjÐtxÔy€ r&   Ú
ui_paletter+   Úhexr   Nr,   rE   Úlogo_candidatesc              3  ó†   K  — | ]9  }|j                  d «      sŒ|j                  d«      sŒ'|j                  d«      –— Œ; y­w)Ú	is_headerr   Nr‹   )rL   Úcs     r'   rO   zbrand_from.<locals>.<genexpr>p   s-   è ø€ ÒT !°·±°kÕ0BÀqÇuÁuÈUÅ|�—‘�u—ÑTùs   ‚A™A«Ar   Úbrand_summaryr1   Ú
brand_nameÚbrandr   r2   Údescriptors)	r   r*   r+   r,   r.   r0   r1   r2   r6   Ú
brandforge)r)   rQ   r   ÚlenrU   rR   rB   rA   r†   r_   r?   r:   r8   )rƒ   r„   rY   Úbestr˜   Úuir+   r,   Úlogosr*   r1   r   r2   Útr›   r=   r>   r.   s                    @r'   Ú
brand_fromr£   d   s>  ø€ áÜ‹wˆØ�7‰7�=Ó!Ò' R€DØ
�'‰'Ð"Ó
#Ò
) r€CØ�x‰x˜Ó!Ò' R×,Ñ,¨YÓ7Ò=¸2€GÛy€DØŸ8™8 LÓ1Ò7°RÖ	9�QŒ#ˆa�&Ð	9€BÐ	9Ù�I‹Ò$ "×)Ñ)¨%Ó0ÒK¹b°R¸²UÀd€GÙ�8‹nÒ" ×'Ñ'¨Ó.ÒR¼CÀ»GÀaºK°2°a²5ÈT€FØ�G‰GÐ%Ó&Ò,¨"€EÜÑT uÔTÐVZÓ[ò  HÑw|Ð`eÐfgÑ`h×`lÑ`lÐmrÔ`sð  CG€DØ�h‰h�Ó'€GÜ(2°7¼DÔ(Aˆg�k‰k˜)Ô$Àw€GØ�7‰7�<Ó €DÙ”J˜tŸx™x¨Ó0´$Ô7Ø�G‰}× Ñ  Ó(ˆØ�8‰8�FÓ€DÜ˜d¤DÔ)‰4Ô^hÐimÔosÔ^t¬t°T²Z¸R×4DÑ4DÀ]Ó4SÒ4YÐWYÔ/ZÐz|€DÜ�t $°ÀÐPRÔZdÐehÓZiÐszØ(,Ö- 1œ˜A�Ò-´kÀ#Ó6FôH€Eà16·±³×1EÑ1EÓ1G×M©¨¨AÊ1�Q˜‘_ÓM€E„MØ€Lùò 
:ùò .ùÛMs   Á<I4ÈI9É
I>É$I>c                óÔ   — d}t        | |d«      r:| j                  d|› d�«      j                  «       }|rt        t	        d|«      «      }t        |«      }|rt        | |«      |_        |S )z¦The organisation's brand from its schema: the newest BrandForge analysis, and its product catalogue when it
    holds one. A schema with neither gives an empty Brand.NÚbrandforge_analysesz:SELECT brand_name, url, full_result, raw_extraction FROM "zA".brandforge_analyses ORDER BY created_at DESC NULLS LAST LIMIT 1)rš   r   rz   r{   )Ú_existsÚexecuteÚfetchonerB   Úzipr£   Úread_productsr4   )ÚconnÚschemar4   rƒ   Úgotr›   s         r'   Ú
read_brandr®   ~   sz   € ð €CÜˆt�VÐ2Ô3Ø�l‰lÐWÐX^ÐW_ð `Ið Ió JßJRÉ(Ë*ð 	áÜ”sÐQÐSVÓWÓXˆCÜ�s‹O€EÙÜ& t¨VÓ4ˆŒØ€Lr&   c                óÞ   — t        | |d«      sg S | j                  d|› dt        |«      › �«      j                  «       }|D ����cg c]  \  }}}}t	        ||||d¬«      ‘Œ c}}}}S c c}}}}w )zYThe account's products as its catalogue states them (Aivora's strategist_products today).Ústrategist_productsz7SELECT name, description, image_url, product_url FROM "zI".strategist_products WHERE coalesce(name, '') <> '' ORDER BY name LIMIT r   )r   r   r   r   r    )r¦   r§   ÚintÚfetchallr   )r«   r¬   ÚlimitÚrowsr]   ÚdÚir^   s           r'   rª   rª   �   s€   € ä�4˜Ð!6Ô7Øˆ	Ø�<‰<ÐQÐRXÐQYð ZNÜNQÐRWËjÈ\ð[ó \ß\dÑ\dÓ\fð 	àae×fÑfÑS]ÐSTÐVWÐYZÐ\]ŒG˜¨°¸À+ÖNÕfÐfùÕfs   ÁA'
c                óJ   — | j                  d||f«      j                  «       d uS )NzSSELECT 1 FROM information_schema.tables WHERE table_schema = %s AND table_name = %s)r§   r¨   )r«   r¬   Útables      r'   r¦   r¦   –   s-   € Ø�<‰<ÐmØ ˜ó)ß)1©«¸4ð@ð @r&   N)rY   rB   r@   r5   )re   r   r@   r   )rt   rB   ru   rA   r@   r   )rƒ   rB   r@   r/   )rƒ   zOptional[dict]r@   r)   )T)r¬   r   r4   Úboolr@   r)   )é2   )r¬   r   r³   r±   r@   r3   )r¬   r   r¸   r   r@   r¹   )Ú__doc__Ú
__future__r   Údataclassesr   r   Útypingr   r   r   r	   rc   r€   r   r)   rV   r_   rf   rx   r†   r£   r®   rª   r¦   r%   r&   r'   ú<module>r¿      sˆ   ðñoõ #ç (ß ,Ó ,â
n€Ø%€ð ÷ð ó ðð ÷3ð 3ó ð3ð, G€ó=óXó0óó"ô4ôgô@r&   