def getidbytoken(self, usertokenstr): # 重要
session = DBSession()
try:
userid = session.query(Usertoken.usertoken_userid).filter_by(
usertoken_str=usertokenstr).one()
return userid[0]
except Exception as a:
print(a)
def getidbyname(self, username):
session = DBSession()
try:
userid = session.query(
User.user_id).filter_by(user_name=username).one()
return userid[0]
except Exception as a:
print(a)
def checkuserexist(self, username):
session = DBSession()
try:
if session.query(User).filter_by(user_name=username).count() > 0:
return True
except Exception as a:
print(a)
return "False"
else:
return False
def getuserid(self, username):
session = DBSession()
try:
userid = session.query(
User.user_id).filter_by(user_name=username).all()
item = {}
item["user_id"] = userid[0] # .decode("utf-8")
return item
except Exception as a:
print(a)
return False
def userlogin(self, username, userpassword): # 通过账号密码登录
session = DBSession()
try:
if session.query(User).filter_by(
user_name=username,
user_password=userpassword).count() > 0:
return True
except Exception as a:
print(a)
return "False"
else:
return False
def Forumshowme(self,usertokenstr): #显示我的帖子
session = DBSession()
try:
if session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).count() > 0:
userid = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).one()
userinfoid =session.query(Userinfo.userinfo_id).filter_by(userinfo_userid=userid[0]).one()
lista = session.query(Forum.forum_id, Forum.forum_title, Forum.forum_publishtime,Forum.forum_userinfoid).filter_by(forum_userinfoid=userinfoid[0]).all()
listb = []
print(lista)
for i in lista:
item = {}
forumpromulgator = session.query(User.user_name).filter_by(userinfo_id=i[4]).one()
item["forum_promulgator"] = forumpromulgator[0]
item["forum_id"] = i[0]
item["forum_title"] = i[1]
item["forum_publishtime"] = i[2]
praisenum = session.query(Praise).filter_by(praise_forumid=i[0]).count()
item["praise_number"] = praisenum
listb.append(item)
listb.sort(key = lambda x:x["forum_publishtime"], reverse = True)
return listb
except Exception as a:
print(a)
return "False"
def addattention(self,usertokenstr,userid): #增加关注
session = DBSession()
try:
userid1 = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).one()
session.add(Attention(attention_userid=userid,attention_fansid=userid1[0]))
session.commit()
session.close()
return True
except Exception as a:
print(a)
return False
def cancleattention(self,usertokenstr,userid): #取消关注
session = DBSession()
try:
userid1 = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).one()
session.query(Attention).filter(Attention.attention_userid==userid,Attention.attention_fansid==userid1[0]).delete()
session.commit()
session.close()
return True
except Exception as a:
print(a)
return False
def forumcommentpublish(self,usertoken,forumid,commentcontent):#发布帖子的评论
session = DBSession()
try:
userid = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertoken).one()
userinfoid = session.query(Userinfo.userinfo_id).filter_by(userinfo_userid=userid[0]).one()
nowtime = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime())
session.add(Comment(comment_forumid=forumid,
comment_userinfoid=userinfoid[0],
comment_content=commentcontent,
comment_time=nowtime))
session.commit()
session.close()
return True
except Exception as a:
print(a)
return "False"
def publishforum(self,usertoken,forumtitle,forumdesp):
session = DBSession()
try:
userid = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertoken).one()
userinfoid = session.query(Userinfo.userinfo_id).filter_by(userinfo_userid=userid[0]).one()
nowtime = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime())
session.add(Forum(forum_userinfoid=userinfoid[0],
forum_title=forumtitle,
forum_publishtime=nowtime,
forum_desp=forumdesp))
session.commit()
session.close()
return True
except Exception as a:
print(a)
return "False"
def forumdefshow(self, usertokenstr): # 帖子首页
session = DBSession()
try:
if session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).count() > 0:
lista = session.query(Forum.forum_id, Forum.forum_title, Forum.forum_publishtime,
Forum.forum_userinfoid).order_by(desc(Forum.forum_publishtime)).all()
listb = []
print(lista)
for i in lista:
item = {}
forumpromulgator = session.query(User.user_name).filter_by(userinfo_id=i[4]).one()
item["forum_id"] = i[0]
item["forum_title"] = i[1] # 帖子标题
item["forum_publishtime"] = i[2]
praisenum = session.query(Praise).filter_by(praise_forumid=i[0]).count()
item["praise_number"] = praisenum
collectnum = session.query(Comment).filter_by(comment_forumid=i[0]).count()
item["comment_number"] = collectnum
listb.append(item)
return listb
except Exception as a:
print(a)
return "False"
def judgeanswer(self, username, userquestion1, useranswer1):
session = DBSession()
try:
print("$$$$$$$$$$$$$$$$$$$$$$4", userquestion1)
print("%%%%%%%%%%%%%%%%%5", useranswer1)
if session.query(User).filter_by(
user_name=username,
user_question=userquestion1).count() > 0:
print("$$$$$$$$$$$$$$$$$$$$$$4", useranswer1)
if session.query(User).filter_by(
user_name=username,
user_answer=useranswer1).count() > 0:
return 3
return 1
return 2
except Exception as a:
print(a)
return "False"
def tokendelete(self, usertoken):
session = DBSession()
try:
session.query(Usertoken).filter_by(
usertoken_str=usertoken).delete()
session.commit()
session.close()
return True
except Exception as a:
print(a)
return False
def changepassword(self, userid, usernewpassword):
session = DBSession()
try:
session.query(User).filter_by(user_id=userid).update(
{'user_password': usernewpassword})
session.commit()
session.close()
return True
except Exception as a:
print(a)
return False
def delectforum(self,usertokenstr,forumid):
session = DBSession()
try:
session.query(Forum).filter_by(forum_id=forumid).delete()
session.commit()
session.close()
return True
except Exception as a:
print(a)
return False
def modifypassword(self, usertokenstr, usernewpassword):
session = DBSession()
a = Userorml()
try:
userid = a.getidbytoken(usertokenstr)
session.query(User).filter_by(user_id=userid).update(
{'user_password': usernewpassword})
session.commit()
session.close()
return True
except Exception as a:
print(a)
return "False"
def ownfans(self,usertokenstr):
session = DBSession()
try:
if session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).count() > 0:
userid = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).one()
fansid = session.query(Attention.attention_fansid).filter_by(attention_userid=userid[0]).all()#查找出所有的fans用户id
listb = []
for j in fansid:
lista = session.query(Userinfo.userinfo_img,User.user_name,).filter_by(userinfo_userid=j[0]).all()
print(lista)
for i in lista:
item = {}
item["userinfo_img"] = i[0]
item["userinfo_name"] = i[1]
listb.append(item)
return listb
except Exception as a:
print(a)
return "False"
def usertokenadd(self, username):
session = DBSession()
try:
usertoken = str(uuid.uuid4())
print(usertoken)
a = Userorml()
userid = a.getidbyname(username)
print(userid)
session.add(
Usertoken(usertoken_str=usertoken, usertoken_userid=userid))
session.commit()
session.close()
return usertoken
except Exception as a:
print(a)
return "False"
def modifyforum(self,usertoken,forumid,forumtitle,forumdesp):
session = DBSession() #bookclass表
try:
#userid = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertoken).one()会出现访问不到的错误
#print("$$$$$$$$$$$$$$$",userid)
#usercollege = session.query(Userinfo.userinfo_college).filter_by(userinfo_userid=userid[0]).one()
#print("&&&&&&&&&&&&&&&",usercollege[0])
nowtime = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime())
session.query(Forum).filter_by(forum_id=forumid).update({"forum_title":forumtitle,
"forum_desp":forumdesp,
"forum_publishtime":nowtime,
})
session.commit()
session.close()
return True
except Exception as a:
print(a)
def modifyquestion(self, usertokenstr, usernewquestion, usernewanswer):
session = DBSession()
a = Userorml()
try:
userid = a.getidbytoken(usertokenstr)
print(2222222222222)
print(userid)
session.query(User).filter_by(user_id=userid).update({
'user_question':
usernewquestion,
'user_answer':
usernewanswer
})
session.commit()
session.close()
return True
except Exception as a:
print(a)
return "False"
def personalcencer(self,usertokenstr):
session = DBSession()
try:
if session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).count() > 0:
userid = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).one()
lista = session.query(Userinfo.userinfo_img,).filter_by(userinfo_userid=userid[0]).all()
listb = []
for i in lista:
item = {}
item["userinfo_img"] = i[0]
item["userinfo_name"] = i[1]
attentionnum = session.query(Attention).filter_by(attention_fansid=userid[0]).count()
item["userinfo_attentionnum"] = attentionnum
fansnum = session.query(Attention).filter_by(attention_userid=userid[0]).count()
item["userinfo_fansnum"] = fansnum
listb.append(item)
return listb
except Exception as a:
print(a)
return "False"
def showotherinfo(self,usertokenstr,userid):
session = DBSession()#显示他人信息
try:
if session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertokenstr).count() > 0:
lista = session.query(Userinfo.userinfo_img,User.user_name,).filter_by(userinfo_userid=userid).all()
listb = []
print(lista)
for i in lista:
item = {}
item["userinfo_img"] = i[0]
item["userinfo_name"] = i[1]
attentionnum = session.query(Attention).filter_by(attention_fansid=userid).count()
item["userinfo_attentionnum"] = attentionnum
fansnum = session.query(Attention).filter_by(attention_userid=userid).count()
item["userinfo_fansnum"] = fansnum
listb.append(item)
return listb
except Exception as a:
print(a)
return "False"
def forumpraise(self,usertoken,forumid,praisestatus):
session = DBSession()
try:
userid = session.query(Usertoken.usertoken_userid).filter_by(usertoken_str=usertoken).one()
if int(praisestatus) == 1 and session.query(Forum).filter_by(forum_id = forumid).count()>0:
session.query(Praise).filter_by(praise_forumid = forumid, praise_userid = userid[0]).delete()
session.commit()
session.close()
return "0"
elif int(praisestatus) == 0:
if session.query(Praise).filter_by(praise_forumid =forumid,praise_userid = userid[0]).count()>0:
return "False"
else:
nowtime = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime())
session.add(Praise(praise_forumid = forumid, praise_userid = userid[0]))
session.commit()
session.close()
return "1"
else:
return "False"
except Exception as a:
print(a)
return "False"
def adduser(self, username, userpassword, userquestion, useranswer):
session = DBSession()
try:
if username != "" and not self.checkuserexist(username):
session.add(
User(user_name=username,
user_password=userpassword,
user_question=userquestion,
user_answer=useranswer))
session.commit()
session.close() # 数据库表连接后，操作后，要关闭
session = DBSession()
userid = session.query(
User.user_id).filter_by(user_name=username).one()
session.add(
Userinfo(userinfo_userid=userid[0])) # 通过userid链接两个表
session.commit()
session.close()
return True
else:
return False
except Exception as a:
print(a)
#注意这里必须先引入model from dbmodels.usermodel import User from dbmodels.usertokenmodel import Usertoken from dbmodels.userinfomodel import Userinfo from dbmodels.picturemodel import Picture from dbmodels.praisemodel import Praise from dbmodels.commentmodel import Comment from dbmodels.forummodel import Forum from dbmodels.attentionmodel import Attention from dbmodels.fansmodel import Fans from orml.dbbase import engine from orml.dbbase import Base from orml.dbbase import DBSession Base.metadata.create_all(engine) import orml.createvalue session = DBSession()
from orml.dbbase import DBSession
from dbmodels.usermodel import User
from dbmodels.usertokenmodel import Usertoken
from dbmodels.userinfomodel import Userinfo
from dbmodels.picturemodel import Picture
from dbmodels.praisemodel import Praise
from dbmodels.commentmodel import Comment
from dbmodels.forummodel import Forum
from dbmodels.attentionmodel import Attention
from dbmodels.fansmodel import Fans
session = DBSession()
if session.query(User).count() == 0:
userlist = [
User(user_id=1,
user_name="小红",
user_password="******",
user_question="我多少岁",
user_answer="18"),
User(user_id=2,
user_name="小明",
user_password="******",
user_question="我来自哪里",
user_answer="贵阳"),
User(user_id=3,
user_name="小蓝",
user_password="******",
user_question="我读哪个大学",
user_answer="贵大"),
User(user_id=4,
def forumallshow(self,usertoken,forumid):
session = DBSession()
if session.query(Usertoken.usertoken_userid).filter_by(usertoken_str = usertoken).count()>0:
try:
userinfoid = session.query(Forum.forum_userinfoid).filter_by(forum_id=forumid).one()
userinfoimg = session.query(Userinfo.userinfo_img).filter_by(userinfo_id = userinfoid[0]).one()
userinfoname = session.query(User.user_name).filter_by(userinfo_id = userinfoid[0]).one()
item = {}
lista = []
lista = session.query(Forum.forum_id,Forum.forum_title,Forum.forum_publishtime,Forum.forum_desp).filter_by(forum_id=forumid).all()
for i in lista:
item["forum_id"] = i[0]
item["forum_userimg"] = userinfoimg[0]
item["forum_username"] = userinfoname[0]
item["forum_title"] = i[1]
item["forum_publishtime"] = i[2]
item["forum_desp"] = i[3]
praisenum = session.query(Praise).filter_by(praise_forumid=forumid).count()
item["praise_number"] = praisenum
listc = session.query(Comment.comment_id,Comment.comment_content,Comment.comment_time,Comment.comment_userinfoid).filter_by(comment_forumid = forumid).all()
commentlist = []
for j in listc:
comer = {}
comer["comment_id"] = j[0]
name = session.query(User.user_name).filter_by(userinfo_id=j[3]).one()
comer["comment_name"] = name[0]
img = session.query(Userinfo.userinfo_img).filter_by(userinfo_id=j[3]).one()
comer["comment_userimg"] = img[0]
comer["comment_content"] = j[1]
comer["comment_time"] = j[2]
commentlist.append(comer)
commentlist.sort(key = lambda x : x['comment_time'],reverse=False)
# item["book_comments"] = commentlist
# return item
except Exception as a:
print(a)
return "False"