manage_profiles.py

import sqlite3
from tkinter import Tk
from tkinter import messagebox


class UserProfile():
    def __init__(self, **kwargs):
        self.name = ""
        self.username = ""
        self.email = ""
        self.password = ""
        self.age = ""
        self.dob = ""
        self.pong_game = 0
        self.snake_game = 0
        self.quiz_game = 0
        self.turtle_crossing_game = 0
        self.hangman = 0


    def create_table(self):
        conn = sqlite3.connect('./database/users.db')
        c = conn.cursor()
        c.execute(
            "CREATE TABLE users (name TEXT, username TEXT PRIMARY KEY, password PASSWORD, email TEXT, age INTEGER, dob TEXT, pong_game INTEGER, snake_game INTEGER, quiz_game INTEGER, turtle_crossing_game INTEGER, hangman INTEGER)"
        )
        conn.commit()
        conn.close()


    def get_user_data(self, username):
        try:
            conn = sqlite3.connect('./database/users.db')
            c = conn.cursor()
            c.execute(f"SELECT * FROM users WHERE username = '{username}'")
            user_data = c.fetchall()
            conn.close()
            # print(user_data)
            return user_data
        except sqlite3.DatabaseError:
            messagebox.showerror("Error", "User not found")


    def register_new_user(self, name, username, password, email, age, dob):
        conn = sqlite3.connect('./database/users.db')
        c = conn.cursor()
        c.execute(
            "INSERT INTO users VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", [name, username, password, email, age, dob, 0, 0, 0, 0, 0]
        )
        conn.commit()
        conn.close()


    def delete_user(self, username):
        conn = sqlite3.connect('./database/users.db')
        c = conn.cursor()
        c.execute(
            f"DELETE FROM users WHERE username = '{username}'"
        )
        conn.commit()
        conn.close()


    def update_score(self, game_name, score, username):
        conn = sqlite3.connect('../database/users.db')
        c = conn.cursor()
        c.execute(
            f"UPDATE users SET {game_name} = {score} WHERE username = '{username}'"
        )
        conn.commit()
        conn.close()


    def get_score(self, game, username):
        conn = sqlite3.connect('../database/users.db')
        c = conn.cursor()
        c.execute(f"SELECT {game} FROM users WHERE username = '{username}'")
        score = c.fetchone()[0]
        conn.close()
        # print(score)
        return score
        # print(game)
        # print(username)
        # print("Activate")


    # def get_highscores(self, username):
    #     conn = sqlite3.connect('./database/users.db')
    #     c = conn.cursor()
    #     c.execute(
    #         f"SELECT pong_game, snake_game, quiz_game, hangman, turtle_crossing_game FROM users WHERE username = '{username}'"
    #     )
    #     scores = c.fetchall()
    #     conn.close()
    #     # print(scores)
    #     return scores


    def get_col_entries(self, colname):
        conn = sqlite3.connect('./database/users.db')
        c = conn.cursor()
        c.execute(f"SELECT {colname} FROM users")
        data = c.fetchall()
        conn.close()
        # print(data)
        return data


# demo = UserProfile()
# demo.update_score("turtle_crossing_game", 2, "NoobStunts")
# data = demo.get_score("turtle_crossing_game", "NoobStunts")
# print(data)