class.ilBadgeDBUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilBadgeDBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        if (!$this->db->tableColumnExists('badge_badge', 'image_rid')) {
            $this->db->addTableColumn(
                'badge_badge',
                'image_rid',
                [
                    'type' => 'text',
                    'length' => 64,
                    'notnull' => false,
                    'default' => '',
                ]
            );
        }
    }
 
    public function step_2(): void
    {
        if (!$this->db->tableColumnExists('badge_image_template', 'image_rid')) {
            $this->db->addTableColumn(
                'badge_image_template',
                'image_rid',
                [
                    'type' => 'text',
                    'length' => 64,
                    'notnull' => false,
                    'default' => '',
                ]
            );
        }
    }
 
    public function step_3(): void
    {
        $this->db->manipulate(
            'UPDATE badge_badge SET image_rid = NULL WHERE image_rid = ' . $this->db->quote(
                '-',
                ilDBConstants::T_TEXT
            )
        );
        $this->db->manipulate(
            'UPDATE badge_image_template SET image_rid = NULL WHERE image_rid = ' . $this->db->quote(
                '-',
                ilDBConstants::T_TEXT
            )
        );
        if ($this->db->tableColumnExists('badge_badge', 'image')) {
            $this->db->dropTableColumn('badge_badge', 'image');
        }
        if ($this->db->tableColumnExists('badge_image_template', 'image')) {
            $this->db->dropTableColumn('badge_image_template', 'image');
        }
    }
}