DeriveFieldTypes.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\LegalDocuments\Repository;

use DateTimeImmutable;
use InvalidArgumentException;
use ilDBConstants;

trait DeriveFieldTypes
{
    private function deriveFieldTypes(array $fields_and_values): array
    {
        $valid_date_time = static function ($value) {
            if ($value instanceof DateTimeImmutable) {
                return ilDBConstants::T_DATETIME;
            }
            throw new InvalidArgumentException('Only DateTimeImmutable objects allowed.');
        };

        $expected_db_form = static fn($value): array => match (gettype($value)) {
            'integer' => [ilDBConstants::T_INTEGER, $value],
            'string' => [ilDBConstants::T_TEXT, $value],
            'object' => [$valid_date_time($value), $value->getTimeStamp()],
        };

        return array_map(
            $expected_db_form,
            $fields_and_values
        );
    }

    private function query(string $query): array
    {
        return $this->database->fetchAll($this->database->query($query));
    }

    private function queryF(string $query, array $values): array
    {
        $values = $this->deriveFieldTypes($values);
        return $this->database->fetchAll($this->database->queryF($query, array_column($values, 0), array_column($values, 1)));
    }
}