def getFlightRealtimeInfo(self, flight):
try:
ret = FlightRealtimeInfo.find(flight_no = flight['flight_no'],
takeoff_airport = flight['takeoff_airport'],
arrival_airport = flight['arrival_airport'],
schedule_takeoff_date = flight['schedule_takeoff_date'])
if len(ret) >= 1:
one = ret[0]
flight['flight_state'] = one.flight_state
flight['estimate_takeoff_time'] = one.estimate_takeoff_time
flight['actual_takeoff_time'] = one.actual_takeoff_time
flight['estimate_arrival_time'] = one.estimate_arrival_time
flight['actual_arrival_time'] = one.actual_arrival_time
flight['full_info'] = one.full_info
return flight
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def getLivedFlight(self):
try:
day = []
day.append(datetime.datetime.now().strftime("%Y-%m-%d"))
day.append((datetime.datetime.now() - datetime.timedelta(1)).strftime("%Y-%m-%d"))
lived_flight_list = []
for one in day:
flights = FlightRealtimeInfo.find(full_info = 0, schedule_takeoff_date = one)
for flight in flights:
lived_flight = {}
lived_flight['flight_no'] = flight.flight_no
lived_flight['schedule_takeoff_time'] = flight.schedule_takeoff_time
lived_flight['schedule_arrival_time'] = flight.schedule_arrival_time
lived_flight['takeoff_airport'] = flight.takeoff_airport
lived_flight['arrival_airport'] = flight.arrival_airport
lived_flight['schedule_takeoff_date'] = flight.schedule_takeoff_date
lived_flight['flight_state'] = flight.flight_state
lived_flight['estimate_takeoff_time'] = flight.estimate_takeoff_time
lived_flight['actual_takeoff_time'] = flight.actual_takeoff_time
lived_flight['estimate_arrival_time'] = flight.estimate_arrival_time
lived_flight['actual_arrival_time'] = flight.actual_arrival_time
lived_flight['full_info'] = flight.full_info
lived_flight_list.append(lived_flight)
return lived_flight_list
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def getFlightRealtimeInfo(self, flight):
try:
ret = FlightRealtimeInfo.find(
flight_no=flight['flight_no'],
takeoff_airport=flight['takeoff_airport'],
arrival_airport=flight['arrival_airport'],
schedule_takeoff_date=flight['schedule_takeoff_date'])
if len(ret) >= 1:
one = ret[0]
flight['flight_state'] = one.flight_state
flight['estimate_takeoff_time'] = one.estimate_takeoff_time
flight['actual_takeoff_time'] = one.actual_takeoff_time
flight['estimate_arrival_time'] = one.estimate_arrival_time
flight['actual_arrival_time'] = one.actual_arrival_time
flight['full_info'] = one.full_info
return flight
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def getLivedFlight(self):
try:
day = []
day.append(datetime.datetime.now().strftime("%Y-%m-%d"))
day.append((datetime.datetime.now() -
datetime.timedelta(1)).strftime("%Y-%m-%d"))
lived_flight_list = []
for one in day:
flights = FlightRealtimeInfo.find(full_info=0,
schedule_takeoff_date=one)
for flight in flights:
lived_flight = {}
lived_flight['flight_no'] = flight.flight_no
lived_flight[
'schedule_takeoff_time'] = flight.schedule_takeoff_time
lived_flight[
'schedule_arrival_time'] = flight.schedule_arrival_time
lived_flight['takeoff_airport'] = flight.takeoff_airport
lived_flight['arrival_airport'] = flight.arrival_airport
lived_flight[
'schedule_takeoff_date'] = flight.schedule_takeoff_date
lived_flight['flight_state'] = flight.flight_state
lived_flight[
'estimate_takeoff_time'] = flight.estimate_takeoff_time
lived_flight[
'actual_takeoff_time'] = flight.actual_takeoff_time
lived_flight[
'estimate_arrival_time'] = flight.estimate_arrival_time
lived_flight[
'actual_arrival_time'] = flight.actual_arrival_time
lived_flight['full_info'] = flight.full_info
lived_flight_list.append(lived_flight)
return lived_flight_list
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def getRandomFlight(self):
try:
ret = FlightRealtimeInfo.getOneArrivedFlightNO()
flight = None
if ret is not None:
flight = {}
flight['flight_no'] = ret.flight_no
flight['schedule_takeoff_date'] = ret.schedule_takeoff_date
return flight
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def getRandomFlight(self):
try:
ret = FlightRealtimeInfo.getOneArrivedFlightNO()
flight = None
if ret is not None:
flight = {}
flight['flight_no'] = ret.flight_no
flight['schedule_takeoff_date'] = ret.schedule_takeoff_date
return flight
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def putFlightRealtimeInfo(self, one):
try:
flight_info = FlightRealtimeInfo.find(flight_no = one['flight_no'], takeoff_airport = one['takeoff_airport'], arrival_airport = one['arrival_airport'], schedule_takeoff_date = one['schedule_takeoff_date'])
if len(flight_info) == 0:
flight_info = FlightRealtimeInfo()
else:
flight_info = flight_info[0]
flight_info.flight_no = one['flight_no']
flight_info.flight_state = one['flight_state']
flight_info.schedule_takeoff_time = one['schedule_takeoff_time']
flight_info.estimate_takeoff_time = one['estimate_takeoff_time']
flight_info.actual_takeoff_time = one['actual_takeoff_time']
flight_info.schedule_arrival_time = one['schedule_arrival_time']
flight_info.estimate_arrival_time = one['estimate_arrival_time']
flight_info.actual_arrival_time = one['actual_arrival_time']
flight_info.schedule_takeoff_date = one['schedule_takeoff_date']
flight_info.takeoff_airport = one['takeoff_airport']
flight_info.arrival_airport = one['arrival_airport']
if one['actual_arrival_time'] != "--:--":
flight_info.full_info = 1
flight_info.add()
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
def putFlightRealtimeInfo(self, one):
try:
flight_info = FlightRealtimeInfo.find(
flight_no=one['flight_no'],
takeoff_airport=one['takeoff_airport'],
arrival_airport=one['arrival_airport'],
schedule_takeoff_date=one['schedule_takeoff_date'])
if len(flight_info) == 0:
flight_info = FlightRealtimeInfo()
else:
flight_info = flight_info[0]
flight_info.flight_no = one['flight_no']
flight_info.flight_state = one['flight_state']
flight_info.schedule_takeoff_time = one['schedule_takeoff_time']
flight_info.estimate_takeoff_time = one['estimate_takeoff_time']
flight_info.actual_takeoff_time = one['actual_takeoff_time']
flight_info.schedule_arrival_time = one['schedule_arrival_time']
flight_info.estimate_arrival_time = one['estimate_arrival_time']
flight_info.actual_arrival_time = one['actual_arrival_time']
flight_info.schedule_takeoff_date = one['schedule_takeoff_date']
flight_info.takeoff_airport = one['takeoff_airport']
flight_info.arrival_airport = one['arrival_airport']
if one['actual_arrival_time'] != "--:--":
flight_info.full_info = 1
flight_info.add()
except:
msg = traceback.format_exc()
self.logger.error(msg)
DBBase.Session.rollback()
DBBase.Engine.dispose()
return None
