Exemple #1
0
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']
        genre = request.form.getlist('genres')
        venue.genres = ','.join(genre)
        venue.facebook_link = request.form['facebook_link']
        db.session.add(venue)
        db.session.commit()
    except:
        error = True
        db.session.rollback()
        print(sys.exc_info())

    db.session.close()
    if error:
        flash('An error occured. Venue ' +
              request.form['name'])
    else:
        flash('Venue ' + request.form['name'] +
              ' was successfully added!')
    return render_template('pages/home.html')
Exemple #2
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
    error = False

    try:
        data = Venue()
        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 = request.form.getlist('genres')
        data.facebook_link = request.form['facebook_link']

        if Venue.query.filter_by(name=data.name).filter_by(
                city=data.city).filter_by(state=data.state).filter_by(
                    address=data.address) != None:
            flash("Venue " + request.form['name'] +
                  " is already in the database")
            return render_template('pages/home.html')

        db.session.add(data)
        db.session.commit()
    except:
        error = True
        db.session.rollback()
        print(sys.exc_info())
    finally:
        db.session.close()
    if error:
        flash("error occurs at " + request.form['name'])
        print(sys.exc_info())
    if not error:
        # 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/
    return render_template('pages/home.html')