From 83c6505c7b6da075d6ed72558e0306079320a1eb Mon Sep 17 00:00:00 2001 From: Joe Banks Date: Tue, 26 Mar 2024 00:33:38 +0000 Subject: Convert IDs in bulk deletes to strings for DB query. Convert IDs into strings to match the format stored in the database to prevent us receiving mismatching type errors (big int vs. character varying). --- metricity/exts/event_listeners/message_listeners.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/metricity/exts/event_listeners/message_listeners.py b/metricity/exts/event_listeners/message_listeners.py index 1e918e0..a71e53f 100644 --- a/metricity/exts/event_listeners/message_listeners.py +++ b/metricity/exts/event_listeners/message_listeners.py @@ -59,7 +59,9 @@ class MessageListeners(commands.Cog): async def on_raw_bulk_message_delete(self, messages: discord.RawBulkMessageDeleteEvent) -> None: """If messages are deleted in bulk and we have a record of them set the is_deleted flag.""" async with async_session() as sess: - await sess.execute(update(Message).where(Message.id.in_(messages.message_ids)).values(is_deleted=True)) + await sess.execute(update(Message).where( + Message.id.in_([str(mid) for mid in messages.message_ids]), + ).values(is_deleted=True)) await sess.commit() -- cgit v1.2.3