-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathapp.py
138 lines (99 loc) · 3.89 KB
/
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
import numpy as np
import sqlalchemy
from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy import create_engine, func
from flask import Flask, jsonify
engine = create_engine("sqlite:///Resources/hawaii.sqlite")
# reflect an existing database into a new model
Base = automap_base()
# reflect the tables
Base.prepare(engine, reflect=True)
# Save reference to the table
measurement = Base.classes.measurement
station = Base.classes.station
# Flask Setup
############################
# KEEP __name__ same
app = Flask(__name__)
@app.route("/")
def welcome():
"""List all available api routes."""
return (
f"Available Routes:<br/>"
f"/api/v1.0/precipitation<br/>"
f"/api/v1.0/stations<br/>"
f"/api/v1.0/tobs<br/>"
f"/api/v1.0/start<br/>"
f"/api/v1.0/startend<br/>"
)
@app.route("/api/v1.0/precipitation")
def preciptiation():
# Create our session (link) from Python to the DB
session = Session(engine)
"""Return a list of all precipitation from last year"""
# Query all precipitation
# session.query(key, value)
results = session.query(measurement.date, measurement.prcp).\
filter(measurement.date > '2016-08-23').\
order_by(measurement.date).all()
session.close()
# Convert list of tuples into normal list
all_results= list(np.ravel(results))
return jsonify(all_results)
@app.route("/api/v1.0/stations")
def stations():
# Create our session (link) from Python to the DB
session = Session(engine)
"""Return a list of all stations from last year"""
# Query all stations
results = session.query(measurement.station, func.count(measurement.id)).group_by(measurement.station).\
order_by(func.count(measurement.id).desc()).all()
session.close()
# Convert list of tuples into normal list
all_results= list(np.ravel(results))
return jsonify(all_results)
@app.route("/api/v1.0/tobs")
def tobs():
# Create our session (link) from Python to the DB
session = Session(engine)
tobs_highest = session.query(measurement.station).group_by(measurement.station).\
order_by(func.count(measurement.tobs).desc()).first()
tobs_highest = tobs_highest[0]
# Query
# session.query(key, value)
results = session.query(measurement.date, measurement.tobs).\
filter(measurement.date > '2016-08-23' ).\
filter(measurement.station == tobs_highest).\
order_by(measurement.date).all()
session.close()
# Convert list of tuples into normal list
all_results= list(np.ravel(results))
return jsonify(all_results)
@app.route("/api/v1.0/start")
def start():
# Create our session (link) from Python to the DB
session = Session(engine)
# session.query(key, value)
results = session.query(measurement.station).group_by(measurement.station).\
order_by(func.count(measurement.id).desc()).first()
session.close()
# Convert list of tuples into normal list
all_results= list(np.ravel(results))
return jsonify(all_results)
@app.route("/api/v1.0/startend")
def startend():
# Create our session (link) from Python to the DB
session = Session(engine)
active_station = session.query(measurement.station).group_by(measurement.station).\
order_by(func.count(measurement.id).desc()).first()
active_station = active_station[0]
# session.query(key, value)
results = session.query(measurement.station, func.min(measurement.tobs), func.avg(measurement.tobs), func.max(measurement.tobs)).group_by(measurement.station).\
filter(measurement.station == active_station).all()
session.close()
# Convert list of tuples into normal list
all_results= list(np.ravel(results))
return jsonify(all_results)
if __name__ == '__main__':
app.run(debug=True)