def update_customer(self, request_form): """ Updates the customer described in request_form and returns the freshly updated customer entry. """ update_sql, values = sql.get_sql_and_values("customer", request_form) self.query_one(update_sql, tuple(values)) return self.get_customer(request_form["id"])
def update_customer(self, request_form): """ Updates the customer described in request_form and returns the freshly updated customer entry. """ update_sql, values = sql.get_sql_and_values("customer", request_form) self.query_one(update_sql, tuple(values)) return self.get_customer(request_form["id"])
def update_order_total(self, id, delta): query = "select total_amount from customer_order where id = %s" old_amount = self.query_one(query, (id))["total_amount"] if old_amount != None: new_amount = old_amount + delta else: new_amount = delta form = {} form["id"] = id form["total_amount"] = new_amount update_order_sql, values = sql.get_sql_and_values("customer_order", form) return self.query_one(update_order_sql, tuple(values))
def update_order_total(self, id, delta): query = "select total_amount from customer_order where id = %s" old_amount = self.query_one(query, (id))["total_amount"] if old_amount != None: new_amount = old_amount + delta else: new_amount = delta form = {} form["id"] = id form["total_amount"] = new_amount update_order_sql, values = sql.get_sql_and_values( "customer_order", form) return self.query_one(update_order_sql, tuple(values))
def add_order_item(self, form): update_sql, values = sql.get_sql_and_values("order_item", form) self.set_creation_date_to_now(form) return self.insert(update_sql, tuple(values))
def update_order_item(self, form): update_sql, values = sql.get_sql_and_values("order_item", form) self.query_one(update_sql, tuple(values))
def update_order(self, form): update_sql, values = sql.get_sql_and_values("customer_order", form) self.query_one(update_sql, tuple(values))
def create_order(self, form): self.set_creation_date_to_now(form) update_sql, values = sql.get_sql_and_values("customer_order", form) return self.insert(update_sql, tuple(values))
def update_product(self, form): update_sql, values = sql.get_sql_and_values("product", form) self.query_one(update_sql, tuple(values))
def create_product(self, form): insert_sql, values = sql.get_sql_and_values("product", form) return self.insert(insert_sql, values)
def add_order_item(self, form): update_sql, values = sql.get_sql_and_values("order_item", form) self.set_creation_date_to_now(form) return self.insert(update_sql, tuple(values))
def update_order_item(self, form): update_sql, values = sql.get_sql_and_values("order_item", form) self.query_one(update_sql, tuple(values))
def update_order(self, form): update_sql, values = sql.get_sql_and_values("customer_order", form) self.query_one(update_sql, tuple(values))
def create_order(self, form): self.set_creation_date_to_now(form) update_sql, values = sql.get_sql_and_values("customer_order", form) return self.insert(update_sql, tuple(values))
def create_product(self, form): insert_sql, values = sql.get_sql_and_values("product", form) return self.insert(insert_sql, values)
def create_customer(self, form): insert_sql, values = sql.get_sql_and_values("customer", form) return self.insert(insert_sql, values)
def update_product(self, form): update_sql, values = sql.get_sql_and_values("product", form) self.query_one(update_sql, tuple(values))
def create_customer(self, form): insert_sql, values = sql.get_sql_and_values("customer", form) return self.insert(insert_sql, values)