Python3 函数返回值

Question

我相信我的函数有些不正确，但我对 python 和一般函数仍然很陌生，我错过了我的问题。 在下面的代码中，我没有向函数发送任何值，但是一旦函数读取数据库，我希望它将值从数据库拉回主程序。 我在函数内部放置了一个 print 语句，以确保它从数据库中提取值并且一切正常。 我在主区域的函数调用之后立即复制并粘贴了相同的打印行，但我得到了一个NameError: 'wins' is not defined. 这让我相信我没有正确返回值？

#Python3
import pymysql
def read_db():
    db = pymysql.connect(host='**********',user='**********',password='**********',db='**********')
    cursor = db.cursor()
    sql = "SELECT * FROM loot WHERE id = 1"
    cursor.execute(sql)
    results = cursor.fetchall()
    for row in results:
        wins = row[2]
        skips = row[3]
        lumber1 = row[4]
        ore1 = row[5]
        mercury1 = row[6]
    db.commit()
    db.close()
    print ("Wins = ",wins," Skips = ",skips," Lumber = ",lumber1," Ore = ",ore1," Mercury = ",mercury1)
    return (wins, skips, lumber1, ore1, mercury1)
read_db()
print ("Wins = ",wins," Skips = ",skips," Lumber = ",lumber1," Ore = ",ore1," Mercury = ",mercury1)

Answer 1

只执行read_db()会导致返回值被抛出。您需要将返回值分配给变量：

wins, skips, lumber, ore = read_db()

您返回一个名为 wins 的变量这一事实并不意味着wins变量将在您调用read_db()的作用域中可用。您需要显式分配返回值。