def getTempertureObservations():
# Get the latest date from database.
precipitation_last_date = session.query(Measurement.date)\
.order_by(Measurement.date.desc())\
.first()[0]
# Calculate one year ago from last date.
one_year_ago = get_one_year_ago(precipitation_last_date)
stations = session.query(Measurement.tobs, Measurement.station)\
.filter(and_(Measurement.date >= one_year_ago, Measurement.date <= precipitation_last_date))\
.group_by(Measurement.station)\
.all()
return make_dic(stations, ["tobs", "station"])
def getPrecipitation():
# Get the latest date from database.
precipitation_last_date = session.query(Measurement.date)\
.order_by(Measurement.date.desc())\
.first()[0]
# Calculate one year ago from last date.
one_year_ago = get_one_year_ago(precipitation_last_date)
# Design a query to retrieve the last 12 months of precipitation data and plot the results
precipitation = session.query(Measurement.date, Measurement.tobs)\
.filter(and_(Measurement.date >= one_year_ago, Measurement.date <= precipitation_last_date))\
.filter(Measurement.prcp != "None")\
.order_by(Measurement.date)\
.all()
return make_dic(precipitation, ["date", "tobs"])
from functions import get_data, make_dic, take_users, call_data, take_another, take_change, convert_currency data_list = get_data() data_dic = make_dic(data_list) call_data(data_dic) cur1 = take_users(data_dic) cur2 = take_another(data_dic) print(cur1) print(cur2) print(format_currency(1000, cur1, u'¤ #,##0.00', locale='en-US'))
def getTobsDescrip2(start_date, end_date):
temp_qr = session.query(Measurement.station, Measurement.tobs)\
.filter(and_(Measurement.date >= start_date, Measurement.date <= end_date))\
.all()
return make_dic(temp_qr, ['station', 'tobs'])