+
    ‚°ñjv6  ã                   óž  € R t ^ RIt^ RIt^ RIt^ RIHt ^ RIHt ^ RIH	t	H
t
Ht ^ RIt^ RIHtHtHt ^ RIHtHtHtHt ^ RIHtHtHtHtHt ^ RIHtHtHt ^ R	I H!t! ^ R
I"H#t#H$t$H%t%H&t&H't'H(t( ^ RI)H*t*H+t+ R R lt,R R lt-R R lt.R(R R llt/R R lt0R R lt1R R lt2R R lt3R R lt4R R lt5R  R! lt6R)R" R# llt7R$ R% lt8R& R' lt9R# )*aZ  Serves the per-asset operations behind the API: reading an asset's detail,
updating its name, tags, metadata and preview, deleting a record, resolving
a hash to a servable path, and looking up the files an export zips. Name and
tag updates move ``updated_at`` only when the requested values differ. Other
supplied metadata fields record a write.
N)ÚPath)ÚSequence)ÚdeleteÚselectÚupdate)ÚAssetÚAssetContentÚAssetTag)Údelete_recordÚfetch_record_tagsÚget_record_by_idÚupdate_record_access_time)Úbump_record_updated_atÚ
ensure_tagÚensure_tag_linkÚget_preview_file_paths_by_idsÚrename_record)Úget_utc_nowÚnormalize_tagsÚvalidate_blake3_hash)Úlookup_for_view)Ú	AssetDataÚAssetDetailResultÚDownloadResolutionResultÚExportableAssetFileÚReferenceDataÚUserMetadata)Úcreate_sessionÚcreate_write_sessionc                ó$   € V ^8„  d   QhR\         /# )é   Úreturn)r   )Úformats   "ÚHC:\Ai_Coding\apps\studio\ComfyUI\app\assets\services\asset_management.pyÚ__annotate__r$   -   s   € ÷ >ñ >Ô1Bñ >ó    c                 ób  € V P                  \        VP                  4      p\        WP                  4      pV'       d   VP
                  MR p\        VP                  VP                  V'       d   VP                  MR VP                  VP                  VP                  VP                  VP                  VP                  VP                  VP                   R7      p\#        TV'       d   VP$                  MR VP&                  \)        T;'       d    VP*                  4      R7      p\-        WVVR7      # )N)ÚidÚnameÚ	file_pathÚloader_pathÚuser_metadataÚ
preview_idÚsystem_metadataÚjob_idÚ
created_atÚ
updated_atÚlast_access_time)ÚhashÚ
size_bytesÚ	mime_typeÚ
is_missing)ÚrefÚassetÚtags)Úgetr   Ú
content_idr   r'   r2   r   r(   Úpathr*   r+   r,   r-   r.   r/   r0   r1   r   r3   r4   Úboolr5   r   )ÚsessionÚrecordÚcontentr8   Úapi_hashr6   r7   s   &&     r#   Ú_record_to_detail_resultrA   -   sæ   € Ø�k‰kœ,¨×(9Ñ(9Ó:€GÜ˜W§i¡iÓ0€Dß&ˆw�|Š|¨D€HÜ
Ø�9‰9Ø�[‰[ß")�'—,’,¨tØ×&Ñ&Ø×*Ñ*Ø×$Ñ$Ø×.Ñ.Ø�}‰}Ø×$Ñ$Ø×$Ñ$Ø×0Ñ0ô€Cô Øß)0�7×%Ò%°dØ×"Ñ"Ü˜×6Ð6 G×$6Ñ$6Ó7ô	€Eô  ¸Ô=Ð=r%   c                ó>   € V ^8„  d   QhR\         R\        R,          /# )r    Úreference_idr!   N)Ústrr   )r"   s   "r#   r$   r$   G   s!   € ÷ 9ñ 9Üð9ä˜Õñ9r%   c                 ó®   € \        4       ;_uu_ 4       p\        W4      pVf    R R R 4       R # \        W4      uuR R R 4       #   + '       g   i     R # ; i)N)r   r   rA   )rC   r=   r>   s   &  r#   Úget_asset_detailrF   G   sB   € ô 
×	Ô	˜WÜ! 'Ó8ˆØŠ>Ø÷ 
Ñ	ô (¨Ó8÷	 
×	×	Ó	ús   “A®
AÁA	c                óF   € V ^8„  d   QhR\         R\        \         ,          /# ©r    rC   r!   )rD   Úset)r"   s   "r#   r$   r$   Q   s   € ÷ ñ ¬cð ´c¼#µhñ r%   c           	      óÈ   € \        V P                  \        \        P                  4      P                  \        P                  V8H  \        P                  R 8g  4      4      4      # )Ú	automatic)rI   Úscalarsr   r	   Útag_nameÚwhereÚasset_idÚorigin)r=   rC   s   &&r#   Ú_fetch_manual_tagsrQ   Q   sN   € ÜØ�‰Ü”8×$Ñ$Ó%×+Ñ+Ü×!Ñ! \Ñ1Ü—‘ ;Ñ.óó	
óð r%   c                óÆ   € V ^8„  d   QhR\         R\         R,          R\        \         ,          R,          R\        R\         R\         R,          R\         R,          R	\        /# )
r    rC   r(   Nr8   r+   Ú
tag_originr4   r,   r!   )rD   r   r   r   )r"   s   "r#   r$   r$   \   sw   € ÷ Eñ EÜðEä
��*ðEô ”3�-˜$Õ
ðEô  ð	Eô
 ðEô �T�zðEô �d•
ðEô ñEr%   c           
      óš  € \        4       ;_uu_ 4       p\        Wp4      pVf   \        RV  R24      hVP                  p	Ve   \	        WpV4       Vea   VP                  \        \        4      P                  \        P                  V 8H  4      P                  \        V4      \        4       R7      4       \        4       p
Ve\   \        Wp4      p
VP                  \        \         4      P                  \         P"                  V 8H  \         P$                  R8g  4      4       VeX   VP                  \        \        4      P                  \        P                  V 8H  4      P                  V\        4       R7      4       Ve©   VP'                  \        V4      f   \        RV: R24      hVP                  \        \        4      P                  \        P                  V 8H  4      P                  V\        4       R7      4       V	'       d"   W–8w  d   VP)                  4        \+        Wy4       Vea   \-        \/        V4      4       F  p\1        W{4       \3        VV VVR	7       K  	  VP)                  4        \        Wp4      V
8w  d   \5        Wp4       VP7                  4        R R R 4       \9        V 4      pVf   \;        R
4      hV#   + '       g   i     L,; i)NzAsset ú
 not found)r+   r0   rK   )r4   r0   zpreview_id z% does not reference an existing asset)r,   r0   )rO   rM   rP   zAsset deleted during update)r   r   Ú
ValueErrorr,   r   Úexecuter   r   rN   r'   ÚvaluesÚdictr   rI   rQ   r   r	   rO   rP   r9   ÚflushÚreclaim_previewr   Úlistr   r   r   ÚcommitrF   ÚRuntimeError)rC   r(   r8   r+   rS   r4   r,   r=   r>   Úreplaced_preview_idÚmanual_tags_beforerM   Údetails   &&&&&&&      r#   Úupdate_asset_metadatarb   \   s;  € ô 
×	Ô	 7Ü! 'Ó8ˆØŠ>Ü˜v l ^°:Ð>Ó?Ð?Ø$×/Ñ/ÐàÒÜ˜'°Ô6ØÒ$Ø�O‰OÜ”u“ß‘”u—x‘x <Ñ/Ó0ß‘¤d¨=Ó&9ÄkÃm�ÓTôô
 (+£uÐØÒÜ!3°GÓ!JÐØ�O‰OÜ”xÓ ×&Ñ&Ü×%Ñ%¨Ñ5Ü—O‘O {Ñ2óôð Ò Ø�O‰OÜ”u“ß‘”u—x‘x <Ñ/Ó0ß‘ )¼»�ÓFôð
 Ò!Ø�{‰{œ5 *Ó-Ò5Ü Ø! *¡Ð/TÐUóð ð �O‰OÜ”u“ß‘”u—x‘x <Ñ/Ó0ß‘ :¼+»-�ÓHô÷
 #Ð':Ô'HØ—‘”Ü Ô=ØÒÜ*¬4°«:Ö6�Ü˜7Ô-ÜØØ)Ø%Ø%÷	ñ 7ð �M‰MŒOÜ! 'Ó8Ð<NÔNÜ& wÔ=Ø�‰Ô÷m 
 ôp ˜lÓ+€FØ‚~ÜÐ8Ó9Ð9Ø€M÷w 
 ×	ús   “JJ:Ê:K
	c                ó0   € V ^8„  d   QhR\         R\        /# )r    r>   r!   )r   r<   )r"   s   "r#   r$   r$   ¤   s   € ÷ pñ p¤eð p´ñ pr%   c                ó\  € R\        WP                  4      9  d   R# V P                  \        VP                  4      P
                  p\        \        P
                  P                  V4      4      P                  \        P
                  P                  \        P                  ! 4       4      4      # )zCA preview Core made: tagged ``preview`` and stored under previews/.ÚpreviewF)r   r'   r9   r   r:   r;   r   ÚosÚrealpathÚis_relative_toÚfolder_pathsÚget_previews_directory)r=   r>   r;   s   && r#   Ú_is_core_previewrk   ¤   sp   € àÔ)¨'·9±9Ó=Ô=ÙØ�;‰;”| V×%6Ñ%6Ó7×<Ñ<€DÜ”—‘× Ñ  Ó&Ó'×6Ñ6´r·w±w×7GÑ7GÌ×HkÒHkÓHmÓ7nÓoÐor%   c                ó(   € V ^8„  d   QhR\         RR/# )r    r:   r!   N©rD   )r"   s   "r#   r$   r$   ¬   s   € ÷ Yñ Y¬cð Y°dñ Yr%   c                óÌ  € V P                  \        \        P                  4      P	                  \        P
                  V8H  4      P                  ^4      4      e   R# V P                  \        V4      pV P                  V4       V P                  4        VP                  '       gh   V P                  \        \        P                  4      P	                  \        P                  VP                  8H  4      P                  ^4      4      '       d   R#  \        P                  ! VP                  4       R#   \         d(    \         P"                  ! RTP                  RR7        R# i ; i)zARemove a preview's content row and file once no record uses them.Nz Could not remove preview file %sT)Úexc_info)Úscalarr   r   r'   rN   r:   Úlimitr9   r   r   rZ   r5   r;   rf   ÚremoveÚOSErrorÚloggingÚwarning)r=   r:   r?   s   && r#   Ú_drop_unused_contentrv   ¬   só   € à‡~�~”fœUŸX™XÓ&×,Ñ,¬U×-=Ñ-=ÀÑ-KÓL×RÑRÐSTÓUÓVÒbÙØ�k‰kœ,¨
Ó3€GØ‡N�N�7ÔØ‡M�M„Oà××Ð˜WŸ^™^¬F´<·?±?Ó,C×,IÑ,IÌ,×J[ÑJ[Ð_f×_kÑ_kÑJkÓ,l×,rÑ,rÐstÓ,u×vÒvÙðYÜ
�	Š	�'—,‘,ÖøÜô YÜ�ŠÐ:¸G¿L¹LÐSW×XÐXðYús   Ä D1 Ä1.E#Å"E#c                ó(   € V ^8„  d   QhR\         RR/# )r    r,   r!   Nrm   )r"   s   "r#   r$   r$   ¼   s   € ÷ 2ñ 2¬ð 2°ñ 2r%   c                óZ  € V P                  \        V4      pVeZ   V P                  \        \        P                  4      P                  \        P                  V8H  4      P                  ^4      4      e   R# \        W4      '       d%   VP                  p\        W4       \        W4       R# R# )zGDelete a Core preview, and its file, once no record links or uses them.N)r9   r   rp   r   r'   rN   r,   rq   rk   r:   r
   rv   )r=   r,   re   r:   s   &&  r#   r[   r[   ¼   s   € à�k‰kœ% Ó,€GØ‚˜'Ÿ.™.¬´·±Ó)9×)?Ñ)?Ä×@PÑ@PÐT^Ñ@^Ó)_×)eÑ)eÐfgÓ)hÓiÒuÙÜ˜×)Ò)Ø×'Ñ'ˆ
Ü�gÔ*Ü˜WÖ1ñ *r%   c                ó0   € V ^8„  d   QhR\         R\        /# rH   ©rD   r<   )r"   s   "r#   r$   r$   Ç   s   € ÷ ñ Üðä	ñr%   c                 ó`  € \        4       ;_uu_ 4       p\        W4      pVf    R R R 4       R# VP                  VP                  rC\	        W4      p\        W4       V'       d   \        W4       V'       d   \        W4       VP                  4         R R R 4       R#   + '       g   i     R # ; i)NFT)	r   r   r:   r,   rk   r
   rv   r[   r]   )rC   r=   r>   r:   r,   Úis_core_previews   &     r#   Údelete_asset_referencer}   Ç   s‚   € ô 
×	Ô	 7Ü! 'Ó8ˆØŠ>Ø÷ 
 Ñ	ð "(×!2Ñ!2°F×4EÑ4E�JÜ*¨7Ó;ˆÜ�gÔ,ßÜ  Ô5ßÜ˜GÔ0Ø�‰ÔØ÷ 
 ×	×	Ò	ús   “B®ABÁ6BÂB-	c                ó0   € V ^8„  d   QhR\         R\        /# )r    Ú
asset_hashr!   rz   )r"   s   "r#   r$   r$   Ú   s   € ÷ ?ñ ?œSð ?¤Tñ ?r%   c                 óº   €  \        V 4      p\        4       ;_uu_ 4       p\        Y!4      RJuuRRR4       #   \         d     R # i ; i  + '       g   i     R# ; i)FN)r   rV   r   r   )r   Ú	canonicalr=   s   &  r#   Úasset_existsr‚   Ú   sQ   € ðÜ(¨Ó4ˆ	ô 
×	Ô	˜WÜ˜wÓ2¸$Ð>÷ 
Ò	øô ô Úðúç	×	Ð	ús   ‚7 ŸA	·AÁAÁ	A	c                ó>   € V ^8„  d   QhR\         R\        R,          /# )r    r   r!   N)rD   r   )r"   s   "r#   r$   r$   ã   s!   € ÷ 3ñ 3Üð3ä Õ$ñ3r%   c           
     óÀ  €  \        V 4      p\        4       ;_uu_ 4       p\        Y!4      pTf    RRR4       R# \	        TP                  \        \        4      P                  \        P                  TP                  8H  4      P                  \        P                  \        P                  4      4      4      p\        P                  P                  TP                  4      pRpT'       d,   TR,          pTP                   ;'       g    TpTP"                  pT F  p\%        Y(P                  4       K  	  TP                  p	TP'                  4        T;'       gM    \(        P*                  ! T4      ^ ,          ;'       g(    \(        P*                  ! T	4      ^ ,          ;'       g    Rp
RRR4       \-        X	X
XR7      #   \         d     R# i ; i  + '       g   i     L0; i)a  Resolve a blake3 hash to an on-disk file path via lookup_for_view.

Uses the first qualified live content row. Temp paths are excluded from all
hash lookups inside qualified_content_iterator, so a hash resolving only to
temp content returns None. Updates last_access_time on every record pointing
at the served content.

Filename and Content-Type both come from the newest record so they never
describe different records. Deleting the last record preserves its content,
so content with zero records stays servable off the content path alone.
Núapplication/octet-stream©Úabs_pathÚcontent_typeÚdownload_nameéÿÿÿÿ)r   rV   r   r   r\   rL   r   r   rN   r:   r'   Úorder_byr/   rf   r;   Úbasenamer(   r4   r   r]   Ú	mimetypesÚ
guess_typer   )r   r�   r=   r?   ÚrecordsÚdisplay_namer4   Úlatest_recordr>   r‡   Úctypes   &          r#   Úresolve_hash_to_pathr“   ã   sƒ  € ðÜ(¨Ó4ˆ	ô 
×	Ô	˜WÜ! 'Ó5ˆØŠ?Ø÷ 
Ñ	ô
 Ø�O‰OÜ”u“ß‘”u×'Ñ'¨7¯:©:Ñ5Ó6ß‘œ%×*Ñ*¬E¯H©HÓ5óó
ˆô —w‘w×'Ñ'¨¯©Ó5ˆØˆ	ßØ# B�KˆMØ(×-Ñ-×=Ð=°ˆLØ%×/Ñ/ˆIÛˆFÜ% g¯y©yÖ9ñ à—<‘<ˆØ�‰Ôð ÷ *ð *Ü×#Ò# LÓ1°!Õ4÷*ð *ä×#Ò# HÓ-¨aÕ0÷*ð *ð *ð	 	÷/ 
ô: $ØØØ"ôð øô? ô Úðúç	×	ús;   ‚F; ŸGºCGÄAGÅ$GÅ=$GÆ"GÆ;G
Ç	G
ÇG	c                óh   € V ^8„  d   QhR\         \        ,          R\        \        \        3,          /# )r    Úpreview_idsr!   )r\   rD   rY   )r"   s   "r#   r$   r$     s*   € ÷ Oñ O¬¬S­	ð O´d¼3Ä¸8µnñ Or%   c                ó�   € V '       g   / # \        4       ;_uu_ 4       p\        WR7      uuRRR4       #   + '       g   i     R# ; i)zGMap preview reference id -> file_path, in one query for the whole page.)r•   N)r   r   )r•   r=   s   & r#   Úget_preview_file_pathsr—     s,   € çØˆ	Ü	×	Ô	˜WÜ,¨WÔN÷ 
×	×	Ó	ús	   �4´A	c                ó<   € V ^8„  d   QhR\         R\        R\        /# )r    rC   Úrecord_accessr!   )rD   r<   r   )r"   s   "r#   r$   r$   !  s&   € ÷ &
ñ &
Üð&
äð&
ô ñ&
r%   c                 ó.  € \        4       ;_uu_ 4       p\        W 4      pVf   \        RV  R24      hVP                  \        VP
                  4      pVeB   VP                  '       g0   \        P                  P                  VP                  4      '       g*   \        RV  RVP
                   RVP                   R24      hVP                  pVP                  pVP                  pV'       d   \        W 4       VP                  4        T;'       g2    \        P                   ! T;'       g    T4      ^ ,          ;'       g    RpT;'       g     \        P                  P#                  V4      p	\%        VVV	R7      uuR R R 4       #   + '       g   i     R # ; i)	NúAssetReference rU   ú#No live content for AssetReference z (content id=z, name=Ú)r…   r†   )r   r   rV   r9   r   r:   r5   rf   r;   ÚisfileÚFileNotFoundErrorr(   r4   r   r]   r�   rŽ   rŒ   r   )
rC   r™   r=   r>   r?   Úref_nameÚ
asset_mimer‡   r’   r‰   s
   &&        r#   Úresolve_asset_for_downloadr¢   !  sV  € ô 
×	Ô	˜WÜ! 'Ó8ˆØŠ>Ü˜¨|¨n¸JÐGÓHÐHà—+‘+œl¨F×,=Ñ,=Ó>ˆàŠOØ×!×!Ð!Ü—7‘7—>‘> '§,¡,×/Ò/ä#Ø5°l°^ð DØ%×0Ñ0Ð1°¸¿¹¸ÀQðHóð ð
 —;‘;ˆØ×%Ñ%ˆ
Ø—<‘<ˆçÜ% gÔ<Ø�N‰NÔð ÷ *ð *Ü×#Ò# H×$8Ð$8°Ó9¸!Õ<÷*ð *à)ð 	ð
 !×>Ð>¤B§G¡G×$4Ñ$4°XÓ$>ˆÜ'ØØØ'ô
÷= 
×	×	Ó	ús7   “AFÁ(.FÂAFÃ,#FÄFÄ*FÄ?FÅ-FÆF	c                óh   € V ^8„  d   QhR\         \        ,          R\        R\        \        ,          /# )r    Újob_idsÚinclude_previewsr!   )r   rD   r<   r\   r   )r"   s   "r#   r$   r$   J  s.   € ÷ $ñ $Ü”c�]ð$Ü.2ð$ä	Ô
Õñ$r%   c                ó$  € V '       g   . # V'       d   RR.MR.p\        4       ;_uu_ 4       pVP                  \        \        P                  \        P
                  \        P                  \        P                  \        P                  \        P                  4      P                  \        \        P                  \        P                  8H  4      P                  \        P                  P                  \        V 4      4      \        P                   P#                  R4      \        P                  P                  \        \$        P&                  4      P                  \$        P(                  P                  V4      4      4      4      4      P+                  4       pRRR4       X Uu. uFP  p\-        VP                  VP
                  VP                  VP                  VP                  VP                  R7      NKR  	  up#   + '       g   i     Lm; iu upi )z[Live output records of the given jobs, plus their temp records when previews are requested.ÚoutputÚtempFN©r'   r(   r;   r2   r.   r/   )r   rW   r   r   r'   r(   r.   r/   r   r;   r2   Újoinr:   rN   Úin_r\   r5   Úis_r	   rO   rM   Úallr   )r¤   r¥   r8   r=   ÚrowsÚrows   &&    r#   Úlist_job_export_filesr°   J  sk  € ÷ Øˆ	ß!1ˆH�fÑ¸°z€DÜ	×	Ô	˜WØ�‰ÜÜ—‘Ü—
‘
Ü—‘Ü× Ñ Ü×!Ñ!Ü×!Ñ!ó÷ ‰T”,¤× 0Ñ 0´L·O±OÑ CÓDß‰UÜ—‘× Ñ ¤ g£Ó/Ü×'Ñ'×+Ñ+¨EÓ2Ü—‘—‘Üœ8×,Ñ,Ó-×3Ñ3´H×4EÑ4E×4IÑ4IÈ$Ó4OÓPóóó
÷" ‰#‹%ð# 	÷ 
ñ8 ó
ñ ˆCô 	Ø�v‰vØ—‘Ø—‘Ø—‘Ø—:‘:Ø—~‘~÷	
ñ ñ
ð 
÷' 
×	üò&
s   ¬E)G:Æ!AHÇ:H
	c                ó0   € V ^8„  d   QhR\         R\        /# rH   )rD   r   )r"   s   "r#   r$   r$   q  s   € ÷ 
ñ 
¤#ð 
Ô*=ñ 
r%   c                 óÂ  € \        4       ;_uu_ 4       p\        W4      pVf   \        RV  R24      hVP                  \        VP
                  4      pVe   VP                  '       d   \        RV  24      h\        VP                  VP                  VP                  VP                  VP                  VP                  R7      uuR R R 4       #   + '       g   i     R # ; i)Nr›   rU   rœ   r©   )r   r   rV   r9   r   r:   r5   rŸ   r   r'   r(   r;   r2   r.   r/   )rC   r=   r>   r?   s   &   r#   Úget_export_filer³   q  s²   € Ü	×	Ô	˜WÜ! 'Ó8ˆØŠ>Ü˜¨|¨n¸JÐGÓHÐHØ—+‘+œl¨F×,=Ñ,=Ó>ˆØŠ?˜g×0×0Ð0Ü#Ø5°l°^ÐDóð ô #Ø�y‰yØ—‘Ø—‘Ø—‘Ø—=‘=Ø×(Ñ(ô
÷ 
×	×	Ó	ús   “ACÁ(ACÃC	)NNNÚmanualNN)T):Ú__doc__rt   r�   rf   Úpathlibr   Útypingr   Ú
sqlalchemyr   r   r   ri   Úapp.assets.database.modelsr   r   r	   Úapp.assets.database.queriesr
   r   r   r   Ú#app.assets.database.queries.recordsr   r   r   r   r   Úapp.assets.helpersr   r   r   Úapp.assets.services.lookupr   Úapp.assets.services.schemasr   r   r   r   r   r   Úapp.database.dbr   r   rA   rF   rQ   rb   rk   rv   r[   r}   r‚   r“   r—   r¢   r°   r³   © r%   r#   Ú<module>rÁ      s¨   ðñó Û Û 	Ý Ý ç -Ñ -ã ç DÑ D÷ó ÷õ ÷ QÑ PÝ 6÷÷ ÷ Aõ>õ49õ÷EõPpõYõ 2õõ&?õ3õlO÷&
õR$÷N
r%   