from services.database import DatabaseEngine

from PySide6.QtWidgets import (
    QMainWindow,
    QTableWidget,
    QTableWidgetItem,
    QLabel
)

from styles.styles import (
    get_font_two,
    table_style
)

class PreviousGames(QMainWindow):
    def __init__(self, window_manager, logged_in_user):
        super(PreviousGames, self).__init__()

        self.window_manager = window_manager
        self.logged_in_user = logged_in_user

        self.db_engine = DatabaseEngine()

        self.font_two = get_font_two()
        self.table_style = table_style()

        self.setStyleSheet("background-color: #D1258A;")
        self.UiComponents()
        self.showMaximized()

    def UiComponents(self):
        self.table = QTableWidget(self)
        self.table.setGeometry(20,20,1880,970)
        self.table.setStyleSheet(self.table_style)
        self.table.setColumnCount(7)

        self.table.setItem(0,0, QTableWidgetItem("Id"))
        self.table.setItem(0,1, QTableWidgetItem("Username"))
        self.table.setItem(0,2, QTableWidgetItem("Stars"))
        self.table.setItem(0,3, QTableWidgetItem("Game Played"))
        self.table.setItem(0,4, QTableWidgetItem("Correct"))
        self.table.setItem(0,5, QTableWidgetItem("Wrong"))
        self.table.setItem(0,6, QTableWidgetItem("Total"))

        user_games = self.db_engine.get_user_games(self.logged_in_user)

        x = 1
        y = 0

        """
        [(1, 'mekasu0124', 3, 'addition', 25, 19, 25), (2, 'mekasu0124', 15, 'subtraction', 16, 13, 25)]
        """

        if user_games:
            for index, value in enumerate(user_games):
                self.table.setItem(x,y, QTableWidgetItem(user_games[index][0]))
                y += 1