def businesses_in_shape(s):
return list(
filter(
lambda b: s.contains(Point(b.longitude, b.latitude)),
list(Business.all())
)
)
def businessesAt(lat, lon):
return Business.where_between('latitude', [lat, lat + 0.001]).where_between('longitude', [lon, lon + 0.001])
def businessesAt(lat, lon):
return Business.where('latitude', '>=', lat).where('latitude', '<', lat + 0.001).where('longitude', '>=', lon).where('longitude', '<', lon + 0.001)
fdist['disgusting']
fdist['vegetarian']
fdist['old-timey']
fdist['healthy']
fdist['expensive']
print text
print(text)
fdist.freq('delicious')
fdist.freq('delicnotehu')
fdist.N()
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()
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:
from orator import DatabaseManager, Model
import csv
from database import Business, Category
DATA_SET = 'sfRestaurants'
with open(f'data/{DATA_SET}.csv', 'r') as csvfile:
reader = csv.DictReader(csvfile)
for b in reader:
business = Business.first_or_new(remote_id=b['id'])
business.name = b['name']
business.review_count = b['review_count']
business.rating = b['rating']
business.latitude = b['latitude']
business.longitude = b['longitude']
business.location = b['location']
business.price = b['price']
business.phone = b['phone']
business.save()
for c in b['categories'].split(';'):
category = Category.first_or_create(name=c)
business.categories().save(category)
}
}, {
"name": "Domenica",
"morning": {
"open": None,
"close": None
},
"afternoon": {
"open": None,
"close": None
}
}])
print("\n================================\n")
print("- Creazione attivita' commerciale: ")
name = input("Inserisci nome: ")
email = input("Inserisci email: ")
address = input("Inserisci indirizzo: ")
business = Business.create(name=name,
email=email,
address=address,
time_table=time_table)
OwnerBusiness.insert(user=admin.user_id,
business=business.business_id).execute()
print("\n================================\n")
print("Configurazione completata! Welcome")