def download():
""" Create file in csv format and downloaded to user's computer"""
db_connection = DbConnect(current_app.config)
query = session['query']
time_title = ''
if query.get("analysis_type") == "Daily":
time_title = "Date"
elif query.get("analysis_type") == "Monthly":
time_title = "Month, Year"
elif query.get("analysis_type") == "Yearly":
time_title = "Year"
else:
time_title = "Timestamp"
header = [
("Output type", "District", "Site", "Reef", "Reef Location", "Depth"),
[
query["output_type"], query["biomimic_type"], query["country"],
query["state_province"], query["location"], query["zone"]
], (time_title, "Temperature")
]
query_results = header + db_connection.get_query_raw_results(
session['db_query'])
db_connection.close()
return excel.make_response_from_array(query_results,
"csv",
file_name="export_data")
def download():
""" Create file in csv format and downloaded to user's computer"""
db_connection = DbConnect(current_app.config)
query = session['query']
time_title = ''
if query.get("analysis_type") == "Daily":
time_title = "Date"
elif query.get("analysis_type") == "Monthly":
time_title = "Month, Year"
elif query.get("analysis_type") == "Yearly":
time_title = "Year"
else:
time_title = "Timestamp"
header = [[key + ":" + str(value) for key, value in query.items()],
(time_title, "Temperature")]
query_results = header + db_connection.get_query_raw_results(session['db_query'])
db_connection.close()
return excel.make_response_from_array(query_results, "csv",
file_name="export_data")
def download():
""" Create file in csv format and downloaded to user's computer"""
db_connection = DbConnect(current_app.config)
query = session['query']
time_title = ''
if query.get("analysis_type") == "Daily":
time_title = "Date"
elif query.get("analysis_type") == "Monthly":
time_title = "Month, Year"
elif query.get("analysis_type") == "Yearly":
time_title = "Year"
else:
time_title = "Timestamp"
header = [[key + ":" + str(value) for key, value in query.items()],
(time_title, "Temperature")]
query_results = header + db_connection.get_query_raw_results(
session['db_query'])
db_connection.close()
return excel.make_response_from_array(query_results,
"csv",
file_name="export_data")
