def create_venue_submission(): # TODO: insert form data as a new Venue record in the db, instead # TODO: modify data to be the data object returned from db insertion name = request.form.get('name') city = request.form.get('city') state = request.form.get('state') phone = request.form.get('phone') genres = request.form.get('genres') facebook_link = request.form.get('facebook_link') venue = Venue(name=name, city=city, state=state, phone=phone, genres=genres, facebook_link=facebook_link) ##venue.id =1 ##Kaustav try: venue.add() flash("Venue" + request.form['name'] + "was successfully listed!") except: flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') db.session.rollback() #abort(422) finally: db.session.close() ##flash('Venue ' + request.form['name'] + ' was successfully listed!') # TODO: on unsuccessful db insert, flash an error instead. # e.g., flash('An error occurred. Venue ' + data.name + ' could not be listed.') # see: http://flask.pocoo.org/docs/1.0/patterns/flashing/ return render_template('pages/home.html')
def create_venue_submission(): # DONE: TODO: insert form data as a new Venue record in the db, instead # DONE: TODO: modify data to be the data object returned from db insertion # on successful db insert, flash success venue_form = VenueForm(request.form) try: newVenue = Venue( name=venue_form.name.data, address=venue_form.address.data, city=venue_form.city.data, state=venue_form.state.data, phone=venue_form.phone.data, facebook_link=venue_form.facebook_link.data, image_link=venue_form.image_link.data, genres=",".join(venue_form.genres.data), seeking_talent=venue_form.seeking_talent.data == 'True') newVenue.add() flash('Venue ' + newVenue.name + ' was successfully listed!') return redirect(url_for('index')) except: # DONE: TODO: on unsuccessful db insert, flash an error instead. # e.g., flash('An error occurred. Venue ' + data.name + ' could not be listed.') flash('An error occurred. Venue ' + venue_form.name.data + ' could not be listed.') print(sys.exc_info()) return render_template('forms/new_venue.html', form=venue_form)
def create_venue_submission(): venue_form = VenueForm(request.form) try: new_venue = Venue(name=venue_form.name.data, genres=','.join(venue_form.genres.data), address=venue_form.address.data, city=venue_form.city.data, state=venue_form.state.data, phone=venue_form.phone.data, facebook_link=venue_form.facebook_link.data, image_link=venue_form.image_link.data) if not new_venue.isExists(): new_venue.add() # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') else: flash( 'Venue with a Name: {} , City: {} , and State: {} already exists! New record not inserted'.\ format(request.form['name'], request.form['city'], request.form['state'])) except Exception as ex: flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') traceback.print_exc() return render_template('pages/home.html')
def create_venue_submission(): venue_form = VenueForm(request.form) try: new_venue = Venue(name=venue_form.name.data, genres=','.join(venue_form.genres.data), city=venue_form.city.data, state=venue_form.state.data, phone=venue_form.phone.data, facebook_link=venue_form.facebook_link.data, image_link=venue_form.image_link.data) new_venue.add() # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') except Exception as ex: flash('An error occurred. Artist ' + request.form['name'] + ' could not be listed.') print(ex) return render_template('pages/home.html')
def create_venue_submission(): # TODO: insert form data as a new Venue record in the db, instead # TODO: modify data to be the data object returned from db insertion form = VenueForm(request.form) try: venue = Venue() form.populate_obj(venue) venue.add() # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') # TODO: on unsuccessful db insert, flash an error instead. # e.g., flash('An error occurred. Venue ' + data.name + ' could not be listed.') # see: http://flask.pocoo.org/docs/1.0/patterns/flashing/ except Exception as ex: flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') response = recent_venue_artist() return render_template('pages/home.html', results=response)