DatabaseInconsistencyMetricsCollectedObjective.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Test\Setup;

use ILIAS\Setup\Environment;
use ILIAS\Setup\Metrics\Metric;
use ILIAS\Setup\Metrics\Storage;
use ILIAS\Setup\Metrics\CollectedObjective;

class DatabaseInconsistencyMetricsCollectedObjective extends CollectedObjective
{
    protected function getTentativePreconditions(Environment $environment): array
    {
        return [
            new \ilDatabaseInitializedObjective()
        ];
    }

    protected function collectFrom(Environment $environment, Storage $storage): void
    {
        $db = $environment->getResource(Environment::RESOURCE_DATABASE);
        $metrics = [
            'database_available' => new Metric(
                Metric::STABILITY_VOLATILE,
                Metric::TYPE_BOOL,
                !is_null($db),
                'This metric is a canary to check for the general existence of this collection.'
            )
        ];

        if ($db) {
            $this->collectMantis37759($metrics, $db);
        }

        $storage->store('database_inconsistencies', new Metric(
            Metric::STABILITY_MIXED,
            Metric::TYPE_COLLECTION,
            $metrics,
            'These metrics collect information about inconsistencies in the database of the T&A.'
        ));
    }

    protected function collectMantis37759(array &$metrics, \ilDBInterface $db)
    {
        $result = $db->query('
            SELECT COUNT(*) as cnt
            FROM tst_active
            LEFT JOIN object_data ON tst_active.test_fi = object_data.obj_id
            WHERE object_data.obj_id IS NULL
        ');

        $metrics["mantis_37759"] = new Metric(
            Metric::STABILITY_VOLATILE,
            Metric::TYPE_GAUGE,
            $db->fetchAssoc($result)['cnt'],
            'Measures active tests runs where the corresponding Test object does not exist anymore.'
        );
    }
}