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