python

from flask import Flask, render_template, request
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:dracoc3@localhost:3306/flight_game'
db = SQLAlchemy(app)

class Country(db.Model):
    iso_country = db.Column(db.String(40), primary_key=True)
    name = db.Column(db.String(40), unique=True)

class Airport(db.Model):
    ident = db.Column(db.String, primary_key=True)
    name = db.Column(db.String(40), unique=True)
    iso_country = db.Column(db.Integer, db.ForeignKey('iso_country'))
    latitude_deg = db.Column(db.Float)
    longitude_deg = db.Column(db.Float)

@app.route('/', methods=['GET', 'POST'])
def home():
    countries = Country.query.all() or []
    airports = []
    country_choosen = None
    airport_choosen = None
    map_pos = None

    if request.method == 'POST':
        country_choosen = request.form.get('country')
        airport_choosen = request.form.get('airport')
        if country_choosen:
            airports = Airport.query.filter_by(iso_country=country_choosen).all() or []
        if airport_choosen:
            airport_select = Airport.query.filter_by(ident=airport_choosen).first()
            if airport_select:
                map_pos = [airport_select.latitude_deg, airport_select.longitude_deg]

    return render_template('index.html', countries=countries, airports=airports,
                           choosen_country=country_choosen, choosen_airport=airport_choosen, map_pos=map_pos)
if __name__ == '__main__':
    app.run(debug=True)