TestManScoringDoneHelper.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Test;
 
class TestManScoringDoneHelper
{
    private ?\ilDBInterface $db;
    private const TABLE_NAME = "manscoring_done";
 
    public function __construct(?\ilDBInterface $db = null)
    {
        if (!$db) {
            global $DIC;
            $db = $DIC->database();
        }
        $this->db = $db;
    }
 
    public function isDone(int $activeId): bool
    {
        $result = $this->db->queryF(
            "SELECT done FROM " . self::TABLE_NAME . " WHERE active_id = %s AND done = 1",
            ["integer"],
            [$activeId]
        );
 
        return $result->numRows() === 1;
    }
 
    public function exists(int $activeId): bool
    {
        $result = $this->db->queryF(
            "SELECT active_id FROM " . self::TABLE_NAME . " WHERE active_id = %s",
            ["integer"],
            [$activeId]
        );
 
        return $result->numRows() === 1;
    }
 
    public function setDone(int $activeId, bool $done): void
    {
        if ($this->exists($activeId)) {
            $this->db->manipulateF(
                "UPDATE " . self::TABLE_NAME . " SET done = %s WHERE active_id = %s",
                ["integer", "integer"],
                [$done, $activeId]
            );
            return;
        }
 
        $this->db->manipulateF(
            "INSERT INTO " . self::TABLE_NAME . " (active_id, done) VALUES (%s, %s)",
            ["integer", "integer"],
            [$activeId, $done]
        );
    }
}