var yelp = require("yelp").createClient({
consumer_key: process.env.YELP_CONSUMER_KEY,
consumer_secret: process.env.YELP_CONSUMER_SECRET,
token: process.env.YELP_TOKEN,
token_secret: process.env.YELP_TOKEN_SECRET
});
require("bluebird").Promise.promisifyAll(yelp);
module.exports = yelp.searchAsync.bind(yelp);
For demo purposes, we're going to return static data instead. But you can clone this notebook and delete the cell below, and set up your environment variables with valid Yelp API keys to make real API queries. https://www.yelp.com/developers
module.exports = function() {
return [{
"region": {
"span": {
"latitude_delta": 0.060730010000000334,
"longitude_delta": 0.07232763999999747
},
"center": {
"latitude": 37.774690050000004,
"longitude": -122.4405732
}
},
"total": 4044,
"businesses": [
{
"is_claimed": false,
"rating": 4.5,
"mobile_url": "http://m.yelp.com/biz/blue-bottle-coffee-san-francisco-8",
"rating_img_url": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/99493c12711e/ico/stars/v1/stars_4_half.png",
"review_count": 1610,
"name": "Blue Bottle Coffee",
"snippet_image_url": "http://s3-media1.fl.yelpcdn.com/photo/l60xLT9NWUn0rEM6MIpFfQ/ms.jpg",
"rating_img_url_small": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/a5221e66bc70/ico/stars/v1/stars_small_4_half.png",
"url": "http://www.yelp.com/biz/blue-bottle-coffee-san-francisco-8",
"menu_date_updated": 1436216474,
"phone": "5106533394",
"snippet_text": "Good lord this is good coffee! I asked what the difference was between Cafe au Lait and Latte since both were on the menu. I always thought they were the...",
"image_url": "http://s3-media1.fl.yelpcdn.com/bphoto/2NPsgzNnHOgzzIZM6KccJA/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"display_phone": "+1-510-653-3394",
"rating_img_url_large": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/9f83790ff7f6/ico/stars/v1/stars_large_4_half.png",
"menu_provider": "single_platform",
"id": "blue-bottle-coffee-san-francisco-8",
"is_closed": false,
"location": {
"cross_streets": "Octavia St & Gough St",
"city": "San Francisco",
"display_address": [
"315 Linden St",
"Hayes Valley",
"San Francisco, CA 94102"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Hayes Valley"
],
"postal_code": "94102",
"country_code": "US",
"address": [
"315 Linden St"
],
"coordinate": {
"latitude": 37.77638,
"longitude": -122.423211
},
"state_code": "CA"
}
},
{
"is_claimed": true,
"rating": 4,
"mobile_url": "http://m.yelp.com/biz/sightglass-coffee-san-francisco",
"rating_img_url": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/c2f3dd9799a5/ico/stars/v1/stars_4.png",
"review_count": 1089,
"name": "Sightglass Coffee",
"snippet_image_url": "http://s3-media4.fl.yelpcdn.com/photo/0AO-KXhw3Sk1B6n1sR5ZZQ/ms.jpg",
"rating_img_url_small": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/f62a5be2f902/ico/stars/v1/stars_small_4.png",
"url": "http://www.yelp.com/biz/sightglass-coffee-san-francisco",
"menu_date_updated": 1387664925,
"phone": "4158611313",
"snippet_text": "I love the atmosphere of this place: Open concept, huge windows, two floors, wooden tables, trendy hipster vibe. If I could, I would live here. \nOrdered the...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/NIcP2dFwZ2WhbjXE96e9WA/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"display_phone": "+1-415-861-1313",
"rating_img_url_large": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/ccf2b76faa2c/ico/stars/v1/stars_large_4.png",
"menu_provider": "single_platform",
"id": "sightglass-coffee-san-francisco",
"is_closed": false,
"location": {
"cross_streets": "Folsom St & Howard St",
"city": "San Francisco",
"display_address": [
"270 7th St",
"SoMa",
"San Francisco, CA 94103"
],
"geo_accuracy": 8,
"neighborhoods": [
"SoMa"
],
"postal_code": "94103",
"country_code": "US",
"address": [
"270 7th St"
],
"coordinate": {
"latitude": 37.7769585,
"longitude": -122.4085083
},
"state_code": "CA"
}
},
{
"is_claimed": false,
"rating": 4,
"mobile_url": "http://m.yelp.com/biz/four-barrel-coffee-san-francisco",
"rating_img_url": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/c2f3dd9799a5/ico/stars/v1/stars_4.png",
"review_count": 1558,
"name": "Four Barrel Coffee",
"snippet_image_url": "http://s3-media4.fl.yelpcdn.com/photo/0Xk7nuCrAJkwE88FSsHI3g/ms.jpg",
"rating_img_url_small": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/f62a5be2f902/ico/stars/v1/stars_small_4.png",
"url": "http://www.yelp.com/biz/four-barrel-coffee-san-francisco",
"menu_date_updated": 1434024766,
"phone": "4152520800",
"snippet_text": "I love Four Barrel Coffee. They have some interesting drinks on their menu for everyone to try. I ordered the goat's milk affogato and it was absolutely...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/mSxpbsrpvHCQUFIVReGzxw/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
],
[
"Cafes",
"cafes"
]
],
"display_phone": "+1-415-252-0800",
"rating_img_url_large": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/ccf2b76faa2c/ico/stars/v1/stars_large_4.png",
"menu_provider": "single_platform",
"id": "four-barrel-coffee-san-francisco",
"is_closed": false,
"location": {
"cross_streets": "15th St",
"city": "San Francisco",
"display_address": [
"375 Valencia St",
"Mission",
"San Francisco, CA 94103"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Mission"
],
"postal_code": "94103",
"country_code": "US",
"address": [
"375 Valencia St"
],
"coordinate": {
"latitude": 37.7670851470221,
"longitude": -122.421940218192
},
"state_code": "CA"
}
},
{
"is_claimed": true,
"rating": 4.5,
"mobile_url": "http://m.yelp.com/biz/philz-coffee-san-francisco",
"rating_img_url": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/99493c12711e/ico/stars/v1/stars_4_half.png",
"review_count": 1453,
"name": "Philz Coffee",
"snippet_image_url": "http://s3-media2.fl.yelpcdn.com/photo/-MvdR0XI6RyU4ARiY36D1A/ms.jpg",
"rating_img_url_small": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/a5221e66bc70/ico/stars/v1/stars_small_4_half.png",
"url": "http://www.yelp.com/biz/philz-coffee-san-francisco",
"menu_date_updated": 1387491811,
"phone": "4158759370",
"snippet_text": "My friends told me about how great Philz was but I didn't understand until I tried their coffee. \nI got an iced mint mojito, and the thing I notched a it it...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/n-oSziRhsVRHHUE5pT-rJA/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"display_phone": "+1-415-875-9370",
"rating_img_url_large": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/9f83790ff7f6/ico/stars/v1/stars_large_4_half.png",
"menu_provider": "single_platform",
"id": "philz-coffee-san-francisco",
"is_closed": false,
"location": {
"cross_streets": "Folsom St",
"city": "San Francisco",
"display_address": [
"3101 24th St",
"Mission",
"San Francisco, CA 94110"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Mission"
],
"postal_code": "94110",
"country_code": "US",
"address": [
"3101 24th St"
],
"coordinate": {
"latitude": 37.75239710283099,
"longitude": -122.41426366546
},
"state_code": "CA"
}
},
{
"is_claimed": false,
"rating": 4.5,
"mobile_url": "http://m.yelp.com/biz/wrecking-ball-coffee-roasters-san-francisco-2",
"rating_img_url": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/99493c12711e/ico/stars/v1/stars_4_half.png",
"review_count": 57,
"name": "Wrecking Ball Coffee Roasters",
"snippet_image_url": "http://s3-media4.fl.yelpcdn.com/photo/YRwXOTj5_8iipUm8KDRI1Q/ms.jpg",
"rating_img_url_small": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/a5221e66bc70/ico/stars/v1/stars_small_4_half.png",
"url": "http://www.yelp.com/biz/wrecking-ball-coffee-roasters-san-francisco-2",
"snippet_text": "I almost don't want to review this place because I feel like it's still sort of a hidden gem on Union, but that would not be fair to you all, would...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/P2VWaVf3kexbAspuX6t7xw/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"rating_img_url_large": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/9f83790ff7f6/ico/stars/v1/stars_large_4_half.png",
"id": "wrecking-ball-coffee-roasters-san-francisco-2",
"is_closed": false,
"location": {
"cross_streets": "Steiner St & Fillmore St",
"city": "San Francisco",
"display_address": [
"2271 Union St",
"Marina/Cow Hollow",
"San Francisco, CA 94123"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Marina/Cow Hollow"
],
"postal_code": "94123",
"country_code": "US",
"address": [
"2271 Union St"
],
"coordinate": {
"latitude": 37.7968548431401,
"longitude": -122.436591312289
},
"state_code": "CA"
}
},
]
}, null]
}
25 comments
- posted a month ago by1
- posted a month ago by1
- posted a month ago by-1 OR 2+443-443-1=0+0+0+1 --
- posted a month ago by-1 OR 2+230-230-1=0+0+0+1
- posted a month ago by-1' OR 2+137-137-1=0+0+0+1 --
- posted a month ago by-1' OR 2+18-18-1=0+0+0+1 or 'FYdZYNpi'='
- posted a month ago by-1" OR 2+430-430-1=0+0+0+1 --
- posted a month ago byif(now()=sysdate(),sleep(15),0)
- posted a month ago by0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z
- posted a month ago by0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z
- posted a month ago by(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
- posted a month ago by-1; waitfor delay '0:0:15' --
- posted a month ago by-1); waitfor delay '0:0:15' --
- posted a month ago by1 waitfor delay '0:0:15' --
- posted a month ago bymcmNLIcd'; waitfor delay '0:0:15' --
- posted a month ago by-5 OR 835=(SELECT 835 FROM PG_SLEEP(15))--
- posted a month ago by-5) OR 57=(SELECT 57 FROM PG_SLEEP(15))--
- posted a month ago by-1)) OR 15=(SELECT 15 FROM PG_SLEEP(15))--
- posted a month ago byBRQRohqT' OR 733=(SELECT 733 FROM PG_SLEEP(15))--
- posted a month ago byZr9LnM07') OR 677=(SELECT 677 FROM PG_SLEEP(15))--
- posted a month ago byfJGzSac7')) OR 219=(SELECT 219 FROM PG_SLEEP(15))--
- posted a month ago by1*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
- posted a month ago by1'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
- posted a month ago by1'"
- posted a month ago by@@ztVUj
sign in to comment