コード例 #1
0
ファイル: DBUtility.py プロジェクト: xulin97/FlightDaemon
 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
コード例 #2
0
    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