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)));
    }
}