def checkRouteInfo(self): try: ret = FlightFixInfo.getAllRoute() route_info = [] for one in ret: route = {} route["takeoff_airport"] = one.takeoff_airport route["arrival_airport"] = one.arrival_airport count = len(FlightFixInfo.find(takeoff_airport = one.takeoff_airport, arrival_airport = one.arrival_airport)) if count == 0: route["flight_count"] = "ZERO" else: route["flight_count"] = count route_info.append(route) return route_info except: msg = traceback.format_exc() self.logger.error(msg) DBBase.Session.rollback() DBBase.Engine.dispose() return None
def checkRouteInfo(self): try: ret = FlightFixInfo.getAllRoute() route_info = [] for one in ret: route = {} route["takeoff_airport"] = one.takeoff_airport route["arrival_airport"] = one.arrival_airport count = len( FlightFixInfo.find(takeoff_airport=one.takeoff_airport, arrival_airport=one.arrival_airport)) if count == 0: route["flight_count"] = "ZERO" else: route["flight_count"] = count route_info.append(route) return route_info except: msg = traceback.format_exc() self.logger.error(msg) DBBase.Session.rollback() DBBase.Engine.dispose() return None
def getFlightFixInfoByRoute(self, takeoff_airport, arrival_airport, company): try: ret = [] if company == 'all': ret = FlightFixInfo.find(takeoff_airport = takeoff_airport, arrival_airport = arrival_airport) else: ret = FlightFixInfo.find(takeoff_airport = takeoff_airport, arrival_airport = arrival_airport, company = company) return self.__convertFixInfo(ret) except: msg = traceback.format_exc() self.logger.error(msg) DBBase.Session.rollback() DBBase.Engine.dispose() return None
def getFlightFixInfoByUniq(self, flight_no, takeoff_airport, arrival_airport): try: ret = FlightFixInfo.find(flight_no = flight_no, takeoff_airport = takeoff_airport, arrival_airport = arrival_airport) return self.__convertFixInfo(ret) except: msg = traceback.format_exc() self.logger.error(msg) DBBase.Session.rollback() DBBase.Engine.dispose() return None
def getFlightFixInfoByRoute(self, takeoff_airport, arrival_airport, company): try: ret = [] if company == 'all': ret = FlightFixInfo.find(takeoff_airport=takeoff_airport, arrival_airport=arrival_airport) else: ret = FlightFixInfo.find(takeoff_airport=takeoff_airport, arrival_airport=arrival_airport, company=company) return self.__convertFixInfo(ret) except: msg = traceback.format_exc() self.logger.error(msg) DBBase.Session.rollback() DBBase.Engine.dispose() return None
def getFlightFixInfoByUniq(self, flight_no, takeoff_airport, arrival_airport): try: ret = FlightFixInfo.find(flight_no=flight_no, takeoff_airport=takeoff_airport, arrival_airport=arrival_airport) return self.__convertFixInfo(ret) except: msg = traceback.format_exc() self.logger.error(msg) DBBase.Session.rollback() DBBase.Engine.dispose() return None
def getFlightList(self): try: ret = FlightFixInfo.find() flight_info_list = [] for one in ret: one_hash = {} one_hash['flight_no'] = one.flight_no one_hash['takeoff_airport'] = one.takeoff_airport one_hash['arrival_airport'] = one.arrival_airport flight_info_list.append(one_hash) return flight_info_list except: msg = traceback.format_exc() self.logger.error(msg) DBBase.Session.rollback() DBBase.Engine.dispose() return None