fdist ?
fdist?
fdist.freq('Delicious')
fdist
fdist.freq('rainy')
Business.where_raw('')
Business.where_raw('latitude <= 40.75')
Business.where_raw('latitude <= 40.75').count()
Business.where_raw('latitude <= 40.75 and latitude > 40.749')
Business.where_raw('latitude <= 40.75 and latitude > 40.749').count
Business.where_raw('latitude <= 40.75 and latitude > 40.749').count()
lat = 40.71
lon = -74.01
Business.where_raw('latitude', '>=', lat).where('latitude', '<', lat + 0.001)
Business.where_raw('latitude', '>=', lat).where('latitude', '<', lat + 0.001).count()
Business.where('latitude', '>=', lat).where('latitude', '<', lat + 0.001)
Business.where('latitude', '>=', lat).where('latitude', '<', lat + 0.001).count()
def businessesAt(lat, lon):
Business.where('latitude', '>=', lat).where('latitude', '<', lat + 0.001).where('longitude', '>=', lon).where('longitude', '<', lon + 0.001)
businessesAt(lat, lon)
businessesAt(lat, lon).count()
b = businessesAt(lat, lon)
b
def businessesAt(lat, lon):
return Business.where('latitude', '>=', lat).where('latitude', '<', lat + 0.001).where('longitude', '>=', lon).where('longitude', '<', lon + 0.001)
businessesAt(lat, lon).count()
businessesAt(lat, lon).reviews()
dir(businessesAt(lat, lon))
def businessesAt(lat, lon):
return Business.where_between('latitude', [lat, lat + 0.001]).where_between('longitude', [lon, lon + 001])
def businessesAt(lat, lon):
def businessesAt(lat, lon):
return Business.where('latitude', '>=', lat).where('latitude', '<', lat + 0.001).where('longitude', '>=', lon).where('longitude', '<', lon + 0.001)
import subprocess
import os.path
import json
import dateutil.parser
import time
from database import Business, Review
for business in Business.where('checked', None).get():
if (business.id > 0) and (business.reviews.count() == 0):
time.sleep(5)
print(f'{business.id}: {business.name}, {2797 - business.id} left')
data = subprocess.check_output(['./bin/reviews', business.remote_id])
parsed = json.loads(data.decode('utf-8'))
reviews = parsed.get('reviews')
if reviews is not None:
for r in reviews:
d = dateutil.parser.parse(r['date'])
review = Review.create(
business_id=business.id,
content=r['content'],
date=round(d.timestamp()),
rating=r['rating']
)
business.update({'checked': round(time.time())})
else: