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)
