def getOrderById(self, oid):
dao = OrdersDAO()
orders_list = dao.getOrderByID(oid)
result_list = []
for row in orders_list:
result = self.build_orders_dict(row)
result_list.append(result)
return jsonify(Orders=result_list)
def getOrdersByType(self, type):
dao = OrdersDAO()
orders_list = dao.getOrderByType(type)
result_list = []
for row in orders_list:
result = self.build_orders_dict(row)
result_list.append(result)
return jsonify(Orders=result_list)
def getReservationsByConsumerId(self, cid):
dao = OrdersDAO()
orders_list = dao.getReservationsByConsumerId(cid)
result_list = []
for row in orders_list:
result = self.build_reservation_dict(row)
result_list.append(result)
return jsonify(Reservations=result_list)
def getReservationsByType(self, type):
dao = OrdersDAO()
orders_list = dao.getReservationByType(type)
result_list = []
for row in orders_list:
result = self.build_reservation_dict(row)
result_list.append(result)
return jsonify(Reservations=result_list)
def getReservationById(self, oid):
dao = OrdersDAO()
orders_list = dao.getReservationByID(oid)
result_list = []
for row in orders_list:
result = self.build_reservation_dict(row)
result_list.append(result)
return jsonify(Reservation=result_list)
def getAllReservations(self):
dao = OrdersDAO()
orders_list = dao.getAllReservations()
result_list = []
for row in orders_list:
result = self.build_reservation_dict(row)
result_list.append(result)
return jsonify(Reservations=result_list)
def getAllOrders(self):
# Creates the list of all orders calling the DAO which creates the query,
# this returns a list. This list is then jsonified to be used as a response.
dao = OrdersDAO()
orders_list = dao.getAllOrders()
result_list = []
for row in orders_list:
result = self.build_orders_dict(row)
result_list.append(result)
return jsonify(Orders=result_list)
def insertReservationJson(self, json):
rid = json['rid']
cid = json['cid']
if rid and cid:
dao = OrdersDAO()
oid = dao.insertReservation(cid, rid)
result = self.build_reservation_attribute_dict(rid, cid, oid)
return jsonify(Order=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400
def insertOrderJson(self, json):
rid = json['rid']
cid = json['cid']
pmethod = json['pmethod']
if rid and cid and pmethod:
dao = OrdersDAO()
oid = dao.insert(cid, rid, pmethod)
result = self.build_order_attribute_dict(rid, cid, pmethod, oid)
return jsonify(Order=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400