AbandonLoadDependantSessionDatabaseUpdateObjective.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Authentication\Setup;

use ilDatabaseUpdateSteps;
use ilDBInterface;

class AbandonLoadDependantSessionDatabaseUpdateObjective implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;

    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }

    public function step_1(): void
    {
        $this->db->manipulate(
            'DELETE FROM settings WHERE ' . $this->db->in(
                'keyword',
                [
                    'session_handling_type',
                    'session_max_count',
                    'session_min_idle',
                    'session_max_idle',
                    'session_max_idle_after_first_request'
                ],
                false,
                \ilDBConstants::T_TEXT
            )
        );

        if ($this->db->tableExists('usr_session_log')) {
            $this->db->dropTable('usr_session_log', false);
        }

        if ($this->db->tableColumnExists('usr_session_stats', 'max_sessions')) {
            $this->db->dropTableColumn('usr_session_stats', 'max_sessions');
        }

        if ($this->db->tableColumnExists('usr_session_stats', 'closed_limit')) {
            $this->db->dropTableColumn('usr_session_stats', 'closed_limit');
        }

        if ($this->db->tableColumnExists('usr_session_stats', 'closed_idle')) {
            $this->db->dropTableColumn('usr_session_stats', 'closed_idle');
        }

        if ($this->db->tableColumnExists('usr_session_stats', 'closed_idle_first')) {
            $this->db->dropTableColumn('usr_session_stats', 'closed_idle_first');
        }
    }
}