def hosUser(self): self.session = self.getSession() datas = self.session.query(TUser).order_by(desc(TUser.fans), desc(TUser.video)).all()[:10] print "datas:", datas all_data = [] for data in datas: try: user_id = data.id video = self.session.query(VVideo).filter_by(user_id=user_id).order_by(desc(VVideo.create_date)).first() video.native_path = URL.make_video_url(video.native_path) video.native_img_path = URL.make_img_url(video.native_img_path) # 获取当前视频数 video_count = self.session.query(VVideo).filter_by(user_id=user_id).count() video.count = video_count except Exception, e: # 点击获取热门用户后查询出他们的最新视频 print e continue all_data.append({user_id: video})
def ListFollower(self, user_id): self.session = self.getSession() followers = self.session.query(FFollower).filter_by(user_id=user_id).all() # 查询出关注的用户的情况 all_data = [] for follower in followers: # 根据用户ID,查询出用户的最新视频 try: user_id = follower.follower_user.id video = self.session.query(VVideo).filter_by(user_id=user_id).order_by(desc(VVideo.create_date)).first() video.native_path = URL.make_video_url(video.native_path) video.native_img_path = URL.make_img_url(video.native_img_path) # 获取当前视频数 video_count = self.session.query(VVideo).filter_by(user_id=user_id).count() video.count = video_count except Exception, e: print e continue all_data.append({user_id: video})