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")