From ed5cb75134019a7ba063a13b5ff6f9cd296c80dd Mon Sep 17 00:00:00 2001 From: Grail Finder Date: Wed, 11 Dec 2024 18:43:04 +0300 Subject: Refactor: sql on conflict; fix unittest; page names to vars --- storage/storage.go | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'storage/storage.go') diff --git a/storage/storage.go b/storage/storage.go index b876dbc..0853328 100644 --- a/storage/storage.go +++ b/storage/storage.go @@ -53,11 +53,15 @@ func (p ProviderSQL) GetLastChatByAgent(agent string) (*models.Chat, error) { return &resp, err } +// https://sqlite.org/lang_upsert.html +// on conflict was added func (p ProviderSQL) UpsertChat(chat *models.Chat) (*models.Chat, error) { // Prepare the SQL statement query := ` - INSERT OR REPLACE INTO chats (id, name, msgs, agent, created_at, updated_at) + INSERT INTO chats (id, name, msgs, agent, created_at, updated_at) VALUES (:id, :name, :msgs, :agent, :created_at, :updated_at) + ON CONFLICT(id) DO UPDATE SET msgs=excluded.msgs, + updated_at=excluded.updated_at RETURNING *;` stmt, err := p.db.PrepareNamed(query) if err != nil { -- cgit v1.2.3