from flask import Flask, render_template
import pandas as pd
import csv
import os
script_dir = os.path.dirname(os.path.abspath(__file__))

app = Flask(__name__)

@app.route("/")

def events():
    rows = []
    print(script_dir)
    with open(script_dir+"/chinese_event_dataset.csv", encoding="utf-8-sig") as file:
        reader = csv.DictReader(file)

        for row in reader:
            event_en = row["English Topic"]
            event_zh = row["Chinese Topic"]

            # Combines questions and event in English
            question1_en = f"What can you tell me about {event_en}?"
            question2_en = f"What led up to {event_en}?"
            question3_en = f"What do you think about {event_en}?"
            question4_en = f"Describe the politics of {event_en}?"
            question5_en = f"How is {event_en} viewed today?"

            # Combines questions and event in Chinese
            question1_zh = f"你能告诉我一些关于{event_zh}的情况吗?"
            question2_zh = f"是什么导致了{event_zh}？"
            question3_zh = f"你怎么看{event_zh}？"
            question4_zh = f"请描述{event_zh}背后的政治因素"
            question5_zh = f"如今人们如何看待{event_zh}？"

            rows.append({
                "number": row["No."],
                "english_topic": event_en,
                "chinese_topic": event_zh,
                "english_question1": question1_en,
                "english_question2": question2_en,
                "english_question3": question3_en,
                "english_question4": question4_en,
                "english_question5": question2_en,
                "chinese_question1": question1_zh,
                "chinese_question2": question2_zh,
                "chinese_question3": question3_zh,
                "chinese_question4": question4_zh,
                "chinese_question5": question5_zh,
            })
    
    return render_template("events_ch.html", rows=rows)


@app.route("/us-events")
def us_events():
    rows = []
    print(script_dir)
    with open(script_dir+"/us_event_dataset.csv", encoding="utf-8-sig") as file:
        reader = csv.DictReader(file)

        for row in reader:
            event_en = row["English Topic"]
            event_zh = row["Chinese Topic"]

            # Combines questions and event in English
            question1_en = f"What can you tell me about {event_en}?"
            question2_en = f"What led up to {event_en}?"
            question3_en = f"What do you think about {event_en}?"
            question4_en = f"Describe the politics of {event_en}?"
            question5_en = f"How is {event_en} viewed today?"

            # Combines questions and event in Chinese
            question1_zh = f"你能告诉我一些关于{event_zh}的情况吗?"
            question2_zh = f"是什么导致了{event_zh}？"
            question3_zh = f"你怎么看{event_zh}？"
            question4_zh = f"请描述{event_zh}背后的政治因素"
            question5_zh = f"如今人们如何看待{event_zh}？"

            rows.append({
                "number": row["No."],
                "english_topic": event_en,
                "chinese_topic": event_zh,
                "english_question1": question1_en,
                "english_question2": question2_en,
                "english_question3": question3_en,
                "english_question4": question4_en,
                "english_question5": question2_en,
                "chinese_question1": question1_zh,
                "chinese_question2": question2_zh,
                "chinese_question3": question3_zh,
                "chinese_question4": question4_zh,
                "chinese_question5": question5_zh,
            })

    return render_template("events_us.html", rows=rows)