(create_session() 후 get_session()으로 조회할 수 있다.zsess-002clizgpt-4)rmodelN session_idrrr get_sessionrrrows r test_get_session_returns_createdz0TestSessionCRUD.test_get_session_returns_created,sh ZWE +< J...8}%%%7|w&&&rc*|jdJy)u6존재하지 않는 session_id 조회 시 None 반환.zdoes-not-existN)rrs r %test_get_session_missing_returns_nonez5TestSessionCRUD.test_get_session_missing_returns_none5s  !12:::rc|jdd|jdd|jd}|ddk(sJ|dJy) u<end_session()으로 세션이 종료 상태로 변경된다.zsess-003rr user_exit end_reasonr(ended_atN)r end_sessionrr s r test_end_sessionz TestSessionCRUD.test_end_session9s[ Z6 *= +< K///:***rc|jdd|jdd|j}|Dcgc]}|d }}d|vsJd|vsJycc}w)u4list_sessions()가 생성된 세션을 반환한다.z sess-list-1rrz sess-list-2rrNr list_sessionsrrrowsridss r "test_list_sessions_returns_createdz2TestSessionCRUD.test_list_sessions_returns_createdAsn ]59 ]59""$(,-1q--######.s Ac|jdd|jdd|jd}|Dcgc]}|d }}d|vsJd|vsJycc}w)u+source 필터가 올바르게 동작한다.z src-api-1rrz src-cli-1rrNr-r/s r #test_list_sessions_filter_by_sourcez3TestSessionCRUD.test_list_sessions_filter_by_sourceJss [7 [7""%"0(,-1q--c!!!#%%%.s ActdD]}|jd|d|jd}t|dksJy)u4limit 파라미터가 반환 개수를 제한한다.zlim-testrlimitN)rangerr.len)rrir0s r test_list_sessions_limitz(TestSessionCRUD.test_list_sessions_limitSsQq rYmcontentss r #test_message_ordering_by_created_atz0TestMessages.test_message_ordering_by_created_ats} \%8q LA  FCF K L!!,/*./QAiL//?***0s A.N)rCrDrErFrQrZrcrjrGrr rIrIgs'I . 1+rrIceZdZdZdZy) TestWALModeuSQLite WAL 저널 모드 확인ctj|j}|jdj d}|j |dk(sJy)u-DB의 journal_mode가 WAL임을 확인한다.zPRAGMA journal_mode;rwalN)sqlite3connectrexecutefetchoner )rrconnmodes r test_wal_mode_enabledz!TestWALMode.test_wal_mode_enabledsFu}}-||23<<>qA u}}rN)rCrDrErFrurGrr rlrls )rrlceZdZdZdZdZy)TestFTS5u+messages_fts 가상 테이블 기본 동작ctj|j}|jdj Dcgc]}|d }}|j d|vsJycc}w)u5messages_fts 가상 테이블이 생성되어 있다.z1SELECT name FROM sqlite_master WHERE type='table'r messages_ftsN)rorprrqfetchallr )rrrsr1tabless r test_fts5_table_existszTestFTS5.test_fts5_table_existss[u}}- $ -` a j j lm1!A$mm '''ns A&c|jdd|jdddtj|j}|j dj }|jt|dk\sJy ) u0FTS5 검색이 삽입된 내용을 반환한다.z fts-sess-1rrrKunique_keyword_xyzrMzNSELECT content FROM messages_fts WHERE messages_fts MATCH 'unique_keyword_xyz'rVN) rrProrprrqrzr r=)rrrsr0s r test_fts5_search_basiczTestFTS5.test_fts5_search_basicsn \%8 \@TUu}}-||lmvvx 4yA~~rN)rCrDrErFr|rrGrr rwrws5(rrwceZdZdZdZdZy) TestPruneu오래된 세션 정리c:|jdd|jddtj|j}|j d|j |j|jd|jdJy ) uNolder_than_days=0으로 prune하면 ended_at이 있는 세션이 삭제된다.z prune-oldrrtimeoutr'zOUPDATE sessions SET ended_at='2000-01-01T00:00:00' WHERE session_id='prune-old'rolder_than_daysN) rr*rorprrqcommitr prune_sessionsr)rrrss r test_prune_removes_old_sessionsz)TestPrune.test_prune_removes_old_sessionss [7 +)<u}}- fg   Q/  -555rct|jdd|jd|jdJy)u<ended_at이 없는 (활성) 세션은 prune되지 않는다.z prune-activerrrrN)rrrrs r test_prune_keeps_active_sessionsz*TestPrune.test_prune_keeps_active_sessionss= ^E: Q/  0<<.workersb !$$uSE]8$D$$uSE]4PSu$V ! a   !s04 AAA )targetargszErrors in threads: r:rrN)r< threadingThreadstartjoinr. startswithr=) rrrr>threadstr0r1conc_idsrs ` @r #test_concurrent_writes_no_exceptionz3TestConcurrency.test_concurrent_writes_no_exceptions !HMRyQ!9##6=QQ A GGI  A FFH |;26(;;|""",-1YQ|_5O5OPW5XAlOYY8}"""RZsC C&CN)rCrDrErFrrGrr rrs 0#rrc"eZdZdZdZdZdZy)TestSanitizeTitleu'제어문자 / zero-width 문자 제거c>td}d|vsJd|vsJd|vsJy)u+ASCII 제어문자(-, )가 제거된다.z helloworld!z helloworld!Nrrresults r #test_sanitize_removes_control_charsz5TestSanitizeTitle.test_sanitize_removes_control_charss7 56V###V###&&&rc2td}d|vsJd|vsJy)u.Zero-width 문자(U+200B 등)가 제거된다.uhe​llou​rLNrrs r &test_sanitize_removes_zero_width_charsz8TestSanitizeTitle.test_sanitize_removes_zero_width_charss( .v%%%&   rc(d}t||k(sJy)u+일반 텍스트는 변경되지 않는다.uHello, World! 안녕하세요.Nr)rtexts r #test_sanitize_normal_text_unchangedz5TestSanitizeTitle.test_sanitize_normal_text_unchanged s/d#t+++rN)rCrDrErFrrrrGrr rrs1'! ,rr)rF __future__rrosysrtimepathlibrpytestpathinsertr __file__parentutils.session_storerrfixturerrrIrlrwrrrrGrr rsH"   3tH~,,33::;<<:6:6D$+$+X 2==:##@,,r