dkforest

commit 0a5d9b8a6ad12279e208898a8fb49d5aeb9011c7
parent e46fdf9969e4b21bf548b448a2920cbe964a8426
Author: n0tr1v <n0tr1v@protonmail.com>
Date:   Thu, 25 May 2023 19:13:14 -0700

add fn to incr all rev of msgs above a certain id

Diffstat:
M
pkg/database/tableChatMessages.go
 | 
7
+++++++

1 file changed, 7 insertions(+), 0 deletions(-)
diff --git a/pkg/database/tableChatMessages.go b/pkg/database/tableChatMessages.go
@@ -256,6 +256,13 @@ func (d *DkfDB) GetUserLastChatMessageInRoom(userID UserID, roomID RoomID) (out 
 	return
 }
 
+func (d *DkfDB) RoomChatMessagesGeIncrRev(roomID RoomID, chatMessageID int64) (err error) {
+	err = d.db.
+		Exec(`UPDATE chat_messages SET rev = rev + 1  WHERE room_id = ? AND id >= ?`, roomID, chatMessageID).
+		Error
+	return
+}
+
 func (d *DkfDB) GetRoomChatMessages(roomID RoomID) (out ChatMessages, err error) {
 	err = d.db.
 		Where("room_id = ?", roomID).