def inviteMany(room, users):
for user in users:
room.users.append(user)
for ot in room.oto:
room.oto.remove(ot)
db_session.delete(ot)
db_session.commit()
def destroy(id):
"""
Elimina un turno especifico de la base de datos
"""
turno = Turno.query.filter_by(id=sql_and_tag_escape(str(id))).first()
if not turno:
abort(404)
db_session.delete(turno)
db_session.commit()
return redirect(url_for('turns.index'))
def delete_item(item_id, item):
"""Route to item's delete page + delete item"""
# GET request
if request.method == 'GET':
return render_template('items/delete.html', item=item)
# POST request
item_name = item.name
db_session.delete(item)
db_session.commit()
flash('Item %s is removed' % item_name, 'info')
return redirect(url_for('catalog.home_page'))
def destroy(username):
"""
Eliminar un usuario de la base de datos
"""
users = User.query.filter_by(username=username).first()
if not users:
abort(404)
# Si llega hasta aca para eliminarse, chequea que no se elimine a si mismo
if users.username == session.get("username"):
flash("No se puede eliminarse a si mismo.", "error")
return redirect(url_for('users.index'))
db_session.delete(users)
db_session.commit()
return redirect(url_for('users.index'))
def get_task(message):
tasks = Task.query.filter(Task.chat_id==message.chat.id).all()
if len(tasks) == 0:
bot.send_message(message.chat.id, "There's nothing for you to do.")
return
task = tasks[int(random()*len(tasks))]
db_session.delete(task)
db_session.commit()
bot.send_message(
message.chat.id,
"Your next mission, should you choose to accept it, is:\n\n" + \
task.description)
def delete_renders():
for r in Render.query.all():
db_session.delete(r)
def remove(self):
db_session.delete(self)
db_session.flush()
def delete(self):
db_session.delete(self)
self._flush()
def delete_from_db(self):
"""
Delete the selected data from database
"""
db_session.delete(self)
db_session.commit()
def invite(room, user):
room.users.append(user)
for ot in room.oto:
room.oto.remove(ot)
db_session.delete(ot)
db_session.commit()
def exitRoom(user, room):
room.users.remove(user)
if len(room.users) == 0:
db_session.delete(room)
db_session.commit()
def del_patient(patient_name='Tomasz AA'):
patient = db_session.query(Appointment)\
.filter(Appointment.patient_name == patient_name).first()
db_session.delete(patient)
db_session.commit()
def delete_having_no_template(self):
items = Tag.query.all()
for item in items:
if len(item.templates)==0:
db_session.delete(item)
db_session.commit()
def delete(self, template):
db_session.delete(template)
db_session.commit()
delete_template_files(template.id)
TagModel().delete_having_no_template()
def delete_having_no_template(self):
items = Tag.query.all()
for item in items:
if len(item.templates) == 0:
db_session.delete(item)
db_session.commit()
def delete(self, template):
db_session.delete(template)
db_session.commit()
delete_template_files(template.id)
TagModel().delete_having_no_template()
