def getPunctualityInfo(self, flight_no, takeoff_airport, arrival_airport):
try:
ret = PunctualityInfo.find(flight_no=flight_no,
takeoff_airport=takeoff_airport,
arrival_airport=arrival_airport)
punctuality_info = None
if len(ret) == 1:
punctuality_info = {}
punctuality_info['on_time'] = ret[0].on_time
punctuality_info['half_hour_late'] = ret[0].half_hour_late
punctuality_info['one_hour_late'] = ret[0].one_hour_late
punctuality_info['more_than_one_hour_late'] = ret[
0].more_than_one_hour_late
punctuality_info['cancel'] = ret[0].cancel
return punctuality_info
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def getPunctualityInfo(self, flight_no, takeoff_airport, arrival_airport):
try:
ret = PunctualityInfo.find(flight_no = flight_no, takeoff_airport = takeoff_airport, arrival_airport = arrival_airport)
punctuality_info = None
if len(ret) == 1:
punctuality_info = {}
punctuality_info['on_time'] = ret[0].on_time
punctuality_info['half_hour_late'] = ret[0].half_hour_late
punctuality_info['one_hour_late'] = ret[0].one_hour_late
punctuality_info['more_than_one_hour_late'] = ret[0].more_than_one_hour_late
punctuality_info['cancel'] = ret[0].cancel
return punctuality_info
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def putPunctualityInfo(self, flight, punctualit_info):
try:
ret = PunctualityInfo.find(flight_no = flight['flight_no'], takeoff_airport = flight['takeoff_airport'], arrival_airport = flight['arrival_airport'])
if len(ret) == 0:
info = PunctualityInfo()
info.flight_no = flight['flight_no']
info.takeoff_airport = flight['takeoff_airport']
info.arrival_airport = flight['arrival_airport']
info.on_time = punctualit_info['on_time']
info.half_hour_late = punctualit_info['half_hour_late']
info.one_hour_late = punctualit_info['one_hour_late']
info.more_than_one_hour_late = punctualit_info['more_than_one_hour_late']
info.cancel = punctualit_info['cancel']
info.add()
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def putPunctualityInfo(self, flight, punctualit_info):
try:
ret = PunctualityInfo.find(
flight_no=flight['flight_no'],
takeoff_airport=flight['takeoff_airport'],
arrival_airport=flight['arrival_airport'])
if len(ret) == 0:
info = PunctualityInfo()
info.flight_no = flight['flight_no']
info.takeoff_airport = flight['takeoff_airport']
info.arrival_airport = flight['arrival_airport']
info.on_time = punctualit_info['on_time']
info.half_hour_late = punctualit_info['half_hour_late']
info.one_hour_late = punctualit_info['one_hour_late']
info.more_than_one_hour_late = punctualit_info[
'more_than_one_hour_late']
info.cancel = punctualit_info['cancel']
info.add()
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
