From 74d6f019cc90214833c00ec45ed92ffc45c07dd7 Mon Sep 17 00:00:00 2001 From: Priyansh Date: Thu, 2 Dec 2021 16:37:41 -0500 Subject: Isolated SQL Functions, Passed JS Data to Flask, time series in a separate function --- sql_functions.py | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql_functions.py (limited to 'sql_functions.py') diff --git a/sql_functions.py b/sql_functions.py new file mode 100644 index 0000000..313c449 --- /dev/null +++ b/sql_functions.py @@ -0,0 +1,18 @@ +import sqlite3 as sql +import pandas as pd + +def execute_sql_statement(sql_statement): + conn = sql.connect("database.db") + cur = conn.cursor() + cur.execute(sql_statement) + rows = cur.fetchall() + return rows + +def run_sql_pandas(sql_statement): + conn = sql.connect("database.db") + df=pd.read_sql_query(sql_statement, conn).to_records(index=False) + return df + +def get_list_of_dict(keys, list_of_tuples): + list_of_dict = [dict(zip(keys, values)) for values in list_of_tuples] + return list_of_dict \ No newline at end of file -- cgit v1.2.3