aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--metricity/exts/event_listeners/startup_sync.py5
1 files changed, 4 insertions, 1 deletions
diff --git a/metricity/exts/event_listeners/startup_sync.py b/metricity/exts/event_listeners/startup_sync.py
index 017ea1f..554f952 100644
--- a/metricity/exts/event_listeners/startup_sync.py
+++ b/metricity/exts/event_listeners/startup_sync.py
@@ -7,6 +7,7 @@ from discord.ext import commands
from pydis_core.utils import logging, scheduling
from sqlalchemy import column, select
from sqlalchemy.dialects.postgresql import insert
+from sqlalchemy.orm import load_only
from metricity import models
from metricity.bot import Bot
@@ -95,7 +96,9 @@ class StartupSyncer(commands.Cog):
users_updated = 0
guild_member_ids = {str(member.id) for member in guild.members}
async with async_session() as sess:
- res = await sess.execute(select(models.User).filter_by(in_guild=True))
+
+ stmt = select(models.User).filter_by(in_guild=True).options(load_only(models.User.id))
+ res = await sess.execute(stmt)
in_guild_users = res.scalars()
for user in in_guild_users:
if user.id not in guild_member_ids: