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()