■ RunnableWithMessageHistory 클래스에서 SQLChatMessageHistory 객체를 사용하는 방법을 보여준다.
※ OPENAI_API_KEY 환경 변수 값은 .env 파일에 정의한다.
▶ main.py
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 |
from dotenv import load_dotenv from langchain_community.chat_message_histories import SQLChatMessageHistory from langchain_core.prompts import ChatPromptTemplate from langchain_core.prompts import MessagesPlaceholder from langchain_core.runnables.history import RunnableWithMessageHistory from langchain_openai import ChatOpenAI from langchain_core.output_parsers import StrOutputParser from langchain_core.runnables.utils import ConfigurableFieldSpec load_dotenv() chatPromptTemplate = ChatPromptTemplate.from_messages( [ ("system", "You are a helpful assistant."), MessagesPlaceholder(variable_name = "chat_history"), ("human" , "{question}") ] ) runnableSequence = chatPromptTemplate | ChatOpenAI(model_name = "gpt-4o-mini") | StrOutputParser() def getChatHistory(user_id, session_id): return SQLChatMessageHistory( table_name = user_id, session_id = session_id, connection = "sqlite:///sqlite.db", ) configurableFieldSpecList = [ ConfigurableFieldSpec( id = "user_id", annotation = str, name = "User ID", description = "Unique identifier for a user.", default = "", is_shared = True ), ConfigurableFieldSpec( id = "session_id", annotation = str, name = "Session ID", description = "Unique identifier for a session.", default = "", is_shared = True ) ] runnableWithMessageHistory = RunnableWithMessageHistory( runnableSequence, getChatHistory, input_messages_key = "question", history_messages_key = "chat_history", history_factory_config = configurableFieldSpecList ) configurableDictionary1 = {"configurable" : {"user_id" : "user1", "session_id" : "1"}} responseString1 = runnableWithMessageHistory.invoke({"question" : "내 이름은 홍길동 입니다."}, configurableDictionary1) print(responseString1) print("-" * 50) responseString2 = runnableWithMessageHistory.invoke({"question" : "내 이름은 무엇입니까?"}, configurableDictionary1) print(responseString2) print("-" * 50) configurableDictionary2 = {"configurable" : {"user_id" : "user1", "session_id" : "2"}} responseString3 = runnableWithMessageHistory.invoke({"question" : "내 이름은 무엇입니까?"}, configurableDictionary2) print(responseString3) print("-" * 50) """ 안녕하세요, 홍길동님! 만나서 반갑습니다. 어떻게 도와드릴까요? -------------------------------------------------- 당신의 이름은 홍길동입니다. 어떻게 더 도와드릴까요? -------------------------------------------------- 죄송하지만, 당신의 이름을 알 수 있는 정보가 없습니다. 당신의 이름을 알려주시면, 제가 그에 대한 대화를 이어갈 수 있습니다! -------------------------------------------------- """ |
▶ requirements.txt
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
aiohappyeyeballs==2.4.4 aiohttp==3.11.11 aiosignal==1.3.2 annotated-types==0.7.0 anyio==4.8.0 async-timeout==4.0.3 attrs==24.3.0 certifi==2024.12.14 charset-normalizer==3.4.1 dataclasses-json==0.6.7 distro==1.9.0 exceptiongroup==1.2.2 frozenlist==1.5.0 greenlet==3.1.1 h11==0.14.0 httpcore==1.0.7 httpx==0.28.1 httpx-sse==0.4.0 idna==3.10 jiter==0.8.2 jsonpatch==1.33 jsonpointer==3.0.0 langchain==0.3.14 langchain-community==0.3.14 langchain-core==0.3.29 langchain-openai==0.3.0 langchain-text-splitters==0.3.5 langsmith==0.2.10 marshmallow==3.25.1 multidict==6.1.0 mypy-extensions==1.0.0 numpy==1.26.4 openai==1.59.6 orjson==3.10.14 packaging==24.2 propcache==0.2.1 pydantic==2.10.5 pydantic-settings==2.7.1 pydantic_core==2.27.2 python-dotenv==1.0.1 PyYAML==6.0.2 regex==2024.11.6 requests==2.32.3 requests-toolbelt==1.0.0 sniffio==1.3.1 SQLAlchemy==2.0.37 tenacity==9.0.0 tiktoken==0.8.0 tqdm==4.67.1 typing-inspect==0.9.0 typing_extensions==4.12.2 urllib3==2.3.0 yarl==1.18.3 |
※ pip install python-dotenv langchain-community langchain_openai 명령을 실행했다.