我想把一个包含不和谐邀请的列表保存到我的数据库中。但每次我运行这段代码时,get在数据库中只保存了1项。我试图打印邀请者ID以检查他是否只运行一个项目,但他为每个项目运行代码。那怎么了?为什么get只有一个项目保存到数据库中?
for invite in invites:
if invite.inviter is None:
continue
if not ctx.author.guild.get_member(int(invite.inviter.id)):
continue
if int(invite.uses) == 0:
continue
await cursor.execute("SELECT * FROM guild_invite_count WHERE guild_id = %s AND user_id = %s IS NOT NULL", (ctx.author.guild.id, invite.inviter.id))
find_user = await cursor.fetchone()
if find_user:
await cursor.execute("UPDATE guild_invite_count SET real_count = real_count + %s, total_count = total_count + %s WHERE guild_id = %s AND user_id = %s", (int(invite.uses), int(invite.uses), ctx.author.guild.id, invite.inviter.id))
else:
await cursor.execute("INSERT INTO guild_invite_count (guild_id, user_id, real_count, total_count) VALUES (%s, %s, %s, %s)", (ctx.author.guild.id, invite.inviter.id, int(invite.uses), int(invite.uses)))
print(invite.inviter.id)
await mydb.commit()