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

Retrieve the messages from Cloud SQL

_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(message: langchain_core.messages.base.BaseMessage) -> None

Append the message to the record in Cloud SQL

clear() -> None

Clear session memory from Cloud SQL