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)
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 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 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 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 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 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 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 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 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"
for i in praiselist:
session.add(i)
if session.query(Attention).count() == 0:
attentionlist = [
Attention(attention_id=1, attention_userid=1, attention_fansid=2),
Attention(attention_id=2, attention_userid=2, attention_fansid=3),
Attention(attention_id=3, attention_userid=1, attention_fansid=4),
Attention(attention_id=4, attention_userid=2, attention_fansid=1),
Attention(attention_id=5, attention_userid=2, attention_fansid=3),
Attention(attention_id=6, attention_userid=2, attention_fansid=4),
Attention(attention_id=7, attention_userid=3, attention_fansid=1),
Attention(attention_id=8, attention_userid=3, attention_fansid=2),
Attention(attention_id=9, attention_userid=3, attention_fansid=4),
]
for i in attentionlist:
session.add(i)
if session.query(Fans).count() == 0:
fanslist = [
Fans(fans_id=1, fans_name="小黄", fans_img="timer.jgp", fans_userid=1),
Fans(fans_id=2, fans_name="小绿", fans_img="timer.jgp", fans_userid=5),
Fans(fans_id=3, fans_name="小蓝", fans_img="timer.jgp", fans_userid=5),
Fans(fans_id=4, fans_name="小明", fans_img="timer.jgp", fans_userid=5),
]
for i in fanslist:
session.add(i)
session.commit()
session.close()
