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
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
