# module.answer from sqlalchemy import Table from common.database import dbconnect from module.user import User from module.question import Question dbsession, md, DBase = dbconnect() class Answer(DBase): __table__ = Table('answer', md, autoload=True) # ----------------------------------查询类------------------------------------ # 根据id查找answer def find_by_id(self, id): row = dbsession.query(Answer).filter_by(id=id).first() return row # 按照问题id查找回答 def find_by_idq(self, idq): result = dbsession.query(Answer).filter_by(idq=idq).order_by(Answer.upvote).all() return result # 按照用户id查找回答 def find_by_idu(self, idu): result = dbsession.query(Answer).filter_by(idu=idu).all() return result # 按照用户id查询回答数量
import time from flask import session from common.database import dbconnect from module.users import Users db = dbconnect() class Article(db.Document): articleid = db.SequenceField() userid = db.IntField() type = db.IntField() headline = db.StringField() replycount = db.StringField() content = db.StringField() thumbnail = db.StringField() credit = db.IntField() readcount = db.IntField() commentcount = db.IntField() hidden = db.BooleanField() drafted = db.BooleanField() checked = db.BooleanField() createtime = db.DateTimeField() updatetime = db.DateTimeField() # def find_all(self): result = Article.objects.filter(hidden=False).filter( drafted=False).filter(checked=True).all() return result #