def get_post(postid):
conn = mysql.connect()
cursor = conn.cursor()
sql_string = "select postid, authorid, pageid, postdate, content from Posts where postid=%s"
cursor.execute(sql_string, (postid))
data = cursor.fetchone()
if not data:
return None
# create Post object
authorname = userid_to_object(data[1]).username
post = Post(data[0], data[1], data[2], data[3], data[4], authorname)
post.set_likes(get_post_likes(post.postid))
post.set_comments(get_comments(post.postid))
return post
def get_posts(pageid):
conn = mysql.connect()
cursor = conn.cursor()
# get posts on pageid from most recent to least recent
sql_string = "select postid, authorid, pageid, postdate, content from Posts where pageid=%s order by postdate desc"
cursor.execute(sql_string, (pageid))
data = cursor.fetchall()
posts = [] # list to store post objects
for d in data:
#get username of post writer from id
authorname = userid_to_object(d[1]).username
post = Post(d[0], d[1], d[2], d[3], d[4], authorname)
# get users who liked post
post.set_likes(get_post_likes(post.postid))
# get comments on post
post.set_comments(get_comments(post.postid))
posts.append(post)
return posts
