FB.Data.query 以及在哪里可以找到 Facebook 数据库方案？

Question

您好，我们已经实现了以下代码

INIT 块 (WORKS)

FB.init({
    appId: 'apiID',
    status: true, // check login status
    cookie: true, // enable cookies to allow the server to access the session
    oauth: true,  // enable OAuth 2.0
    xfbml: true,   // parse XFBML
    frictionlessRequests: true
});

LOGIN 块 (WORKS)

FB.login(function(response) {
    if (response.authResponse) {
      console.log('User logged and fully authorize the app.');

    } else {
      console.log('User cancelled login or did not fully authorize.');
    }
  }, {scope: 'email,user_location,friends_location'});

DATA RETRIEVE 块 (DON'T WORK)

var friends = FB.Data.query('SELECT uid, name, location FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me() ORDER BY rand() LIMIT 15) AND has_added_app=0');

FB.Data.waitOn([friends], function() {
  FB.Array.forEach(friends.value, function(row) {
      console.log(row);
  });
});

最后“SELECT uid, name FROM user ...”不会出现问题。

有人知道 facebook 的“user”和“friend”表的数据库方案吗？可以通过“FB.Data.query”访问其他表？

谢谢你！

编辑

正确的数据检索块（工作）

var friends = FB.Data.query('SELECT uid, name, hometown_location, current_location FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me() ORDER BY rand() LIMIT 15) AND has_added_app=0');

FB.Data.waitOn([friends], function() {
  FB.Array.forEach(friends.value, function(row) {
      console.log(row);
  });
});

Answer 1

Facebook 查询语言 (FQL) 的规范可用于 Facebook 的其余部分开发人员文档，包括 用户 和 friend 表。