今天测试数据的入对数据库操作的时候出现了报错pymysql.err.InterfaceError: (0, ‘‘)
后来发现,是我把数据库的连接代码放到了函数外边
"""
db = pymysql.connect(host=settings.MYSQL_HOST,
port=settings.MYSQL_PORT,
user=settings.MYSQL_USER,
password=settings.MYSQL_PASSWD,
db=settings.MYSQL_ID_DB,
charset='utf8',
)
cursor = db.cursor()
cursor.execute("SELECT NEXTVAL('item_id');")
data = cursor.fetchone()
db.commit()
item_id = list(data)[0]
db.close()
# -----------------------------------
"""
假如我们把 db = pymysql.connect(XXXXXXXXXXXX) 放到主函数外边 就会导致无法连接数据库