使用python和executemany将facebook帖子插入数据库中

Question

我正在使用python、oursql和facebook SDK从facebook获取数据并将其放入数据库。我编写了一个函数并设法在列表中获取数据，但executemany只将第一行放入数据库。我不知道哪里出错了。提前谢谢你的帮助。 这是我的职责：

def get_posts(page_id, follow_account_id):
graph = facebook.GraphAPI(get_facebook_access_token()) 
posts = graph.get_connections(page_id, 'posts')
facebook_posts = list()
should_finish = False
while True:  # keep paginating 
    try: 
        with get_db_connection() as cursor: 
            for post in posts['data']: 
                #print post
                if datetime_from_iso(post["created_time"]) < until_time:
                    should_finish = True
                    break
                try:
                    user_id, post_id = post["id"].split("_")  # "133174387208_10154860725907209
                    link = "https://www.facebook.com/{0}/posts/{1}".format(user_id, post_id)
                except:
                    link = None
                facebook_posts.append((3, post_id, None, None,  0, post.get("from").get("name"), post.get("from").get("id"), post.get("from").get("name"), filter_using_re(post.get("message", None)), link, follow_account_id)) 
                print facebook_posts


            cursor.executemany(post_insert_query, facebook_posts)
# get next page 
            posts = requests.get(posts['paging']['next']).json() 
    except KeyError:  
        break 

准备声明：

^{pr2}$