interface.ilDBPdoInterface.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
interface ilDBPdoInterface extends ilDBInterface
{
    public function getServerVersion(bool $native = false): int;
 
    public function queryCol(string $query, int $type = ilDBConstants::FETCHMODE_DEFAULT, int $colnum = 0): array;
 
    public function queryRow(
        string $query,
        ?array $types = null,
        int $fetchmode = ilDBConstants::FETCHMODE_DEFAULT
    ): array;
 
    public function escape(string $value, bool $escape_wildcards = false): string;
 
    public function escapePattern(string $text): string;
 
    public function migrateTableToEngine(string $table_name, string $engine = ilDBConstants::MYSQL_ENGINE_INNODB): void;
    public function migrateAllTablesToEngine(string $engine = ilDBConstants::MYSQL_ENGINE_INNODB): array;
 
    public function supportsEngineMigration(): bool;
 
    public function migrateTableCollation(string $table_name, string $collation = ilDBConstants::MYSQL_COLLATION_UTF8MB4): bool;
    public function migrateAllTablesToCollation(string $collation = ilDBConstants::MYSQL_COLLATION_UTF8MB4): array;
 
    public function supportsCollationMigration(): bool;
 
    public function addUniqueConstraint(string $table, array $fields, string $name = "con"): bool;
 
    public function dropUniqueConstraint(string $table, string $name = "con"): bool;
 
    public function dropUniqueConstraintByFields(string $table, array $fields): bool;
 
    public function checkIndexName(string $name): bool;
 
    public function getLastInsertId(): int;
 
    public function uniqueConstraintExists(string $table, array $fields): bool;
 
    public function dropPrimaryKey(string $table_name): bool;
 
    public function executeMultiple(ilDBStatement $stmt, array $data): array;
 
    public function fromUnixtime(string $expr, bool $to_text = true): string;
 
    public function unixTimestamp(): string;
 
    public function getDBVersion(): string;
}