def monthlyStatistics():
originButton = flightUtil.Button('Select','')
destinationButton = flightUtil.Button('Select','')
airlineButton = flightUtil.Button('Select','')
monthButton = flightUtil.Button('Select','')
yearButton = flightUtil.Button('Select','Select')
try:
als = flightUtil.executeQueryAndReturn(flightUtil.airlineQuery)
als = (('Select',''),)+als
cities = flightUtil.executeQueryAndReturn(flightUtil.cityQuery)
if request.method=='POST':
originButton.setValue(request.form['selectedOrigin'])
destinationButton.setValue(request.form['selectedDestination'])
airlineButton.setValue(request.form['selectedAirline'])
yearButton.setValue(request.form['selectedYear'])
yearButton.setLabel(request.form['selectedYear'])
monthButton.setValue(request.form['selectedMonth'])
#monthButton.setLabel(flightUtil.months[monthButton.getValue()])
destinationButton.setLabel(\
flightUtil.executeQueryAndReturn(\
flightUtil.cityNameQuery%(destinationButton.getValue()))[0][0])
originButton.setLabel(\
flightUtil.executeQueryAndReturn(\
flightUtil.cityNameQuery%(originButton.getValue()))[0][0])
if airlineButton.getValue()!='':
airlineButton.setLabel(flightUtil.executeQueryAndReturn(\
flightUtil.airlineNameQuery%(airlineButton.getValue()))[0][0])
else :
airlineButton.setLabel('Select')
except Exception, e:
print 'Error occured'+str(e)
return render_template('error.html',error=str(e))
def priceHistory():
slotFrom='Select'
slotTo='Select'
origin='Select'
originValue=''
destination='Select'
destinationValue=''
date=''
metrics=['MIN','AVG','MAX']
metric='Select'
history=[]
try:
cities = flightUtil.executeQueryAndReturn(flightUtil.cityQuery)
if request.method=='POST':
slotFrom=request.form['selectedSlotFrom']
slotTo=request.form['selectedSlotTo']
origin=request.form['selectedOrigin']
destination=request.form['selectedDestination']
date=request.form['datepicker']
metric=request.form['selectedMetric']
query = flightUtil.metricPriceHistoryQuery%(\
metric,\
slotFrom,\
slotTo,\
origin,\
destination,\
origin+'%'+flightUtil.flightQuerySufix(date)+'%')
print query
history=flightUtil.executeQueryAndReturn(query)
print history
priceHistory = [(hist[0],hist[1]) for hist in history]
print priceHistory
history =''
p = ''
for i in range(len(priceHistory)):
p = priceHistory[i][1]
dt = str(priceHistory[i][0])
print dt
dt = dt.split('/')
history += dt[2]+' '+dt[1]+' '+dt[0]+' '
history += str(p)+':'
history += (flightUtil.currentDate())+' '
history += str(p)
print history
originValue = origin
destinationValue = destination
destination = flightUtil.executeQueryAndReturn(\
flightUtil.cityNameQuery%(destination))[0][0]
origin = flightUtil.executeQueryAndReturn(\
flightUtil.cityNameQuery%(origin))[0][0]
except Exception, e:
print 'Error occured'+str(e)
return render_template('error.html',error=str(e))
def flight(name):
typ = flightUtil.flightType(name)
query = ''
if typ=="direct":
query = flightUtil.directFlightPriceHistoryQuery
elif typ=="oneStop":
query = flightUtil.oneStopFlightPriceHistoryQuery
elif typ=="twoStop":
query = flightUtil.twoStopFlightPriceHistoryQuery
priceHistory = flightUtil.executeQueryAndReturn(
query%name)
print priceHistory
priceHistory = [(price[0],price[1]) for price in priceHistory]
history =''
p = ''
print priceHistory
for i in range(len(priceHistory)):
p = priceHistory[i][0]
dt = str(priceHistory[i][1])
print dt
dt = dt.split('/')
history += dt[0]+' '+dt[1]+' '+dt[2]+' '
history += str(priceHistory[i][0])+';'
history += (flightUtil.currentDate())+' '
history += str(p)
print history
return history
def flightView(query,pattern,orig,dest):
fltLst = []
nowTime = time.strftime("%H:%M")
currentDay = time.strftime("%d")
currentMonth = time.strftime("%m")
flightDate = dt
todayDate = time.strftime('%m/%d/%Y')
fltHst = \
flightUtil.executeQueryAndReturn( \
query%(pattern,orig,dest))
for flt in fltHst:
if flightDate!=todayDate or nowTime < flt[1][:5]:
fltLst.append(flightUtil.flightDescription(flt[0],flt[1]))
return fltLst
def flightHistory():
airlineButton = flightUtil.Button('Select','')
originButton = flightUtil.Button('Select','')
destinationButton = flightUtil.Button('Select','')
stopButton = flightUtil.Button('Select','')
oneStop = []
twoStop = []
direct = []
fltLst = []
dt = ''
try:
cities = flightUtil.executeQueryAndReturn(flightUtil.cityQuery)
als = flightUtil.executeQueryAndReturn(flightUtil.airlineQuery)
als = (('Select',''),)+als
if request.method=='POST':
originButton.setValue(request.form['selectedOrigin'])
destinationButton.setValue(request.form['selectedDestination'])
dt = request.form['datepicker']
airlineButton.setValue(request.form['selectedAirline'])
stopButton.setValue(request.form['selectedStop'])
stopButton.setLabel(request.form['selectedStop'])
pattern = flightUtil.flightQueryPattern(\
airlineButton.getValue(),\
originButton.getValue(),\
dt)
print pattern
def flightView(query,pattern,orig,dest):
fltLst = []
nowTime = time.strftime("%H:%M")
currentDay = time.strftime("%d")
currentMonth = time.strftime("%m")
flightDate = dt
todayDate = time.strftime('%m/%d/%Y')
fltHst = \
flightUtil.executeQueryAndReturn( \
query%(pattern,orig,dest))
for flt in fltHst:
if flightDate!=todayDate or nowTime < flt[1][:5]:
fltLst.append(flightUtil.flightDescription(flt[0],flt[1]))
return fltLst
twoStop = flightView(\
flightUtil.twoStopFlightsQuery,pattern,originButton.getValue(),destinationButton.getValue())
oneStop = flightView(\
flightUtil.oneStopFlightsQuery,pattern,originButton.getValue(),destinationButton.getValue())
direct = flightView(\
flightUtil.directFlightsQuery,pattern,originButton.getValue(),destinationButton.getValue())
destinationButton.setLabel(\
flightUtil.executeQueryAndReturn(\
flightUtil.cityNameQuery%(destinationButton.getValue()))[0][0])
originButton.setLabel(\
flightUtil.executeQueryAndReturn(\
flightUtil.cityNameQuery%(originButton.getValue()))[0][0])
if airlineButton.getValue()!='':
airlineButton.setLabel(flightUtil.executeQueryAndReturn(\
flightUtil.airlineNameQuery%(airlineButton.getValue()))[0][0])
else :
airlineButton.setLabel('Select')
if stopButton.getValue()=='':
stopButton.setLabel('Select')
except Exception, e:
print 'Error occured'+str(e)
return render_template('error.html',error=str(e))
