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)