<?php

/*
 * Copyright 2005 - 2025 Centreon (https://www.centreon.com/)
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * For more information : contact@centreon.com
 *
 */

declare(strict_types=1);

namespace Core\Infrastructure\Common\Repository;

use Centreon\Domain\Repository\RepositoryException;
use Centreon\Infrastructure\DatabaseConnection;
use Centreon\Infrastructure\Repository\AbstractRepositoryDRB;
use Core\Application\Common\Session\Repository\ReadSessionRepositoryInterface;

class DbReadSessionRepository extends AbstractRepositoryDRB implements ReadSessionRepositoryInterface
{
    /**
     * @param DatabaseConnection $db
     */
    public function __construct(DatabaseConnection $db)
    {
        $this->db = $db;
    }

    /**
     * @inheritDoc
     */
    public function findSessionIdsByUserId(int $userId): array
    {
        $statement = $this->db->prepare(
            $this->translateDbName(
                'SELECT session_id FROM session WHERE user_id = :user_id'
            )
        );
        $statement->bindValue(':user_id', $userId, \PDO::PARAM_INT);
        $statement->execute();

        $sessionIds = [];
        while ($result = $statement->fetch(\PDO::FETCH_ASSOC)) {
            /** @var array<string,string> $result */
            $sessionIds[] = $result['session_id'];
        }

        return $sessionIds;
    }

    /**
     * @inheritDoc
     */
    public function getValueFromSession(string $sessionId, string $key): mixed
    {
        throw RepositoryException::notYetImplemented();
    }
}
