passwordResetToken.dao.php

Aller à la documentation de ce fichier.

<?php
 
namespace ComusParty\Models;
 
use DateMalformedStringException;
use DateTime;
use PDO;

class PasswordResetTokenDAO
{
    private ?PDO $pdo;

    public function __construct(?PDO $pdo)
    {
        $this->pdo = $pdo;
    }

    public function getPdo(): ?PDO
    {
        return $this->pdo;
    }

    public function setPdo(?PDO $pdo): void
    {
        $this->pdo = $pdo;
    }

    public function findByUserId(int $userId): ?PasswordResetToken
    {
        $stmt = $this->pdo->prepare('SELECT * FROM ' . DB_PREFIX . 'pswd_reset_token WHERE user_id = :userId');
        $stmt->execute(['userId' => $userId]);
        $row = $stmt->fetch();
        if ($row === false) {
            return null;
        }
        return $this->hydrate($row);
    }

    private function hydrate(array $row): PasswordResetToken
    {
        return new PasswordResetToken($row['user_id'], $row['token'], new DateTime($row['created_at']));
    }

    public function findByToken(string $token): ?PasswordResetToken
    {
        $stmt = $this->pdo->prepare('SELECT * FROM ' . DB_PREFIX . 'pswd_reset_token WHERE token = :token');
        $stmt->execute(['token' => $token]);
        $row = $stmt->fetch();
        if ($row === false) {
            return null;
        }
        return $this->hydrate($row);
    }

    public function insert(PasswordResetToken $token): bool
    {
        $stmt = $this->pdo->prepare('INSERT INTO ' . DB_PREFIX . 'pswd_reset_token (user_id, token, created_at) VALUES (:userId, :token, :createdAt)');
        return $stmt->execute([
            'userId' => $token->getUserId(),
            'token' => $token->getToken(),
            'createdAt' => $token->getCreatedAt()->format('Y-m-d H:i:s')
        ]);
    }

    public function delete(int $userId): bool
    {
        $stmt = $this->pdo->prepare('DELETE FROM ' . DB_PREFIX . 'pswd_reset_token WHERE user_id = :userId');
        return $stmt->execute(['userId' => $userId]);
    }

    private function hydrateMany(array $rows): array
    {
        $tokens = [];
        foreach ($rows as $row) {
            $tokens[] = $this->hydrate($row);
        }
        return $tokens;
    }
}