def get(self):
# ensure all the beers are part of the ndb database. If they aren't, add them
if len(Beer.query().fetch()) == 0:
for beer in beers:
ndbBeer = Beer()
ndbBeer.beerid = int(beer['id'])
ndbBeer.brewery = beer['brewery']
ndbBeer.product = beer['product']
ndbBeer.style = beer['style']
ndbBeer.abv = float(beer['abv'])
ndbBeer.price = beer['price']
ndbBeer.key = ndb.Key('Beer', beer['id'])
ndbBeer.put()
email = get_user_email()
user_is_admin = is_user_admin()
if email:
beerUser = BeerUser.get_user_profile(email)
page_params = {
'balance': "${:.2f}".format(beerUser.balance),
'user_email': email,
'user_is_admin': user_is_admin,
'login_url': users.create_login_url('/home'),
'logout_url': users.create_logout_url('/home')
}
else:
page_params = {
'user_email': email,
'user_is_admin': user_is_admin,
'login_url': users.create_login_url('/home'),
'logout_url': users.create_logout_url('/home')
}
render_template(self, 'home.html', page_params)
def load_beer():
"""
Load beer from allbeerdata.json into database.
>>> beerz = json.load(open('seed_data/allbeerdata.json'))
>>> len(beerz)
6300
>>> name = beerz[1]['name_display']
>>> name
u'1916 Irish Stout'
"""
beerz = json.load(open('seed_data/allbeerdata.json'))
beerz_len = len(beerz)
# json.load(open(‘file.json’)) loads JSON from a file
# beerz is a python list
# there are 6300 beers in beerz
print "Fill er up! Beers are being loaded."
# can only add 49 beers to db right now, because I haven't split the file on the dictionaries.
# go back and change later!
# really need to be getting the brewey back as well.
for i in range(0, 49):
name = beerz[i]['name_display']
abv = beerz[i]['abv']
beer_code = beerz[i]['beer_id']
# description = beerz[i]['description']
ibu = beerz[i]['ibu']
# labels = beerz[i]['labels']
# website = beerz[i]['website']
style_id = beerz[i]['style_id']
beer_variation = beerz[i]['beer_variation']
beer_variation_id = beerz[i]['beer_variation_id']
year = beerz[i]['year']
# add the beer object as a beer in the beer table
beer = Beer(
abv=abv,
beer_code=beer_code,
beer_variation=beer_variation,
beer_variation_id=beer_variation_id,
# description=description,
ibu=ibu,
# labels=labels,
# website=website,
style_id=style_id,
year=year,
name=name,
)
db.session.add(beer)
# Once we're done, we should commit our work
db.session.commit()
def newBeer(beerType_id):
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
addBeer = Beer(name=request.form['name'],
description=request.form['description'],
type_id=beerType_id)
user_id = login_session['user_id']
session.add(addBeer)
session.commit()
return redirect(url_for('showBeers', beerType_id=beerType_id))
else:
return render_template('newBeer.html', beerType_id=beerType_id)
def load_beer():
"""Load beer from allbeerdata.json into database."""
print "Fill er up! Beers are being loaded."
for i in range(0, 6300):
name = beerz[i]['name_display']
abv = beerz[i]['abv']
beer_code = beerz[i]['beer_id']
description = beerz[i]['description']
ibu = beerz[i]['ibu']
labels = beerz[i]['labels']
website = beerz[i]['website']
style_id = beerz[i]['style_id']
beer_variation = beerz[i]['beer_variation']
beer_variation_id = beerz[i]['beer_variation_id']
year = beerz[i]['year']
# add the beer object as a beer in the beer table
beer = Beer(
abv=abv,
beer_code=beer_code,
beer_variation=beer_variation,
beer_variation_id=beer_variation_id,
description=description,
ibu=ibu,
labels=labels,
website=website,
style_id=style_id,
year=year,
name=name,
)
db.session.add(beer)
# Once we're done, we should commit our work
db.session.commit()
userOne = User(name="Cousin Luigi",
email="*****@*****.**",
picture=4)
session.add(userOne)
session.commit()
# Add lager beer type
beerType1 = BeerType(type="Lager", user_id=1)
session.add(beerType1)
session.commit()
# Add lagers
beer1 = Beer(name="5 Points",
description="Hoppy beer, with a good head, from London",
type_id=beerType1.id,
user_id=userOne.id)
session.add(beer1)
session.commit()
beer2 = Beer(name="Hell's Lager",
description="From Camden brewery, popular lager for good reason",
type_id=beerType1.id,
user_id=userOne.id)
session.add(beer2)
session.commit()
beer3 = Beer(
name="Meantime Lager",
