bd.class.php

Aller à la documentation de ce fichier.

<?php
 
class bd
{
    public const ROLE_SITE_USER = 'site_user';
    public const ROLE_SITE_ADMINISTRATEUR = 'site_administrateur';
    public const ROLE_DB_ADMINISTRATEUR = 'db_administrateur';
 
    private static ?bd $instance = null;
 
    private array $connections = [];
 
    private array $dbConfig;
 
    private function __construct()
    {
        $config = Constantes::getInstance()->getConfig()['db'];
        $this->dbConfig = [
            'host' => $config['host'],
            'dbname' => $config['dbname'],
            'port' => (int) ($config['port'] ?? 3306),
        ];
    }
 
    public static function getInstance(): bd
    {
        if (self::$instance === null) {
            self::$instance = new bd();
        }
        return self::$instance;
    }
 
    private function getDsn(): string
    {
        return sprintf(
            'mysql:host=%s;port=%d;dbname=%s;charset=utf8mb4',
            $this->dbConfig['host'],
            $this->dbConfig['port'],
            $this->dbConfig['dbname']
        );
    }
 
    private function createConnection(string $role): PDO
    {
        $config = Constantes::getInstance()->getConfig()['db'];
        if (!isset($config[$role]['username']) || !isset($config[$role]['password'])) {
            throw new PDOException("Configuration DB manquante pour le rôle : {$role}");
        }
        $username = $config[$role]['username'];
        $password = $config[$role]['password'];
        $pdo = new PDO($this->getDsn(), $username, $password, [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        ]);
        $this->connections[$role] = $pdo;
        return $pdo;
    }
 
    public function getConnexion(string $role = self::ROLE_SITE_USER): PDO
    {
        if (!isset($this->connections[$role])) {
            $this->createConnection($role);
        }
        return $this->connections[$role];
    }
 
    private function __clone() {}
 
    public function __wakeup()
    {
        throw new Exception("Un singleton ne doit pas être deserialisé.");
    }
}