from flask import Flask, render_template, request, url_for
from database import *
import pandas as pd
from fuzzywuzzy import process, fuzz
import os
import pinecone

PINECONE_KEY = os.getenv("PINECONE_API_DEFAULT")

database_url = "sqlite:///jlm.db"

engine, Session = init_db_stuff(database_url)

df = pd.read_sql("Select * from movies", engine)
movie_titles = df["title"].tolist()

pinecone.init(api_key=PINECONE_KEY, environment="us-west1-gcp")
index = pinecone.Index("movies")

app = Flask(__name__, template_folder="./templates")


def title2trakt_id(title: str, df=df):
    # Matches Exact Title, Otherwise Returns None
    records = df[df["title"].str.lower() == title.lower()]
    if len(records) == 0:
        return 0, None
    elif len(records) == 1:
        return 1, records.trakt_id.tolist()[0]
    else:
        return 2, records.trakt_id.tolist()


def get_vector_value(trakt_id: int):
    fetch_response = index.fetch(ids=[str(trakt_id)])
    return fetch_response["vectors"][str(trakt_id)]["values"]


def query_vectors(
    vector: list,
    top_k: int = 20,
    include_values: bool = False,
    include_metada: bool = True,
):
    query_response = index.query(
        queries=[
            (vector),
        ],
        top_k=top_k,
        include_values=include_values,
        include_metadata=include_metada,
    )
    return query_response


def query2ids(query_response):
    trakt_ids = []
    for match in query_response["results"][0]["matches"]:
        trakt_ids.append(int(match["id"]))
    return trakt_ids


def get_deets_by_trakt_id(df, trakt_id: int):
    df = df[df["trakt_id"] == trakt_id]
    return {
        "title": df.title.values[0],
        "overview": df.overview.values[0],
        "runtime": int(df.runtime.values[0]),
        "year": int(df.year.values[0]),
        "trakt_id": trakt_id,
        "tagline": df.tagline.values[0],
    }


@app.route("/similar")
def get_similar_titles():
    trakt_id = request.args.get("trakt_id")
    filterin = request.args.get("filter")

    min_year = request.args.get("minYear")
    if min_year == None:
        min_year = 1900
    else:
        try:
            min_year = int(min_year)
        except TypeError:
            min_year = 1900
    max_year = request.args.get("maxYear")
    if max_year == None:
        max_year = 2021
    else:
        try:
            max_year = int(max_year)
        except TypeError:
            max_year = 2021
    minRuntime = request.args.get("minRuntime")
    if minRuntime == None:
        minRuntime = 70
    else:
        try:
            minRuntime = int(minRuntime)
        except TypeError:
            minRuntime = 70
    maxRuntime = request.args.get("maxRuntime")
    if maxRuntime == None:
        maxRuntime = 220
    else:
        try:
            maxRuntime = int(maxRuntime)
        except TypeError:
            maxRuntime = 220
    vector = get_vector_value(trakt_id)
    movie_queries = query_vectors(vector, top_k=69)
    movie_ids = query2ids(movie_queries)
    results = []
    # for trakt_id in movie_ids:
    #    deets = get_deets_by_trakt_id(df, trakt_id)
    #    results.append(deets)
    max_res = 30
    cur_res = 0
    for trakt_id in movie_ids:
        if cur_res >= max_res:
            break
        deets = get_deets_by_trakt_id(df, trakt_id)
        if ((deets["year"] >= min_year) and (deets["year"] <= max_year)) and (
            (deets["runtime"] >= minRuntime) and (deets["runtime"] <= maxRuntime)
        ):
            results.append(deets)
            cur_res += 1
    return render_template("show_results.html", deets=results)


@app.route("/", methods=("GET", "POST"))
def find_similar_title():
    if request.method == "GET":
        return render_template("index.html")
    elif request.method == "POST":
        to_search_title = request.form["title"]
        code, values = title2trakt_id(to_search_title)
        print(f"Code {code} for {to_search_title}")
        if code == 0:
            search_results = process.extract(
                to_search_title, movie_titles, scorer=fuzz.token_sort_ratio
            )
            to_search_titles = []
            to_search_ids = []
            results = []
            for search_result in search_results:
                search_title, score = search_result
                to_search_titles.append(search_title)
            for to_search in to_search_titles:
                code, values = title2trakt_id(to_search)
                if code == 1:
                    to_search_ids.append(values)
                else:
                    for trakt_id in values:
                        to_search_ids.append(trakt_id)
            for trakt_id in to_search_ids:
                deets = get_deets_by_trakt_id(df, int(trakt_id))
                deets["trakt_id"] = trakt_id
                results.append(deets)
            return render_template("same_titles.html", deets=results)

        elif code == 1:
            vector = get_vector_value(values)
            movie_queries = query_vectors(vector)
            movie_ids = query2ids(movie_queries)
            results = []
            for trakt_id in movie_ids:
                deets = get_deets_by_trakt_id(df, trakt_id)
                results.append(deets)
            return render_template("show_results.html", deets=results)
        else:
            results = []
            for trakt_id in values:
                deets = get_deets_by_trakt_id(df, int(trakt_id))
                deets["trakt_id"] = trakt_id
                results.append(deets)
            return render_template("same_titles.html", deets=results)