def delete_menu(restaurant_id: int, menu_id: int):
session = DBSession()
restaurant = session.query(Restaurant).filter_by(
id=restaurant_id).one_or_none()
item = (session.query(MenuItem).filter_by(
id=menu_id, restaurant_id=restaurant_id).one_or_none())
if restaurant is None:
return (
jsonify({"details": f"Restaurant {restaurant_id} does not exist"}),
404,
{},
)
if item is None:
return (
jsonify(
{
"details":
f"Menu item {menu_id} does not exist in restaurant {restaurant.name}",
}, ),
404,
{},
)
session.delete(item)
session.commit()
return (
None,
204,
{},
)
def DeleteProject(self, request, context):
client = create_client()
session = DBSession()
for user in session.query(ProjectUser).filter_by(
project_id=request.projectId):
delete_db_user(user, client)
session.delete(user)
session.commit()
return DeleteProjectResponse()
def DeleteUser(self, request: DeleteUserRequest,
context) -> DeleteUserResponse:
client = create_client()
session = DBSession()
for user in session.query(ProjectUser).filter_by(
user_id=request.userId):
delete_db_user(user, client)
session.delete(user)
session.commit()
return DeleteUserResponse()
def delete_plot(id):
if id == None:
return 'Invalid ID'
plot = DBSession.query(Restraurant)\
.filter(Restraurant.id == id)\
.first()
if plot == None:
return 'Invalid ID'
if plot.created_by != session['user_id']:
return 'Invalid ID'
DBSession.delete(plot)
DBSession.commit()
return 'ok'
def RemoveUserFromProject(self, request: RemoveUserFromProjectRequest,
context) -> RemoveUserFromProjectResponse:
client = create_client()
session = DBSession()
user = get_user(session, request.userId, request.projectId)
# delete instances and volumes from server
delete_db_user(user, client)
# delete user from db
# db instances and volumes will be cascade deleted.
session.delete(user)
session.commit()
return RemoveUserFromProjectResponse()
def delete_menu_item(restaurant_id: int, menu_id: int):
session = DBSession()
item_to_delete = session.query(MenuItem).filter_by(id=menu_id).one_or_none()
if request.method == "POST":
session.delete(item_to_delete)
session.commit()
flash(f"Menu item {item_to_delete.name} successfully deleted")
return redirect(url_for("show_menu", restaurant_id=restaurant_id))
else:
return render_template(
"7_delete_menu_item.html",
item=item_to_delete,
)
def cancel_result(message_id, user_id):
"""
This method is responsible to cancel sending particular sms if it is not yet delivered.
"""
transaction.commit()
message_id = int(message_id.decode(encoding='ascii'))
smses = DBSession.query(Sms).filter_by(sms_type='outgoing', id=message_id, user_id=user_id).first()
if(smses is None):
return False
elif(smses.status == 'delivered'):
return command_status.ESME_RCANCELFAIL
else:
DBSession.delete(smses)
transaction.commit()
return True
def delete_restaurant(restaurant_id: int):
session = DBSession()
restaurant_to_delete = (
session.query(Restaurant).filter_by(id=restaurant_id).one_or_none()
)
if request.method == "POST":
session.delete(restaurant_to_delete)
session.commit()
flash(f"Restaurant {restaurant_to_delete.name} successfully deleted")
return redirect(url_for("show_restaurants"))
else:
return render_template(
"3_delete_restaurants.html",
restaurant_id=restaurant_id,
restaurant=restaurant_to_delete,
)
def DeleteInstance(self, request, context):
client = create_client()
# Get the server
server = client.connection.get_server_by_id(id=request.instanceId)
# Get the volume
# volume = server.volumes[0]
# Get the flavor
flavor = client.connection.get_flavor_by_id(server.flavor["id"])
resp = DeleteInstanceResponse()
resp.flavor.name = flavor.name
resp.flavor.cpu = flavor.vcpus
resp.flavor.memory = flavor.ram
resp.flavor.rootDisk = flavor.disk
# Delete the server
client.connection.delete_server(name_or_id=request.instanceId,
wait=True,
delete_ips=True)
# Get the server from db
session = DBSession()
instance = session.query(
models.Instance).filter_by(id=request.instanceId).one()
# Delete the volume.
volume = instance.volumes[0]
resp.volume = volume.size
client.connection.delete_volume(name_or_id=volume.id, force=True)
# Delete the instance from db
session.delete(instance)
session.commit()
return resp
