Ë
    hDýjJ  ã                   ó€   — d dl mZm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 d dlmZmZmZ d dlmZ  G d„ d	«      Zy
)é    )ÚOptionalÚSequence)ÚUUID)ÚselectÚand_Údelete)Úselectinload)ÚAsyncSession)ÚBotMessageTemplateÚBotMessageButtonÚBotMessageVersion)ÚButtonSchemac                   ó  — e Zd Zdefd„Z	 ddededee   dee	   fd„Z
	 dd	edee   dee	   fd
„Z	 	 ddedededee   dee	   f
d„Zde	de	fd„Zd	edee   ddfd„Z	 dde	dee   defd„Zd	edee   fd„Zd	ededee   fd„Zde	ddfd„Zy)ÚMessageStudioRepositoryÚdbc                 ó   — || _         y ©N)r   )Úselfr   s     ú8/root/telegram-saas/modules/message_studio/repository.pyÚ__init__z MessageStudioRepository.__init__   s	   € Øˆ�ó    NÚbot_idÚ	tenant_idÚlocaleÚreturnc              ƒ   ó  K  — t        t        «      j                  t        t        j                  «      «      j                  t        j                  |k(  t        j                  |k(  «      }|r"|j                  t        j                  |k(  «      }|j                  t        j                  t        j                  «      }| j                  j                  |«      ƒ d {  –—† }|j                  «       j                  «       S 7 Œ"­wr   )r   r   Úoptionsr	   ÚbuttonsÚwherer   r   r   Úorder_byÚmessage_keyr   ÚexecuteÚscalarsÚall)r   r   r   r   ÚstmtÚress         r   Úlist_by_botz#MessageStudioRepository.list_by_bot   s¾   è ø€ ô Ô%Ó&ß‰W”\Ô"4×"<Ñ"<Ó=Ó>ß‰UÜ"×)Ñ)¨VÑ3Ü"×,Ñ,°	Ñ9óð 	ñ Ø—:‘:Ô0×7Ñ7¸6ÑAÓBˆDØ�}‰}Ô/×;Ñ;Ô=O×=VÑ=VÓWˆØ—G‘G—O‘O DÓ)×)ˆØ�{‰{‹}× Ñ Ó"Ð"ð *ús   ‚CC?ÃC=Ã#C?Útemplate_idc              ƒ   óf  K  — t        t        «      j                  t        t        j                  «      «      j                  t        j                  |k(  «      }|r"|j                  t        j                  |k(  «      }| j                  j                  |«      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r   r   r	   r   r   Úidr   r   r"   Úscalar_one_or_none)r   r(   r   r%   r&   s        r   Ú	get_by_idz!MessageStudioRepository.get_by_id&   sŠ   è ø€ ô Ô%Ó&ß‰W”\Ô"4×"<Ñ"<Ó=Ó>ß‰UÔ%×(Ñ(¨KÑ7Ó8ð 	ñ
 Ø—:‘:Ô0×:Ñ:¸iÑGÓHˆDØ—G‘G—O‘O DÓ)×)ˆØ×%Ñ%Ó'Ð'ð *ús   ‚BB1ÂB/ÂB1r!   c              ƒ   ó®  K  — t        t        «      j                  t        t        j                  «      «      j                  t        j                  |k(  t        j                  |k(  t        j                  |k(  «      }|r"|j                  t        j                  |k(  «      }| j                  j                  |«      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r   r   r	   r   r   r   r!   r   r   r   r"   r+   )r   r   r!   r   r   r%   r&   s          r   Ú
get_by_keyz"MessageStudioRepository.get_by_key5   s¨   è ø€ ô Ô%Ó&ß‰W”\Ô"4×"<Ñ"<Ó=Ó>ß‰UÜ"×)Ñ)¨VÑ3Ü"×.Ñ.°+Ñ=Ü"×)Ñ)¨VÑ3óð 	ñ Ø—:‘:Ô0×:Ñ:¸iÑGÓHˆDØ—G‘G—O‘O DÓ)×)ˆØ×%Ñ%Ó'Ð'ð *ús   ‚B<CÂ>CÂ?CÚtemplatec              ƒ   óŒ   K  — | j                   j                  |«       | j                   j                  «       ƒ d {  –—†  |S 7 Œ­wr   )r   ÚaddÚflush©r   r/   s     r   Úcreate_templatez'MessageStudioRepository.create_templateJ   s3   è ø€ Ø�‰�‰�HÔØ�g‰g�m‰m‹o×ÐØˆð 	ús   ‚9A»A¼Ar   c           
   ƒ   óØ  K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      «      ƒ d {  –—†  |D ]k  }t        ||j                  |j                  |j                  |j                  |j                  |j                  ¬«      }| j                   j                  |«       Œm | j                   j                  «       ƒ d {  –—†  y 7 Œ—7 Œ­w)N)r(   ÚtextÚbutton_typeÚaction_valueÚrow_positionÚcolumn_positionÚ
sort_order)r   r"   r   r   r   r(   r6   r7   r8   r9   r:   r;   r1   r2   )r   r(   r   ÚbtnÚnew_btns        r   Úreplace_buttonsz'MessageStudioRepository.replace_buttonsO   sÂ   è ø€ ð
 �g‰g�o‰oÜÔ#Ó$×*Ñ*Ô+;×+GÑ+GÈ;Ñ+VÓWó
÷ 	
ð 	
ð ò 
	!ˆCÜ&Ø'Ø—X‘XØŸO™OØ ×-Ñ-Ø ×-Ñ-Ø #× 3Ñ 3ØŸ>™>ôˆGð �G‰G�K‰K˜Õ ð
	!ð �g‰g�m‰m‹o×Ñð	
øð 	ús%   ‚AC*ÁC&ÁBC*Ã C(Ã!C*Ã(C*Ú
updated_byc              ƒ   ób  K  — |j                   D �cg c]G  }|j                  |j                  |j                  |j                  |j
                  |j                  dœ‘ŒI }}|j                  |j                  |j                  |j                  |j                  |j                  |j                  |j                  |j                  |dœ
}t!        |j"                  |j$                  ||¬«      }| j&                  j)                  |«       | j&                  j+                  «       ƒ d {  –—†  |S c c}w 7 Œ­w)N)r6   r7   r8   r9   r:   r;   )
r!   ÚtitleÚmessage_textÚ
parse_modeÚ
media_typeÚmedia_file_idr   Ú	is_activeÚis_draftr   )r(   ÚversionÚsnapshot_jsonr?   )r   r6   r7   r8   r9   r:   r;   r!   rA   rB   rC   rD   rE   r   rF   rG   r   r*   Úcurrent_versionr   r1   r2   )r   r/   r?   ÚbÚbuttons_snapshotÚsnapshotÚversion_records          r   Úcreate_versionz&MessageStudioRepository.create_versiond   s  è ø€ ð ×%Ñ%ö

ð ð Ÿ™Ø Ÿ}™}Ø !§¡Ø !§¡Ø#$×#4Ñ#4ØŸl™lóð

Ðð 

ð $×/Ñ/Ø—^‘^Ø$×1Ñ1Ø"×-Ñ-Ø"×-Ñ-Ø%×3Ñ3Ø—o‘oØ!×+Ñ+Ø ×)Ñ)Ø'ñ
ˆô +Ø Ÿ™Ø×,Ñ,Ø"Ø!ô	
ˆð 	�‰�‰�NÔ#Ø�g‰g�m‰m‹o×ÐØÐùòC

ð@ 	ús   ‚D/‘AD(ÁCD/Ä!D-Ä"D/c              ƒ   óD  K  — t        t        «      j                  t        j                  |k(  «      j	                  t        j
                  j                  «       «      }| j                  j                  |«      ƒ d {  –—† }|j                  «       j                  «       S 7 Œ"­wr   )r   r   r   r(   r    rH   Údescr   r"   r#   r$   )r   r(   r%   r&   s       r   Úget_versionsz$MessageStudioRepository.get_versions�   su   è ø€ äÔ$Ó%ß‰UÔ$×0Ñ0°KÑ?Ó@ß‰XÔ'×/Ñ/×4Ñ4Ó6Ó7ð 	ð
 —G‘G—O‘O DÓ)×)ˆØ�{‰{‹}× Ñ Ó"Ð"ð *ús   ‚A9B Á;BÁ<#B rH   c              ƒ   óö   K  — t        t        «      j                  t        j                  |k(  t        j                  |k(  «      }| j
                  j                  |«      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r   r   r(   rH   r   r"   r+   )r   r(   rH   r%   r&   s        r   Úget_versionz#MessageStudioRepository.get_version–   sc   è ø€ ÜÔ'Ó(×.Ñ.Ü×)Ñ)¨[Ñ8Ü×%Ñ%¨Ñ0ó
ˆð —G‘G—O‘O DÓ)×)ˆØ×%Ñ%Ó'Ð'ð *ús   ‚A A9Á"A7Á#A9c              ƒ   óž   K  — | j                   j                  |«      ƒ d {  –—†  | j                   j                  «       ƒ d {  –—†  y 7 Œ'7 Œ­wr   )r   r   r2   r3   s     r   Údelete_templatez'MessageStudioRepository.delete_templatež   s8   è ø€ Ø�g‰g�n‰n˜XÓ&×&Ð&Ø�g‰g�m‰m‹o×Ñð 	'øØús!   ‚A¡A	¢!AÁAÁAÁAr   )ÚenN)Ú__name__Ú
__module__Ú__qualname__r
   r   r   r   Ústrr   r   r'   r,   r.   r4   Úlistr   r>   r   rO   rR   ÚintrT   rV   © r   r   r   r      sr  „ ð˜<ó ð !%ñ	#àð#ð ð#ð ˜‘ð	#ð
 
Ð$Ñ	%ó#ð. %)ñ(àð(ð ˜D‘>ð(ð 
Ð$Ñ	%ó	(ð& Ø$(ñ(àð(ð ð(ð ð	(ð
 ˜D‘>ð(ð 
Ð$Ñ	%ó(ð*Ð.@ð ÐEWó ð
àðð �lÑ#ðð 
ó	ð0 &*ñ'à$ð'ð ˜T‘Nð'ð 
ó	'ðR#¨dð #°xÐ@QÑ7Ró #ð(¨Tð (¸Cð (ÀHÐM^ÑD_ó (ðÐ.@ð ÀTô r   r   N)Útypingr   r   Úuuidr   Ú
sqlalchemyr   r   r   Úsqlalchemy.ormr	   Úsqlalchemy.ext.asyncior
   Úmodules.message_studio.modelsr   r   r   Úmodules.message_studio.schemasr   r   r^   r   r   ú<module>rf      s2   ðß %Ý ß +Ñ +Ý 'Ý /÷ñ õ
 8÷Rò Rr   