def create_venue_submission():
error = False
venue_name = request.get_json()['name']
try:
body = {}
venue = Venue(name=venue_name)
city_name = request.get_json()['city']
state_id = request.get_json()['state']
genres = request.get_json()['genres']
city = City.query.filter(City.name == city_name).first()
if city == None:
city = City(name=city_name)
city.state_id = state_id
venue.city = city
venue.phone = request.get_json()['phone']
venue.facebook_link = request.get_json()['facebook_link']
for genre_id in genres:
genre = Genre.query.get(genre_id)
venue.genres.append(genre)
db.session.add(venue)
db.session.commit()
body['id'] = venue.id
body['name'] = venue.name
except:
print("Oops!", sys.exc_info(), "occured.")
error = True
db.session.rollback()
finally:
db.session.close()
if error:
flash('venue ' + venue_name + ' could not be listed.')
abort(400)
else:
flash('venue ' + venue_name + ' was successfully listed!')
return jsonify(body)
# Cities
uniondale = City(name="Uniondale, NY")
veneta = City(name="Veneta, OR")
nyc = City(name="New York, NY")
ithaca = City(name="Ithaca, NY")
# Venues
nassau_coliseum = Venue(name='Nassau Veterans Memorial Coliseum',
capacity=17686)
springfield_creamery = Venue(name='Springfield Creamery', capacity=30000)
msg = Venue(name="Madison Square Garden", capacity=20789)
barton_hall = Venue(name="Barton Hall", capacity=5000)
brooklyn_bowl = Venue(name="Brooklyn Bowl", capacity=600)
nassau_coliseum.city = uniondale
springfield_creamery.city = veneta
msg.city = nyc
barton_hall.city = ithaca
brooklyn_bowl.city = nyc
phish_11_28_03.venue = nassau_coliseum
phish_12_31_95.venue = msg
dead_5_8_77.venue = barton_hall
dead_venetta.venue = springfield_creamery
dead_1_7_79.venue = msg
# Songs
mikes = Song(name="Mike's Song")
brown_eyed_women = Song(name="Brown Eyed Women")
scarlet_begonias = Song(name="Scarlet Begonias")
