discord.py：MySQL"游标未连接"

Question

在踢开一个公会成员之前，我正在尝试将数据存储在本地数据库中。我在另一个文件中设置了数据库。我正在另一个文件中调用kick函数。我注意到的是，有时它有效，当我再次这样做时，它就不再有效了。

我的代码：

# Database.py
import os
import mysql.connector
from dotenv import load_dotenv
load_dotenv()

def modlog_db_connex():
class ModLogDB:
def __init__(self, connection, mycursor):
self.connection = connection
self.mycursor = mycursor
modlog_db = mysql.connector.connect(
host=os.getenv("DB_HOST"),
user=os.getenv("DB_USERNAME"),
password=os.getenv("DB_PASSWORD"),
database=os.getenv("DB_NAME"),
use_unicode=True
)
mycursor = modlog_db.cursor()
return ModLogDB(modlog_db, mycursor)

# Kick.py
import discord
import GlobalSupport
import Database
moderator_above = GlobalSupport.moderator_above
modlog_db = Database.modlog_db_connex()

async def kick(client, ctx, member, reason):

author_id = ctx.author.id
log_channel = GlobalSupport.moderation_logs
if any(role.id in moderator_above for role in ctx.author.roles) and author_id != int(member.id):
if reason is None:
reason = "None provided."
sql = "INSERT INTO RLH_Cases_v2 (UserID, ModeratorID, CaseType, Reason) VALUES (%s, %s, %s, %s)"
val = (str(member.id), str(ctx.author.id), "Kick", reason)
modlog_db.mycursor.execute(sql, val)
modlog_db.connection.commit()
case_id = str(modlog_db.mycursor.lastrowid)
modlog_db.connection.close()
# ...

错误：

Traceback (most recent call last):
File "C:UsersuserDesktopTeam Stuff (TS, DC, MC)RLHProgrammingOnMessage.py RewriteCommandsKick.py", line 31, in kick
modlog_db.mycursor.execute(sql, val)
File "C:UsersuserAppDataLocalProgramsPythonPython38libsite-packagesmysqlconnectorcursor_cext.py", line 242, in execute
raise errors.ProgrammingError("Cursor is not connected", 2055)
mysql.connector.errors.ProgrammingError: 2055: Cursor is not connected

Answer 1

每次kick后都会关闭与MySQL数据库的连接，在再次调用kick之前不要重新连接。