def followed_posts(self):
followedid = mysql.All('followers', {"follower_id": self.id},
['followed_id'])
tmp = ""
for i in followedid:
tmp += str(i[0]) + ","
followed = mysql.Sel(
'post', {"user_id": "(%s)" %
tmp[:-1]} if tmp[:-1] != "" else {"user_id": "(-1)"},
where_symbols="in")
own = mysql.Sel('post', {"user_id": self.id}, order=["id desc"])
posts = mysql.Unionall([followed, own])
return posts
def explore():
page = request.args.get('page', 1, type=int)
page = page if page > 0 else 1
all_posts = mysql.All("post", order=["id desc"])
post_per_page = app.config['POSTS_PER_PAGE']
posts = all_posts[
(page - 1) * post_per_page:page * post_per_page if len(all_posts) >= page * post_per_page else len(
all_posts)]
next_url = url_for('explore', page=page + 1) \
if len(all_posts) > page * post_per_page else None
prev_url = url_for('explore', page=page - 1) \
if (page > 1 and len(all_posts) > (page - 1) * post_per_page) else None
usernames = []
for i in posts:
usernames.append(load_user(i[2]))
return render_template('index.html', title='Home',
posts=posts, usernames=usernames, next_url=next_url,
prev_url=prev_url, izip=izip, avatars=avatar, dt=datetime.strptime)
def get_followed(self):
return mysql.All('followers', {"follower_id": self.id},
['followed_id'])