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')
Пример #2
0
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)
Пример #3
0
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')
Пример #4
0
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')
Пример #5
0
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)