class.ilQueryUtils.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
abstract class ilQueryUtils implements ilQueryUtilsInterface
{
    protected \ilDBInterface $db_instance;
 
    public function __construct(ilDBInterface $ilDBInterface)
    {
        $this->db_instance = $ilDBInterface;
    }
 
    abstract public function in(string $field, array $values, bool $negate = false, string $type = ""): string;
 
    abstract public function quote($value, ?string $type = null): string;
 
    abstract public function concat(array $values, bool $allow_null = true): string;
 
    abstract public function locate(string $a_needle, string $a_string, int $a_start_pos = 1): string;
 
    abstract public function free(ilPDOStatement $statement): bool;
 
    abstract public function quoteIdentifier(string $identifier): string;
 
    abstract public function createTable(string $name, array $fields, array $options = []): string;
 
    abstract public function like(
        string $column,
        string $type,
        string $value = "?",
        bool $case_insensitive = true
    ): string;
 
    abstract public function now(): string;
 
    abstract public function lock(array $tables): string;
 
    abstract public function unlock(): string;
 
    abstract public function createDatabase(string $name, string $charset = "utf8", string $collation = ""): string;
 
    abstract public function groupConcat(string $a_field_name, string $a_seperator = ",", string $a_order = null): string;
 
    abstract public function cast(string $a_field_name, $a_dest_type): string;
}