Skip to main content
 首页 » 编程设计

python之SQLAlchemy:难以查询我的数据库

2024年10月24日14cmt

我正在编写一个小的 Python 脚本/应用程序,并且刚刚开始接触 SQLAlchemy。我唯一的类是“Player”,定义如下:

class Player: 
    def __init__(self,  rating, college, ranking = None, firstName = None, lastName = None): 
        self.rating = rating 
        self.college = college 
        self.ranking = ranking 
        self.firstName = firstName 
        self.lastName = lastName 

现在我有一个名为 databaseFunctions.py 的模块,在其中我有这两个函数:

#if player exists, update his rating and ranking; otherwise, add new object to DB 
def updateSpecificDBEntry(playerObject, session): 
    #find player in DB with firstName and lastName 
    currentPlayer = session.query(Player).filter(firstName == playerObject.firstName).filter(playerObject.lastName == lastName).first() 
    #set rating = newRating 
    if currentPlayer.count(): 
        currentPlayer.rating = playerObject.rating 
        currentPlayer.ranking = playerObject.ranking 
    else: 
        addEntryToDB(playerObject, session) 
 
def updateEntireDB(arrayOfPlayerObjects, session): 
    for player in arrayOfPlayerObjects: 
        updateSpecificDBEntry(player, session) 

这是我的主要方法:

def main(): 
    #create engine (for use by base and session) 
    engine = databaseFunctions.createEngine() 
    #create session 
    session = databaseFunctions.createSession(engine) 
    #get all players from CSA website 
    allPlayers = getSortedGender(constants.mainURL, constants.menTeams) 
    databaseFunctions.updateEntireDB(allPlayers, session) 

我的代码实际上一直运行到最后一个函数调用。此时,我收到以下错误:

  File "helpfulFunctions.py", line 114, in <module> 
    main() 
  File "helpfulFunctions.py", line 107, in main 
    databaseFunctions.updateEntireDB(allPlayers, session) 
  File "/Users/benjaminclayman/Desktop/SquashScraper/databaseFunctions.py", line 42, in updateEntireDB 
    updateSpecificDBEntry(player, session) 
  File "/Users/benjaminclayman/Desktop/SquashScraper/databaseFunctions.py", line 32, in updateSpecificDBEntry 
    currentPlayer = session.query(Player).filter(firstName == playerObject.firstName).filter(playerObject.lastName == lastName).first() 
NameError: global name 'firstName' is not defined 

我有点困惑,因为我正在查询数据库中的所有 Player 对象,以查找其名字与传入的 playerObject 的 firstName 匹配且其最后一个匹配的条目名称与传入的 playerObject 的 lastName 匹配。

知道我为什么会收到此错误吗?

我最初在 main() 中调用了这个函数,但没有使用它,所以把它去掉了:

def createBase(engine):   
    Base = declarative_base() 
    Base.metadata.create_all(engine) 
    return Base 

就像我说的那样:

Base = databaseFunctions.createBase(engine) 

然后不对 Base 做任何事情。不确定这是否是问题的一部分。

感谢您的帮助, 布莱曼

请您参考如下方法:

在您的 updateSpecificDBEntry 过滤器中,您有:

.filter(firstName == playerObject.firstName)

变量“firstName”不存在。

看起来你的意思是这样的:

currentPlayer = session.query(Player).filter(Player.firstName == playerObject.firstName).filter(playerObject.lastName == Player.lastName).first()

所以您要根据给定的 playerObject 属性过滤 Player 列。