Package org.springframework.ai.chat.memory.repository.jdbc

Class MysqlChatMemoryRepositoryDialect

java.lang.Object

org.springframework.ai.chat.memory.repository.jdbc.MysqlChatMemoryRepositoryDialect

All Implemented Interfaces:

JdbcChatMemoryRepositoryDialect

public class MysqlChatMemoryRepositoryDialect
extends Object
implements JdbcChatMemoryRepositoryDialect

MySQL dialect for chat memory repository.

Since:

1.0.0

Author:

Mark Pollack

Field Summary

Fields inherited from interface org.springframework.ai.chat.memory.repository.jdbc.JdbcChatMemoryRepositoryDialect

logger

Constructor Summary

Constructors

Constructor	Description
MysqlChatMemoryRepositoryDialect()

Method Summary

Modifier and Type	Method	Description
String	getDeleteMessagesSql()	Returns the SQL to delete all messages for a conversation.
String	getInsertMessageSql()	Returns the SQL to insert a message.
String	getSelectConversationIdsSql()	Returns the SQL to fetch conversation IDs.
String	getSelectMessagesSql()	Returns the SQL to fetch messages for a conversation, ordered by timestamp, with limit.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

MysqlChatMemoryRepositoryDialect

public MysqlChatMemoryRepositoryDialect()

Method Details

getSelectMessagesSql

public String getSelectMessagesSql()

Description copied from interface: JdbcChatMemoryRepositoryDialect

Returns the SQL to fetch messages for a conversation, ordered by timestamp, with limit.

Specified by:

getSelectMessagesSql in interface JdbcChatMemoryRepositoryDialect

getInsertMessageSql

public String getInsertMessageSql()

Description copied from interface: JdbcChatMemoryRepositoryDialect

Returns the SQL to insert a message.

Specified by:

getInsertMessageSql in interface JdbcChatMemoryRepositoryDialect

getSelectConversationIdsSql

public String getSelectConversationIdsSql()

Description copied from interface: JdbcChatMemoryRepositoryDialect

Returns the SQL to fetch conversation IDs.

Specified by:

getSelectConversationIdsSql in interface JdbcChatMemoryRepositoryDialect

getDeleteMessagesSql

public String getDeleteMessagesSql()

Description copied from interface: JdbcChatMemoryRepositoryDialect

Returns the SQL to delete all messages for a conversation.

Specified by:

getDeleteMessagesSql in interface JdbcChatMemoryRepositoryDialect