Sqlalchemy.类型错误:filter_by() 只需要 1 个参数(给定 2 个)

问题描述

我将 sqlalchemy 从 0.7 升级到 0.9.6.升级后出现以下错误:

I upgraded sqlalchemy from 0.7 to 0.9.6. After upgrade I am getting the following error:

TypeError
TypeError: filter_by() takes exactly 1 argument (2 given)

但是在它正常工作之前没有任何问题.我该如何解决这个问题?

howerver before it was working without any issue. How can I manage that issue?

推荐答案

没有看到代码，显然你在调用 filter_by 错误.filter_by 只接受隐含的 self('exactly 1 argument' 表示恰好 1 个位置参数)和可选的关键字参数.您正在提供 filter_by 另一个位置参数，可能是字典.

Without seeing code, obviously you are calling filter_by wrong. filter_by takes only the implicit self (the 'exactly 1 argument' meaning exactly 1 positional argument) and optional keyword arguments. You are providing filter_by another positional argument, possibly a dictionary.

语法是:

query.filter_by(column1=value, column2=value)

而对于 filter:

query.filter(Model.column1 == value, Model.column2 == value)

这篇关于Sqlalchemy.类型错误:filter_by() 只需要 1 个参数(给定 2 个)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！