class.ilADNDatabaseObjective.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilADNDatabaseObjective implements ilDatabaseUpdateSteps
{
    private ?ilDBInterface $database = null;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->database = $db;
    }
 
 
    public function step_1(): void
    {
        $this->abortIfNotPrepared();
 
        if (!$this->database->tableExists('il_adn_notifications') ||
            $this->database->tableColumnExists('il_adn_notifications', 'has_language_limitation')
        ) {
            return;
        }
        $this->database->addTableColumn(
            'il_adn_notifications',
            'has_language_limitation',
            [
                'type' => 'integer',
                'length' => 1,
                'notnull' => true,
                'default' => 0,
            ]
        );
        $this->database->manipulate('
            UPDATE il_adn_notifications SET has_language_limitation = 0;
        ');
 
        if ($this->database->tableColumnExists('il_adn_notifications', 'limited_to_languages')
        ) {
            return;
        }
        $this->database->addTableColumn(
            'il_adn_notifications',
            'limited_to_languages',
            [
                'type' => 'text',
                'length' => 256,
                'notnull' => true,
                'default' => '',
            ]
        );
        $this->database->manipulate('
            UPDATE il_adn_notifications SET limited_to_languages = "[]";
        ');
    }
 
 
    private function abortIfNotPrepared(): void
    {
        if (null === $this->database) {
            throw new LogicException(self::class . '::prepare() must be called before db-update-steps execution.');
        }
    }
}