Facebook fql and tweepy
1 like1,639 views
This document discusses the Facebook Query Language (FQL) and the Python library Tweepy. It provides examples of using FQL to query Facebook for status updates and comments. It also shows how to use Tweepy to access the Twitter API and retrieve public tweets. The document recommends getting Twitter access tokens to use more advanced API functions beyond the public timeline.
![Expression
SELECT [Field] FROM [Table] WHERE [conditions]](https://image.slidesharecdn.com/facebookfqlandtweepy-110923221326-phpapp01/85/Facebook-fql-and-tweepy-6-320.jpg)
![Expression
SELECT [Field] FROM [Table] WHERE [conditions]
SELECT [Field] FROM [Table] Error
Limitation
Alawys Need Condtions Field](https://image.slidesharecdn.com/facebookfqlandtweepy-110923221326-phpapp01/85/Facebook-fql-and-tweepy-7-320.jpg)
![.fbconsole.py Sample
from urllib import urlretrieve
import imp
urlretrieve('https://raw.github.com/gist/1194123/fbconsole.py', '.fbconsole.py')
fb = imp.load_source('fb', '.fbconsole.py')
fb.AUTH_SCOPE = ['read_stream']
fb.authenticate()
comments = fb.fql(
"SELECT post_id, actor_id, target_id, message, comments FROM stream WHERE filter_key in
(SELECT filter_key FROM stream_filter WHERE uid=me() AND type='newsfeed') AND is_hidden =
0 LIMIT 1
)
print comments](https://image.slidesharecdn.com/facebookfqlandtweepy-110923221326-phpapp01/85/Facebook-fql-and-tweepy-10-320.jpg)
![.fbconsole.py Result(JSON)
[{u'post_id': u'100001220342847_269268529764053', u'message': u'uc81cuac00
uc911ud559uc0dd ub54c uac10ub3d9 ubc1buc73cuba74uc11c ud588ub358
uac8cuc784..nuc9c0uae08ub3c4 uac8cuc784 uad00ub828 uc77c
ud558uba74uc11c ub2f9uc2e0uc774 uac00uc7a5 uac10uba85uae4auac8c ud55c
uac8cuc784uc774 ubb34uc5c7uc785ub2c8uae4c?nub77cuace0
ubb3cuc5b4ubcfc ub54c uc8fcuc800 uc5c6uc774 ub300ub2f5ud558ub294
uac8cuc784..nnhttp://itunes.apple.com/us/app/another-world-20th-
anniversary/id460076328?mt=8nnuc5b4ub098ub354uc6d4ub4dcuac00 20uc8fcub144
uae30ub150ud310uc774 ub098uc654ub124uc694, uceacud558ud558 ^^', u'target_id':
None, u'actor_id': 100001220342847, u'comments': {u'count': 1, u'comment_list': [{u'text':
u'uc774uac74 uadf8ub798ud53d uc5ecubd80ub97c ub5a0ub098uc11c uaf2d
uc5d4ub529uc744 ubd10uc57c ub428..', u'likes': 0, u'time': 1316830670, u'fromid':
100001220342847, u'id': u'100001220342847_269268529764053_3910464', u'user_likes': False}],
u'can_remove': False, u'can_post': True}}]](https://image.slidesharecdn.com/facebookfqlandtweepy-110923221326-phpapp01/85/Facebook-fql-and-tweepy-11-320.jpg)
More Related Content
Similar to Facebook fql and tweepy (20)
More from DaeMyung Kang (20)
Recently uploaded (20)
Facebook fql and tweepy
- 1. Facebook FQL And Tweepy charsyam@naver.com
- 2. Facebook Graph API(Json) http://developers.facebook.com/docs/reference/api/ { "name": "Facebook Platform", "type": "page", "website": "http://developers.facebook.com", "username": "platform", "founded": "May 2007", "company_overview": "Facebook Platform enables anyone to build...", "mission": "To make the web more open and social.", "products": "Facebook Application Programming Interface (API)...", "likes": 449921, "id": 19292868552, "category": "Technology" }
- 3. FQL = Facebook Query Language http://developers.facebook.com/docs/reference/fql/
- 4. FQL = Facebook Query Language SQL like Easy to Use Graph API
- 5. SELECT status_id,message,TIME,SOURCE FROM `status` WHERE uid = me() Login User Unique ID 112345667889
- 6. Expression SELECT [Field] FROM [Table] WHERE [conditions]
- 7. Expression SELECT [Field] FROM [Table] WHERE [conditions] SELECT [Field] FROM [Table] Error Limitation Alawys Need Condtions Field
- 8. Expression SELECT link_id, owner, owner_comment, created_time, title, summary, url, image_urls FROM link WHERE link_id = 114961875194024
- 10. .fbconsole.py Sample from urllib import urlretrieve import imp urlretrieve('https://raw.github.com/gist/1194123/fbconsole.py', '.fbconsole.py') fb = imp.load_source('fb', '.fbconsole.py') fb.AUTH_SCOPE = ['read_stream'] fb.authenticate() comments = fb.fql( "SELECT post_id, actor_id, target_id, message, comments FROM stream WHERE filter_key in (SELECT filter_key FROM stream_filter WHERE uid=me() AND type='newsfeed') AND is_hidden = 0 LIMIT 1 ) print comments
- 11. .fbconsole.py Result(JSON) [{u'post_id': u'100001220342847_269268529764053', u'message': u'uc81cuac00 uc911ud559uc0dd ub54c uac10ub3d9 ubc1buc73cuba74uc11c ud588ub358 uac8cuc784..nuc9c0uae08ub3c4 uac8cuc784 uad00ub828 uc77c ud558uba74uc11c ub2f9uc2e0uc774 uac00uc7a5 uac10uba85uae4auac8c ud55c uac8cuc784uc774 ubb34uc5c7uc785ub2c8uae4c?nub77cuace0 ubb3cuc5b4ubcfc ub54c uc8fcuc800 uc5c6uc774 ub300ub2f5ud558ub294 uac8cuc784..nnhttp://itunes.apple.com/us/app/another-world-20th- anniversary/id460076328?mt=8nnuc5b4ub098ub354uc6d4ub4dcuac00 20uc8fcub144 uae30ub150ud310uc774 ub098uc654ub124uc694, uceacud558ud558 ^^', u'target_id': None, u'actor_id': 100001220342847, u'comments': {u'count': 1, u'comment_list': [{u'text': u'uc774uac74 uadf8ub798ud53d uc5ecubd80ub97c ub5a0ub098uc11c uaf2d uc5d4ub529uc744 ubd10uc57c ub428..', u'likes': 0, u'time': 1316830670, u'fromid': 100001220342847, u'id': u'100001220342847_269268529764053_3910464', u'user_likes': False}], u'can_remove': False, u'can_post': True}}]
- 12. But, Facebook supports partial Cant get Recent Activity
- 14. tweepy Sample import tweepy public_tweets = tweepy.api.public_timeline() for tweet in public_tweets: print tweet.text
- 15. Need Twitter Access Token For OAuth
- 17. Create Twitter Access Token
- 18. Create Twitter Access Token
- 19. Support API List For Timeline http://code.google.com/p/tweepy/wiki/APIReference Timeline Public_timeline Returns the 20 most recent public statuses Home_timeline Returns the statuses of user and friends with retweets Friends_timeline Returns the statuses of user and friends User_timeline Returns the statuses of the user Mentions Returns the mentions of the user Retweeted_by_me Returns the retweets posted by the user Retweeted_to_me Returns the retweets posted by the user's friends Retweets_of_me Returns the tweets of the authenticated user that have been retweeted by others
- 20. DEMO
- 21. Q&A
- 22. Thank you!