FQL多查询

2024-09-27 00:20:39 发布

您现在位置:Python中文网/ 问答频道 /正文

我还是不太确定多查询语法。。在

我想得到一些照片数据,我想加入它与地方,这样我可以得到照片的地点信息。。在

这是我的密码

query1 = "SELECT+object_id+,+place_id+,+caption+,+images+,+owner+,+created+FROM+photo+" \
         "WHERE+owner=%s+AND+created>=%s" % (update_user, update_ti
query2 = "SELECT+name+,+latitude+,+longitude+FROM+place+" \
         "WHERE+page_id+IN+(+SELECT+place_id+FROM+#query1+)"
update_url = "https://graph.facebook.com/fql?q={'query1':'%s', 'query2':'%s'}" \
             "&access_token=%s" % (query1, query2, client.token)

在http请求中,它将是这样的

^{pr2}$

它返回OAuthException:

error: {
  message: "(#601) Parser error: unexpected '{' at position 0.",
  type: "OAuthException",
  code: 601
}

更新代码(工作):

query1 = "SELECT object_id, place_id, caption, images, owner, created FROM photo " \
         "WHERE owner=%s AND created>=%s" % (update_user, update_time)
query2 = "SELECT name, latitude, longitude FROM place " \
         "WHERE page_id IN (SELECT place_id FROM #query1)"
query_params = {
    'q': '{"query1":"%s", "query2":"%s"}' % (query1, query2),
    'access_token': client.token
}
update_url = "https://graph.facebook.com/fql?%s" % urllib.urlencode(query_params)

Tags: fromtokenidobjectupdateplacewhereselect

热门问题