本文整理汇总了Python中wrapper.Wrapper.insert方法的典型用法代码示例。如果您正苦于以下问题:Python Wrapper.insert方法的具体用法?Python Wrapper.insert怎么用?Python Wrapper.insert使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类wrapper.Wrapper
的用法示例。
在下文中一共展示了Wrapper.insert方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: Waiter
# 需要导入模块: from wrapper import Wrapper [as 别名]
# 或者: from wrapper.Wrapper import insert [as 别名]
class Waiter(object):
"""waiter"""
def __init__(self):
self.wrap = Wrapper()
def add_order(self, waiter_id, order_data):
"""must put waiter id and tickets in list of dict
[{"id_dish": 1, "count": 1},{"id_dish": 12, "count": 1}..."""
date = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
order = {"id_status": 4,
"id_user": waiter_id,
"date": date
}
order_id = self.wrap.insert(order, "orders")
for ticket in order_data:
ticket["id_order"] = order_id
try:
del ticket["image"]
del ticket["name"]
del ticket["id"]
del ticket["description"]
del ticket["id_category"]
except Exception, e:
print e
self.wrap.insert(ticket, "tickets")
return order_id
示例2: Admin
# 需要导入模块: from wrapper import Wrapper [as 别名]
# 或者: from wrapper.Wrapper import insert [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))
示例3: Cooker
# 需要导入模块: from wrapper import Wrapper [as 别名]
# 或者: from wrapper.Wrapper import insert [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))