# 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
#
