本文整理汇总了Python中wrapper.Wrapper.delete方法的典型用法代码示例。如果您正苦于以下问题:Python Wrapper.delete方法的具体用法?Python Wrapper.delete怎么用?Python Wrapper.delete使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类wrapper.Wrapper
的用法示例。
在下文中一共展示了Wrapper.delete方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: Manager
# 需要导入模块: from wrapper import Wrapper [as 别名]
# 或者: from wrapper.Wrapper import delete [as 别名]
class Manager(Waiter):
"""in data we put all fields we need to see in ticket!"""
def __init__(self):
self.wrap = Wrapper()
def get_full_order(self, order_id):
"""in data put all what we need to see in ticket"""
data = "dishes.image, dishes.name, dishes.price, dishes.id as id_dish, tickets.count, tickets.id, tickets.id_order"
condition = "INNER JOIN dishes ON tickets.id_dish = dishes.id WHERE tickets.id_order = %s" % (order_id)
tickets = self.wrap.select(data, "tickets", condition)
full_price = 0
if len(tickets) != 0:
"""for ticket in tickets:
full_price += ticket["price"]
tickets += ({"full_price": full_price},)"""
return tickets
return None
def get_all_orders(self, Date = ''):
"""get all orders all waiters for curent date"""
if Date == '':
date = datetime.datetime.now().strftime('%Y-%m-%d')
else:
date = Date
data = "orders.id, statuses.status, CAST(Sum(tickets.price) as UNSIGNED) as TotalCount"
condition = "JOIN orders on orders.id=tickets.id_order \
WHERE orders.id_status = statuses.id \
AND (orders.id_status = 4 OR orders.id_status =5) \
AND orders.id_user = users.id \
AND orders.date LIKE '{0}%' \
GROUP BY tickets.id_order".format(date)
orders = self.wrap.select(data, "statuses, users, tickets", condition)
if len(orders) != 0:
return orders
return None
def edit_order(self, order_data):
"""get order data with order id
[{count": 1,"id": 15},..."""
id = order_data["id"]
del order_data["id"]
del order_data["name"]
del order_data["image"]
del order_data["price"]
self.wrap.update(order_data, "tickets", "WHERE tickets.id = %s" % (id))
def del_ticket(self, ticket_id):
"""update ticket status to 0, default 1"""
return self.wrap.delete("tickets", ticket_id)
def get_order(self, order_id):
tickets = self.wrap.select("*", "tickets",
"WHERE tickets.id_order = %s" % (order_id))
return tickets
def remove_order(self, order_id):
"""get order id. Set status to NULL"""
self.wrap.update({"id_status": 3}, "orders",
"WHERE id = %s" % (order_id))
def get_user_id(self, username):
data = "users.id"
table = "users"
condition = "WHERE users.login = '%s'" % (username)
resp = self.wrap.select(data, table, condition)
return resp[0]['id']
def get_summ(self):
data = "orders.id, Sum(tickets.price) as TotalCount"
condition = "JOIN orders on orders.id=tickets.id_order GROUP BY tickets.id_order"
orders = self.wrap.select(data, "tickets", condition)
return orders