def deleteRequester(self, rid):
dao = RequesterDAO()
if not dao.getRequesterById(rid):
return jsonify(Error="Requester not found."), 404
else:
dao.deleteRequester(rid)
return jsonify(DeleteStatus="OK"), 200
def getAllRequesters(self):
dao = RequesterDAO()
requesters_list = dao.getAllRequesters()
result_list = []
for requester in requesters_list:
result = self.build_requester_dict(requester)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequesterById(self, rid):
dao = RequesterDAO()
row = dao.getRequesterById(rid)
if not row:
return jsonify(Error="Requester Not Found"), 404
else:
requester = self.build_requester_dict(row)
return jsonify(Requester=requester)
def getRequesterCity(self, rid):
daoReq = RequesterDAO()
dao = CityDAO()
if not daoReq.getRequesterById(rid):
return jsonify(Error='Requester Not Found'), 404
cities_list = dao.getRequesterCity(rid)
result_list = []
for row in cities_list:
result = self.build_city_dict(row)
result_list.append(result)
return jsonify(City=result_list)
def getRequesterRegion(self, rid):
daoReq = RequesterDAO()
dao = RegionDAO()
if not daoReq.getRequesterById(rid):
return jsonify(Error='Requester Not Found'), 404
regions_list = dao.getRequesterRegion(rid)
result_list = []
for row in regions_list:
result = self.build_region_dict(row)
result_list.append(result)
return jsonify(Region=result_list)
def getRequestersOfThisCreditCard(self, cid):
dao = RequesterDAO()
daoC = CreditCardDAO()
if not daoC.getCreditCardById(cid):
return jsonify(Error="Credit Card Not Found"), 404
requesters_list = dao.getRequestersOnThisCreditCard(cid)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequestersOfThisCategory(self, cat_name):
dao = RequesterDAO()
daoCat = CategoryDAO()
if not daoCat.getCategoryByName(cat_name):
return jsonify(Error="Category Not Found"), 404
requesters_list = dao.getRequestersOnThisCategory(cat_name)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequestersOfThisOrderInfo(self, oid):
dao = RequesterDAO()
daoO = OrderDAO()
if not daoO.getOrderById(oid):
return jsonify(Error="Order Info Not Found"), 404
requesters_list = dao.getRequestersOnThisOrderInfo(oid)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequestersOfThisPayment(self, payid):
dao = RequesterDAO()
daoP = PaymentDAO()
if not daoP.getPaymentById(payid):
return jsonify(Error="Payment Not Found"), 404
requesters_list = dao.getRequestersOnThisPayment(payid)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequesterAddress(self, rid):
daoReq = RequesterDAO()
dao = AddressDAO()
if not daoReq.getRequesterById(rid):
return jsonify(Error='Requester Not Found'), 404
address_list = dao.getRequesterAddress(rid)
results_list = []
for row in address_list:
result = self.build_address_dict(row)
results_list.append(result)
return jsonify(Address=results_list)
def getRequestersOfThisTransaction(self, tid):
dao = RequesterDAO()
daoT = TransactionDAO()
if not daoT.getTransactionById(tid):
return jsonify(Error="Transaction Not Found"), 404
requesters_list = dao.getRequestersOnThisTransaction(tid)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequestersOnThisAddressID(self, addId):
dao = RequesterDAO()
daoAdd = AddressDAO()
if not daoAdd.getAddressById(addId):
return jsonify(Error='Address Not Found'), 404
requesters_list = dao.getRequestersWithThisAddressID(addId)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequestersOfThisResourceRequested(self, rrid):
dao = RequesterDAO()
daoRecRec = ResourceRequestedDAO()
if not daoRecRec.getResourceRequestedById(rrid):
return jsonify(Error="Resource Requested Not Found"), 404
requesters_list = dao.getRequestersOnThisResourceRequested(rrid)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequestersOnThisRegion(self, rname):
dao = RequesterDAO()
daoReg = RegionDAO()
if not daoReg.getRegionByName(rname):
return jsonify(Error="Region Not Found"), 404
requesters_list = dao.getRequestersOnThisRegion(rname)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def getRequestersOnThisCity(self, cname):
daoCity = CityDAO()
dao = RequesterDAO()
if not daoCity.getCityByName(cname):
return jsonify(Error="City Not Found"), 404
requesters_list = dao.getRequestersOnThisCity(cname)
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def addNewRequester(self, form):
if len(form) != 4:
return jsonify(Error="Malformed post request"), 400
else:
afirst = form['afirst']
alast = form['alast']
email = form['email']
phone = form['phone']
if afirst and alast and email and phone:
dao = RequesterDAO()
rid = dao.addNewRequester(afirst, alast, email, phone)
result = self.build_requester_attributes(
rid, afirst, alast, email, phone)
return jsonify(Requester=result), 201
else:
return jsonify(
Error="Unexpected attributes in post request"), 400
def updateRequester(self, rid, form):
dao = RequesterDAO()
if not dao.getRequesterById(rid):
return jsonify(Error="Requester not found"), 404
else:
if len(form) != 4:
return jsonify(Error="Malformed update request"), 400
afirst = form['afirst']
alast = form['alast']
email = form['email']
phone = form['phone']
if afirst and alast and email and phone:
dao.updateRequester(rid, afirst, alast, email, phone)
result = self.build_requester_attributes(
rid, afirst, alast, email, phone)
return jsonify(Requester=result), 200
else:
return jsonify(
Error="Unexpected attributes in update request"), 400
def searchRequestersOfThisOrderInfo(self, oid, args):
dao = RequesterDAO()
daoO = OrderDAO()
if not daoO.getOrderById(oid):
return jsonify(Error="Order Info Not Found"), 404
afirst = args.get('afirst')
alast = args.get('alast')
email = args.get('email')
phone = args.get('phone')
requesters_list = []
if (len(args) == 4) and afirst and alast and email and phone:
requesters_list = dao.getRequestersOnThisOrderInfoAfirstAlastEmailPhone(
oid, afirst, alast, email, phone)
elif (len(args) == 3) and afirst and alast and email:
requesters_list = dao.getRequestersOnThisOrderInfoByAfirstAlastEmail(
oid, afirst, alast, email)
elif (len(args) == 3) and afirst and alast and phone:
requesters_list = dao.getRequestersOnThisOrderInfoByAfirstAlastPhone(
oid, afirst, alast, phone)
elif (len(args) == 3) and afirst and phone and email:
requesters_list = dao.getRequestersOnThisOrderInfoByAfirstPhoneEmail(
oid, afirst, phone, email)
elif (len(args) == 3) and alast and email and phone:
requesters_list = dao.getRequestersOnThisOrderInfoByAlastEmailPhone(
oid, alast, email, phone)
elif (len(args) == 2) and afirst and alast:
requesters_list = dao.getRequestersOnThisOrderInfoByAfirstAlast(
oid, afirst, alast)
elif (len(args) == 2) and afirst and email:
requesters_list = dao.getRequestersOnThisOrderInfoByAfirstEmail(
oid, afirst, email)
elif (len(args) == 2) and afirst and phone:
requesters_list = dao.getRequestersOnThisOrderInfoByAfirstPhone(
oid, afirst, phone)
elif (len(args) == 2) and alast and email:
requesters_list = dao.getRequestersOnThisOrderInfoByAlastEmail(
oid, alast, email)
elif (len(args) == 2) and alast and phone:
requesters_list = dao.getRequestersOnThisOrderInfoByAlastPhone(
oid, alast, phone)
elif (len(args) == 2) and email and phone:
requesters_list = dao.getRequestersOnThisOrderInfoByEmailPhone(
oid, email, phone)
elif (len(args) == 1) and afirst:
requesters_list = dao.getRequestersOnThisOrderInfoByAfirst(
oid, afirst)
elif (len(args) == 1) and alast:
requesters_list = dao.getRequestersOnThisOrderInfoByAlast(
oid, alast)
elif (len(args) == 1) and email:
requesters_list = dao.getRequestersOnThisOrderInfoByEmail(
oid, email)
elif (len(args) == 1) and phone:
requesters_list = dao.getRequestersOnThisOrderInfoByPhone(
oid, phone)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def searchRequesters(self, args):
dao = RequesterDAO()
afirst = args.get('afirst')
alast = args.get('alast')
email = args.get('email')
phone = args.get('phone')
requesters_list = []
if (len(args) == 4) and afirst and alast and email and phone:
requesters_list = dao.getRequestersByAFirstALastEmailPhone(
afirst, alast, email, phone)
elif (len(args) == 3) and afirst and alast and email:
requesters_list = dao.getRequestersByAFirstALastEmail(
afirst, alast, email)
elif (len(args) == 3) and afirst and alast and phone:
requesters_list = dao.getRequestersByAFirstALastPhone(
afirst, alast, phone)
elif (len(args) == 3) and afirst and phone and email:
requesters_list = dao.getRequestersByAFirstPhoneEmail(
afirst, phone, email)
elif (len(args) == 3) and alast and email and phone:
requesters_list = dao.getRequestersByALastEmailPhone(
alast, email, phone)
elif (len(args) == 2) and afirst and alast:
requesters_list = dao.getRequestersByAFirstALast(afirst, alast)
elif (len(args) == 2) and afirst and email:
requesters_list = dao.getRequestersByAFirstEmail(afirst, email)
elif (len(args) == 2) and afirst and phone:
requesters_list = dao.getRequestersByAFirstPhone(afirst, phone)
elif (len(args) == 2) and alast and email:
requesters_list = dao.getRequestersByALastEmail(alast, email)
elif (len(args) == 2) and alast and phone:
requesters_list = dao.getRequestersByALastPhone(alast, phone)
elif (len(args) == 2) and email and phone:
requesters_list = dao.getRequestersByEmailPhone(email, phone)
elif (len(args) == 1) and afirst:
requesters_list = dao.getRequestersByAFirst(afirst)
elif (len(args) == 1) and alast:
requesters_list = dao.getRequestersByALast(alast)
elif (len(args) == 1) and email:
requesters_list = dao.getRequestersByEmail(email)
elif (len(args) == 1) and phone:
requesters_list = dao.getRequestersByPhone(phone)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def searchRequestersOnThisAddressID(self, addId, args):
dao = RequesterDAO()
daoAdd = AddressDAO()
if not daoAdd.getAddressById(addId):
return jsonify(Error='Address Not Found'), 404
afirst = args.get('afirst')
alast = args.get('alast')
email = args.get('email')
phone = args.get('phone')
requesters_list = []
if (len(args) == 4) and afirst and alast and email and phone:
requesters_list = dao.getRequestersOnThisAddressIDByAfirstAlastEmailPhone(
addId, afirst, alast, email, phone)
elif (len(args) == 3) and afirst and alast and email:
requesters_list = dao.getRequestersOnThisAddressIDByAfirstAlastEmail(
addId, afirst, alast, email)
elif (len(args) == 3) and afirst and alast and phone:
requesters_list = dao.getRequestersOnThisAddressIDByAfirstAlastPhone(
addId, afirst, alast, phone)
elif (len(args) == 3) and afirst and phone and email:
requesters_list = dao.getRequestersOnThisAddressIDByAfirstPhoneEmail(
addId, afirst, phone, email)
elif (len(args) == 3) and alast and email and phone:
requesters_list = dao.getRequestersOnThisAddressIDByAlastEmailPhone(
addId, alast, email, phone)
elif (len(args) == 2) and afirst and alast:
requesters_list = dao.getRequestersOnThisAddressIDByAfirstAlast(
addId, afirst, alast)
elif (len(args) == 2) and afirst and email:
requesters_list = dao.getRequestersOnThisAddressIDByAfirstEmail(
addId, afirst, email)
elif (len(args) == 2) and afirst and phone:
requesters_list = dao.getRequestersOnThisAddressIDByAfirstPhone(
addId, afirst, phone)
elif (len(args) == 2) and alast and email:
requesters_list = dao.getRequestersOnThisAddressIDByAlastEmail(
addId, alast, email)
elif (len(args) == 2) and alast and phone:
requesters_list = dao.getRequestersOnThisAddressIDByAlastPhone(
addId, alast, phone)
elif (len(args) == 2) and email and phone:
requesters_list = dao.getRequestersOnThisAddressIDByEmailPhone(
addId, email, phone)
elif (len(args) == 1) and afirst:
requesters_list = dao.getRequestersOnThisAddressIDByAfirst(
addId, afirst)
elif (len(args) == 1) and alast:
requesters_list = dao.getRequestersOnThisAddressIDByAlast(
addId, alast)
elif (len(args) == 1) and email:
requesters_list = dao.getRequestersOnThisAddressIDByEmail(
addId, email)
elif (len(args) == 1) and phone:
requesters_list = dao.getRequestersOnThisAddressIDByPhone(
addId, phone)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
def searchRequesterAddress(self, rid, args):
daoReq = RequesterDAO()
dao = AddressDAO()
if not daoReq.getRequesterById(rid):
return jsonify(Error='Requester Not Found'), 404
street = args.get('street')
number = args.get('number')
unit = args.get('unit')
zipcode = args.get('zipcode')
addresses_list = []
if (len(args) == 4) and street and number and unit and zipcode:
addresses_list = dao.getRequesterAddressesByStreetNumberUnitZipCode(
rid, street, number, unit, zipcode)
elif (len(args) == 3) and street and number and unit:
addresses_list = dao.getRequesterAddressesByStreetNumberUnit(
rid, street, number, unit)
elif (len(args) == 3) and street and number and zipcode:
addresses_list = dao.getRequesterAddressesByStreetNumberZipCode(
rid, street, number, zipcode)
elif (len(args) == 3) and street and zipcode and unit:
addresses_list = dao.getRequesterAddressesByStreetZipCodeUnit(
rid, street, zipcode, unit)
elif (len(args) == 3) and number and unit and zipcode:
addresses_list = dao.getRequesterAddressesByNumberUnitZipCode(
rid, number, unit, zipcode)
elif (len(args) == 2) and street and number:
addresses_list = dao.getRequesterAddressesByStreetNumber(
rid, street, number)
elif (len(args) == 2) and street and unit:
addresses_list = dao.getRequesterAddressesByStreetUnit(
rid, street, unit)
elif (len(args) == 2) and street and zipcode:
addresses_list = dao.getRequesterAddressesByStreetZipCode(
rid, street, zipcode)
elif (len(args) == 2) and number and unit:
addresses_list = dao.getRequesterAddressesByNumberUnit(
rid, number, unit)
elif (len(args) == 2) and number and zipcode:
addresses_list = dao.getRequesterAddressesByNumberZipCode(
rid, number, zipcode)
elif (len(args) == 2) and unit and zipcode:
addresses_list = dao.getRequesterAddressesByUnitZipCode(
rid, unit, zipcode)
elif (len(args) == 1) and street:
addresses_list = dao.getRequesterAddressesByStreet(rid, street)
elif (len(args) == 1) and number:
addresses_list = dao.getRequesterAddressesByNumber(rid, number)
elif (len(args) == 1) and unit:
addresses_list = dao.getRequesterAddressesByUnit(rid, unit)
elif (len(args) == 1) and zipcode:
addresses_list = dao.getRequesterAddressesByZipCode(rid, zipcode)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in addresses_list:
result = self.build_address_dict(row)
result_list.append(result)
return jsonify(Addresses=result_list)
def searchRequestersOfThisCategory(self, cat_name, args):
dao = RequesterDAO()
daoCat = CategoryDAO()
if not daoCat.getCategoryByName(cat_name):
return jsonify(Error="Category Not Found"), 404
afirst = args.get('afirst')
alast = args.get('alast')
email = args.get('email')
phone = args.get('phone')
requesters_list = []
if (len(args) == 4) and afirst and alast and email and phone:
requesters_list = dao.getRequestersOnThisCategoryAfirstAlastEmailPhone(
cat_name, afirst, alast, email, phone)
elif (len(args) == 3) and afirst and alast and email:
requesters_list = dao.getRequestersOnThisCategoryByAfirstAlastEmail(
cat_name, afirst, alast, email)
elif (len(args) == 3) and afirst and alast and phone:
requesters_list = dao.getRequestersOnThisCategoryByAfirstAlastPhone(
cat_name, afirst, alast, phone)
elif (len(args) == 3) and afirst and phone and email:
requesters_list = dao.getRequestersOnThisCategoryByAfirstPhoneEmail(
cat_name, afirst, phone, email)
elif (len(args) == 3) and alast and email and phone:
requesters_list = dao.getRequestersOnThisCategoryByAlastEmailPhone(
cat_name, alast, email, phone)
elif (len(args) == 2) and afirst and alast:
requesters_list = dao.getRequestersOnThisCategoryByAfirstAlast(
cat_name, afirst, alast)
elif (len(args) == 2) and afirst and email:
requesters_list = dao.getRequestersOnThisCategoryByAfirstEmail(
cat_name, afirst, email)
elif (len(args) == 2) and afirst and phone:
requesters_list = dao.getRequestersOnThisCategoryByAfirstPhone(
cat_name, afirst, phone)
elif (len(args) == 2) and alast and email:
requesters_list = dao.getRequestersOnThisCategoryByAlastEmail(
cat_name, alast, email)
elif (len(args) == 2) and alast and phone:
requesters_list = dao.getRequestersOnThisCategoryByAlastPhone(
cat_name, alast, phone)
elif (len(args) == 2) and email and phone:
requesters_list = dao.getRequestersOnThisCategoryByEmailPhone(
cat_name, email, phone)
elif (len(args) == 1) and afirst:
requesters_list = dao.getRequestersOnThisCategoryByAfirst(
cat_name, afirst)
elif (len(args) == 1) and alast:
requesters_list = dao.getRequestersOnThisCategoryByAlast(
cat_name, alast)
elif (len(args) == 1) and email:
requesters_list = dao.getRequestersOnThisCategoryByEmail(
cat_name, email)
elif (len(args) == 1) and phone:
requesters_list = dao.getRequestersOnThisCategoryByPhone(
cat_name, phone)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in requesters_list:
result = self.build_requester_dict(row)
result_list.append(result)
return jsonify(Requesters=result_list)
