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_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():
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.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():
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(
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():
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():
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 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():
# 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 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 edit_venue_submission(venue_id):
# TODO: take values from the form submitted, and update existing
# venue record with ID <venue_id> using the new attributes
form = VenueForm(request.form)
venue = Venue().query.get(venue_id)
try:
venue = Venue().query.get(venue_id)
venue.name = form.name.data
venue.genres = ','.join(form.genres.data)
venue.city = form.city.data
venue.state = form.state.data
venue.phone = form.phone.data
venue.facebook_link = form.facebook_link.data
venue.image_link = form.image_link.data
db.session.commit()
flash('Venue ' + request.form['name'] + 'was successfully updated!')
except:
db.session.rollback()
flash(f'An error occurred.')
finally:
db.session.close()
return redirect(url_for('show_venue', venue_id=venue_id))
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():
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')
