Ë
    µ_ýjß+  ã                   ó$  — d dl Z d dlmZ d dlZd dlmZmZ d dlmZ d dl	Z	d dl
mZ d dlmZmZmZ d dlmZ d dlmZmZ d d	lmZ d d
lmZmZmZmZmZmZmZmZ  ee «      Z! ee"«      jG                  «       jH                  dz  dz  Z% G d„ d«      Z&y)é    N)ÚPath)ÚOptionalÚSequence)ÚUUID)ÚAsyncSession)ÚNotFoundErrorÚAppExceptionÚValidationError)Ú
get_logger)ÚCustomEmojiÚ	EmojiPack)ÚCustomEmojiRepository)ÚBulkEmojiImportRequestÚBulkEmojiImportResponseÚCreateEmojiPackRequestÚEmojiValidationRequestÚEmojiValidationResponseÚEmojiPackResponseÚEmojiPackDetailResponseÚCustomEmojiResponseÚ	seed_datazcurated_emojis.jsonc                   ó@  — e Zd Zdefd„Z	 	 	 	 ddee   dee   dededee	   f
d	„Z
dee   fd
„Zeddededefd„«       Zeddededefd„«       Zededefd„«       Zdedefd„Zddededee   fd„Zdedefd„Zdedefd„Zdeddfd„Zdefd„Z	 ddedededefd„Z y)ÚEmojiServiceÚdbc                 ó2   — || _         t        |«      | _        y ©N)r   r   Úrepo)Úselfr   s     ú-/root/telegram-saas/modules/emojis/service.pyÚ__init__zEmojiService.__init__   s   € ØˆŒÜ)¨"Ó-ˆ�	ó    NÚqueryÚcategoryÚlimitÚoffsetÚreturnc              ƒ   ó\   K  — | j                   j                  ||||¬«      ƒ d {  –—† S 7 Œ­w)N)r"   r#   r$   r%   )r   Úsearch)r   r"   r#   r$   r%   s        r   r(   zEmojiService.search    s-   è ø€ ð —Y‘Y×%Ñ%¨E¸HÈEÐZ`Ð%Óa×aÐaÐaús   ‚#,¥*¦,c              ƒ   óR   K  — | j                   j                  «       ƒ d {  –—† S 7 Œ­wr   )r   Úget_categories)r   s    r   r*   zEmojiService.get_categories)   s   è ø€ Ø—Y‘Y×-Ñ-Ó/×/Ð/Ð/ús   ‚' %¡'Úcustom_emoji_idÚfallback_emojic                 ó   — d| › d|› d�S )z2Formats custom emoji for Telegram HTML parse mode.ú<tg-emoji emoji-id="ú">ú</tg-emoji>© ©r+   r,   s     r   Úformat_htmlzEmojiService.format_html,   s   € ð & oÐ%6°b¸Ð8HÈÐTÐTr!   c                 ó   — d|› d| › d�S )z8Formats custom emoji for Telegram MarkdownV2 parse mode.ú![ú](tg://emoji?id=ú)r1   r2   s     r   Úformat_markdownzEmojiService.format_markdown1   s   € ð �NÐ#Ð#3°OÐ3DÀAÐFÐFr!   Úreqc                 ó¾  — g }| j                   }d}| j                  r©| j                  j                  «       }t        j                  d|«      }t        j                  d|«      }|r'|j                  d«      }|j                  d«      xs d}n:|r'|j                  d«      xs d}|j                  d«      }n|j                  d«       |s|j                  d«       nH|j                  «       s|j                  d«       n&t        |«      }|d	k  s|d
k\  r|j                  d«       t        |«      d	k(  }|r	d|› d|› d�nd}	|r	d|› d|› d�nd}
t        ||r|nd||	|
|¬«      S )zž
        Validates Telegram custom emoji IDs and tags.
        Custom emoji IDs must be valid numeric strings representing a 64-bit unsigned integer.
        õ   âœ¨z/<tg-emoji\s+emoji-id="(\d+)">([^<]*)</tg-emoji>z'!\[([^\]]*)\]\(tg:\/\/emoji\?id=(\d+)\)é   é   z(Invalid Telegram custom emoji tag formatzMissing custom_emoji_idz(custom_emoji_id must be a numeric stringr   l            z>custom_emoji_id is out of range for a 64-bit Telegram emoji IDr.   r/   r0   Nr5   r6   r7   )Úis_validr+   r,   Úhtml_tagÚmarkdown_tagÚerrors)r+   Úformatted_tagÚstripÚrer(   ÚgroupÚappendÚisdigitÚintÚlenr   )r9   rA   Úemoji_idÚfallbackÚtagÚhtml_mÚmd_mÚvalr>   r?   Úmd_tags              r   Úvalidate_emojizEmojiService.validate_emoji6   sZ  € ð ˆØ×&Ñ&ˆØˆà×ÒØ×#Ñ#×)Ñ)Ó+ˆCä—Y‘YÐQÐSVÓWˆFä—9‘9ÐGÈÓMˆDáØ!Ÿ<™<¨›?�Ø!Ÿ<™<¨›?Ò3¨e‘ÙØŸ:™: a›=Ò1¨E�ØŸ:™: a›=‘à—‘ÐHÔIáØ�M‰MÐ3Õ4à×#Ñ#Ô%Ø—‘ÐHÕIä˜(“m�Ø˜!’8˜s eš|Ø—M‘MÐ"bÔcä�v“; !Ñ#ˆÙOWÐ)¨(¨°2°h°Z¸{ÑKÐ]aˆÙ?G�2�h�ZÐ/°¨z¸Ñ;ÈTˆä&ØÙ(0™H°dØ#ØØØô
ð 	
r!   c           	   ƒ   ó>  K  — d}d}d}g }i }|j                   D �]Ä  }|j                  j                  «       s2|dz  }|j                  d|j                  › d|j                  › d�«       ŒP|j
                  xs |j                  }d }	|rf||vr]| j                  j                  |j                  «       j                  dd«      ||j                  ¬«      ƒ d {  –—† }
|
j                  ||<   ||   }	| j                  j                  |j                  «      ƒ d {  –—† }|rb| j                  j                  |j                  |j                  |j                  |j                   |j                  |	¬	«      ƒ d {  –—†  |dz  }�Œe| j                  j                  |j                  |j                  |j                  |j                   |j                  |	¬	«      ƒ d {  –—†  |dz  }�ŒÇ | j"                  j%                  «       ƒ d {  –—†  t'        ||||¬
«      S 7 �Œ>7 Œÿ7 Œ¤7 ŒD7 Œ­w)Nr   r<   zSkipped z: ID 'z' is not numericú Ú_©ÚnameÚtitleÚis_animated©r+   rV   r,   r#   rX   Úpack_id)Úimported_countÚupdated_countÚerrors_countÚdetails)Úemojisr+   rG   rF   rV   Ú	pack_nameÚdefault_pack_namer   Úget_or_create_packÚlowerÚreplacerX   ÚidÚget_by_custom_emoji_idÚupsert_emojir,   r#   r   Úflushr   )r   r9   r[   r\   r]   r^   Úpacks_cacheÚitemr`   rZ   ÚpackÚexistings               r   Úbulk_importzEmojiService.bulk_importg   s  è ø€ ØˆØˆØˆØˆàˆà—J‘Jó )	$ˆDà×'Ñ'×/Ñ/Ô1Ø Ñ!�Ø—‘ ¨$¯)©)¨°F¸4×;OÑ;OÐ:PÐP`ÐaÔbØð Ÿ™Ò?¨#×*?Ñ*?ˆIØˆGÙØ KÑ/Ø!%§¡×!=Ñ!=Ø&Ÿ_™_Ó.×6Ñ6°s¸CÓ@Ø'Ø$(×$4Ñ$4ð ">ó "÷ �Dð
 .2¯W©W�K 	Ñ*Ø% iÑ0�ð "ŸY™Y×=Ñ=¸d×>RÑ>RÓS×SˆHÙØ—i‘i×,Ñ,Ø$(×$8Ñ$8ØŸ™Ø#'×#6Ñ#6Ø!Ÿ]™]Ø $× 0Ñ 0Ø#ð -ó ÷ ð ð  Ñ"’à—i‘i×,Ñ,Ø$(×$8Ñ$8ØŸ™Ø#'×#6Ñ#6Ø!Ÿ]™]Ø $× 0Ñ 0Ø#ð -ó ÷ ð ð  !Ñ#’ðS)	$ðV �g‰g�m‰m‹o×ÐÜ&Ø)Ø'Ø%Øô	
ð 	
ðAùð Tøðøðøð 	ús]   ‚CHÃHÃA HÄHÄAHÅ2HÅ3A!HÇHÇ)HÇ>HÇ?HÈHÈHÈHÈHc              ƒ   ó&  K  — | j                   j                  ||¬«      ƒ d {  –—† }|D ��cg c]S  \  }}t        |j                  |j                  |j
                  |j                  |j                  ||j                  ¬«      ‘ŒU c}}S 7 Œec c}}w ­w)N)r$   r%   ©re   rV   rW   rX   Úis_videoÚemojis_countÚ
created_at)	r   Ú
list_packsr   re   rV   rW   rX   rp   rr   )r   r$   r%   Ú	pack_rowsrk   Úcounts         r   rs   zEmojiService.list_packs¢   s„   è ø€ ØŸ)™)×.Ñ.°UÀ6Ð.ÓJ×Jˆ	ð  )÷
ñ ��eô Ø—7‘7Ø—Y‘YØ—j‘jØ ×,Ñ,ØŸ™Ø"ØŸ?™?öó
ð 	
ð Kúó
ùs!   ‚!B£B	¤	B­ABÂBÂBrZ   c              ƒ   ó   K  — | j                   j                  |«      ƒ d {  –—† }|st        d«      ‚| j                   j                  |«      ƒ d {  –—† }t	        |j
                  |j                  |j                  |j                  |j                  |D �cg c]  }t        j                  |«      ‘Œ c}|j                  ¬«      S 7 Œ£7 Œuc c}w ­w)NúEmoji pack not found)re   rV   rW   rX   rp   r_   rr   )r   Úget_pack_by_idr   Úget_pack_emojisr   re   rV   rW   rX   rp   r   Úmodel_validaterr   )r   rZ   rk   r_   Úes        r   Úget_pack_detailzEmojiService.get_pack_detail±   s§   è ø€ Ø—Y‘Y×-Ñ-¨gÓ6×6ˆÙÜÐ 6Ó7Ð7Ø—y‘y×0Ñ0°Ó9×9ˆÜ&Ø�w‰wØ—‘Ø—*‘*Ø×(Ñ(Ø—]‘]ØCIÖJ¸aÔ'×6Ñ6°qÕ9ÒJØ—‘ô
ð 	
ð	 7øð :úò Kùs4   ‚C¡C¢/CÁCÁACÂC	Â2CÃCÃ	Cc           	   ƒ   ó„  K  — | j                   j                  |j                  j                  «       j	                  dd«      |j
                  |j                  |j                  ¬«      ƒ d {  –—† }t        |j                  |j                  |j
                  |j                  |j                  d|j                  ¬«      S 7 ŒR­w)NrS   rT   ©rV   rW   rX   rp   r   ro   )r   Úcreate_packrV   rc   rd   rW   rX   rp   r   re   rr   )r   r9   rk   s      r   r   zEmojiService.create_packÀ   s—   è ø€ Ø—Y‘Y×*Ñ*Ø—‘—‘Ó!×)Ñ)¨#¨sÓ3Ø—)‘)ØŸ™Ø—\‘\ð	 +ó 
÷ 
ˆô !Ø�w‰wØ—‘Ø—*‘*Ø×(Ñ(Ø—]‘]ØØ—‘ô
ð 	
ð
ús   ‚A)C Á+B>Á,AC c              ƒ   óº   K  — | j                   j                  |«      ƒ d {  –—† }|st        d«      ‚| j                   j                  |«      ƒ d {  –—†  y 7 Œ57 Œ­w)Nrw   )r   rx   r   Údelete_pack)r   rZ   rk   s      r   r�   zEmojiService.delete_packÑ   sO   è ø€ Ø—Y‘Y×-Ñ-¨gÓ6×6ˆÙÜÐ 6Ó7Ð7Ø�i‰i×#Ñ# DÓ)×)Ñ)ð 7øð 	*ús!   ‚A¡A¢/AÁAÁAÁAc              ƒ   ó6  K  — | j                  d¬«      ƒ d{  –—† }t        |«      dk\  rt        |«      S t        j                  «       syt	        t        dd¬«      5 }t        j                  |«      }ddd«       j                  dg «      }d}| j                  j                  d	d
d¬«      ƒ d{  –—† }|D ]¥  }t        |j                  d«      «      }|j                  «       sŒ.| j                  j                  ||j                  dd«      |j                  dd«      |j                  dd«      |j                  dd«      |j                  ¬«      ƒ d{  –—†  |dz  }Œ§ | j                  j                  «       ƒ d{  –—†  |S 7 �Œk# 1 sw Y   �ŒxY w7 Œâ7 ŒA7 Œ­w)z]Seeds curated emojis from seed_data/curated_emojis.json if database has fewer than 10 emojis.é
   )r$   Nr   Úrzutf-8)Úencodingr_   Útelegram_curatedzCurated Premium EmojisTrU   r+   rV   zCustom EmojiÚemojir;   r#   ÚgeneralrX   rY   r<   )r(   rI   ÚSEED_DATA_FILEÚexistsÚopenÚjsonÚloadÚgetr   rb   ÚstrrG   rg   re   r   rh   )	r   rl   ÚfÚdataÚemojis_dataÚsyncedÚdefault_packr{   Úcids	            r   Úseed_default_emojisz EmojiService.seed_default_emojis×   s}  è ø€ àŸ™¨2˜Ó.×.ˆÜˆx‹=˜BÒÜ�x“=Ð ä×$Ñ$Ô&Øä”. #°Ô8ð 	 ¸AÜ—9‘9˜Q“<ˆD÷	 ð —h‘h˜x¨Ó,ˆØˆØ!ŸY™Y×9Ñ9Ø#Ø*Øð :ó 
÷ 
ˆð ò 	ˆAÜ�a—e‘eÐ-Ó.Ó/ˆCØ—;‘;”=ØØ—)‘)×(Ñ(Ø #Ø—U‘U˜6 >Ó2Ø Ÿu™u W¨eÓ4ØŸ™˜z¨9Ó5ØŸE™E -°Ó6Ø$Ÿ™ð )ó ÷ ð ð �a‰K‰Fð	ð �g‰g�m‰m‹o×ÐØˆðC /ù÷	 ñ 	 úð

øðøð 	úsY   ‚F˜F™AFÁFÁ3=FÂ0FÂ1B"FÅFÅ(FÅ<FÅ=FÆFÆ	FÆFÆFr`   Ú	bot_tokenc           	   ƒ   ó  K  — d|› d�}t        j                  d¬«      4 ƒd{  –—† }|j                  |d|i¬«      ƒ d{  –—† }|j                  «       }ddd«      ƒd{  –—†  j                  d«      s"|j                  d	d
«      }t	        d|› �d¬«      ‚|j                  di «      }	|	j                  d|«      }
|	j                  dd«      }|	j                  dd«      }|	j                  dg «      }| j
                  j                  ||
||¬«      ƒ d{  –—† }d}t        |«      D ]v  \  }}|j                  d«      }|sŒ|j                  dd«      }|
› d|dz   › �}| j
                  j                  t        |«      |||||j                  ¬«      ƒ d{  –—†  |dz  }Œx | j                  j                  «       ƒ d{  –—†  t        j                  d||¬«       ||
||dœS 7 �Œ½7 �Œ£7 �Œ†# 1 ƒd{  –—†7  sw Y   �Œ—xY w7 Œê7 Œm7 ŒF­w) z‹
        Fetches an emoji pack from Telegram Bot API via getStickerSet
        and syncs all custom_emoji_id values into database.
        zhttps://api.telegram.org/botz/getStickerSetg      .@)ÚtimeoutNrV   )ÚparamsÚokÚdescriptionzFailed to retrieve sticker setzTelegram API Error: i�  )Ústatus_codeÚresultrW   rX   Trp   FÚstickersr~   r   r+   r‡   r;   z #r<   rY   Úcustom_emoji_pack_synced)r`   Úsynced_count)r`   rW   rX   Úsynced_emojis_count)ÚhttpxÚAsyncClientrŽ   rŒ   r	   r   rb   Ú	enumeraterg   r�   re   r   ÚcommitÚloggerÚinfo)r   r`   r—   r#   ÚurlÚclientÚrespr‘   Úerr_descrž   Ú
pack_titlerX   rp   rŸ   rk   r¡   ÚidxÚstickerÚ	custom_idrK   rV   s                        r   Úsync_pack_from_telegramz$EmojiService.sync_pack_from_telegramý   s'  è ø€ ð -¨Y¨K°~ÐFˆÜ×$Ñ$¨TÔ2÷ 	ð 	°fØŸ™ C°¸Ð0C˜ÓD×DˆDØ—9‘9“;ˆD÷	÷ 	ð �x‰x˜Œ~Ø—x‘x Ð/OÓPˆHÜÐ!5°h°ZÐ@ÈcÔRÐRà—‘˜( BÓ'ˆØ—Z‘Z ¨Ó3ˆ
Ø—j‘j °Ó5ˆØ—:‘:˜j¨%Ó0ˆØ—:‘:˜j¨"Ó-ˆð —Y‘Y×1Ñ1ØØØ#Øð	 2ó 
÷ 
ˆð ˆÜ% hÓ/ò 	‰LˆC�ØŸ™Ð$5Ó6ˆIÙØà—{‘{ 7¨EÓ2ˆHØ �\  C¨!¡G 9Ð-ˆDØ—)‘)×(Ñ(Ü # I£ØØ'Ø!Ø'ØŸ™ð )ó ÷ ð ð ˜AÑ‰Lð	ð" �g‰g�n‰nÓ×ÐÜ�‰Ø&ØØ%ð 	ô 	
ð #ØØ&Ø#/ñ	
ð 	
ð_	ùØDùð	ù÷ 	÷ 	ò 	úð
øðøð 	úsˆ   ‚!H£G ¤H§G)Á G#ÁG)ÁHÁ G&Á!B3HÄG?ÄA>HÆHÆ(HÆ<HÆ=$HÇ#G)Ç&HÇ)G<Ç/G2Ç0G<Ç7	HÈHÈH)NNé2   r   )r;   )r²   r   )rˆ   )!Ú__name__Ú
__module__Ú__qualname__r   r    r   r�   rH   r   r   r(   r*   Ústaticmethodr3   r8   r   r   rQ   r   r   rm   Úlistr   rs   r   r   r|   r   r   r�   r–   Údictr±   r1   r!   r   r   r      s¤  „ ð.˜<ó .ð  $Ø"&ØØñbà˜‰}ðbð ˜3‘-ðbð ð	bð
 ðbð 
�+Ñ	óbð0 h¨s¡mó 0ð ñU Sð U¸#ð UÈ#ò Uó ðUð ñG¨ð G¸cð GÈcò Gó ðGð ð.
Ð2ð .
Ð7Nò .
ó ð.
ð`9
Ð%;ð 9
Ð@Wó 9
ñv
 cð 
¸ð 
ÀDÐIZÑD[ó 
ð
¨Tð 
Ð6Mó 
ð
Ð%;ð 
Ð@Qó 
ð"*¨ð *°$ó *ð#¨3ó #ðT "ñ	?
àð?
ð ð?
ð ð	?
ð
 
ô?
r!   r   )'rŒ   Úpathlibr   rD   Útypingr   r   Úuuidr   r£   Úsqlalchemy.ext.asyncior   Úcore.exceptionsr   r	   r
   Úcore.loggingr   Úmodules.emojis.modelsr   r   Úmodules.emojis.repositoryr   Úmodules.emojis.schemasr   r   r   r   r   r   r   r   r³   r§   Ú__file__ÚresolveÚparentr‰   r   r1   r!   r   ú<module>rÅ      ss   ðÛ Ý Û 	ß %Ý Û Ý /ß HÑ HÝ #ß 8Ý ;÷	÷ 	ó 	ñ 
�HÓ	€Ù�h“×'Ñ'Ó)×0Ñ0°;Ñ>ÐAVÑV€÷a
ò a
r!   