diff options
| author | Priyansh <[email protected]> | 2021-12-09 03:01:49 -0500 |
|---|---|---|
| committer | Priyansh <[email protected]> | 2021-12-09 03:01:49 -0500 |
| commit | 3b48c04470e2c368ba18716bb789b40942d6989f (patch) | |
| tree | 1cb97d5271f2233fbf9d0ef864b91fc8a61efb17 /sql_functions.py | |
| parent | 22e1d761027501bfa59b92776cf1c13eef3a0004 (diff) | |
| download | temp_pred_arima-3b48c04470e2c368ba18716bb789b40942d6989f.tar.xz temp_pred_arima-3b48c04470e2c368ba18716bb789b40942d6989f.zip | |
changed project structure
Diffstat (limited to 'sql_functions.py')
| -rw-r--r-- | sql_functions.py | 21 |
1 files changed, 0 insertions, 21 deletions
diff --git a/sql_functions.py b/sql_functions.py deleted file mode 100644 index 54d1d05..0000000 --- a/sql_functions.py +++ /dev/null @@ -1,21 +0,0 @@ -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 |
