ilDBManager.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
use ILIAS\Database\PDO\FieldDefinition\ForeignKeyConstraints;
 
interface ilDBManager
{
    public function listTables(?string $database = null): array;
 
    public function listSequences(?string $database = null): array;
 
    public function createConstraint(string $table, string $name, array $definition): bool;
 
    public function listTableFields(string $table): array;
 
    public function listTableConstraints(string $table): array;
 
    public function createSequence(string $seq_name, int $start = 1, array $options = []): bool;
 
    public function listTableIndexes(string $table): array;
 
    public function alterTable(string $name, array $changes, bool $check): bool;
 
    public function createIndex(string $table, string $name, array $definition): bool;
 
    public function dropIndex(string $table, string $name): bool;
 
    public function dropSequence(string $seq_name): bool;
 
    public function dropConstraint(string $table, string $name, bool $primary = false): bool;
 
    public function dropTable(string $name): bool;
 
    public function getQueryUtils(): \ilQueryUtilsInterface;
 
    public function createTable(string $name, array $fields, array $options = []): bool;
 
    public function addForeignKey(
        string $foreign_key_name,
        array $field_names,
        string $table_name,
        array $reference_field_names,
        string $reference_table,
        ?ForeignKeyConstraints $on_update = null,
        ?ForeignKeyConstraints $on_delete = null
    ): bool;
 
    public function foreignKeyExists(string $foreign_key_name, string $table_name): bool;
 
    public function dropForeignKey(string $foreign_key_name, string $table_name): bool;
}