def delete_show(show_id):
show = Show(id=show_id)
try:
show.delete()
response = jsonify(type="success")
response.status_code = 200
return response
except Exception as ex:
_message = 'An error occurred. ' + ex.args[0]
response = jsonify(type="error", message=_message)
response.status_code = 522 #custom server error code
return response
def delete_venue(venue_id):
# TODO: Complete this endpoint for taking a venue_id, and using
# SQLAlchemy ORM to delete a record. Handle cases where the session commit could fail.
print("demande delete recue")
try:
venue_genre = GenreVenue.delete().where(venue_id == venue_id)
db.engine.execute(venue_genre)
show = Show.delete().where('Show.venue_id' == venue_id)
db.engine.execute(show)
db.session.delete(Venue.query.get(venue_id))
db.session.commit()
print("deleted")
flash('Venue with ID= ' + venue_id + ' is deleted.')
except:
print("not deleted")
flash('An error 1 occurred. Venue with ID= ' + venue_id +
' could not be deleted.')
db.session.rollback()
finally:
db.session.close()
# BONUS CHALLENGE: Implement a button to delete a Venue on a Venue Page, have it so that
# clicking that button delete it from the db then redirect the user to the homepage
#return render_template('pages/home.html')
return redirect(url_for('index'))
def db_cleanup():
# Movie cleanup
aprint('Cleaning up movies...', 'NOTIFICATOR')
movies = Movie.select().order_by(Movie.title)
n_movies = len(movies)
for movie in movies:
deletion = Movie.delete().where(Movie.imdb == movie.imdb,
Movie.quality == movie.quality)
deletion.execute()
aprint('Deleted {} movies.'.format(n_movies), 'NOTIFICATOR')
# TV cleanup
aprint('Cleaning up tv shows...', 'NOTIFICATOR')
episodes = Show.select().order_by(Show.series).order_by(
Show.season).order_by(Show.episode)
n_episodes = len(episodes)
for episode in episodes:
deletion = Show.delete().where(Show.series == episode.series,
Show.season == episode.season,
Show.episode == episode.episode)
deletion.execute()
aprint('Deleted {} episodes.'.format(n_episodes), 'NOTIFICATOR')
# Tracks cleanup
aprint('Cleaning up tracks...', 'NOTIFICATOR')
tracks = Track.select().order_by(Track.artist).order_by(Track.tracknumber)
n_tracks = len(tracks)
for track in tracks:
deletion = Track.delete().where(Track.artist == track.artist,
Track.title == track.title,
Track.tracknumber == track.tracknumber,
Track.quality == track.quality)
deletion.execute()
aprint('Deleted {} tracks.'.format(n_tracks), 'NOTIFICATOR')
def func():
show = Show(showtime=showtime, end=end)
show.save()
show.delete()
def func():
show = Show(showtime=showtime, end=end)
show.save()
show.delete()
