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 delete(self):
session = DBBase.getSession()
ret = self.find()
if ret is not None:
session.delete(ret)
session.commit()
DBBase.Session.remove()
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 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 getAllFlightNO():
session = DBBase.getSession()
key_item = session.query(FlightFixInfo.flight_no).all()
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 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 delete(self):
session = DBBase.getSession()
session.delete(self)
session.commit()
DBBase.Session.remove()
def findOne(**kwargs):
session = DBBase.getSession()
key_item = session.query(VersionInfo).filter_by(**kwargs).first()
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 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 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
