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()