Class MSSQLChatMessageHistory (0.2.0)

MSSQLChatMessageHistory(
    engine: langchain_google_cloud_sql_mssql.engine.MSSQLEngine,
    session_id: str,
    table_name: str,
)

Chat message history stored in a Cloud SQL MSSQL database.

Parameters
Name	Description
`engine`	`MSSQLEngine` SQLAlchemy connection pool engine for managing connections to Cloud SQL for SQL Server.
`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 MSSQLChatMessageHistory class.

Use helper method MSSQLEngine.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