def _execute_users_query(self): users = """ SELECT uid, first_name, last_name, name, pic_square, birthday_date, sex, hometown_location, current_location, significant_other_id FROM user WHERE uid = me() OR uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) """ return ws.queryFacebookFQL(users, self.access_token)
def _execute_pages_query(self): pages = """ SELECT page_id, name FROM page WHERE page_id IN (SELECT page_id FROM page_fan WHERE (uid = me() OR uid IN (SELECT uid2 FROM friend WHERE uid1 = me())) ) """ return ws.queryFacebookFQL(pages, self.access_token)
def _execute_likes_query(self): likes = """ SELECT uid, page_id, type FROM page_fan WHERE (uid = me() OR uid IN (SELECT uid2 FROM friend WHERE uid1 = me())) AND ( (type = "BAR") OR (type = "LANDMARK") OR (type = "CHURCH/RELIGIOUS ORGANIZATION") OR (type = "LOCAL BUSINESS") OR (type = "RESTAURANT/CAFE") OR (type = "CLUB") OR (type = "MOVIE THEATER") OR (type = "SCHOOL") OR (type = "ATTRACTIONS/THINGS TO DO") OR (type = "ARTS/ENTERTAINMENT/NIGHTLIFE") OR (type = "LOCAL/TRAVEL") OR (type = "RESTAURANT") OR (type = "EDUCATION") OR (type = "UNIVERSITY") OR (type = "SHOPPING/RETAIL") OR (type = "FOOD/BEVERAGES") OR (type = "BOOK STORE") OR (type = "THEME PARK") OR (type = "HOTEL") OR (type = "SPAS/BEAUTY/PERSONAL CARE") OR (type = "TRAVEL/LEISURE") OR (type = "TOURS/SIGHTSEEING") OR (type = "SMALL BUSINESS") OR (type = "ARTS/HUMANITIES") OR (type = "CITY") OR (type = "LIBRARY") OR (type = "PUBLIC PLACES") OR (type = "CONCERT VENUE") OR (type = "HEALTH/MEDICAL/PHARMACY") OR (type = "ENTERTAINMENT") OR (type = "MUSEUM/ART GALLERY") OR (type = "MUSEUM") OR (type = "FOOD") ) """ return ws.queryFacebookFQL(likes, self.access_token)