| 知乎专栏 |
exist = (
session.query(PictureLike)
.filter(
PictureLike.android_id == android_id,
PictureLike.picture_id == picture_id,
)
.exists()
)
输出结果
EXISTS (SELECT 1 FROM picture_like WHERE picture_like.android_id = :android_id_1 AND picture_like.picture_id = :picture_id_1)
from sqlalchemy import exists
it_exists = Session.query(
exists().where( SomeObject.field==value )
).scalar()