Uik0ddlZddlZddlZddlmZddlmZmZm Z ej e Z dZ eeddZdZeeezZded efd Zd efd Zd ed ed efdZded edzfdZdededed efdZded efdZdS)N)types)get_vertex_client A_DB_CONFIG C_DB_CONFIGzgemini-3-pro-preview  session_idreturncltjjdit}|d} |d|f|pi ||S#||wxYw)u7A_DB.user_profile_summary에서 유저 프로필 조회T dictionarya SELECT session_id, username, final_goal, mbti, spi_language, spi_nonverbal, spi_personality, studyplan_duration, studyplan_status, studyplan_weekday_hours, studyplan_weekend_hours, studyplan_time_slot, it_level, ai_analysis FROM user_profile_summary WHERE session_id = %s N)mysql connectorconnectrcursorexecutefetchoneclose)r connrs '/app/app/models/ai_curriculum_module.py_fetch_user_profilers ? " 1 1[ 1 1D [[D[ ) )F  ]     &B&     s ,B *B3cbtjjdit}|d} |d|||S#||wxYw)u.C_DB.master_items 전체 조회 (AI 참고용)Tr z SELECT item_id, block_id, name, category, item_type, sort_order FROM master_items ORDER BY block_id, sort_order, item_id Nr)rrrrrrfetchallr)rrs r_fetch_master_itemsr.s ? " 1 1[ 1 1D [[D[ ) )F            s (B*B.profile master_itemsc g}|dr|d|d|dr|d|d|dr|d|d|dr|d|dd |d r&|d |d d d |rd|nd}d|D}d|dt|dd|dt|dt|d }|S)uJAI에게 PJT 아이템의 우선순위만 결정하게 하는 프롬프트 final_goalu目標:mbtizMBTI:it_levelzIT:studyplan_weekday_hoursu平日:h ai_analysisu分析:NP/u 情報なしcPg|]#}|ddkt|d$ScategoryPJTitem_id)str.0ms r z!_build_prompt..Ts2QQQQ!J-5:P:Ps1Y<  :P:P:PuIT教育カリキュラムPJT教材の学習順序を最適化してください。 CERT（資格）教材は固定のため、PJTのみ並び替えます。 【ユーザー】u 【PJT ID(u個)】,u ルール: - 全uL個のIDを必ず含めること。省略禁止 - 初心者=基礎→応用,中級者=基礎スキップし応用から - MBTIに基づき学習スタイルを最適化（例:ENTJ=効率重視で実践から） - ユーザーの目標に最も関連性の高い分野を前半に配置 出力:1行JSON。改行禁止。{{ "pjt":[全u 個のid] }})getappendjoinlen)rrparts user_linepjt_idsprompts r _build_promptr<Bs E{{<  8 6w|466777{{60 .WV_..///{{:2 07:.00111{{,--F Dw'@ADDDEEE{{=!!> .s?```aAGGIIL]L]L_L_`3qwwyy>>```r2r3z#[AI Curriculum] JSON repaired: pjt=pjt) jsonloads isinstancedictJSONDecodeErrorresearchgroupsplitloggerinfor7)r=resultsuffixrK pjt_matchr:s r_try_parse_jsonrTlsN D!! fd # # M        1 Zv ..F&$''   #    H III 6==I$``9??1+=+=+C+CC+H+H```  $ KKLc'llLL M M M7# # 4s *.AA-A99B  B  pjt_order all_pjt_idscert_items_by_dayc t g}|D]4}||vr.| vr*|| |5 fdt|D}||t dt|dt|ddt|dzg}d}tD]}tdtdzD]g} |t|kr|||| f| || f} | r|| | f|dz }h|S) uI AI가 정해준 PJT 우선순위 + CERT 고정 순서를 120일에 배치. Args: pjt_order: AI가 정한 PJT ID 우선순위 리스트 all_pjt_ids: 유효한 PJT ID 집합 cert_items_by_day: {(block_id, sort_order): item_id} — CERT 고정 배치 Returns: [(item_id, sort_order), ...] cg|]}|v| Srr)r/iseens rr1z(_place_items_to_days..sCCCQd]]1]]]r2z[AI Curriculum] Placement: PJT=z(+z fallback), zCERT=z items (fixed)rrD) setr5addsortedextendrOrPr7BLOCKSrangeDAYS_PER_BLOCKr4) rUrVrW pjt_cleanrZ missing_pjtrQ day_indexblock_id sort_ordercert_idr[s @r_place_items_to_daysris 55DI      Q    HHQKKKDCCCf[11CCCK [!!! KKb#i..bbC DTDTbbb>-..>>>?@@@FI  >A#566  J3y>>)) y3Z@AAA'++Xz,BCCG 5 w 3444 NII  Mr2c K tdt}|sddddSt}d|D}d|D}i}|D]'}|dd vr|d |d f}|d ||<(t ||}td t dtdt |dtdt |dt |dt} | j t tj dtj |ggtj dd} | j} tdt | dtd| dd| dr6| d } d!| D} d | } | d d"d#d"} t)| } | d$| vrdd%ddS| d$}td&t |d't+|||}t |d(krdd)t |d*ddStd+t |d,t-jjd>it2}|} |d-f|j}td.|d/d0}fd1|D}|||||j}td2|d3d4d5|d6|d||S#t@$ry}|!t"d7|dd8tG|ddcYd}~||Sd}~wwxYw#||wxYw#tHj%$rR}t"d9|t"d| dd:dd;ddcYd}~Sd}~wt@$r=}t"d<|dd=tG|ddcYd}~Sd}~wwxYw)?u Vertex AI로 우선순위만 결정 → Python이 배치 → user_curriculum에 저장 Returns: {"success": bool, "message": str, "item_count": int} z"[AI Curriculum] Fetching data for Fu6ユーザープロフィールが見つかりませんr)successmessage item_countch|] }|d S)r,rr.s r z)generate_ai_curriculum..s888aQy\888r2c6h|]}|ddk|dSr)rr.s rroz)generate_ai_curriculum..s*PPPA:%9O9O1Y<9O9O9Or2r*)CERTREVIEWrfrgr,z#[AI Curriculum] Calling Vertex AI (z) - PJT only modez[AI Curriculum] Prompt length: z charszI Curriculum] Items: PJT=z, CERT=z (fixed)user)r=)roler8g333333?i) temperaturemax_output_tokens)modelcontentsconfigz%[AI Curriculum] Raw response length: z[AI Curriculum] Raw text: Ni,``` c`g|]+}|d)|,S)rz)r@ startswith)r/ls rr1z*generate_ai_curriculum..s3III1QWWYY-A-A%-H-HIQIIIr2 rEu8AI応答の形式が不正です（pjtキーが必要）z [AI Curriculum] AI returned PJT:z items u&有効な項目が少なすぎます (u件)z[AI Curriculum] Placed z items into schedulez1DELETE FROM user_curriculum WHERE session_id = %sz[AI Curriculum] Deleted z old itemsz INSERT INTO user_curriculum (session_id, item_id, sort_order, status) VALUES (%s, %s, %s, 'NOT_STARTED') c g|] \}}||f Srr)r/r,rgr s rr1z*generate_ai_curriculum..s4;;;+ *5;;;r2z[AI Curriculum] Inserted z new items for Tu-カリキュラムが作成されました（u 項目）z[AI Curriculum] DB Error: uDB保存エラー: z"[AI Curriculum] JSON Parse Error: iu*AI応答のJSON解析に失敗しましたz[AI Curriculum] Error: u#カリキュラム生成エラー: r)&rOrPrrr< VERTEX_MODELr7rmodelsgenerate_contentrContentPartGenerateContentConfigr=r@r}rNr6replacerTrirrrrrrrowcount executemanycommitr Exceptionrollbackerrorr-rFrJ)r rr valid_idsr:rWr0keyr;clientresponseraw_textlines ai_resultrU placementsrrdeleted insert_sqlrowsinserteddb_errjees` rgenerate_ai_curriculumrsCnn EEEFFF%j11 |$1iyz{{ {*,, 98<888 PPPPP 6 6A} 222}a o6)*9!#&w 55 Y,YYYZZZ Ic&kkIIIJJJ g#g,,ggsK\G]G]ggghhh"$$=11m 8O8O8O7PQQQR."&2  =&&(( QCMMQQQRRR A$3$AABBB   u % % (NN4((EIIIIIEyy''H##D"--55dB??EEGG$H--  Y 6 6$1k{|}} }e$  Ms9~~MMMNNN*)W>OPP z??R  $1oZ]^hZiZi1o1o1o@ABB B Sc*ooSSSTTT&5555  NNC    oG KKF7FFF G G GJ;;;;/9;;;D   z4 0 0 0 KKMMMH KKYHYYZYY Z Z Z ^8^^^& LLNNN JJLLLL  g g g MMOOO LL>f>> ? ? ?$1Ts6{{1T1Tdeff f f f f f LLNNN JJLLLL  g LLNNN JJLLLL  lll >">>??? B(4C4.BBCCC -Yijkkkkkkkk nnn 2q22333 -[SVWXSYSY-[-[klmmmmmmmmns3S'I"S'A-S' AS'%B&P4 (S'4 R7>AR2R7R: (S'2R77R::*S$$S''V 6AU=V  V 2VV V )rFloggingmysql.connectorr google.genairapp.core.configrrr getLogger__name__rOrlistrar`rbr7 TOTAL_DAYSr-rIrrr<rTr\rirrr2rrs  GGGGGGGGGG  8 $ $%  eeArll   S[[> ) CD( T    (#4#t#####T#$+H)D)s),0)59))))`unSunTununununununr2