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