From 3b48c04470e2c368ba18716bb789b40942d6989f Mon Sep 17 00:00:00 2001 From: Priyansh Date: Thu, 9 Dec 2021 03:01:49 -0500 Subject: changed project structure --- functions/sql_functions.py | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 functions/sql_functions.py (limited to 'functions/sql_functions.py') diff --git a/functions/sql_functions.py b/functions/sql_functions.py new file mode 100644 index 0000000..5cc2ae9 --- /dev/null +++ b/functions/sql_functions.py @@ -0,0 +1,16 @@ +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 -- cgit v1.2.3