def updateVoteByAnswerId(cls, answer_id, type, against_count, agree_count):
session = DBSession()
# 0反对票, 1赞同票
# if type == '-1' :
# print 'update against_count'
# session.query(cls).filter(cls.answer_id == answer_id).update({cls.against_count:count})
# elif type == '1' :
# print 'update agree_count'
# session.query(cls).filter(cls.answer_id == answer_id).update({cls.agree_count:count})
session.query(cls).filter(cls.answer_id == answer_id).update({cls.against_count:against_count, cls.agree_count:agree_count})
session.commit()
session.close()
def queryByAnswerId(cls, answerId, voteValue): session = DBSession() name = session.query(AutoUser.name).filter(AutoUser.id == AnswerVote.vote_uid, AnswerVote.answer_id == answerId, AnswerVote.vote_value == voteValue).distinct().all() namelist = [] for str in name : namelist.append(str[0]) return namelist
def queryByUserId(cls, userid): session = DBSession() u = session.query(cls).filter(cls.id==userid).first() if not u: return None else: return u
def queryByUsername(cls, username): """ 按用户名查询用户 """ session = DBSession() u = session.query(cls).filter(cls.user_name==username).first() if not u: return None else: return u
def queryByUserIdAndLinkId(cls, userId, linkid): session = DBSession() userVote = session.query(cls).filter(cls.user_id == userId, cls.link_id == linkid).first() session.close() if not userVote: return False else: print userVote return userVote
def checkEmail(cls, email): ''' 检查邮箱是否已经被注册 ''' session = DBSession() u = session.query(cls).filter(cls.email==email).first() if not u: return False else: return u print 'hi'
def checkUsername(cls, username): ''' 检查用户名是否已经被注册 ''' session = DBSession() u = session.query(cls).filter(cls.name==username).first() if not u: return False else: return u print 'hi'
def queryUser(cls, username, password): # 创建session对象: session = DBSession() u = session.query(cls).filter(cls.name==username).first() if not u: return False hashed_password = bcrypt.hashpw(password, tornado.escape.utf8(u.hashed_password)) if u.hashed_password == hashed_password: return u else: print 'wrong password' return False
def unfollow(cls, fansUid, friendUid): ''' 取消关注 ''' # 创建session对象: session = DBSession() ret = session.query(cls).filter(cls.friend_uid==friendUid, cls.fans_uid==fansUid).delete() session.commit() session.close() # 更新uid为fansUid的关注人数和粉丝数 following = cls.countFollowing(fansUid) follower = cls.countFollower(fansUid) Users.updateFollowCount(fansUid, follower, following) # 更新uid为friendUid的关注人数和粉丝数 following = cls.countFollowing(friendUid) follower = cls.countFollower(friendUid) Users.updateFollowCount(friendUid, follower, following) return True
def queryById(cls, questionId):
session = DBSession()
question = session.query(cls).filter(cls.question_id == questionId).first()
return question
def queryAllQuestions(cls):
session = DBSession()
questions = session.query(cls)
return questions
def addQuestion(cls, question_content, question_detail, published_uid):
obj = cls(question_content = question_content, question_detail = question_detail,
published_uid = published_uid, add_time = long(time.time()), update_time = long(time.time()))
session = DBSession()
session.add(obj)
session.commit()
session.close()
return True
if __name__ == "__main__":
# 创建session对象:
session = DBSession()
# 创建新User对象:
#new_user = AutoUser(id='6', name='Bob', hashed_password='******', email = '*****@*****.**')
# 添加到session:
#session.add(new_user)
query = session.query(Question)
for question in query:
print question.question_content
print question.question_detail
print question.comment_count
# 提交即保存到数据库:
session.commit()
# 关闭session:
session.close()
def queryPageCount(cls): session = DBSession() count = session.query(cls)
def queryAll(cls): session = DBSession() linkList = session.query(cls) return linkList
def followerList(cls, uid): ''' 获取用户粉丝名单，uid, url_token, ''' # 创建session对象: session = DBSession() ret = session.query(Users.uid, Users.user_name, Users.url_token).filter(cls.friend_uid == uid, Users.uid == cls.fans_uid).all() return ret
def updateByUserIdAndLinkId(cls, userId, linkid, type):
session = DBSession()
session.query(cls).filter(cls.user_id == userId, cls.link_id == linkid).update({cls.type: type})
session.commit()
session.close()
return True
def queryByAnswerId(cls, answerId): session = DBSession() answer = session.query(cls).filter(cls.answer_id == answerId).first() print "answer[0].uid", answer.uid return answer
def countFollower(cls, uid): ''' 查询被关注人数 ''' # 创建session对象: session = DBSession() follower = session.query(cls).filter(cls.friend_uid==uid).count() return follower
def countFollowing(cls, uid): ''' 查询关注人数 ''' # 创建session对象: session = DBSession() following = session.query(cls).filter(cls.fans_uid==uid).count() return following
def queryIsFollowed(cls, fansUid, friendUid): ''' 查询是否关注 ''' # 创建session对象: session = DBSession() count = session.query(cls).filter(cls.friend_uid==friendUid, cls.fans_uid==fansUid).count() return count
def queryByFriendUidId(cls, friendUid): # 创建session对象: session = DBSession() fans = session.query(cls).filter(cls.friend_uid==friendUid).all() return fans
def queryAllUsers(cls): # 创建session对象: session = DBSession() u = session.query(cls).all() return u
def deleteByUserIdAndLinkId(cls, userId, linkid): session = DBSession() session.query(cls).filter(cls.user_id == userId, cls.link_id == linkid).delete() session.commit() session.close() return True
def updateFollowCount(cls, uid, fans_count, friend_count):
session = DBSession()
session.query(cls).filter(cls.uid == uid).update({cls.fans_count:fans_count, cls.friend_count:friend_count})
session.commit()
session.close()
def queryByFansUid(cls, fansUid):
# 创建session对象:
session = DBSession()
follows = session.query(cls).filter(cls.fans_uid == fansUid).all()
return follows
def queryByAnswerId(cls, answerId): session = DBSession() answer = session.query(cls).filter(cls.answer_id == answerId) return answer
def queryByQuestionId(cls, questionId): session = DBSession() answers = session.query(cls).filter(cls.question_id == questionId).all() return answers
def queryById(cls, catalogId): session = DBSession() answer = session.query(cls).filter(cls.id == catalogId) return answer
def queryById(cls, sessionId): session = DBSession() captcha = session.query(cls).filter(cls.session_id == session_id) return captcha
def queryByUserId(cls, userId): session = DBSession() userVotes = session.query(cls).filter(cls.user_id == userId).first() return userVotes
