1 files changed, 32 insertions, 0 deletions
diff --git a/app/main.py b/app/main.py
new file mode 100644
index 0000000..c2308f9
--- /dev/null
+++ b/app/main.py
@@ -0,0 +1,32 @@
+from flask import Flask, render_template
+from flask import Markup
+import sqlite3 as sql
+import pandas as pd
+
+app = Flask(__name__)
+
+
+def execute_sql_statement(sql_statement, conn):
+    cur = conn.cursor()
+    cur.execute(sql_statement)
+    rows = cur.fetchall()
+    return rows
+
+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
+
+def get_cities_list():
+    conn = sql.connect("database.db")
+    sql_statement = 'SELECT DISTINCT(City_Name) as City_Name, Lat, Long FROM City_table join Loc_Table on City_Table.City_Id = Loc_table.City_Id'
+    df=pd.read_sql_query(sql_statement, conn).to_records(index=False)
+    return df
+
+[email protected]("/")
+[email protected]("/index")
+def index():
+
+    cities_list = get_cities_list()
+    keys = ("city", "latitude", "longitude")
+    cities_list = get_list_of_dict(keys, cities_list)
+    return render_template("index.html", cities_list=cities_list)
+\ No newline at end of file