diff options
| author |  Joe Banks <[email protected]> | 2024-03-26 00:33:38 +0000 |
|---|---|---|
| committer | Joe Banks <[email protected]> | 2024-03-26 00:33:38 +0000 |
| commit | 83c6505c7b6da075d6ed72558e0306079320a1eb (patch) | |
| tree | 780e4ccd8540da8c72d7a78cda7bc588aec6ac54 | |
| parent | Bump version to 2.4.0 (diff) | |
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).
| -rw-r--r-- | metricity/exts/event_listeners/message_listeners.py | 4 |
1 files changed, 3 insertions, 1 deletions
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() |