ix! dZddlZddlZddlmZmZddlmZddlmZm Z m Z ddl m Z ddl mZddlmZdd lmZmZmZdd lmZed d g ZGdde ZGdde Zej7ddde ee efdeedededefdZej7de ee efdedefdZej7de ee efdedededefdZ ej7de de de ee efd ed!ededefd"Z!ej7d#e ee efd$ededefd%Z"ejGde ee efd&ededefd'Z$ejKd#e ee efd$ed&ededefd(Z&ejGd)e ee efd$ededefd*Z'y)+u1프롬프트 관리 API — CRUD + 버전 관리.N)datetimetimezone)Optional) APIRouterDependsQuery) BaseModel)text)Session)get_dbget_current_user require_admin) UserAccountz/api/v1/promptsprompts)prefixtagscJeZdZUeed<eed<eed<eed<dZeeed<y) PromptCreatemodulenameversioncontentN schema_json__name__ __module__ __qualname__str__annotations__rrH/Users/manta/Documents/Projects/TheRoad-I1/backend/app/api/v1/prompts.pyrrs$ K I L L!%K#%r!rc,eZdZUeed<dZeeed<y) PromptUpdaterNrrr r!r"r$r$s L!%K#%r!r$/Fr active_onlydb current_userc d}i}g}|r|jd||d<|r|jd|r|ddj|zz }|dz }|jt||j }dd lmt|fd d }dd lm } g} | |dD]+\\} } } | jtt| -| Dcgc])}|d|d|d|d|d|d|d|d|dd +c}Scc}w)u?프롬프트 목록 조회. module 필터 + active_only 옵션.zSELECT id, module, name, version, is_active, file_path, created_at, created_by, LENGTH(content) as content_length FROM prompt_templatezmodule = :modulerzis_active = truez WHERE z AND z ORDER BY module, namer_version_sort_keyc4|d|d|dxsdfS)Nr )rr+s r"zlist_prompts..=s"qtQqT#4QqTZR#@Ar!Fkeyreverse)groupbyc|d|dfS)Nr-r.r )r1s r"r2zlist_prompts..CsadAaD\r!)r4r-r.r/) idrrr is_active file_path created_at created_bycontent_length) appendjoinexecuter fetchallapp.modules.prompt_loaderr+sorted itertoolsr6extendreversedlist)rr&r'r(queryparams conditionsrows sorted_rowsr6finalmodnmgrpr1r+s @r" list_promptsrV s> UE FJ ,-!x,- W\\*555 %%E ::d5k6 * 3 3 5D; AK "E!+3IJ b3 Xd3i()K   !dadAaDQqTqT!AaDdad    s.Dz/modulesc|jtdj}ddlm}ddlm}|t}|D]!}||dj|d|df#g}t|jD]m}||} t| } td| D} | D cgc] \} } | s |  }} } |j|d |r|dnd }|j|| | |d o|Scc} } w) u 모듈 목록 + 각 모듈의 프롬프트/버전 수. latest_version 은 SQL ``MAX(version)`` 이 lexical (``9.x`` > ``10.x`` 버그) 이므로 module 별 row 를 모두 fetch 한 뒤 Python ``_version_sort_key`` 로 numeric-aware 최대값 계산. zFSELECT module, version, is_active FROM prompt_template ORDER BY moduler) defaultdictr*r-r.c3,K|] \}}|s dyw)r-Nr ).0_r>s r" zlist_modules..esFII1s Tr3N)rtotal active_countlatest_version)rEr rF collectionsrXrGr+rLrCrHkeyslensumsort)r'r(rPrXr+ by_moduler1outrentriesr]r^vr[versionslatests r" list_modulesrkLs ::dP xz (;!$'I !A$!ad|, C)*F#G FFF ")/'$!QQA'/ +T : (!d ul$  + J0s , C47C4z/effective/{module}/{name}rc"ddlm}||||S)u현재 ``load_prompt`` 가 실제 사용할 source 표시 — DB row + file fallback 모두 검사. admin UI 가 prompt_template DB row 만 보고 active prompt 판단하던 문제 해소 (problems.md #8). winner / fallback_reason / candidate 정보 표시. r)get_effective_source)rGrm)rrr'r(rms r"get_effective_promptrnps? b 11r!z/compare.id1id2c6|jtdd|ij}|jtdd|ij}|r|sddlm}|ddd|d|d |d |d |d d |d|d |d |d |d d dS)u두 프롬프트 버전 비교.zVSELECT module, name, version, content, schema_json FROM prompt_template WHERE id = :idr=rAppErrorprompt.not_foundu(비교 대상을 찾을 수 없습니다codemessage status_coder-r.r/r8)rrrrr)leftrightrEr fetchoneapp.core.errorsrs)rorpr'r(r1r2rss r"compare_versionsrs D` c{ HJ D` c{ HJ R,.8bpstta5"Q%BqEbQRedfghdijqE2a5RUrRSueghiejk r!z /{prompt_id} prompt_idc |jtdd|ij}|sddlm}|ddd|d|d |d |d |d |d |d|d|d|dd S)u%프롬프트 상세 (content 포함).zSELECT id, module, name, version, content, schema_json, is_active, file_path, created_at, created_by FROM prompt_template WHERE id = :idr=rrrrt'프롬프트를 찾을 수 없습니다rurvr-r.r/r8r9r:r;r< ) r=rrrrrr>r?r@rAr|)rr'r(rowrss r" get_promptrs **T . i #(* ,.8aorss!fAA3q6q6#a&s1vV3q6Q r!bodyc tjtjj }t t j}|jtd||j|j|j|j|j||jd|j!|ddS)u새 프롬프트 버전 생성.z INSERT INTO prompt_template (id, module, name, version, content, schema_json, is_active, created_at, created_by) VALUES (:id, :module, :name, :version, :content, :schema_json, false, :created_at, :created_by) )r=rrrrrr@rAu%프롬프트가 생성되었습니다)r=rx)rnowrutc isoformatruuiduuid4rEr rrrrrr=commit)rr'r(rpids r" create_promptrs ,,x|| $ . . 0C djjl CJJt T[[$))<|jtdd|ij}|sddlm}|ddd|d|d }}|jtd ||d |jtd d|i|j d |d|ddS)ub이 프롬프트를 활성 버전으로 설정 (같은 module+name의 다른 버전은 비활성).z7SELECT module, name FROM prompt_template WHERE id = :idr=rrrrtrrurvr-zLUPDATE prompt_template SET is_active = false WHERE module = :m AND name = :n)mnz:UPDATE prompt_template SET is_active = true WHERE id = :idTr%u' 활성 버전이 변경되었습니다)rrx)rEr r}r~rsr)rr'r(rrsrrs r"activate_promptrs **TA i "(* ,.8aorssq63q6DFJJtV $!JJtD iIIKfXQtf4[#\ ]]r!)(__doc__jsonrrrtypingrfastapirrrpydanticr sqlalchemyr sqlalchemy.ormr OrmSession app.api.depsr r rapp.models.catalogrrouterrr$getrboolrVrkrnrrpostrputrrr r!r"rs7 '--0@@* +9+ >&9&&9& C V_ '(8 9 ( SM(( ( ((VJV_ '(8 9    F ()V_ '(8 9 2  2  2  2 2* 2JSzSzV_ '(8 9     .NV_ '(8 9(SV_ ' 6K KKKK,NV_ ' 6    " $%V_ ' 6^^^^&^r!