vitdZddlZddlZddlmZmZmZmZddl m Z m Z ddl m Z mZeddgZd Zd ed ed efd ZdedefdZededdeddfdedefdZededdfd ed edefdZdS)u 매뉴얼(C파트) REST API 라우터 - GET /manual/list?title=NDA&session_id=xxx → 매뉴얼 목록 반환 - GET /manual/media/{path:path}?session_id=xxx → 파일 서빙 (인증 포함) N) APIRouter HTTPExceptionQueryRequest) FileResponseStreamingResponse) C_DB_CONFIGBACK_DIRManual)prefixtagsc8tjjditS)N)mysql connectorconnectr r!/app/app/routers/manual_router.py_get_cdbrs ? " 1 1[ 1 11rrequest file_path content_typecz tjj}|jd}|dt |d}d |dz }d}||dd d }|drt|d t|dkr|drt|d}| z dz t |d <d d |d ||d <d}n|  fd} t| ||S)Nrangebytes)z content-typez accept-rangescontent-lengthrzbytes=r -rzbytes /z content-rangec3 Ktd5}|}d}|dkrB|t||}|sn|t |z}|V|dkBddddS#1swxYwYdS)Nrbir)openseekreadminlen)f remaining chunk_sizedata chunk_lengthrstarts riterfilez)range_requests_response..iterfile5s )T " " a FF5MMM$I$Ja--vvc*i8899SYY&  a--                  sA"BB B) status_codeheaders) osstatst_sizer2getstrstriplowerreplacesplitintr)r) rrr file_size range_headerr2endr1 range_matchr0r.r/s ` @@rrange_requests_responserAsw ""*I?&&w//L% i..G E a-CK"((**0022::8RHHNNsSS q> ( A''E {  a  KN k!n%%CU{Q $' $5$5 !#EE#E#EC#E#E)#E#E           XXZZ[' R R RRr session_idreturncHt|o|S)u 세션 ID 유효성 검사. chat_log_DB 또는 Goalskill_DB 등 기존 세션 관리 DB에서 확인. 현재는 단순히 "비어있지 않으면 허용" 방식 (추후 강화 가능). )boolr8)rBs r_validate_sessionrFDs#  1z//11 2 22rz/listNDAu매뉴얼 타이틀 (예: NDA))default description.u세션 ID (로그인 확인용))rItitlecKt|stdd t}|d}|d|f|}||d|t||dS#t$r&}td d t|d }~wwxYw) ud C_DB.manual 테이블에서 title 기준으로 sortorder 순 데이터를 반환합니다. Unauthorized: invalid sessionr1detailT) dictionaryz SELECT id, title, media_type, img_path, logo_path, slide_label, sort_order FROM manual WHERE title = %s ORDER BY sort_order ASC success)statusrJtotalitemsiz DB error: N) rFrrcursorexecutefetchallcloser) Exceptionr7)rJrBconnrUrowses rget_manual_listr]Ps Z ( (U4STTTTKzz--  H        YY    KKK4IQ4I4IJJJJKsB B// C9!CCz/media/{file_path:path}u세션 ID (인증용)c 2Kt|stddd|vs|drtddtjtjt|}|tjtstddtj|std d |tj |d  }d d d dddddd}| |d}|drt|||St||S)u back/img/menual/NDA/ 등의 파일을 인증된 사용자에게만 반환합니다. 직접 URL 접근은 불가능하고 반드시 이 API를 통해야 합니다. 예) GET /manual/media/img/menual/NDA/1-0.png?session_id=abc123 rLrMrNz..r!izInvalid file pathz Access denied: path out of scopeizFile not found: rz image/pngz image/jpegz image/gifz image/webpz video/mp4z video/webmzvideo/quicktime)z.pngz.jpgz.jpegz.gifz.webpz.mp4z.webmz.movzapplication/octet-streamzvideo/) media_type)rFr startswithr3pathnormpathjoinr isfilesplitextr9r6rAr)rrrBabs_pathextmedia_type_mapr_s rserve_manual_mediarixs Z ( (U4STTTT yI00554GHHHHw Xy A ABBH   rw//99 : :X4VWWWW 7>>( # #T4Ry4R4RSSSS '  8 $ $Q ' - - / /C!  N ##C)CDDJX&&F&w*EEE Z 8 8 88r)__doc__r3mysql.connectorrfastapirrrrfastapi.responsesrrapp.core.configr r routerrr7rArErFr6r]rirrrrps  <<<<<<<<<<<<========11111111 "H: . . . 222(SW(S(SC(S(S(S(SV3#3$3333Gu2RSSSeC-NOOO!K!K !K!K!K!K!KN %&&eC-DEEE-9-9 -9-9-9-9-9'&-9-9-9r