def create_venue_submission(): """ The function create new venue with properties filled into Venue Form and insert new venue to database Returns: Render Home Page with flash for successed or faild """ New_Venue_Form = VenueForm(request.form) try: New_Venue = Venue() New_Venue.name = New_Venue_Form.name.data New_Venue.genres = ','.join(New_Venue_Form.genres.data) New_Venue.city = New_Venue_Form.city.data New_Venue.state = New_Venue_Form.state.data New_Venue.phone = New_Venue_Form.phone.data New_Venue.address = New_Venue_Form.address.data New_Venue.facebook_link = New_Venue_Form.facebook_link.data if(not ValidPhoneNumber(New_Venue_Form.phone.data)): raise ValueError db.session.add(New_Venue) db.session.commit() flash('Venue ' + request.form['name'] + ' was successfully listed!') except ValueError: db.session.rollback() flash('Incorrect phone number format xxx-xxx-xxxx (' + request.form['phone']+ '), please try again.') except: db.session.rollback() flash('An error occurred. Venue ' + request.form['name']+ ' could not be listed.') finally: db.session.close() return render_template('pages/home.html')
def create_venue_submission(): error = False try: venue = Venue() venue.name = request.form.get('name') venue.city = request.form.get('city') venue.state = request.form.get('state') venue.address = request.form.get('address') venue.phone = request.form.get('phone') venue.genres = request.form.getlist('genres') venue.image_link = request.form.get('image_link') venue.facebook_link = request.form.get('facebook_link') venue.website = request.form.get('website') venue.seeking_talent = request.form.get('seeking_talent') venue.seeking_description = request.form.get('seeking_description') db.session.add(venue) db.session.commit() except: error = True db.session.rollback() print(sys.exc_info()) finally: db.session.close() if error: flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') else: flash('Venue ' + request.form['name'] + ' was successfully listed!') return render_template('pages/home.html')
def create_venue_submission(): data = Venue() error = False try: # TODO: insert form data as a new Venue record in the db, instead data.name = request.form['name'] data.city = request.form['city'] data.state = request.form['state'] data.address = request.form['address'] data.phone = request.form['phone'] data.genres = ','.join(request.form.getlist('genres')) data.facebook_link = request.form['facebook_link'] db.session.add(data) db.session.commit() # TODO: modify data to be the data object returned from db insertion except: error = True db.session.rollback() # 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 occured! Venue ' + request.form['name'] + ' could not be added.') finally: # on successful db insert, flash success if error == False: flash('Venue ' + request.form['name'] + ' was successfully listed!') # see: http://flask.pocoo.org/docs/1.0/patterns/flashing/ return render_template('pages/home.html')
def create_venue_submission(): error = False try: venue = Venue() venue.name = request.form['name'] venue.city = request.form['city'] venue.state = request.form['state'] venue.address = request.form['address'] venue.phone = request.form['phone'] tmp_genres = request.form.getlist('genres') venue.genres = ','.join(tmp_genres) venue.facebook_link = request.form['facebook_link'] db.session.add(venue) db.session.commit() except: error = True db.session.rollback() print(sys.exc_info()) finally: db.session.close() if error: flash('An error occured. Venue ' + request.form['name'] + ' Could not be listed!') else: flash('Venue ' + request.form['name'] + ' was successfully listed!') return render_template('pages/home.html')
def create_venue_submission(): errorFlag = False try: venue = Venue() submission = request.form venue.address = submission['address'] venue.city = submission['city'] venue.facebook_link = submission['facebook_link'] venue.genres = submission.getlist('genres') venue.image_link = submission['image_link'] venue.name = submission['name'] venue.phone = submission['phone'] venue.seeking_description = submission['seeking_description'] venue.seeking_talent = True if 'seeking_talent' in submission else False venue.state = submission['state'] venue.website = submission['website'] db.session.add(venue) db.session.commit() except Exception as e: errorFlag = True db.session.rollback() finally: db.session.close() if not errorFlag: # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') else: # on unsuccessful db insert, flash an error instead. flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') return render_template('pages/home.html')
def create_venue_submission(): form = VenueForm(request.form) new_venue = Venue() new_venue.name = form.name.data, new_venue.city = form.city.data new_venue.state = form.state.data new_venue.address = form.address.data new_venue.phone = form.phone.data new_venue.facebook_link = form.facebook_link.data new_venue.genres = form.genres.data new_venue.image_link = form.image_link.data new_venue.website = form.website.data new_venue.seeking_description = form.seeking_description.data new_venue.seeking_talent = form.seeking_talent.data try: db.session.add(new_venue) db.session.commit() # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') except: db.session.rollback() flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') finally: db.session.close() return render_template('pages/home.html')
def create_venue( offerer, name='La petite librairie', booking_email='*****@*****.**', address='123 rue de Paris', postal_code='93100', city='Montreuil', departement_code='93', is_virtual=False, longitude='2.4002701', latitude='48.8363788', siret='12345678912345', validation_token=None, comment=None, idx=None, publicName=None ): venue = Venue() venue.bookingEmail = booking_email if not is_virtual: venue.address = address venue.postalCode = postal_code venue.city = city venue.departementCode = departement_code venue.name = name venue.managingOfferer = offerer venue.isVirtual = is_virtual venue.longitude = longitude venue.latitude = latitude venue.siret = siret venue.validationToken = validation_token venue.comment = comment venue.id = idx venue.publicName = publicName return venue
def create_venue_submission(): form = VenueForm() if form.validate_on_submit(): try: venue = Venue() venue.name = request.form['name'] venue.city = request.form['city'] venue.state = request.form['state'] venue.address = request.form['address'] venue.phone = request.form['phone'] venue.image_link = request.form['image_link'] venue.genres = request.form.getlist('genres') venue.facebook_link = request.form['facebook_link'] venue.website = request.form['website'] venue.seeking_talent = True if 'seeking_talent' in request.form else False venue.seeking_description = request.form['seeking_description'] db.session.add(venue) db.session.commit() except Exception as e: db.session.rollback() flash( 'An error occurred. Venue {} Could not be listed!, {}'.format( request.form['name'], str(e))) finally: db.session.close() flash('Venue {} was successfully listed!'.format( request.form['name'])) return redirect(url_for('venues')) return render_template('forms/new_venue.html', form=form)
def create_venue_submission(): error = False try: # TODO: insert form data as a new Venue record in the db, instead venue = Venue() venue.name = request.form['name'] venue.city = request.form['city'] state = State.query.filter_by(name=request.form['state']).first() venue.state = state venue.address = request.form['address'] venue.phone = request.form['phone'] venue.facebook_link = request.form['facebook_link'] venue.genres = Genre.query.filter( Genre.name.in_(request.form.getlist('genres'))).all() db.session.add(venue) db.session.commit() except: error = True # TODO: on unsuccessful db insert, flash an error instead. flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') db.session.rollback() print(sys.exc_info()) finally: db.session.close() # TODO: modify data to be the data object returned from db insertion if not error: # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') 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) if form.validate(): try: venue = Venue() venue.name = request.form.get('name') venue.city = request.form.get('city') venue.state = request.form.get('state') venue.address = request.form.get('address') venue.phone = request.form.get('phone') venue.genres = form.genres.data venue.image_link = request.form.get('image_link', None) venue.facebook_link = request.form.get('facebook_link', None) venue.website = request.form.get('website', None) venue.seeking_description = request.form.get('seeking_description', None) venue.seeking_talent = boolean_check(request.form.get('seeking_talent')) venue.insert() # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') except: flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') else: flash(form.errors) # 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(): # TODO: [COMPLETED] insert form data as a new Venue record in the db, instead # TODO: [COMPLETED] modify data to be the data object returned from db insertion error = False try: website = '' seeking_talent = False seeking_description = '' image_link = '' if 'seeking_talent' in request.form: seeking_talent = request.form['seeking_talent'] if 'seeking_description' in request.form: seeking_description = request.form['seeking_description'] if 'website' in request.form: website = request.form['website'] if 'image_link' in request.form: image_link = request.form['image_link'] venue = Venue() venue.name = request.form['name'] venue.city = request.form['city'] venue.state = request.form['state'] venue.address = request.form['address'] venue.phone = request.form['phone'] venue.genres = ','.join(request.form.getlist('genres')) venue.facebook_link = request.form['facebook_link'] venue.website = website venue.image_link = image_link venue.seeking_talent = seeking_talent venue.seeking_description = seeking_description db.session.add(venue) db.session.commit() except Exception as e: error = True print(f'Error ==> {e}') db.session.rollback() finally: db.session.close() if error: flash('An error occured. Venue ' + request.form['name'] + ' could not be listed!') else: flash('Venue ' + request.form['name'] + ' was successfully listed!') return render_template('pages/home.html')
def addVenueData(): venues = Venue.query.all() # only load data if db is empty if (not len(venues)): for defaultVenue in venues_default_data: venue = Venue() venue.address = defaultVenue['address'] venue.city = defaultVenue['city'] venue.facebook_link = defaultVenue['facebook_link'] venue.genres = defaultVenue['genres'] venue.image_link = defaultVenue['image_link'] venue.name = defaultVenue['name'] venue.phone = defaultVenue['phone'] venue.seeking_description = defaultVenue['seeking_description'] venue.seeking_talent = defaultVenue['seeking_talent'] venue.state = defaultVenue['state'] venue.website = defaultVenue['website'] db.session.add(venue) db.session.commit()
def create_venue_submission(): form = VenueForm() error = False try: name = form.name.data if (db.session.query(Venue.name).filter_by(name=name).scalar() is not None): flash('The venue : "' + name + '" already exists', 'error') return render_template('forms/new_venue.html', form=form) form.validate() if (len(form.phone.errors) > 0): flash(','.join(form.phone.errors)) return render_template('forms/new_venue.html', form=form) venue = Venue() venue.name = name venue.city = form.city.data venue.state = form.state.data venue.address = form.address.data venue.phone = format_phone(form.phone.data) venue.genres = ','.join(request.form.getlist('genres')) venue.facebook_link = form.facebook_link.data venue.website = form.website.data venue.image_link = form.image_link.data venue.seeking_talent = form.seeking_talent.data venue.seeking_description = form.seeking_description.data db.session.add(venue) db.session.commit() except Exception as e: error = True print('Error in creating venue', e) db.session.rollback() finally: db.session.close() if error: flash( 'An error occured. Venue ' + request.form['name'] + ' Could not be listed.', 'error') else: flash('Venue ' + request.form['name'] + ' was successfully listed.') return render_template('pages/home.html')
def create_venue_submission(): # 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 - DONE # TODO: on unsuccessful db insert, flash an error instead. - DONE # e.g., flash('An error occurred. Venue ' + data.name + ' could not be listed.') # see: http://flask.pocoo.org/docs/1.0/patterns/flashing/ form = VenueForm(request.form, meta={'csrf': False}) if form.validate(): try: venue = Venue() venue.name = request.form.get('name', '') venue.city = request.form.get('city', '') venue.state = request.form.get('state', '') venue.address = request.form.get('address', '') venue.phone = request.form.get('phone', '') venue.genres = json.dumps(request.form.getlist('genres')) if (request.form.get('seeking_talent', False) == 'y'): venue.seeking_talent = True else: venue.seeking_talent = False venue.seeking_description = request.form.get('seeking_description', '') venue.website = request.form.get('website', '') venue.facebook_link = request.form.get('facebook_link', '') venue.image_link = request.form.get('image_link', '') db.session.add(venue) db.session.commit() # on successful db insert, flash success flash('Venue ' + request.form['name'] + ' was successfully listed!') except: db.session.rollback() # on unsuccessful db insert, flash an error flash('An error occurred. Venue ' + venue.name + ' could not be listed.') finally: return render_template('pages/home.html') else: message = [] for field, err in form.errors.items(): message.append(field + ' ' + '|'.join(err)) flash('Errors ' + str(message)) return render_template('pages/home.html')
def create_venue_submission(): error = False try: data = request.form venue = Venue() venue.name = data['name'] genres = [] for (k, v) in data.items(multi=True): if k == 'genres': genres.append(v) venue.genres = genres venue.address = data['address'] venue.city = data['city'] venue.state = data['state'] venue.phone = data['phone'] venue.website = data['website'] venue.facebook_link = data['facebook_link'] venue.seeking_talent = 'seeking_talent' in data venue.seeking_description = data['seeking_description'] venue.image_link = data['image_link'] db.session.add(venue) db.session.commit() except: db.session.commit() error = True print(sys.exc_info()) finally: db.session.close() if error: flash('ERROR: Venue ' + request.form['name'] + ' could not be listed!') else: flash('Venue ' + request.form['name'] + ' successfully listed!') return render_template('pages/home.html')
def create_venue_submission(): form = VenueForm() if form.validate_on_submit(): try: venue = Venue() venue.name = form.name.data venue.city_id = get_city_id(form.city.data, form.state.data) venue.address = form.address.data venue.facebook_link = form.facebook.data venue.image_link = form.image.data venue.phone = form.phone.data venue.seeking_talent = form.isSeeking.data venue.seeking_description = form.seekingDescription.data venue.genres = form.genres.data db.session.add(venue) db.session.commit() flash('Venue ' + venue.name + ' was successfully listed!') except Exception as e: flash('An error occurred: ' + str(e)) db.session.rollback() finally: db.session.close() return redirect(url_for('venues')) return render_template('forms/new_venue.html', form=form)
def create_venue_submission(): try: venue = Venue(name=request.form.get('name', '')) venue.city = request.form.get('city', '') venue.state = request.form.get('state', '') venue.address = request.form.get('address', '') venue.phone = request.form.get('phone', '') venue.image_link = request.form.get('image_link', '') venue.genres = request.form.getlist('genres') venue.facebook_link = request.form.get('facebook_link', '') venue.website = request.form.get('website_link', '') venue.seeking_talent = request.form.get('seeking_talent', 'n') == 'y' venue.seeking_description = request.form.get('seeking_description', '') db.session.add(venue) db.session.commit() flash('Venue ' + venue.name + ' was successfully listed!') except: db.session.rollback() flash('An error occurred. Venue ' + request.form['name'] + ' could not be listed.') finally: db.session.close() return render_template('pages/home.html')