blob: c2308f9bdb007ba3beb379c2dbc96d22e04bb18b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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
@app.route("/")
@app.route("/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)
|
