<?php

namespace Infrastructure\Persistence;

use Infrastructure\Config\DatabaseFactory;

/**
 * Repository für KI-Protokoll Datenbank (SRP)
 */
class KiProtokollRepository
{
    private \PDO $pdo;

    public function __construct(?\PDO $pdo = null)
    {
        $this->pdo = $pdo ?? DatabaseFactory::dev();
    }

    /**
     * Letzte N Protokoll-Einträge abrufen
     */
    public function findLatest(int $limit = 20): array
    {
        $stmt = $this->pdo->prepare(
            'SELECT id, timestamp, client_name, request, status, duration_ms
             FROM protokoll
             ORDER BY id DESC
             LIMIT :limit'
        );
        $stmt->bindValue(':limit', $limit, \PDO::PARAM_INT);
        $stmt->execute();

        return $stmt->fetchAll();
    }
}