如何生成一个允许in_
子句的^{
class Version(Base):
version_id = Column(Integer, primary_key=True)
package_id = Column(Integer, ForeignKey('package.package_id')
version = Column(String(32), index=True)
@hybrid_property
def pkg_id_concat_vers(self):
# "23~~0.2.4"
return "{}~~{}".format(self.package_id, self.version)
# TODO
#@pkg_id_concat_vers(self):
# pass
# Using the naive `(not) in` doesn't actually apply the filter
data = ['23~~0.2.4', '57~~0.0.1']
result = (session.query(Version)
.filter(Version.pkg_id_concat_vers in data)
).all()
# Using `in_()` throws an Attribute Error, as it's a string.
data = ['23~~0.2.4', '57~~0.0.1']
result = (session.query(Version)
.filter(Version.pkg_id_concat_vers.in_(data))
).all()
SQLAlchemy在类型为
String
的表达式上支持+
运算符,因此可以将列强制转换为String
,然后执行如下操作:相关问题 更多 >
编程相关推荐