知乎专栏 |
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()