ilCertificateDatabaseUpdateSteps11.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilCertificateDatabaseUpdateSteps11 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        if ($this->db->tableExists('il_cert_user_cert') &&
            $this->db->tableColumnExists('il_cert_user_cert', 'thumbnail_image_path')) {
            $this->db->renameTableColumn(
                'il_cert_user_cert',
                'thumbnail_image_path',
                'tile_image_path'
            );
        }
        if ($this->db->tableExists('il_cert_template') &&
            $this->db->tableColumnExists('il_cert_template', 'thumbnail_image_path')) {
            $this->db->renameTableColumn(
                'il_cert_template',
                'thumbnail_image_path',
                'tile_image_path'
            );
        }
 
        if ($this->db->tableExists('il_cert_user_cert') &&
            $this->db->tableColumnExists('il_cert_user_cert', 'thumbnail_image_ident')) {
            $this->db->renameTableColumn(
                'il_cert_user_cert',
                'thumbnail_image_ident',
                'tile_image_ident'
            );
        }
        if ($this->db->tableExists('il_cert_template') &&
            $this->db->tableColumnExists('il_cert_template', 'thumbnail_image_ident')) {
            $this->db->renameTableColumn(
                'il_cert_template',
                'thumbnail_image_ident',
                'tile_image_ident'
            );
        }
    }
 
    public function step_2(): void
    {
        if (
            $this->db->tableExists('il_cert_user_cert')
        ) {
            if (
                $this->db->tableColumnExists('il_cert_user_cert', 'background_image_path')
            ) {
                $this->db->dropTableColumn('il_cert_user_cert', 'background_image_path');
            }
            if (
                $this->db->tableColumnExists('il_cert_user_cert', 'thumbnail_image_path')
            ) {
                $this->db->dropTableColumn('il_cert_user_cert', 'thumbnail_image_path');
            }
        }
 
        if (
            $this->db->tableExists('il_cert_template')
        ) {
            if (
                $this->db->tableColumnExists('il_cert_template', 'background_image_path')
            ) {
                $this->db->dropTableColumn('il_cert_template', 'background_image_path');
            }
            if (
                $this->db->tableColumnExists('il_cert_template', 'thumbnail_image_path')
            ) {
                $this->db->dropTableColumn('il_cert_template', 'thumbnail_image_path');
            }
        }
    }
}