def refresh():
"""Pull fresh data from Open AQ and replace existing data."""
db.drop_all()
db.create_all()
# todo get all of the data from api and save it to a db
# fetch data
api = openaq.OpenAQ()
_, body = api.measurements(city='Los Angeles', parameter='pm25')
t = body['results']
# save to list of tuples
out = []
for i in t:
out.append((i['date']['utc'], i['value']))
# put that list of tuples in a db
# oneliners mean for each entry in dates and for each entry in values do:
for k, v in zip([x['date']['utc'] for x in t], [x['value'] for x in t]):
r = Record()
r.utc_time = k
r.value = v
db.session.add(r)
db.session.commit()
return redirect('/')
def reset_db():
print(type(db))
# drop all tablees in database
db.drop_all()
# create tables base on models
db.create_all()
return jsonify({"message": "DB RESET OK"})
def reset_db():
print("RESET ROUTE...")
print("FORM DATA:", dict(request.form))
print(type(db))
db.drop_all()
db.create_all()
return render_template("reset_db.html", db=db)
def reset_db():
db.drop_all()
db.create_all()
return render_template(
"twitter.html",
message=
"This is Twitter central. Either get a specific users tweets or display all past retrieved users and their tweets."
)
def reset_db():
print("URL PARMS", dict(request.args))
if "api_key" in dict(request.args) and request.args["api_key"] == API_KEY:
print(type(db))
db.drop_all()
db.create_all()
return jsonify({"message": "DB RESET OK"})
else:
flash("OOPS Permission Denied", "danger")
return redirect("/users")
def reset_db():
# print("URL PARMS", dict(request.args))
# if "api_key" in dict(request.args) and request.args["api_key"] == API_KEY:
# print(type(db))
# db.drop_all()
# db.create_all()
# # return jsonify({"message": "DB RESET OK"})
# return redirect("/tweets")
# else:
# return redirect("/tweets")
db.drop_all()
db.create_all()
# return jsonify({"message": "DB RESET OK"})
return redirect("/tweets")
def reset_db():
print(type(db))
db.drop_all()
db.create_all()
return jsonify({"message": "DB RESET OK"})
# @admin_routes.route("/admin/db/seed")
# def seed_db():
# print(type(db))
# # TODO: refactor the existing user and tweet storage logic from our twitter_routes into a re-usable function
# # ... so we can "seed" our database with some example users and tweets
# # ... to ensure that it is ready to make predictions later
# # FYI: you might run into Timeout errors, which you'll need to think about how to avoid
# return jsonify({"message": "DB SEEDED OK (TODO)"})
def reset_db():
print("URL PARMS", dict(request.args))
if "api_key" in dict(request.args) and request.args["api_key"] == API_KEY:
print(type(db))
db.drop_all()
db.create_all()
return jsonify({"message": "DB RESET OK"})
else:
flash("OOPS Permission Denied", "danger")
return redirect("/users")
#example without api key verification
#@admin_routes.route("/admin/db/reset")
# def reset_db():
# print(type(db))
# db.drop_all()
# db.create_all()
# return jsonify({"message": "DB RESET OK"})
def reset_db():
# Grab arguments from the URI
if len(request.args) == 0:
print(f"ERROR: query arguments missing")
flash("Missing API Key. Please check and try again", "danger")
return redirect("/db_reset")
if "api_key" not in dict(request.args):
print(f"ERROR: missing API Key. Reset database not allowed")
flash("Missing API Key. Please check and try again", "danger")
return redirect("/db_reset")
if request.args["api_key"] != API_KEY:
print(f"WARN: invalid API Key. Reset database not allowed")
flash("Invalid API Key. Please check and try again", "danger")
return redirect("/db_reset")
print(f"INFO: resetting the database")
db.drop_all() # drop all tables
db.create_all() # create tables from scratch
print(f"INFO: database has been reset")
flash('Your database has been reset!', "success")
return redirect("/db_reset")
def reset_db():
print("URL PARMS", dict(request.args))
if "api_key" in dict(request.args) and request.args["api_key"] == API_KEY:
print(type(db))
db.drop_all()
db.create_all()
return jsonify({"message": "DB RESET OK"})
else:
print("Permission Denied")
flash("OOPS Permission Denied", "danger")
return redirect("/")
# @admin_routes.route("/admin/db/seed")
# def seed_db():
# print(type(db))
# # TODO: refactor the existing user and tweet storage logic from our twitter_routes into a re-usable function
# # ... so we can "seed" our database with some example users and tweets
# # ... to ensure that it is ready to make predictions later
# # FYI: you might run into Timeout errors, which you'll need to think about how to avoid
# return jsonify({"message": "DB SEEDED OK (TODO)"})
def reset_db():
db.drop_all()
db.create_all()
# return jsonify({'message': 'Database has been reset'})
return redirect('/')
def reset():
db.drop_all()
db.create_all()
return render_template('layout.html', title='DB RESET!', users=[])
def reset_db():
print(type(db))
db.drop_all()
#breakpoint() to be used to investigate
db.create_all()
return jsonify({"message": "DB RESET OK"})
def reset_db():
print(type(db))
db.drop_all()
db.create_all()
return jsonify({"message": "DB RESET OK"})
def reset_db():
print(type(db))
db.drop_all()
db.create_all()
return jsonify({'message': 'DB RESET OK'})
def reset():
db.drop_all()
db.create_all()
return jsonify({"message": "Database Reset OK"})
def reset_db():
db.drop_all()
db.create_all()
return jsonify({"message":"DB RESET OK"})
def reset():
db.drop_all()
db.create_all()
return render_template('homepage.html', title='Reset database!')
def reset():
db.drop_all()
db.create_all()
return jsonify({"message": "We have successfuly reset the database."})
