作者:手机用户26536338_53 | 来源:互联网 | 2023-09-18 08:33
Howtofilterinsqlalchemybystringlength?如何按字符串长度过滤sqlalchemy?Thiscodesnippet:这个代码片段:se
How to filter in sqlalchemy
by string length?
如何按字符串长度过滤sqlalchemy ?
This code snippet:
这个代码片段:
sess.query(db.ArticlesTable).filter(or_(
and_(db.ArticlesTable.shorttext.length > 0),
...
gave me the following error:
给了我以下的错误:
File "./aggregate_news.py", line 69, in is_acceptable
db.ArticlesTable.shorttext.length > 0),
File ".../sqlalchemy/orm/attributes.py", line 211, in __getattr__
key)
AttributeError: Neither 'InstrumentedAttribute' object nor 'Comparator'
object associated with ArticlesTable.shorttext has an attribute 'length'
Where ArticlesTable
is:
ArticlesTable在哪里:
class ArticlesTable(Base):
__tablename__ = TABLE_ARTICLES
id = Column(Integer, primary_key=True)
shorttext = Column(String)
...
1 个解决方案