Class MySQLChatMessageHistory (0.2.3)

MySQLChatMessageHistory(
    engine: langchain_google_cloud_sql_mysql.engine.MySQLEngine,
    session_id: str,
    table_name: str,
)

Chat message history stored in a Cloud SQL MySQL database.

Parameters

Name Description
engine MySQLEngine

Connection pool engine for managing connections to Cloud SQL for MySQL.

session_id str

Arbitrary key that is used to store the messages of a single chat session.

table_name str

The name of the table to use for storing/retrieving the chat message history.

Properties

messages

Retrieve the messages from Cloud SQL

Methods

_verify_schema

_verify_schema() -> None

Verify table exists with required schema for MySQLChatMessageHistory class.

Use helper method MySQLEngine.init_chat_history_table(...) to create table with valid schema.

add_message

add_message(message: langchain_core.messages.base.BaseMessage) -> None

Append the message to the record in Cloud SQL

clear

clear() -> None

Clear session memory from Cloud SQL