{"_id":"fql-workbench","_rev":"41-339d585c22831932a4cb15873114bdb5","name":"fql-workbench","description":"A FQL Workbench tool","dist-tags":{"latest":"0.2.9"},"versions":{"0.1.0":{"name":"fql-workbench","version":"0.1.0","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","dependencies":{"fbgraph":"0.2.5","repl-console":"0.3.x","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\nA workbench for Facebook's FQL","readmeFilename":"README.md","_id":"fql-workbench@0.1.0","dist":{"shasum":"9312ecc7b1f589ecc5993d9717c72618b54f3d82","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.0.tgz","integrity":"sha512-3hIougDn3Uu6syN+wcgvAqKP2OIlHLI0gvM8VZuQFHN5BapByP7o4ToNQ83idmdyoSxfwOl5nCUJzpRKrNuB0g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBqpjeDb/CPckQRNHZPi2pcDYMFTu0pwQNTMWcxg/RKVAiEA3zsipC4xtnJBO6mMcwz2xgj0JcOuUf50MDGA1kM8iy8="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}],"directories":{}},"0.1.1":{"name":"fql-workbench","version":"0.1.1","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":"0.3.x","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\nA workbench for Facebook's FQL","readmeFilename":"README.md","_id":"fql-workbench@0.1.1","dist":{"shasum":"62c9e3389175b8db32232941a3e832f09762c7c8","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.1.tgz","integrity":"sha512-3F28oDQc8ptaHYMxscgxcsqp6ZbpFmGTTOKswR7qvELnDsS05VXoPIFutmeWPjLGO0/SWXZuRwOt+l2weh87Yw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCqWCO3tFgmlLoRk6ykmUmBNx/E4s6PKEXju1lKVyEJvAIhAN/RsgqlTLqbX1GJRegUkcLh3YUXx/ALoTqsoIBK9gjv"}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.1.2":{"name":"fql-workbench","version":"0.1.2","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":"0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\nA workbench for Facebook's FQL","readmeFilename":"README.md","_id":"fql-workbench@0.1.2","dist":{"shasum":"793afafc75227f88a00b521ae820a1116bdec160","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.2.tgz","integrity":"sha512-pm0NEc2mS7I+miO0bIuczKXNxctKlY4c0kFJyhnDFscAw1rsiKyDyZpVLwLcYzfOjQDjy+Y7IWN7JxSdUCR3Eg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEDExPAEUfu4Dp58UMu10nxfX52la/JhRDg2qGf2RjZbAiEAjpejG5u5OHd+e8uaEj8kMPJEZVrlZBIuCFilqF2fHdY="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.1.3":{"name":"fql-workbench","version":"0.1.3","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":"0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect --host [host] --id [id] --secret [secret] --uid [uid]\n```\n\n### Step 4 - Play\n```\nfql> select uid, username, first_name, last_name, name, sex, is_app_user from user where uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nfql>\n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.1.3","dist":{"shasum":"d15e2e38a398659f83c3b57bbcb8def333142397","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.3.tgz","integrity":"sha512-gsfnRdAqrnnJo0e4zFjUnG01Mrq5967ODC7188UznY0ZNiWMBtRxgkBWzlzy7KAfdOS6jnZts73BFR27Jn4kVg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGJEcfIniW0++C5Xma7ZTivb7EuStAUqvbfHS86WODDaAiBEHmacNZRLMr7hBfLy9izndZLFCjAipFVJ6lT7gARneQ=="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.1.4":{"name":"fql-workbench","version":"0.1.4","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect --host [host] --id [id] --secret [secret] --uid [uid]\n```\n\n### Step 4 - Play\n```\nfql> select uid, username, first_name, last_name, name, sex, is_app_user from user where uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nfql>\n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.1.4","dist":{"shasum":"866eced24b6b330ee46830c160602165e79f4c6f","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.4.tgz","integrity":"sha512-WdRd5/ReCrp+F1IgIA0u/6k/HwSWLMhVFmlYggAF+5knmzSnUW0vc+8p9oeVW3284XZpQA9hKJNlOo5piUo7AQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBOKaMWFkysExJMfWqnkoTsvb7eyfdswh2Jz91AZchWMAiEAvewGqFvC6jvHIGGZ+2ggnMCueCus/3FoZj5GrxSd2ig="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.1.5":{"name":"fql-workbench","version":"0.1.5","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect --host [host] --id [id] --secret [secret] --uid [uid]\n```\n\n### Step 4 - Play\n```\nfql> select uid, username, first_name, last_name, name, sex, is_app_user from user where uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nfql>\n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.1.5","dist":{"shasum":"fb7287f821d8d824469cb34ad74050b5ee879961","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.5.tgz","integrity":"sha512-F15GWmTeLA0jcOxKQz737h7gs2PNFXCcRWjK6R9b8zWoNYuAMKtAn9oUGdnbVkyCXrtXcQ4t2wH7EnoKmNcywA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDy976HP8rWaVsdfRe9QLHm0ZrUs6zByQShGxNGd8/J4QIga8FWWh109r+RroK3lGzFR22cGkXfTXO4BjCaHq8DlxA="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.1.6":{"name":"fql-workbench","version":"0.1.6","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect --host [host] --id [id] --secret [secret] --uid [uid]\n```\n\n### Step 4 - Play\n```\nfql> select uid, username, first_name, last_name, name, sex, is_app_user from user where uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nfql>\n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.1.6","dist":{"shasum":"cc2843f295e9e0e51e15fa1e0cddaf417f4db51c","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.6.tgz","integrity":"sha512-5INjC+TVxnFJZbyrGI0p2xoHcMh39S508HctEeHMLoIbMoSDla8Y9b5DkFbyPZEuV07rRXKEtiqTCTSKASrUFA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBPASTBdkwTgHBbSz70VmgKheMMZX05uMYsD/IKT9FTSAiEAuo7JcB0hSFPv+o3GQWWwDZTrYaRPt/2YX7R7EhogPNg="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.1.7":{"name":"fql-workbench","version":"0.1.7","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\n```\nfql> select uid, username, first_name, last_name, name, sex, is_app_user from user where uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\nThis is a convenience so you don't have to keep entering long bits of data over and over\n\nThere is tab completion too for the support query syntax. maybe i'll get completion for table names and fields too! \n\nYou can leave the remote session by simply typing 'exit' or calling it as a function 'exit()'\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.1.7","dist":{"shasum":"ef6ef8bf222170821929425996958f269e56ab6e","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.7.tgz","integrity":"sha512-UfkArz+E736AKOiTNnP1bcl+ZKPXoYr8bKZoECk1TLQtBF9FFwXs1a/asA9O4P8AkfxWa3+OyioJh/LFb+GRcA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIATGthd5yxH4hc2mtmflhKPjmAukt/NQGySVf8UnuHKrAiBenYxODkWqxNsVK9uMQp9/MEwbuPV+ybjeWHXbHupQ4w=="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.1.8":{"name":"fql-workbench","version":"0.1.8","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Tab Completion \nThere is tab completion too for the support query syntax. Tables are not supported (yet?)\n\n### Exiting\nYou can leave the remote session by simply typing 'exit' or calling it as a function 'exit()'\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_shares' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_shares\n  value: 94\n\nQuery took 0.123 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'page_engaged_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: page_engaged_users\n  value: 136\n\nQuery took 0.125 seonds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'page_consumptions' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: page_consumptions\n  value: 2023\n\nQuery took 0.13 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.1.8","dist":{"shasum":"b79604d762a5034143fafe0b1e1332e8077f29a1","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.1.8.tgz","integrity":"sha512-cDaIND+VsC+oD4vVGNc8IAi/z5PW6RG5GaeC8Vv58Tqx4CNCphqx1KTvULr25MaISqUh5tIsQWkC8Cc/WfUZXA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICbAInT0Mwe44LNJZrXyhBdfW/Dd0YU5kgWY1UEwDB8xAiAKNzN2T3q8fLsosNymzr/Y0sUSE8XtyV4rofzJeQN/1g=="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.0":{"name":"fql-workbench","version":"0.2.0","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the remote session by simply typing 'exit' or calling it as a function 'exit()'\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:desc | :describe``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n\n\nfql>\n```\n\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.0","dist":{"shasum":"8347b1484a8f725b25e6657fbd948ff47f5ad882","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.0.tgz","integrity":"sha512-ieIidbkNvVgRxuOxBDsjBYKJCCpfl6f9m+Lo547ebqafoyE5Cl86Nb4KqD3XpeU/CEgLxJaPNOagVawxFDDcCA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGMDbFhCa0whB+XoIcbPJtUeNTIou+EWbw6tZJI3RfFlAiEAn6bGJOq6p3W+Y+Z8KKVmu1hTI3qaGeulOs477K3GdHE="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.1":{"name":"fql-workbench","version":"0.2.1","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the remote session by simply typing 'exit' or calling it as a function 'exit()'\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:desc | :describe``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n\n\nfql>\n```\n\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.1","dist":{"shasum":"a2b418dc2532124741176ccf5d1a2291d769c48c","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.1.tgz","integrity":"sha512-b9QtVYtomMfeP/EZW1LtneqDHdJXD2/iHUDsDw/xv3obZDVqXOhqU6Lay4CE6q/99N28ZaIdf5L9DTtydabpzQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDgzSoot3W+HgIzEOJPAuvQswncgx6nSjPVtTbiJx7ZcAiEAjdN+IcR8sPTxerd+OE33gO8aJ+wLEVU4Hd+GGJjuzuo="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.2":{"name":"fql-workbench","version":"0.2.2","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the remote session by simply typing 'exit' or calling it as a function 'exit()'\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:desc | :describe``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n\n\nfql>\n```\n\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.2","dist":{"shasum":"a0a86293c3fd58e6c0993f1dbf31a4a41a0187f8","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.2.tgz","integrity":"sha512-Ox0w+ZcuYs5GiCvvVl4AXUhPhgRJ6Zt8Atcekn7jPVUpJ4XuyHhRdkdiWG1TJh8kYAeQPyC7RM4UcGUWtiTAaw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDNugMXYeyteTW5nfaUvsJzyKdIstOYpCL/nWyoToeB3gIgNG35BC1HbKKkfwfAs23ZdsOLcIVe9WiwZu0Q25VzjkA="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.3":{"name":"fql-workbench","version":"0.2.3","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/fql","fql-cli":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">0.4.1","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\nAll output is yaml output.\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:help <command>     - Displays usage on a given command\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Help\nUsing :help\n```\nfql> :help\n... \n':help <command> - Displays usage on a given command'\n\nfql> :help print\n... \n':print <string> - Prints a string to the buffer'\n\nfql> :help describe\n... \n':describe <table> - Shows a table definition'\n\nfql> \n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the session in a few ways.\n```\nfql> :exit\n... \n$\n```\nor\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:describe`` or ``:desc``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n\n\nfql>\n```\n\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.3","dist":{"shasum":"663af0c66ac9112c4b3fe44dec6b7f640f94f21e","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.3.tgz","integrity":"sha512-4oi97bg7pZBVJ8VyQMHFW11vMfmfel8a/4LOT+P0XR9XD7duTj6+ZENDqQWZVvBFh/Cht3l5JJqBWcMxOHOqGQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD0IO/OX+is2MQHpmSPNsvVWIHkTzMqE4UCSsfjv2+NZAIgFuDYtnvhZNedVKpaR4kYHpwfP3zv8p7BDvfYVterXMk="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.4":{"name":"fql-workbench","version":"0.2.4","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/fql","fql-cli":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">=0.4.5","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\nAll output is yaml output.\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:help <command>     - Displays usage on a given command\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Help\nUsing :help\n```\nfql> :help\n... \n':help <command> - Displays usage on a given command'\n\nfql> :help print\n... \n':print <string> - Prints a string to the buffer'\n\nfql> :help describe\n... \n':describe <table> - Shows a table definition'\n\nfql> \n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the session in a few ways.\n```\nfql> :exit\n... \n$\n```\nor\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:describe`` or ``:desc``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n\n\nfql>\n```\n\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.4","dist":{"shasum":"e82de74c8f1bd66e985ac45b8156ca84a92fa3a9","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.4.tgz","integrity":"sha512-HS5euqlAFpWovUDZ/J7N2UhR9Tfn7D2vs88lnwC9EdGxbefaoWcf/gGYKL7qlj47DA5k9NIhJUJjopDQw5zSFA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDghYlGfxxEWr1a4hkHhXZ9/qwtkOZNpE8P7EHkf4NHjgIgA9i7pHNhWegGjHC6KfK1j4BTaXMubUq1BHot6cnSquQ="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.5":{"name":"fql-workbench","version":"0.2.5","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">=0.4.5","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\nAll output is yaml output.\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:help <command>     - Displays usage on a given command\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Help\nUsing :help\n```\nfql> :help\n... \n':help <command> - Displays usage on a given command'\n\nfql> :help print\n... \n':print <string> - Prints a string to the buffer'\n\nfql> :help describe\n... \n':describe <table> - Shows a table definition'\n\nfql> \n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the session in a few ways.\n```\nfql> :exit\n... \n$\n```\nor\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:describe`` or ``:desc``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n\n\nfql>\n```\n\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.5","dist":{"shasum":"64f1e21e51dfd29c72c81ddfcb1838471ec252e1","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.5.tgz","integrity":"sha512-JqZmiyn5v/tRPQfst/8I+8KGU/+fbY1mX1OGirvDSSB/5HyjwYlg5L69Hs9m49lU7odCNpZ/4qzdUxNC9btAWg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDlpuQvj4CsveVl63JJS6ppdzTdDaILooZrFA2QFT4nigIgcdcxKWrUGd5agv0epbvPf2Nn/pU+rLER3wjG9lfEpfU="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.8":{"name":"fql-workbench","version":"0.2.8","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">=0.4.x","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\nAll output is yaml output.\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:help <command>     - Displays usage on a given command\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Help\nUsing :help\n```\nfql> :help\n... \n':help <command> - Displays usage on a given command'\n\nfql> :help print\n... \n':print <string> - Prints a string to the buffer'\n\nfql> :help describe\n... \n':describe <table> - Shows a table definition'\n\nfql> \n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the session in a few ways.\n```\nfql> :exit\n... \n$\n```\nor\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:show tables``\n```\nfql> :show tables\n... Fetching tables from http://developers.facebook.com/docs/reference/fql/\n\ntables:\n  - album\n  - application\n  - apprequest\n  - checkin\n  - comment\n  - comments_info\n  - connection\n  - cookies\n  - developer\n  - domain\n  - domain_admin\n  - event\n  - event_member\n  - family\n  - friend\n  - friend_request\n  - friendlist\n  - friendlist_member\n  - group\n  - group_member\n  - insights\n  - like\n  - link\n  - link_stat\n  - location_post\n  - mailbox_folder\n  - message\n  - note\n  - notification\n  - object_url\n  - offer\n  - page\n  - page_admin\n  - page_blocked_user\n  - page_fan\n  - page_global_brand_child\n  - page_milestone\n  - permissions\n  - permissions_info\n  - photo\n  - photo_src\n  - photo_tag\n  - place\n  - privacy\n  - privacy_setting\n  - profile\n  - profile_pic\n  - profile_view\n  - question\n  - question_option\n  - question_option_votes\n  - review\n  - standard_friend_info\n  - standard_user_info\n  - status\n  - stream\n  - stream_filter\n  - stream_tag\n  - subscription\n  - thread\n  - translation\n  - unified_message\n  - unified_thread\n  - unified_thread_action\n  - unified_thread_count\n  - url_like\n  - user\n  - video\n  - video_tag\n```\n\n``:describe`` or ``:desc``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n```\n\nFilter the output of a :describe call\n```\nfql> :desc user perms\n... Fetching table definition for user http://developers.facebook.com/docs/reference/fql/user\n\nname: user\npermissions:\n  - user_likes\n  - user_education_history\n  - user_work_history\n  - user_religion_politics\n  - user_about_me\n  - user_notes\n  - user_status\n  - user_online_presence\n  - email\n  - user_birthday\n  - user_hometown\n  - user_relationships\n  - user_relationship_details\n  - user_activities\n  - user_interests\n  - user_location\n  - user_website\n```\n\nFilter user table to show fields and filter the output to only show the type\n```\nfql> :desc user fields:type\n... Fetching table definition for user http://developers.facebook.com/docs/reference/fql/user\n\nname: user\nfields:\n  uid: int\n  username: string\n  first_name: string\n  middle_name: string\n  last_name: string\n  name: string\n  pic_small: string\n  pic_big: string\n  pic_square: string\n  pic: string\n  affiliations: array\n  profile_update_time: time\n  timezone: int\n  religion: string\n  birthday: string\n  birthday_date: string\n  devices: array\n  sex: string\n  hometown_location: array\n  meeting_sex: array\n  meeting_for: array\n  relationship_status: string\n  significant_other_id: uid\n  political: string\n  current_location: array\n  activities: string\n  interests: string\n  is_app_user: bool\n  music: string\n  tv: string\n  movies: string\n  books: string\n  quotes: string\n  about_me: string\n  hs_info: array\n  education_history: array\n  work_history: array\n  notes_count: int\n  wall_count: int\n  status: string\n  has_added_app: bool\n  online_presence: string\n  locale: string\n  proxied_email: string\n  profile_url: string\n  email_hashes: array\n  pic_small_with_logo: string\n  pic_big_with_logo: string\n  pic_square_with_logo: string\n  pic_with_logo: string\n  pic_cover: array\n  allowed_restrictions: string\n  verified: bool\n  profile_blurb: string\n  family: array\n  website: string\n  is_blocked: bool\n  contact_email: string\n  email: string\n  third_party_id: string\n  name_format: string\n  video_upload_limits: array\n  games: string\n  work: array\n  education: array\n  sports: array\n  favorite_athletes: array\n  favorite_teams: array\n  inspirational_people: array\n  languages: array\n  likes_count: int\n  friend_count: int\n  mutual_friend_count: int\n  can_post: bool\n```\n\nDescribing a single field in a table\n```\nfql> :describe insights field:metric\n... \nname: insights\nfields:\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n```\n\nFiltering meta information on a field\n```\nfql> :describe insights field:metric.description\n... \nname: insights\nfields:\n  metric: 'The usage data to retrieve.'\n\nfql> :describe insights field:metric.type\n... \nname: insights\nfields:\n  metric: { type: string }\n\nfql> desc user field:username.type,username.name,username.description,pic.type\n... \nname: user\nfields:\n  username: [{ type: string }, username, 'The username of the user being queried.']\n  pic: [{ type: string }]\n  \n```\n\nDescribing tables that do not exist\n```\nfql> :desc like\n... Fetching table definition for like http://developers.facebook.com/docs/reference/fql/like\n\n- 'Unsupported table.'\n```\n\nGetting more output from a filter\n```\nfql> :desc insights fields:type,description\n... \nname: insights\nfields:\n  object_id: { type: int, description: '''The object for which you are retrieving metrics.''' }\n  metric: { type: string, description: '''The usage data to retrieve.''' }\n  end_time: { type: int, description: '\"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in ''YYYY-MM-DD'' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\"' }\n  period: { type: int, description: '\"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\"' }\n  value: { type: mixed, description: '''The value of the requested metric.''' }\n```\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nSELECT *\n```\nfql> select * from user where uid = :uid\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  middle_name: \n  last_name: Werle\n  name: 'Joseph Werle'\n  pic_small: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_t.jpg'\n  pic_big: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_n.jpg'\n  pic_square: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_q.jpg'\n  pic: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_s.jpg'\n  affiliations: []\n  profile_update_time: null\n  timezone: null\n  religion: null\n  birthday: null\n  birthday_date: null\n  devices: null\n  sex: male\n  hometown_location: null\n  meeting_sex: null\n  meeting_for: null\n  relationship_status: null\n  significant_other_id: null\n  political: null\n  current_location: null\n  activities: \n  interests: \n  is_app_user: false\n  music: \n  tv: \n  movies: \n  books: \n  quotes: null\n  about_me: null\n  hs_info: null\n  education_history: []\n  work_history: []\n  notes_count: null\n  wall_count: null\n  status: null\n  has_added_app: false\n  online_presence: null\n  locale: en_US\n  proxied_email: null\n  profile_url: null\n  email_hashes: []\n  pic_small_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQBqN7ykEVtkBj8a&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_t.jpg&logo&v=5'\n  pic_big_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQCJdVZedb1KWG1D&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_n.jpg&logo&v=5'\n  pic_square_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQDy8oj7Jkur4m27&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_q.jpg&logo&v=5'\n  pic_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQBLIlCy5KXvtmFo&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_s.jpg&logo&v=5'\n  pic_cover: null\n  allowed_restrictions: null\n  verified: null\n  profile_blurb: null\n  family: []\n  website: null\n  is_blocked: null\n  contact_email: null\n  email: null\n  third_party_id: GmFMcou46KWeiU_Kg4ByPNQODS8\n  name_format: '{first} {last}'\n  video_upload_limits: null\n  games: \n  work: []\n  education: []\n  sports: []\n  favorite_athletes: []\n  favorite_teams: []\n  inspirational_people: []\n  languages: []\n  likes_count: null\n  friend_count: null\n  mutual_friend_count: null\n  can_post: false\n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.8","dist":{"shasum":"e71d6608053ddc819e88bc9d8fe10ef79baba458","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.8.tgz","integrity":"sha512-QefvxGNUlor/ys7JgWoOk0S4cIaSy4xhGwIUjyVuGa7+ECZ8Oi3boUbmeXJoDr9ARGRfsV1HRkqk3H3h5fZNkA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDnziIJjcauq+FpmpuXL+wpgqnz0X0tEuTJGfpmEltCeAiAusU0sSkDO5mnyUUOXnUtkhJZLrsm8jyjuxmTqV96DSw=="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]},"0.2.9":{"name":"fql-workbench","version":"0.2.9","description":"A FQL Workbench tool","keywords":["facebook","api","graph","fql","workbench"],"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"main":"index","bin":{"fql":"./bin/cli.js"},"dependencies":{"fbgraph":"0.2.5","repl-console":">=0.4.x","request":"2.11.x","utilities":"0.0.x","colors":"0.6.0-1","yamljs":"0.1.3","jsdom":"0.2.x","jquery":"1.7.x"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"},"engines":{"node":">= 0.8.8"},"readme":"FQLWorkbench\n============\n\n#### A workbench for Facebook's FQL\n\n### Step 1 - Install\n```\n$ sudo npm install fql-workbench -g\n```\n\n### Step 2 - Start the daemon\n```\n$ fql daemon\n```\n\n### Step 3 - Connect (Local/remote)\n```\n$ fql connect -h/--host [host] -p/--port [port] -i/--id [id] -s/--secret [secret] -u/--uid [uid] (optional) -U/--user (optional)\n```\n\n### Step 4 - Play\nAll output is yaml output.\n```\nfql> SELECT uid, username, first_name, last_name, name, sex, is_app_user FROM user WHERE uid = :uid;\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  last_name: Werle\n  name: 'Joseph Werle'\n  sex: male\n  is_app_user: false\n\nQuery took 0.087 seconds to execute.\nfql>\n```\n\n### Aliases\nThe following aliases are available within the query:\n```\n:id           - App ID\n:secret       - App Secret\n:accessToken  - The access token generated by the app id and secret\n:uid          - The UID supplied by the -u or --uid flag.\n:me           - If the -U or --user flag was supplied then the value of this variable is the uid supplied by the -u or --uid flag\n```\n\n### Commands\nThe following commands are available at the command line interface\n```\n:help <command>     - Displays usage on a given command\n:print <string>     - Prints a string to the buffer\n:exit               - Exits the session\n:describe <table>   - Shows a table definition\n```\n\n### Help\nUsing :help\n```\nfql> :help\n... \n':help <command> - Displays usage on a given command'\n\nfql> :help print\n... \n':print <string> - Prints a string to the buffer'\n\nfql> :help describe\n... \n':describe <table> - Shows a table definition'\n\nfql> \n```\n\n### Tab Completion \nThere is tab completion for the support query syntax. Tables, fields, permissions coming soon.\n```\nfql> sele\nselect \nfql> select name fr\nfrom \nfql> select name from user w\nwhere \nfql> select name from user where uid = :uid\n... \n-\n  name: 'Joseph Werle'\n\nQuery took 0.082 seconds to execute.\nfql> \n```\n\n### Exiting\nYou can leave the session in a few ways.\n```\nfql> :exit\n... \n$\n```\nor\n```\nQuery took 0.081 seconds to execute.\nfql> exit\nExiting...\n```\n\n### Using commands\n\n``:print`` \n```\nfql> :print :uid\n... \n'543985131'\n\nfql> :print :id\n... \n'459902834061249'\n\nfql> \n```\n\n``:show tables``\n```\nfql> :show tables\n... Fetching tables from http://developers.facebook.com/docs/reference/fql/\n\ntables:\n  - album\n  - application\n  - apprequest\n  - checkin\n  - comment\n  - comments_info\n  - connection\n  - cookies\n  - developer\n  - domain\n  - domain_admin\n  - event\n  - event_member\n  - family\n  - friend\n  - friend_request\n  - friendlist\n  - friendlist_member\n  - group\n  - group_member\n  - insights\n  - like\n  - link\n  - link_stat\n  - location_post\n  - mailbox_folder\n  - message\n  - note\n  - notification\n  - object_url\n  - offer\n  - page\n  - page_admin\n  - page_blocked_user\n  - page_fan\n  - page_global_brand_child\n  - page_milestone\n  - permissions\n  - permissions_info\n  - photo\n  - photo_src\n  - photo_tag\n  - place\n  - privacy\n  - privacy_setting\n  - profile\n  - profile_pic\n  - profile_view\n  - question\n  - question_option\n  - question_option_votes\n  - review\n  - standard_friend_info\n  - standard_user_info\n  - status\n  - stream\n  - stream_filter\n  - stream_tag\n  - subscription\n  - thread\n  - translation\n  - unified_message\n  - unified_thread\n  - unified_thread_action\n  - unified_thread_count\n  - url_like\n  - user\n  - video\n  - video_tag\n```\n\n``:describe`` or ``:desc``\n```\nfql> :describe insights\n... \nname: insights\nfields:\n  object_id: { name: object_id, type: { type: int }, indexable: true, description: 'The object for which you are retrieving metrics.' }\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n  end_time: { name: end_time, type: { type: int }, indexable: true, description: \"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in 'YYYY-MM-DD' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\" }\n  period: { name: period, type: { type: int }, indexable: true, description: \"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\" }\n  value: { name: value, type: { type: mixed }, indexable: false, description: 'The value of the requested metric.' }\npermissions:\n  - access_token\n  - read_insights\n```\n\nFilter the output of a :describe call\n```\nfql> :desc user perms\n... Fetching table definition for user http://developers.facebook.com/docs/reference/fql/user\n\nname: user\npermissions:\n  - user_likes\n  - user_education_history\n  - user_work_history\n  - user_religion_politics\n  - user_about_me\n  - user_notes\n  - user_status\n  - user_online_presence\n  - email\n  - user_birthday\n  - user_hometown\n  - user_relationships\n  - user_relationship_details\n  - user_activities\n  - user_interests\n  - user_location\n  - user_website\n```\n\nFilter user table to show fields and filter the output to only show the type\n```\nfql> :desc user fields:type\n... Fetching table definition for user http://developers.facebook.com/docs/reference/fql/user\n\nname: user\nfields:\n  uid: int\n  username: string\n  first_name: string\n  middle_name: string\n  last_name: string\n  name: string\n  pic_small: string\n  pic_big: string\n  pic_square: string\n  pic: string\n  affiliations: array\n  profile_update_time: time\n  timezone: int\n  religion: string\n  birthday: string\n  birthday_date: string\n  devices: array\n  sex: string\n  hometown_location: array\n  meeting_sex: array\n  meeting_for: array\n  relationship_status: string\n  significant_other_id: uid\n  political: string\n  current_location: array\n  activities: string\n  interests: string\n  is_app_user: bool\n  music: string\n  tv: string\n  movies: string\n  books: string\n  quotes: string\n  about_me: string\n  hs_info: array\n  education_history: array\n  work_history: array\n  notes_count: int\n  wall_count: int\n  status: string\n  has_added_app: bool\n  online_presence: string\n  locale: string\n  proxied_email: string\n  profile_url: string\n  email_hashes: array\n  pic_small_with_logo: string\n  pic_big_with_logo: string\n  pic_square_with_logo: string\n  pic_with_logo: string\n  pic_cover: array\n  allowed_restrictions: string\n  verified: bool\n  profile_blurb: string\n  family: array\n  website: string\n  is_blocked: bool\n  contact_email: string\n  email: string\n  third_party_id: string\n  name_format: string\n  video_upload_limits: array\n  games: string\n  work: array\n  education: array\n  sports: array\n  favorite_athletes: array\n  favorite_teams: array\n  inspirational_people: array\n  languages: array\n  likes_count: int\n  friend_count: int\n  mutual_friend_count: int\n  can_post: bool\n```\n\nDescribing a single field in a table\n```\nfql> :describe insights field:metric\n... \nname: insights\nfields:\n  metric: { name: metric, type: { type: string }, indexable: true, description: 'The usage data to retrieve.' }\n```\n\nFiltering meta information on a field\n```\nfql> :describe insights field:metric.description\n... \nname: insights\nfields:\n  metric: 'The usage data to retrieve.'\n\nfql> :describe insights field:metric.type\n... \nname: insights\nfields:\n  metric: { type: string }\n\nfql> desc user field:username.type,username.name,username.description,pic.type\n... \nname: user\nfields:\n  username: [{ type: string }, username, 'The username of the user being queried.']\n  pic: [{ type: string }]\n  \n```\n\nDescribing tables that do not exist\n```\nfql> :desc like\n... Fetching table definition for like http://developers.facebook.com/docs/reference/fql/like\n\n- 'Unsupported table.'\n```\n\nGetting more output from a filter\n```\nfql> :desc insights fields:type,description\n... \nname: insights\nfields:\n  object_id: { type: int, description: '''The object for which you are retrieving metrics.''' }\n  metric: { type: string, description: '''The usage data to retrieve.''' }\n  end_time: { type: int, description: '\"The end of the period during which the metrics were collected,\\nexpressed as a unix time (which should always be midnight, Pacific Daylight Time)\\nor using the function end_time_date() which takes a date string in ''YYYY-MM-DD'' format.\\nNote: If the unix time provided is not midnight, Pacific Daylight Time, your query may return an empty resultset.\\nExample: To obtain data for the 24-hour period starting on September 15th at 00:00 (i.e. 12:00 midnight)\\nand ending on September 16th at 00:00 (i.e. 12:00 midnight),\\nspecify 1284620400 as the end_time and 86400 as the period.\\n\\nNote: end_time should not be specified when querying lifetime metrics.\"' }\n  period: { type: int, description: '\"The length of the period during which the metrics were collected,\\nexpressed in seconds as one of 86400 (day), 604800 (week),\\n2592000 (month) or 0 (lifetime) or using the function period(),\\nwhich takes one of the strings day, week, month or lifetime.\\n\\nNote: Each metric may not have all periods available.\"' }\n  value: { type: mixed, description: '''The value of the requested metric.''' }\n```\n\n### Examples\n\nQuery your own data\n```\nfql> SELECT name FROM user WHERE uid = :uid\n... \n-\n  name: 'Joseph Werle'\n```\n\nQuery data about a Facebook page\n```\nfql> SELECT name, page_id, username, description, page_url FROM page WHERE username = 'facebook';\n... \n-\n  name: Facebook\n  page_id: 20531316728\n  username: facebook\n  description: \n  page_url: 'http://www.facebook.com/facebook'\n\nQuery took 0.103 seconds to execute.\nfql> \n```\n\nSELECT *\n```\nfql> select * from user where uid = :uid\n... \n-\n  uid: 543985131\n  username: joseph.werle\n  first_name: Joseph\n  middle_name: \n  last_name: Werle\n  name: 'Joseph Werle'\n  pic_small: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_t.jpg'\n  pic_big: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_n.jpg'\n  pic_square: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_q.jpg'\n  pic: 'http://profile.ak.fbcdn.net/hprofile-ak-ash4/273334_543985131_475654434_s.jpg'\n  affiliations: []\n  profile_update_time: null\n  timezone: null\n  religion: null\n  birthday: null\n  birthday_date: null\n  devices: null\n  sex: male\n  hometown_location: null\n  meeting_sex: null\n  meeting_for: null\n  relationship_status: null\n  significant_other_id: null\n  political: null\n  current_location: null\n  activities: \n  interests: \n  is_app_user: false\n  music: \n  tv: \n  movies: \n  books: \n  quotes: null\n  about_me: null\n  hs_info: null\n  education_history: []\n  work_history: []\n  notes_count: null\n  wall_count: null\n  status: null\n  has_added_app: false\n  online_presence: null\n  locale: en_US\n  proxied_email: null\n  profile_url: null\n  email_hashes: []\n  pic_small_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQBqN7ykEVtkBj8a&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_t.jpg&logo&v=5'\n  pic_big_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQCJdVZedb1KWG1D&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_n.jpg&logo&v=5'\n  pic_square_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQDy8oj7Jkur4m27&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_q.jpg&logo&v=5'\n  pic_with_logo: 'http://external.ak.fbcdn.net/safe_image.php?d=AQBLIlCy5KXvtmFo&url=http%3A%2F%2Fprofile.ak.fbcdn.net%2Fhprofile-ak-ash4%2F273334_543985131_475654434_s.jpg&logo&v=5'\n  pic_cover: null\n  allowed_restrictions: null\n  verified: null\n  profile_blurb: null\n  family: []\n  website: null\n  is_blocked: null\n  contact_email: null\n  email: null\n  third_party_id: GmFMcou46KWeiU_Kg4ByPNQODS8\n  name_format: '{first} {last}'\n  video_upload_limits: null\n  games: \n  work: []\n  education: []\n  sports: []\n  favorite_athletes: []\n  favorite_teams: []\n  inspirational_people: []\n  languages: []\n  likes_count: null\n  friend_count: null\n  mutual_friend_count: null\n  can_post: false\n```\n\nMulti Query\n```\nfql>  #user SELECT uid, username, name, first_name, last_name FROM user WHERE uid = :uid; #profile SELECT uid, username, name FROM #user\n... \n-\n  name: user\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle', first_name: Joseph, last_name: Werle }]\n-\n  name: profile\n  fql_result_set: [{ uid: 543985131, username: joseph.werle, name: 'Joseph Werle' }]\n\nQuery took 0.08 seconds to execute.\nfql>\n```\n\nQuery app metric data\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_active_users' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_active_users\n  value: 434\n\nQuery took 0.144 seconds to execute.\nfql> \n```\n\n```\nfql> SELECT metric, value FROM insights WHERE object_id = :id AND metric = 'application_like_adds' AND end_time=end_time_date('2011-06-26') AND period=period('month')\n... \n-\n  metric: application_like_adds\n  value: 87\n\nQuery took 0.125 seconds to execute.\nfql> \n```\n\nCopyright and license\n---------------------\n\nCopyright 2012\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this work except in compliance with the License.\nYou may obtain a copy of the License in the LICENSE file, or at:\n\n   http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n- - -\nfql-workbench copyright 2012\njoseph.werle@gmail.com","readmeFilename":"README.md","_id":"fql-workbench@0.2.9","dist":{"shasum":"e749fb5e6212218100005c98d8c313d827594eb3","tarball":"https://registry.npmjs.org/fql-workbench/-/fql-workbench-0.2.9.tgz","integrity":"sha512-sR8UZfrFq9RdDAJdFbOxjWTk43nCxnGwu1OVF3xvNoYASlAs6x0qVcfXdpGfbNGIHYTxPj6wvlXuxQ3SmXyQGQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDce6tJPNR1Lk0Qf2JO0Smvth8/5fffiNBv22H5N5acdwIgAwrolQtnAmG/2oihQHn0bPSKMAqS42zRG+PfyKrYi20="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"werle","email":"joseph.werle@gmail.com"},"maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}]}},"readme":"FQLWorkbench\n============\n\nA workbench for Facebook's FQL","maintainers":[{"name":"werle","email":"joseph.werle@gmail.com"}],"time":{"modified":"2022-06-18T03:24:07.446Z","created":"2012-11-08T22:10:21.483Z","0.1.0":"2012-11-08T22:10:22.085Z","0.1.1":"2012-11-08T22:22:40.963Z","0.1.2":"2012-11-08T22:23:18.914Z","0.1.3":"2012-11-08T22:38:48.795Z","0.1.4":"2012-11-08T22:45:17.930Z","0.1.5":"2012-11-08T23:01:59.403Z","0.1.6":"2012-11-08T23:33:56.172Z","0.1.7":"2012-11-08T23:41:59.219Z","0.1.8":"2012-11-09T00:04:18.191Z","0.2.0":"2012-11-11T01:09:44.807Z","0.2.1":"2012-11-11T01:30:48.066Z","0.2.2":"2012-11-11T01:37:14.321Z","0.2.3":"2012-11-11T16:34:33.167Z","0.2.4":"2012-11-11T16:38:03.392Z","0.2.5":"2012-11-11T16:42:48.388Z","0.2.8":"2012-11-11T23:52:52.723Z","0.2.9":"2012-11-12T19:08:22.114Z"},"author":{"name":"Jospeh Werle","email":"joseph.werle@gmail.com"},"repository":{"type":"git","url":"git://github.com/jwerle/fql-workbench.git"}}