本文整理汇总了Python中wrapper.Wrapper.update方法的典型用法代码示例。如果您正苦于以下问题:Python Wrapper.update方法的具体用法?Python Wrapper.update怎么用?Python Wrapper.update使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类wrapper.Wrapper
的用法示例。
在下文中一共展示了Wrapper.update方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: Admin
# 需要导入模块: from wrapper import Wrapper [as 别名]
# 或者: from wrapper.Wrapper import update [as 别名]
class Admin(Users):
"""Admin Class
Methods:
adduser()
edituser()
deleteuser()
set_permission()
"""
db_name = "users"
def __init__(self):
self.w = Wrapper()
def __del__(self):
pass
def adduser(self, fields):
""" Add user method insert data from user form in to db
"""
return self.w.insert(fields, self.db_name)
def edituser(self, fields, condition):
""" Edit user method update user data
"""
return self.w.update(fields, self.db_name, condition)
def deleteuser(self, uid):
""" Delete user method
Dete user from db (change status to remove)
"""
self.edituser({"id_status": "2"}, "where id={0}".format(uid))
def set_permission(self, uname, role):
""" Set user permission method
change users permission
"""
if role == 'admin':
self.w.update(
"id_role=1", self.db_name, "where login='{0}'".format(uname))
if role == 'manager':
self.w.update(
"id_role=2", self.db_name, "where login='{0}'".format(uname))
if role == 'waiter':
self.w.update(
"id_role=3", self.db_name, "where login='{0}'".format(uname))
if role == 'cooker':
self.w.update(
"id_role=4", self.db_name, "where login='{0}'".format(uname))
示例2: Cooker
# 需要导入模块: from wrapper import Wrapper [as 别名]
# 或者: from wrapper.Wrapper import update [as 别名]
class Cooker(object):
"""docstring for Cooker"""
def __init__(self):
self.wrapper = Wrapper()
def advanced_search(self, diction):
return advanced_search(
["distinct dishes.id", "name", "description", "price",
"status", "image", "id_status", "count", "id_category"],
"dishes inner join statuses on dishes.id_status=statuses.id",
diction)
def search_dishes(self, string):
return self.wrapper.select(["distinct dishes.id", "name", "description", "price", "status",
"image", "id_status", "count", "id_category"],
"dishes",
"inner join statuses on statuses.id=id_status "\
"where lower(name) LIKE lower('%{0}%') or "\
"lower(description) LIKE lower('%{0}%') or "\
"lower(price) LIKE lower('%{0}%') or "\
"lower(status) LIKE lower('%{0}%') or "\
"lower(count) LIKE lower('%{0}%')".format(string))
def delete_item_menu(self, id_item_menu):
return self.wrapper.update({"id_status":2},
"dishes",
"where id={0}".format(id_item_menu))
def get_all_categories(self):
return self.wrapper.select(["category", "id"], "categories")
def get_categories_from_inner_dishes(self):
dictionary = {}
for category in self.wrapper.select(["category", "id"], "categories"):
dishes = self.wrapper.select("*", "dishes", "where id_category=%s" % (category['id']))
dictionary[category['category']] = list(dishes)
return dictionary
def get_menu_by_category(self, id_category):
return self.wrapper.select(["dishes.id", "name", "description", "price", "status",
"image", "id_status", "count", "id_category"],
["dishes", "statuses"],
"where id_category=%s and id_status=statuses.id" % (id_category))
def get_item_menu(self, id_item_menu):
return self.wrapper.select(["dishes.id", "name", "description", "price", "category",
"image", "id_status", "count", "id_category"],
["dishes", "categories"],
"where dishes.id={0} and id_category=categories.id".format(id_item_menu))
def get_all_dishes(self):
""" Get all dishes from DB """
return self.wrapper.select(["dishes.id", "name", "description", "price",
"image", "count", "status", "id_status", "id_category"],
["dishes", "statuses"],
"where id_status=statuses.id")
def get_dishes_by_cat(self,catid):
""" Get dishes by categories """
return self.wrapper.select(["*"], "dishes","where id_category={0}".format(catid))
def add_item_category(self, item_category):
return self.wrapper.insert(item_category, "categories")
def add_item_menu(self, item_menu):
return self.wrapper.insert(item_menu, "dishes")
def edit_item_category(self, id_category, item_category):
return self.wrapper.update(item_category, "categories", "where id={0}".format(id_category))
def edit_item_menu(self, id_menu, item_menu):
return self.wrapper.update(item_menu, "dishes", "where id={0}".format(id_menu))
示例3: Manager
# 需要导入模块: from wrapper import Wrapper [as 别名]
# 或者: from wrapper.Wrapper import update [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