from flask import Flask, Response
import sqlite3
from operator import itemgetter

app = Flask(__name__)


@app.route("/schedule")
def schcedule_route():
    return get_data()


def get_data():
    with open("data.txt", "r") as read_file:
        file = read_file.read().split("\n")
        db_path = file[0]
        year = file[1]

    conn = sqlite3.connect(db_path)
    c = conn.cursor()
    c.execute("""SELECT * FROM spaceships
    WHERE year = ?""", (year,))
    result = []
    for el in c.fetchall():
        result.append({
            "id": el[0],
            "name": el[1],
            "load": el[2],
            "crew": el[3],
            "year": el[4]
        })
    result.sort(key=itemgetter("load", "name"))
    c.close()
    conn.close()
    return result


app.run()