class.ilWebResourceDropValidSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilWebResourceDropValidSteps implements ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;

    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }
    public function step_1(): void
    {
        //Drops the column 'disable_check' from webr_items
        if ($this->db->tableColumnExists('webr_items', 'disable_check')) {
            $this->db->dropTableColumn('webr_items', 'disable_check');
        }
    }

    public function step_2(): void
    {
        //Drops the column 'last_check' from webr_items
        if ($this->db->tableColumnExists('webr_items', 'last_check')) {
            $this->db->dropTableColumn('webr_items', 'last_check');
        }
    }

    public function step_3(): void
    {
        //Drops the column 'valid' from webr_items
        if ($this->db->tableColumnExists('webr_items', 'valid')) {
            $this->db->dropTableColumn('webr_items', 'valid');
        }
    }

    public function step_4(): void
    {
        // Removes entries from table webr_params where 'value' is 2.
        // This removes all link session_id link parameters
        if ($this->db->tableExists('webr_params')) {
            $this->db->manipulate("DELETE FROM webr_params WHERE value = " . $this->db->quote(2, 'integer'));
        }
    }
}