def update_password(self,id,old_password,new_password): try: user = User.query.filter_by(id=id).first() if(user.password != old_password): return ResponseResult.error(ResponseCode.PASSWORD_ERROR) user.password = new_password db.session.commit() return ResponseResult.success() except: return ResponseResult.error()
def add_user(self,user_name, phone, password, email): if(self.check_add_param(user_name,phone,email,password)): return ResponseResult.error(ResponseCode.PARAM_IS_NULL) # 创建时间 created_time = datetime.datetime.now() user = User(user_name, phone, password, email,created_time) try: db.session.add(user) db.session.commit() return ResponseResult.success() except: return ResponseResult.error()
def login(self,phone,password): try: print(phone) print(password) user = User.query.filter_by(phone=phone,password=password).first() print(user) if(user): return ResponseResult.success(data=user.to_json()) else: return ResponseResult.error(ResponseCode.LOGIN_ERROR) except: return ResponseResult.error()
def delete_user(self,id): try: User.query.filter_by(id=id).delete() db.session.commit() return ResponseResult.success() except: return ResponseResult.error()
def getHotWeiboList(self, orderBy, weibo_keywords, topic_keywords, limit, page): print(orderBy) if (orderBy == 1): orderBy = Weibo.comments_count.desc() elif (orderBy == 2): orderBy = Weibo.attitudes_count.desc() elif (orderBy == 3): orderBy = Weibo.reposts_count.desc() else: return ResponseResult.error() if (weibo_keywords != None and weibo_keywords != ''): if (topic_keywords != None and topic_keywords != ''): data = Weibo.query.filter( Weibo.text.contains(weibo_keywords), Weibo.topics.contains(topic_keywords)).order_by( orderBy).all() else: data = Weibo.query.filter(Weibo.text.contains( weibo_keywords)).order_by(orderBy).all() else: if (topic_keywords != None and topic_keywords != ''): data = Weibo.query.filter(Weibo.topics.contains( topic_keywords)).order_by(orderBy).all() else: data = Weibo.query.order_by(orderBy).all() start = (page - 1) * limit end = page * limit if len(data) > page * limit else len(data) result = [] for i in range(start, end): result.append(data[i].to_json()) return ResponseResult.lay_success(data=result, count=len(data))
def update_user(self,id,user_name,phone,email): try: User.query.filter_by(id=id).update({"user_name":user_name,"phone":phone,"email":email}) db.session.commit() user = User.query.filter_by(id=id).first() return ResponseResult.success(data=user.to_json()) except: return ResponseResult.error()
def get_user(self,id): try: print(id) user = User.query.filter_by(id=id).first() print(user.user_name) return ResponseResult.success(data=user.to_json()) except: return ResponseResult.error()
def register(self,user_name, phone, password, email): user = userService.get_user_by_phone(phone) if(user): return ResponseResult.error(ResponseCode.PHONE_EXIST_ERROR) return userService.add_user(user_name, phone, password, email)