def findLike(flight_no): session = DBBase.getSession() key_item = None #@UnusedVariable key_item = session.query(FlightFixInfo).filter( FlightFixInfo.flight_no.like("%" + flight_no + "%")).all() DBBase.Session.remove() return key_item
def delete(self): session = DBBase.getSession() ret = self.find() if ret is not None: session.delete(ret) session.commit() DBBase.Session.remove()
def getNowFlightNO(cur_time): session = DBBase.getSession() key_item = session.query(FlightFixInfo.flight_no).filter( and_(FlightFixInfo.schedule_takeoff_time <= cur_time, FlightFixInfo.schedule_arrival_time >= cur_time)).all() DBBase.Session.remove() return key_item
def getAllRoute(): session = DBBase.getSession() key_item = session.query( FlightFixInfo.takeoff_airport, FlightFixInfo.arrival_airport).distinct().all() DBBase.Session.remove() return key_item
def getOverdayRoute(cur_date): session = DBBase.getSession() key_item = session.query( FlightFixInfo.takeoff_airport, FlightFixInfo.arrival_airport).distinct().filter( FlightFixInfo.valid_date_to < cur_date).all() DBBase.Session.remove() return key_item
def find(one=False, **kwargs): session = DBBase.getSession() key_item = None if one: key_item = session.query(FlightFixInfo).filter_by(**kwargs).first() else: key_item = session.query(FlightFixInfo).filter_by(**kwargs).all() DBBase.Session.remove() return key_item
def getOverdayRoute(cur_date): session = DBBase.getSession() key_item = ( session.query(FlightFixInfo.takeoff_airport, FlightFixInfo.arrival_airport) .distinct() .filter(FlightFixInfo.valid_date_to < cur_date) .all() ) DBBase.Session.remove() return key_item
def getNowFlightNO(cur_time): session = DBBase.getSession() key_item = ( session.query(FlightFixInfo.flight_no) .filter( and_(FlightFixInfo.schedule_takeoff_time <= cur_time, FlightFixInfo.schedule_arrival_time >= cur_time) ) .all() ) DBBase.Session.remove() return key_item
def find(**kwargs): session = DBBase.getSession() key_item = session.query(AirportInfo).filter_by(**kwargs).all() DBBase.Session.remove() return key_item
def findAll(**kwargs): session = DBBase.getSession() key_item = session.query(FollowedInfo).filter_by(**kwargs).all() DBBase.Session.remove() return key_item
def getOneArrivedFlightNO(): session = DBBase.getSession() key_item = session.query(FlightRealtimeInfo).filter_by(full_info = 1).order_by(FlightRealtimeInfo.date.desc()).first() DBBase.Session.remove() return key_item
def delete(self): session = DBBase.getSession() session.delete(self) session.commit() DBBase.Session.remove()
def getAllFlightNO(): session = DBBase.getSession() key_item = session.query(FlightFixInfo.flight_no).all() DBBase.Session.remove() return key_item
def findAll(**kwargs): session = DBBase.getSession() key_item = session.query(VersionInfo).filter_by(**kwargs).order_by(VersionInfo.id.desc()).all() DBBase.Session.remove() return key_item
def findDelete(**kwargs): session = DBBase.getSession() key_item = session.query(FlightFixInfo).filter_by(**kwargs).delete() session.commit() DBBase.Session.remove() return key_item
def find(**kwargs): session = DBBase.getSession() key_item = session.query(CompanyInfoAll).filter_by(**kwargs).all() DBBase.Session.remove() return key_item
def count(**kwargs): session = DBBase.getSession() key_item = session.query(VersionInfo).filter_by(**kwargs).count() DBBase.Session.remove() return key_item
def findNewest(**kwargs): session = DBBase.getSession() key_item = session.query(VersionInfo).filter_by(**kwargs).order_by( VersionInfo.version.desc()).first() DBBase.Session.remove() return key_item
def add(self): session = DBBase.getSession() self.date = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") session.add(self) session.commit() DBBase.Session.remove()
def getAllRoute(): session = DBBase.getSession() key_item = session.query(FlightFixInfo.takeoff_airport, FlightFixInfo.arrival_airport).distinct().all() DBBase.Session.remove() return key_item
def findLike(flight_no): session = DBBase.getSession() key_item = None # @UnusedVariable key_item = session.query(FlightFixInfo).filter(FlightFixInfo.flight_no.like("%" + flight_no + "%")).all() DBBase.Session.remove() return key_item
def findAll(**kwargs): session = DBBase.getSession() key_item = session.query(VersionInfo).filter_by(**kwargs).order_by( VersionInfo.id.desc()).all() DBBase.Session.remove() return key_item
def count(**kwargs): session = DBBase.getSession() key_item = session.query(FlightFixInfo).filter_by(**kwargs).count() DBBase.Session.remove() return key_item
def findOne(**kwargs): session = DBBase.getSession() key_item = session.query(VersionInfo).filter_by(**kwargs).first() DBBase.Session.remove() return key_item
def findNewest(**kwargs): session = DBBase.getSession() key_item = session.query(VersionInfo).filter_by(**kwargs).order_by(VersionInfo.version.desc()).first() DBBase.Session.remove() return key_item