def admin_delete_chal(): challenge = Challenges.query.filter_by(id=request.form['id']).first() if challenge: WrongKeys.query.filter_by(chalid=challenge.id).delete() Solves.query.filter_by(chalid=challenge.id).delete() Keys.query.filter_by(chal=challenge.id).delete() files = Files.query.filter_by(chal=challenge.id).all() Files.query.filter_by(chal=challenge.id).delete() for file in files: folder = os.path.dirname(file.location) rmdir(folder) Tags.query.filter_by(chal=challenge.id).delete() Challenges.query.filter_by(id=challenge.id).delete() db.session.commit() db.session.close() return '1'
def admin_delete_chal(): challenge = Challenges.query.filter_by(id=request.form['id']).first_or_404() WrongKeys.query.filter_by(chalid=challenge.id).delete() Solves.query.filter_by(chalid=challenge.id).delete() Keys.query.filter_by(chal=challenge.id).delete() files = Files.query.filter_by(chal=challenge.id).all() Files.query.filter_by(chal=challenge.id).delete() for file in files: upload_folder = app.config['UPLOAD_FOLDER'] folder = os.path.dirname(os.path.join(os.path.normpath(app.root_path), upload_folder, file.location)) utils.rmdir(folder) Tags.query.filter_by(chal=challenge.id).delete() Challenges.query.filter_by(id=challenge.id).delete() db.session.commit() db.session.close() return '1'
def admin_delete_chal(): challenge = Challenges.query.filter_by( id=request.form['id']).first_or_404() Announcements.query.filter_by(chalid=challenge.id).delete() Notepads.query.filter_by(chalid=challenge.id).delete() Marks.query.filter_by(chalid=challenge.id).delete() WrongKeys.query.filter_by(chalid=challenge.id).delete() Solves.query.filter_by(chalid=challenge.id).delete() Keys.query.filter_by(chal=challenge.id).delete() files = Files.query.filter_by(chal=challenge.id).all() for file in files: folder = os.path.dirname( os.path.join(os.path.normpath(app.root_path), 'uploads', file.location)) rmdir(folder) Files.query.filter_by(chal=challenge.id).delete() Tags.query.filter_by(chal=challenge.id).delete() Challenges.query.filter_by(id=challenge.id).delete() db.session.commit() db.session.close() return '1'