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)
