rememberToken.dao.php

Aller à la documentation de ce fichier.

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

class RememberTokenDAO
{
    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 insert(RememberToken $rememberToken): bool
    {
        $query = $this->pdo->prepare("INSERT INTO cp_remember_user (user_id, token, rmb_key, created_at, expires_at) VALUES (:user_id, :token, :rmb_key, :created_at, :expires_at)");
 
        $query->bindValue(":user_id", $rememberToken->getUserId());
        $query->bindValue(":token", $rememberToken->getToken());
        $query->bindValue(":rmb_key", $rememberToken->getKey());
        $query->bindValue(":created_at", $rememberToken->getCreatedAt()->format("Y-m-d H:i:s"));
        $query->bindValue(":expires_at", $rememberToken->getExpiresAt()->format("Y-m-d H:i:s"));
 
        return $query->execute();
    }

    public function delete(RememberToken $rememberToken): bool
    {
        $query = $this->pdo->prepare("DELETE FROM cp_remember_user WHERE user_id = :user_id AND token = :token");
 
        $query->bindValue(":user_id", $rememberToken->getUserId());
        $query->bindValue(":token", $rememberToken->getToken());
 
        return $query->execute();
    }

    public function find(int $userId, string $token): ?RememberToken
    {
        $query = $this->pdo->prepare("SELECT * FROM cp_remember_user WHERE user_id = :user_id AND token = :token");
 
        $query->bindValue(":user_id", $userId);
        $query->bindValue(":token", $token);
 
        $query->execute();
 
        $data = $query->fetch();
 
        if ($data === false) {
            return null;
        }
 
        return $this->hydrate($data);
    }

    private function hydrate(array $data): RememberToken
    {
        return new RememberToken(
            $data['user_id'],
            $data['token'],
            $data['rmb_key'],
            new DateTime($data['created_at']),
            new DateTime($data['expires_at'])
        );
    }

    public function findByUserId(int $userId): ?array
    {
        $query = $this->pdo->prepare("SELECT * FROM cp_remember_user WHERE user_id = :user_id");
 
        $query->bindValue(":user_id", $userId);
 
        $query->execute();
 
        $data = $query->fetch();
 
        if ($data === false) {
            return null;
        }
 
        return $this->hydrateMany($data);
    }

    private function hydrateMany(array $datas): array
    {
        $rememberTokens = [];
        foreach ($datas as $data) {
            $rememberTokens[] = $this->hydrate($data);
        }
        return $rememberTokens;
    }

    public function deleteAllForUserId(int $userId): bool
    {
        $query = $this->pdo->prepare("DELETE FROM cp_remember_user WHERE user_id = :user_id");
 
        $query->bindValue(":user_id", $userId);
 
        return $query->execute();
    }
}