<?php
    class Database {
        public PDO $pdo_article;
        public PDO $pdo_teams;

        public function __construct() {
            $data_path = "/../data/";
            try {
                // Création des bases de données
                // Base des énigmes :
                $this->pdo_article = new PDO("sqlite:" . dirname(__FILE__) . $data_path . "article.db");
                $this->pdo_article->query('CREATE TABLE IF NOT EXISTS "puzzles" (
                    "id"	INTEGER NOT NULL UNIQUE,
                    "title"	TEXT NOT NULL,
                    "text"	TEXT NOT NULL,
                    "hint"	TEXT,
                    "answer"	TEXT NOT NULL,
                    "location"	TEXT NOT NULL,
                    "code"	TEXT NOT NULL,
                    PRIMARY KEY("id" AUTOINCREMENT)
                )');

                // Base des équipes :
                $this->pdo_teams = new PDO("sqlite:" . dirname(__FILE__) . $data_path . "teams.db");
                $this->pdo_teams->query('CREATE TABLE IF NOT EXISTS "teams" (
                    "id"	INTEGER NOT NULL UNIQUE,
                    "bonus"	INTEGER NOT NULL,
                    PRIMARY KEY("id" AUTOINCREMENT)
                )');

                $this->pdo_teams->query('CREATE TABLE IF NOT EXISTS "solved" (
                    "puzzle_id"	INTEGER NOT NULL,
                    "team_id"	INTEGER NOT NULL
                )');

                $this->pdo_teams->query('CREATE TABLE IF NOT EXISTS "members" (
                    "name"	TEXT NOT NULL,
                    "team_id"	INTEGER NOT NULL
                )');
            }

            catch (PDOException $exception) {
                var_dump($exception);
                die();
            }
        }

        public function checkTeamExists(int $id) {
            $stmt = $this->pdo_teams->prepare("SELECT * FROM teams WHERE id == :id");
            $stmt->bindValue(":id", $id);
            $stmt->execute();
            return !empty($stmt->fetch());
        }

        public function getArticleNb() {
            $query = $this->pdo_article->query("SELECT COUNT(*) FROM puzzles");
            return $query->fetch()["COUNT(*)"];
        }

        function checkTeamBonus(int $team) {
            // $team doit être une équipe existante :
            $query = $this->pdo_teams->query("SELECT bonus FROM teams WHERE id = " . $team);
            return $query->fetch()[0] == 1;
        }

        // public function getTeamsNb() {
        //     $query = $this->pdo_teams->query("SELECT COUNT(*) FROM teams");
        //     return $query->fetch()["COUNT(*)"];
        // }
    }
?>