sqlalchemy 获取计数 count
2021-05-17 本文已影响0人
晓函
from sqlalchemy import func
message_count = self.db.query(func.count(Message.uid)).filter(Message.uid == self.uid, Message.msg_readstatus == MessageStatus.un_read.value).scalar()
from sqlalchemy import func
message_count = self.db.query(func.count(Message.uid)).filter(Message.uid == self.uid, Message.msg_readstatus == MessageStatus.un_read.value).scalar()